Question

Lead Time Quantity on Hand 0 1 1 1 40 20 1 1 200 0 Parts List for Electric Golf Cart Electric Golf Cart Top Base Top Supports (4) Cover Base Motor Body Seats (2) Body Frame Controls Wheels (4) 2 3 300 50 120 2 1 35 0 240 1 Operations Management Assignment #4 Page 1 Question 2. (Total 20 points): Refer to Question 1. 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. a) Determine the timing and quantities of orders for top and base b) Assume that equipment problems have resulted in the manufacturer being able to assemble supports in lots of 100 and seats in lots of 50. Revise your material requirements plan for supports and seats to reflect this.

I need help with part B of this question.

NOTE: THIS QUESTION WAS NOT ALREADY ANSWERED. There is a difference, my questions is asking for Supports and Seats NOT Top and Bases.

Answer 1

Answer b)

Since the requirement is in the start of weeks, it should be ready at the end of previous week, so that it is available at the start of next week.

GOLF CART Ending inventory 1 2 3 4 5 6 189 0 0 0 0 100 0 100 100 0 0 0 0 0 0 0 0 0 Gross requirement Projected ending inventory Planned receipt Planned release OOOO 0 0 0 0 100 0 100 100 0 0 0 100 0 100 100 0 TOP Ending inventory 1 3 4 5 6 7 8 9 N 0 0 0 100 0 100 100 0 401 40 40 40 0 0 0 0 0 Gross requirement Projected ending inventory Planned receipt Planned release Oo olo 0 0 60 0 100 100 0 0 0 60 0 100 100 0 0 N BASE Ending inventory 1 2 3 3 7 9 0 0 100 0 100 100 0 0 0 20 20 20 20 0 0 0 0 0 0 Gross requirement Projected ending inventory Planned receipt Planned release 0 0 0 0 0 80 0 100 100 0 100 100 0 0 0 80 0 0

Hence the MRP for Supports and Seats is as under:

SUPPORTS 2 4 5 6 7 8 9 Ending 1 3 inventory 0 0 240 2000 2001 200 60 0 O 0 0 400 400 60 60 60 0 400 400 60 50 Gross requirement Projected ending inventory Planned receipt Planned release 60 0 0 100 0 0 0 100 0 4000 400 0 0 0 0 SEATS 9 0 0 0 Ending 1 2 inventory 0 0 160 0 2001 200 120 120 120 10 10 10 0 0 200 200 50 0 2001 200 0 0 10 10 Gross requirement Projected ending inventory Planned receipt Planned release 10 50 0 0 0 Olo 0 0 0

Excel working is shown below:

A B C D E F H - J K L 1 GOLF CART Ending inventory 1 2 3 4 5 67 8 9 2 3 0 0 0 0 0 100 100 0 0 0 4 0 0 0 0 0 100 0 0 0 100 Gross requirement Projected ending inventory Planned receipt Planned release 0 5 0 0 0 0 100 100 0 6 0 0 0 100 0 100 100 0 0 7 8 TOP Ending inventory 1 3 4 5 6 7 8 9 N 9 10 0 0 ol 100 0 100 100 0 0 11 40 40 40 40 0 0 Gross requirement Projected ending inventory Planned receipt Planned release 12 0 0 0 0 0 0 0 60 0 100 100 0 100 100 이 0 0 13 0 0 60 0 0 14 BASE Ending inventory 1 2 3 4 67 9 15 16 0 0 0 0 17 20 20 20 20 0 0 Gross requirement Projected ending inventory Planned receipt Planned release 0 100 0 100 100 0 0 0 0 0 80 0 100 100 80 0 100 100 0 18 0 0 0 0 19 0 0 0 0

SUPPORTS 3 4 8 9 21 O 22 0 O Ending 1 2 inventory 0 0 240 0 400 400 200 200 200 60 60 60 60 0 0 100 0 400 400 0 100 0 400 400 0 23 60 60 Gross requirement Projected ending inventory Planned receipt Planned release 60 24 0 0 0 0 25 0 0 26 SEATS 3 4 6 7 8 9 27 28 Ending 1 2 inventory 0 0 160 120 120 120 10 0 0 50 O 0 0 29 0 200 200 10 10 0 200 200 10 10 Gross requirement Projected ending inventory Planned receipt Planned release 10 10 30 0 0 0 31 50 0 2001 200 0 0 0 0 0