Assignment 1: 25% Q1 (10%). For the following data, calculate the number of workers required for level production and the resulting month-end inventories. Each worker can produce 9 units per day, and the desired ending inventory is 800 units. Calculating the ending inventory and explain why is it not possible to meet the ending inventory target? Any suggestion you can recommend to achieve the ending inventory number? Month 1 2 3 4 5 6 Total Working Days 20 24 12 22 20 19 Forecast Demand 2800 3000 2700 3300 2900 3200 Planned Production 1000 Planned Inventory Q2 (15%). You are hired as a planner for a furniture manufacture, please see below table, and complete the following MRP record. The lead time is four weeks, and the lot size is 200. What will happen if the gross requirements in week 3 are increased to 210 units? As a planner, what are your main responsibilities, in this case what actions can you take? Initial MRP Week 1 2 3 4 5 50 125 100 60 40 Gross Requirements Scheduled Receipts Projected Available 100 200 200 Net Requirements Planned Order Receipt Planned Order Release Revised MRP Week 2 3 4 5 Gross Requirements Scheduled Receipts Projected Available 100 Net Requirements Planned Order Receipt Planned Order Release 1