Assume that unusually mild weather has caused a change in the quantity and timing of orders...

Transcribed Image Text:

Assume that unusually mild weather has caused a change in the quantity and timing of orders for golf carts. The revised plan calls for 100 golf carts at the start of week 6, 100 at the start of week 8, and 100 at the start of week 9. (Assume all parts are lot-for-lot.) Parts List for Electric Golf Cart Electric golf cart Top Base Top Supports (4) Cover Base Motor Body Seats (2) Body Frame Controls Wheel assemblies (4) Lead Time 1 1 1 Quantity on Hand 0 40 20 EL 1 200 1 0 232 300 50 120 1 35 1 0 1 240 a. Develop a master schedule for this revised plan. (Leave no cells blank - be certain to enter "0" wherever required.) Week Quantity Beg. Inv. 1 2 3 4 5 6 7 8 9 b. Determine the timing and quantities for orders for tops and bases. (Leave no cells blank - be certain to enter "O" wherever required.) Item: Tops LT = 1 week Beg. Inv. 1 2 3 4 5 6 7 8 9 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases Item: Base LT = 1 week Beg. Inv. 2 3 4 5 6 7 8 9 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases c. Assume that equipment problems reduce the firm's capacity for assembling bases to 50 units per week. Revise your material plan for bases to reflect this, but still meet delivery dates. (Leave no cells blank - be certain to enter "0" wherever required.) Item: Bases LT = 1 week Beg. Inv. Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases 2 3 4 5 6 7 8 9 Assume that unusually mild weather has caused a change in the quantity and timing of orders for golf carts. The revised plan calls for 100 golf carts at the start of week 6, 100 at the start of week 8, and 100 at the start of week 9. (Assume all parts are lot-for-lot.) Parts List for Electric Golf Cart Electric golf cart Top Base Top Supports (4) Cover Base Motor Body Seats (2) Body Frame Controls Wheel assemblies (4) Lead Time 1 1 1 Quantity on Hand 0 40 20 EL 1 200 1 0 232 300 50 120 1 35 1 0 1 240 a. Develop a master schedule for this revised plan. (Leave no cells blank - be certain to enter "0" wherever required.) Week Quantity Beg. Inv. 1 2 3 4 5 6 7 8 9 b. Determine the timing and quantities for orders for tops and bases. (Leave no cells blank - be certain to enter "O" wherever required.) Item: Tops LT = 1 week Beg. Inv. 1 2 3 4 5 6 7 8 9 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases Item: Base LT = 1 week Beg. Inv. 2 3 4 5 6 7 8 9 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases c. Assume that equipment problems reduce the firm's capacity for assembling bases to 50 units per week. Revise your material plan for bases to reflect this, but still meet delivery dates. (Leave no cells blank - be certain to enter "0" wherever required.) Item: Bases LT = 1 week Beg. Inv. Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases 2 3 4 5 6 7 8 9