table for b

2. Answer the following questions. a. (9 points) A La Luna LLC produces circuit boards and wants to prepare a master production schedule for May and June. Marketing has forecasted demand of 100 pumps for May and 120 pumps for June. These have been evenly distributed over the four weeks in each month: 25 per week in May and 30 per week in June. At the beginning of May, A La Luna LLC will have 47 circuit boards on hand. The current customer orders for each week is also shown below. Prepare a master production schedule for A La Luna LLC. Use the MPS rule of scheduling production when the projected on-hand inventory would be negative without production and use a lot size of 100. May June 1 2 3 4 5 6 7 18 34 27 12 47 Forecast Customer Orders Projected on-hand inventory MPS Available-to-promise b. (6 points) Product A is assembled using part B and assembly C, as shown in the product structure tree. There are 20 units of B now on hand. B can only be ordered in whole cases (100 units per case) and lead time is 1 week. The necessary parts of the MRP tables for A and C are shown below. Complete the MRP table for B. B (2) C (4) B (1) B (1) D (3) DIB) Beg. Inv. 1 3 4 6 7 Master Schedule for Week Number Quantity 5 80 Beg. Inv. 4 67 8 Gross Requirements Planned-order receipts Planned-order releases Beg. Inv. 1 - 3 I I 5 4 300 Planned-order receipts Planned-order releases 300 Beg. Inv. 3 4 L 5 6 - 8 Gross Requirements Scheduled Receipts Projected on hand Net Requirements Planned-order receipts Planned-order releases