Toys Plus Inc Essay

1136 Words Jul 3rd, 2008 5 Pages
1. Calculate economic order quantities for each of the three types of toys.
MASTER SCHEDULE FORECAST INPUT SEP26 OCT3 OCT10 OCT17 OCT24 OCT31 ----- ----- ----- ----- ----- -----
TOY AUTO 1100 1150 1200 1300 1400 1500
TOY TRUCK 500 450 400 350 300 300
TOY ROBOT 700 650 650 625 625 600 ------ ------ ------ ------ ------ ------ TOTAL UNITS 2300 2250 2250 2275 2325 2400 AVERAGE WEEKLY DEMAND (CALCULATED)
TOY AUTO 1275
TOY TRUCK 383
TOY ROBOT 642

MASTER SCHEDULE
EOQ CALCULATIONS AUTO TRUCK ROBOT
WEEKLY DEMAND RATE 1275 383 642
PRODUCTION RATE PER WEEK 3500 1750 2333
UNIT COST 3.2 6.5 4.1 SETUP COST 293
CARRYING COST(% Per Year) 25% ECONOMIC ORDER
…show more content…
ORDER RELEASES 0 0 0 10204 0 0 - - - - - - -
619 GROSS REQUIREMENTS 0 0 0 0 760 3500 SCHEDULED RECEIPTS 0 0 0 0 0 0 PROJ. ON HAND INV. 2500 2500 2500 2500 1740 766 NET REQUIREMENTS 0 0 0 0 0 2526 PLAN. ORDER RELEASES 0 0 0 2526 0 0 - - - - - - -
621 GROSS REQUIREMENTS 0 0 0 0 380 1750 SCHEDULED RECEIPTS 0 0 1200 0 0 0 ON HAND INVENTORY 4600 4600 5800 5800 5420 3670 NET REQUIREMENTS 0 0 0 0 0 0 PLAN. ORDER RELEASES 0 0 0 0 0 0 - - - - - - -
730 GROSS REQUIREMENTS 2267 2333 530 0 0 0 SCHEDULED RECEIPTS 0 0 0 0 0 0 ON HAND INVENTORY 642 642 642 642 642 642 NET REQUIREMENTS 1309 2333 530 0 0 0 PLAN. ORDER RELEASES 530 0 0 0 0 0 - - - - - - -
732 GROSS REQUIREMENTS 4533 4667 1060 0 0 0 SCHEDULED RECEIPTS 0 0 0 0 0 0 PROJ. ON HAND INV. 1284 1284 1284 1284 1284 1284 NET REQUIREMENTS 2317 4667 1060 0 0 0 PLAN. ORDER RELEASES 1060 0 0 0 0 0 - - - - - - - 734 GROSS REQUIREMENTS 4533 4667 1060 0 0 0 SCHEDULED RECEIPTS 0 0 0 0 0 0 ON HAND INVENTORY 1284 1284 1284 1284 1284 1284 NET REQUIREMENTS 1797 4667 1060 0 0 0 PLAN. ORDER RELEASES 4667 1060 0 0 0 0 - - - - - - -
736 GROSS REQUIREMENTS 2267 2333 530 0 0 0 SCHEDULED RECEIPTS 0 0 0 0 0 0 ON HAND INVENTORY 642 642 642 642 642

More about Toys Plus Inc Essay

Open Document