(exponentially distributed) to approve each schedule, and students arrive at the adviser's office at the rate of 10 per hour (Poisson distributed). Student Name a. Compute L, LG, W. Wg, and p. b. What do you think about this system? How would you change it? Problem 1 A firm received an order of 200 electric golf carts. The carts must be ready for delivery by week 8. Based on the following information, finish the questions. Lead Time Parts List for Electric Golf Cart Electric golf cart Top Supports (4) Cover Base Motor Body Quantity on Hand 0 40 200 0 20 300 50 35 0 240 120 1 1 2 3 1 1 1 2 Frame Controls Wheel assemblies (4) Seats (2) a. What levels in the bill of materials are the following parts at? - Top a level Base @ level Body a level - Wheel assemblies a level Seats a level b. Develop a material requirements plan (MRP) by fill in the attached Excel template (tab p1(b)). Notice that 200 carts must be ready by week 8. Use lot-for-lot. [You can submit the Excel file or you can copy-paste your MRP table into Word] c. There is a change in the quantity and timing of orders for golf carts due to weather. The revised plan calls for 100 carts by week 6, 150 by week 8, and 200 by week 9. Furthermore, the firm now adopts a fixed order quantity lot sizing (lot size = 50). Develop an MRP for this new plan. Fill in the Excel sheet (tab p1c)). If one order (that is, planned order receipts = order size) cannot cover net requirement, you can increase the number of orders (to 2 or more) till net requirement is covered. Notice that there is no "week 0 or earlier. So, if planned order receipts or planned order releases" must occur before week 1, simply ignore them. [You can submit the Excel file or you can copy-paste your MRP table into Word] d. Based on part (c), what items have "planned order receipts or planned order releases that must occur before week 1? That is to say, what items need to be obtained immediately? How many for each of them? (exponentially distributed) to approve each schedule, and students arrive at the adviser's office at the rate of 10 per hour (Poisson distributed). Student Name a. Compute L, LG, W. Wg, and p. b. What do you think about this system? How would you change it? Problem 1 A firm received an order of 200 electric golf carts. The carts must be ready for delivery by week 8. Based on the following information, finish the questions. Lead Time Parts List for Electric Golf Cart Electric golf cart Top Supports (4) Cover Base Motor Body Quantity on Hand 0 40 200 0 20 300 50 35 0 240 120 1 1 2 3 1 1 1 2 Frame Controls Wheel assemblies (4) Seats (2) a. What levels in the bill of materials are the following parts at? - Top a level Base @ level Body a level - Wheel assemblies a level Seats a level b. Develop a material requirements plan (MRP) by fill in the attached Excel template (tab p1(b)). Notice that 200 carts must be ready by week 8. Use lot-for-lot. [You can submit the Excel file or you can copy-paste your MRP table into Word] c. There is a change in the quantity and timing of orders for golf carts due to weather. The revised plan calls for 100 carts by week 6, 150 by week 8, and 200 by week 9. Furthermore, the firm now adopts a fixed order quantity lot sizing (lot size = 50). Develop an MRP for this new plan. Fill in the Excel sheet (tab p1c)). If one order (that is, planned order receipts = order size) cannot cover net requirement, you can increase the number of orders (to 2 or more) till net requirement is covered. Notice that there is no "week 0 or earlier. So, if planned order receipts or planned order releases" must occur before week 1, simply ignore them. [You can submit the Excel file or you can copy-paste your MRP table into Word] d. Based on part (c), what items have "planned order receipts or planned order releases that must occur before week 1? That is to say, what items need to be obtained immediately? How many for each of them