Results are out! Find what you need...fast. Get quick advice or join the chat
x

Unlock these great extras with your FREE membership

  • One-on-one advice about results day and Clearing
  • Free access to our personal statement wizard
  • Customise TSR to suit how you want to use it

Excel assignment

Announcements Posted on
Had your SQA results? Find your uni forum to get talking to other applicants, existing students and your future course-mates 04-08-2015
Competition: win a karting session for you and seven mates! 24-07-2015
  1. Offline

    ReputationRep:
    Can someone please please help me with this excel assignment.
    Attached Files
  2. File Type: docx work_excel.docx (17.1 KB, 482 views)
  3. Offline

    ReputationRep:
    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. Offline

    ReputationRep:
    I'm not asking you to do it for me am just asking you for help. Just explain the questions to me please.
  5. Offline

    ReputationRep:
    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. Offline

    ReputationRep:
    Am having difficulty with question number 2.

  7. Offline

    ReputationRep:
    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. Offline

    ReputationRep:
    Thanks man! I thought that i should calculate the production costs for each bottles.
  9. Offline

    ReputationRep:
    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.

Reply

Submit reply

Register

Thanks for posting! You just need to create an account in order to submit the post
  1. this can't be left blank
    that username has been taken, please choose another Forgotten your password?
  2. this can't be left blank
    this email is already registered. Forgotten your password?
  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
    your full birthday is required
  1. By joining you agree to our Ts and Cs, privacy policy and site rules

  2. Slide to join now Processing…

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.

Poll
Uni students: did you know what you wanted to do when you left school/college?
Results and Clearing

SQA results chat

Come talk about your results here

new on tsr

Indian? Join the society here

Take part in the chat and make friends

x

Think you'll be in clearing or adjustment?

Hear direct from unis that want to talk to you

Get email alerts for university course places that match your subjects and grades. Just let us know what you're studying.

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