limiting factors

taskeytaskey Font Of All KnowledgePosts: 1,800Registered
k, stuck on limiting factors.

have attached an excel sheet if anyone can help me

how do i work out where the short fall will be (if any). mind gone completly blank and my books are no help whatsoever

Thanks in advance

Tracy

Comments

  • taskeytaskey Font Of All Knowledge Posts: 1,800Registered
    wont let me attach file duh!!!

    so the tabs on this are gonna be out
    .....................................small units....... medum units .......large units
    mixing labour hours per unit .....0.05......... 0.07 ................0.08

    fnishing labour hours per unit .....0.04 ........0.08.............. 0.10

    packing labour hours per unit .....0.10........ 0.09 .................0.09

    number of units to be produced....800 .........600.............. 700


    department....... hours available
    mixing........ 160
    finishing..... 120
    packing....... 210
  • ToffeemadblueToffeemadblue Well-Known Posts: 102Registered
    Hi Taskey,
    I haven't got this far yet but looking at your example it seems to me that the limiting factor would be finishing as this is the only area where the hours required for the total production exceed the hours available

    small medum Large Production Production Production Total hours
    units units units Hours Hours Hours per area
    0.05 0.07 0.08 40 42 56 138

    0.04 0.08 0.1 32 48 70 150

    0.1 0.09 0.09 80 54 63 197

    800 600 700

    Don't know if this helps
  • Bookworm55Bookworm55 Trusted Regular Posts: 479Registered
    I'll get you started:

    Start with a line under "Number of units to be produced" called "mixing labour hours for full production". Fill it in. For small units that's 800 units * 0.05 hours/unit = 40 hours. Do the same for medium and large to get 42 and 56 respectively.

    Repeat the process for Finishing and Packing hours.

    Add a 'total' column on the right. Add up the number of hours you need at each stage for full production, and compare to the number available.

    EDIT: oops, ToffeMadBlue had already posted.
  • taskeytaskey Font Of All Knowledge Posts: 1,800Registered
    fab thanks for your answers. i will have a look and see if it is any clearer.

    it is frustrating when my book gives me half a page and that is all.

    Once again, thanks

    Tracy
  • SandyHoodSandyHood Font Of All Knowledge Posts: 2,034Registered, Moderator
    If you send me the excel as an attachment I'll try to help.
    Sandy
    [email protected]
    www.sandyhood.com
  • blobbyhblobbyh Font Of All Knowledge Posts: 2,415Registered
    Apart from one of your friends telling you to eat them and another asking are they like the X Factor, did you get much help with this topic off your Facebook friends Tracy? :-)
Sign In or Register to comment.