Task-1
You are required to write an overview on the wholesale stationers in Germany, which will also include trends in this area.
Task-2
By taking help of the EXCEL spreadsheet, you are required to provide a graph to present the annual spending on drawing materials in seven European countries in 2015, in which two will be France and Germany.
Task-3
after gaining proper understanding of the wholesale stationary market in Europe, you have decided to inspect 3 years financial data of sales of Duque's. The data mentioned is of the printer cartridges, general office suppliers, low cost printers, office furniture and much more.
Product item |
2015 Sales (€) |
2016 Sales (€) |
2017 Sales (€) |
printer cartridges |
25000 |
26000 |
22000 |
general office supplies |
25000 |
27000 |
23000 |
low-cost printers |
15000 |
18000 |
18000 |
office furniture |
25000 |
25000 |
27000 |
shredders |
25000 |
29000 |
29000 |
paper-based supplies |
25000 |
27000 |
27000 |
writing/drawing materials |
25000 |
30000 |
32000 |
- By making use of the EXCEL spreadsheet, make an adjustment to above table and will be included as appendix
- Take help of the mixed pie chart, present the sales of 2016 and 2017
- When presenting the total sales and year in appropriate scatter diagram, you are asked to identify related correlation coefficient and also discuss the interpretation
- With the help of same scatter diagram, analyse the sales of 2018 and 2019
Task-4
All the operations of Dueque in present is taking place in Northern France. Also, the business has never operated across the border in Germany. For answering the question asked by Donald that “should the expansion of business must be made or not”, it was decided by you to make use of the pros and cons method table
Should I expand my business to Belgium & Germany? |
||||
Pros |
Score/10 |
Cons |
Score/10 |
|
Total Pros |
Total Cons |
|||
Average Pros |
|
Average Cons |
|
- Complete the table
- In order to conduct the activities, it has become necessary for the European companies to comply with the international standards. Make a list of the international standards that is applied to Duques activities. You can also make use of the information given at iso.org
Task-5
Now if it is decided by the Donald to expand the operations, it automatically means that facilities are required to be enhanced and as it happens, A highly suitable building will be available for the sale nearby. Also, he thinks that the asking price of €220,000 might be negotiable closer to €200,000
- Calculate the monthly cost of a 30-year repayment mortgage of £200,000, where interest is applied to the loan outstanding at the beginning of each year and the mortgage rate is 10% per annum.
- Re-calculate the monthly cost assuming that the interest is applied to the loan every month (12 times a year. Hint. Use APR in the place of r)
Task-6
It was believed by Donald that the mean value of the orders received is around euro 240. It has been seen that hundreds of orders are received each month, but the time is not available so that every one's can be checked. The accounts office decides on a strategy of randomly selecting a sample of 50 accounts and finds a sample mean of €230 and sample standard deviation of €43. Does this evidence support his belief? Assume a 5% significance level
Task-7
- It has been the trend that every year a questionnaire is sent to the customer in form of email each December by the Dueque. The response made to this is not that appropriate that is only less that 5 percent is concerned about giving response to it. What advice can be given to enhance the situation.
- Calculate mean, standard deviation for the four variables mentioned. Describe that if any of the mentioned above give rise to concern.
In 2017, twenty questionnaires were returned completed. Results for Question 3 (“Please rate us on the following ... “). Names of respondents have been anonymised.
ID |
CUST_SERV |
QUAL_P&S |
SALES_STAFF |
PRICE_VALUE |
||
01 |
3 |
3 |
3 |
3 |
||
02 |
3 |
3 |
3 |
2 |
||
03 |
4 |
4 |
4 |
2 |
||
04 |
4 |
3 |
4 |
1 |
||
05 |
2 |
3 |
2 |
2 |
||
06 |
4 |
4 |
4 |
2 |
||
07 |
4 |
3 |
4 |
2 |
||
08 |
4 |
3 |
4 |
2 |
||
09 |
2 |
3 |
2 |
2 |
||
10 |
4 |
3 |
4 |
1 |
||
11 |
4 |
3 |
4 |
2 |
||
12 |
4 |
3 |
4 |
2 |
||
13 |
4 |
3 |
4 |
2 |
||
14 |
4 |
3 |
4 |
1 |
||
15 |
2 |
3 |
2 |
2 |
||
16 |
4 |
3 |
4 |
2 |
||
17 |
4 |
4 |
4 |
2 |
||
18 |
3 |
3 |
3 |
3 |
||
19 |
4 |
3 |
4 |
2 |
||
20 |
3 |
3 |
2 |
2 |
||
DATA KEY |
||||||
ID |
01 ... 99: ANONYMISING IDENTIFIER |
|||||
CUST_SERV |
1 ... 4: RATING |
|||||
QUAL_P&S |
1 ... 4: RATING |
|||||
SALES_STAFF |
1 ... 4: RATING |
|||||
PRICE_VALUE |
1 ... 4: RATING |
Task-8
by considering the task from 1 to 7, you are requiring to prepare the summary in one paragraph on the significant findings. Also give a look to the overall structure and presentation of your report.