Toys Plus Inc Essay

1136 Words5 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