Please solve Q2!

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 200 golf carts at the start of week 8. 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 and seats as lot for lot ordering. Revise your material requirements plan for supports and seats to reflect this. Note: Template for MRP included here; print as many copies as necessary Question 1. (Total 50 points) Information concerning the product structure, lead times and quantities on hand for an electric golf cart is shown in the following table. Use this information to do each of the following: a) Draw the product structure tree b) Develop the material requirements plan that will provide 100 golf carts at the start of week 6, 100 golf carts at the start of week 8, and 100 golf carts at the start of week 9; assume lot-for-lot ordering for all parts except supports in lots of 100 and seats in lots of 50. Note: Template for MRP included here; print as many copies as necessary Lead Time Quantity on Hand 1 O 1 40 20 1 1 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) 200 O 1 wNN 300 50 120 1 1 35 o 240 1 Beg Inv. 1 2 3 4 5 6 7 8 9 Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipt Planned Order Release Beg Inv. 1 2 3 4 5 ON 7 8 9 Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipt Planned Order Release Beg Inv. 1 2 3 4 5 6 7 8 9 Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipt Planned Order Release