limiting factors

taskey

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

taskey

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

Toffeemadblue

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

Bookworm55

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.

taskey

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

SandyHood

If you send me the excel as an attachment I'll try to help.

blobbyh

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? :-)