A. Work out on Microsoft Excel the following:
i. The total number of sales for week 1, week 2, week 3, week 4 and week 5
ii. The total amount of money lost during these 5 weeks
iii. Draw a line chart to show the loss of the company for the last 5 weeks with all proper labels and formatting
iv. Write an analysis report to the Director, using Microsoft Word to show your findings, comments and recommendations.
v. Show on the table where do you situate loss and profit during the last 5 weeks
Which of these are you struggling with? It's hard to help if you don't tell us what the problem you are having is!
Also this doesn't seem to add up:
each with a cargo of half the total number of crates of 1 litre, 3/10 of the total number of crates of 0.5 litre and half the total number of crates of 2 litres
depends on whether you are looking at unecessary costs (which will just be the manufacturing of the returned bottles), or lost money from ineffective distribution (in which case you need to use the sale prices of the bottles).