Duque Company: Sales, Expansion, Financials, and Customer Feedback

This report provides a comprehensive analysis of Duque Company's performance, focusing on sales data from 2015 to 2017, and assessing the potential for business expansion. It includes a valuation of gross sales, a pie chart representation of sales records, and a calculation of the correlation and coefficient between sales figures. The report also examines the pros and cons of expanding the business to Belgium and Germany, along with an evaluation of relevant international standards like ISO 50001, ISO 13485, ISO 26000, and ISO 14001. Furthermore, it includes a computation of monthly expenses over 30 years and a re-analysis of loan interest. The assessment of data reveals customer feedback, including mean and standard deviation for customer service, product quality, sales staff, and price value. The report concludes with appropriate findings and recommendations, emphasizing the potential for business expansion, strategic management, and financial planning, particularly in the stationary market in Germany.

SUMMATIVE ASSESSMENT

Table of Contents
TASK 3............................................................................................................................................1
Valuation of Duque fiscal time period of gross sales from last three year.............................1
(a) Information refreshing sales records for the years............................................................1
b) Pie chart..............................................................................................................................1
c) Calculation of correlation and coefficient..........................................................................3
TASK 4............................................................................................................................................5
a) PROS and CONS table with explanation...........................................................................5
b) International organisation for standards.............................................................................6
TASK 5............................................................................................................................................6
a) Computation of monthly expenses for 30 years.................................................................6
b) Re analysis of loan interest................................................................................................7
TASK 6............................................................................................................................................7
Assessment of data.................................................................................................................7
TASK 7............................................................................................................................................8
TASK 8............................................................................................................................................8
Appropriate findings...............................................................................................................8

TASK 3
Valuation of Duque fiscal time period of gross sales from last three year
(a) Information refreshing sales records for the years
As per the above table it is analyses that sales for 2015 was recorded as £165000, sales
for 2016 was £182000 and sales for 2017 was £178000.
b) Pie chart
There are sales records for three years are defined above and graphical representation
given on the basis of above records below
1

The above chart describes the sales records of stationary products for the year 2016. there
are 8 products introduced by the organization subject to sale of stationary products.
The above graph represents the figures of supplies of stationary products for the year
2017.
2

c) Calculation of correlation and coefficient
There is a results evaluated by implementing statistical analysis as 0.847510399 as
coefficient correlation. Significant difference was evaluated between sales of 2016 and 2017.
3

The above scatted diagram reflect the information related to sales records and the
variations among the sales records for 2016 and 2015. as per the scatter diagram it is evaluated
that sales in 2016 increased in comparison to 2015.
4

the above graphical representation indicates toward analysis of sales records between
2017 and 2016. the sales was counted less in 2017 for printer and general office suppliers. The
sales records of paper based supplies and writing materials are recorded higher in comparision to
last year.
TASK 4
a) PROS and CONS table with explanation
Should I expand my business to Belgium & Germany?
Pros Score/10 Cons Score/10
Possibilities of grasping of new
customer market 8
Diverse political environment and
policies regarding expand the
business 6
Opportunities to introduce creative
stationary products 7
Requirement of high amount of
financial resources 6
Capacity to derive economic scale of
organisation towards sustainability 6
Low feasibility and changes
subject to sustainable
development 5
Improving the scale of effective
communication skills 9
Lack of locality support to
enhance the product development 4
Government support and analytical
support 8
Challenges in tracking and
controlling system 5
Total Pros 38 Total Cons 26
Average Pros 7.6 Average Cons 5.2
There are following results found in terms of expanding the business in Germany. It is
evaluated that two options are available in form of Duque company. Average pros were counted
5

as 7.6 and average cons were counted as 5.2. Overall the results are analysed as Total Pros –
Total Cons (38 - 26 = 12). Positive pros are found as 12 that indicates that managers should
expand the business in Germany.
b) International organisation for standards
ISO 500001 (2018): This international standard will assist Duque company to develop
the structure to make more efficient energy system and management approaches.
ISO 13485 (2016): This standards provides requirements for regulatory purpose and
quality management system for specific medical devices and industries. It will improve Duque's
legislative activities and legal actions.
ISO 26000 (2010): It is mainly developed to enhance the working with group of peoples
for enhancing the communication with stakeholders across the world.
ISO 14001 (2015): Practical tools are provided under this international standard. This
contains auditing, labelling and environmental challenges regarding climate change and
development.
TASK 5
a) Computation of monthly expenses for 30 years
The record managers required to keep 100 total demands in consistently. In that preface,
mean 50 tests size will be considered with standard deviation of 43 pounds. The invalid
hypothesis is the mean estimation of oil that is used as 240 consistently. While elective
hypothesis is that all mean regard isn't proportional to the 240 (starting now and into the
foreseeable future, it might be more broad or little).
Formula:
A*(1+r)n – 12 * X { (1+r)n / (1+r) – 1} =0
6

b) Re analysis of loan interest
TASK 6
Assessment of data
Summary:
H0: μ = £240
H1: μ ≠ £240
Where, μ refers the value of mean.
Working at the 5% significance level.
SE: Standard deviation / √𝑛
7

= 43/ √50
= 43 /7.07
= 6.08= 6.
Researcher need to work out the acceptance interval as [ μ – 2SE, μ + 2SE]
= 240- 2(6), 240+2(6)
= [228, 252].
The results are presents the sample mean of 230 lies within the class intervals of 228 and
252. there is a 95% of randomly selected means are analysed with proper management an control
as H0 and H1 as the mean value of orders sustained by 240.
TASK 7
a) Price and value was the main reason of disappointment among customers. Pricing strategy of
Duque is wrong that is why company is getting feedbacks form customers. The uneven product
price is one of the main reason that is creating the differences between the products and services.
b) There is following results come across the evaluation of customer responses in terms of
providing ratings.
Mean
The formula of mean is, Mean <x> = ∑x/N
where∑ refers the addition of x represents and N refers the number of grades.
Mean was calculated for customer service 3.5, for quality_P&S 3.15, for sales staff is
3.45 and 1.95 for Price value.
Standard deviation
Formual of σ =√1/N ∑ (Xi - x̄)2
The standard deviation in terms of customer's response was found as 0.73608 for
customer services, 0.36634 for quality_P&S, 0.825577947 for sales_staff and 0.5104177 for
price value.
TASK 8
Appropriate findings
There is a description made after analysing information about Duque organization, it has
been found that rebate grandstand for stationary business is adequately sufficient for devising
augmentation of their constant business. It would be precisely assumed that general
8

administration of stationary business to affiliate genuine strategic management and planning. It
would be effective in the long run and help to realize their methods in reasonable way. It is
evaluated that stationary market can be expanded in Germany. It is enhanced through evaluation
of far reaching number of individual that are spending in their compensation level on acquiring
stationary things and products. With assistance of suitable resources organisers have the ability
to accomplish most extraordinary return in not all that inaccessible future time.
9