Hey there! Sign in to join this conversationNew here? Join for free
    • Thread Starter
    Offline

    1
    ReputationRep:
    This is done in excel. Some help on where to start would be nice.

    A computer manufacturer has four factories A, B, C and D which produce in order 500, 250, 300 and 600 computers per week. The computers are transported to be stored in 5 warehouses W1, W2, W3, W4 and W5 which can accomodate in order 200, 150, 300, 600 and 400 computers.
    Subsequently the computers are sent on to shops for sale. The transport costs per computer are
    given as below.
    a) Manually fill in the number of computers transported in the top table to get an initial cost.
    b) Try to change your initial attempt in a) to reduce the overall costs.
    c) Use the excel solver to get a solution to the costs. Comment briefly on your answers to a), b)
    and c).
    d) Comment briefly on any practical difficulties that the above problem may encounter.
    • TSR Support Team
    • Clearing and Applications Advisor
    Offline

    21
    ReputationRep:
    (Original post by MatthewTG)
    This is done in excel. Some help on where to start would be nice.

    A computer manufacturer has four factories A, B, C and D which produce in order 500, 250, 300 and 600 computers per week. The computers are transported to be stored in 5 warehouses W1, W2, W3, W4 and W5 which can accomodate in order 200, 150, 300, 600 and 400 computers.
    Subsequently the computers are sent on to shops for sale. The transport costs per computer are
    given as below.
    a) Manually fill in the number of computers transported in the top table to get an initial cost.
    b) Try to change your initial attempt in a) to reduce the overall costs.
    c) Use the excel solver to get a solution to the costs. Comment briefly on your answers to a), b)
    and c).
    d) Comment briefly on any practical difficulties that the above problem may encounter.
    Can you apply the north-west corner method to obtain an initial solution? You know the supply of each factory and the demand of each warehouse so this is enough information.

    Pictures would be helpful when done
    • Thread Starter
    Offline

    1
    ReputationRep:
    (Original post by NiamhM1801)
    Can you apply the north-west corner method to obtain an initial solution? You know the supply of each factory and the demand of each warehouse so this is enough information.

    Pictures would be helpful when done
    Thanks for the reply but i got help elsewhere and have finished it now but thanks anyway. p.s. i have no idea what the n-w corner method even is.
    • TSR Support Team
    • Clearing and Applications Advisor
    Offline

    21
    ReputationRep:
    (Original post by MatthewTG)
    Thanks for the reply but i got help elsewhere and have finished it now but thanks anyway. p.s. i have no idea what the n-w corner method even is.
    Ah okay, and really? Maybe we were taught different methods aha
 
 
 
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    What newspaper do you read/prefer?
    Useful resources

    Make your revision easier

    Maths

    Maths Forum posting guidelines

    Not sure where to post? Read the updated guidelines here

    Equations

    How to use LaTex

    Writing equations the easy way

    Student revising

    Study habits of A* students

    Top tips from students who have already aced their exams

    Study Planner

    Create your own Study Planner

    Never miss a deadline again

    Polling station sign

    Thinking about a maths degree?

    Chat with other maths applicants

    Can you help? Study help unanswered threads

    Groups associated with this forum:

    View associated groups
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • 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

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