You are Here: Home

# Excel assignment

Announcements Posted on
Four hours left to win £100 of Amazon vouchers!! Don't miss out! Take our short survey to enter 24-10-2016
Attached Files
2. work_excel.docx (17.1 KB, 551 views)
3. how far have you got? where are you stuck?

Please don't just post your work and expect us to do it for you. It's called "study help" not "suckers that do your work for you"
4. I'm not asking you to do it for me am just asking you for help. Just explain the questions to me please.
5. 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
as the total shows that each lorry is 13/10 full!
6. Am having difficulty with question number 2.

7. If you calculate the number of returned bottles by the lorries, you can calculate the money lost by not selling those bottles each week.
8. Thanks man! I thought that i should calculate the production costs for each bottles.
9. 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).

In my eyes the questions are a little vague tbh.

## Register

Thanks for posting! You just need to create an account in order to submit the post
1. this can't be left blank
2. this can't be left blank
3. this can't be left blank

6 characters or longer with both numbers and letters is safer

4. this can't be left empty
1. Oops, you need to agree to our Ts&Cs to register

Updated: August 3, 2012
TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Today on TSR

### Who is getting a uni offer this half term?

Find out which unis are hot off the mark here

### How to get a 1st class degree

Poll
Useful resources
Study resources

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.