3. (40 points) The MPS table for a specific end item is below. Suppose that you are in the marketing department and you send the forecasts and committed orders for that item to the manufacturing department (select different integer Fi and values from the interval [50, 100] for weeks 1,2,3,4,5,6 and copy in the first two rows of the MPS table, respectively). The company currently has A units of product select an intervale from the interval [50, 1001) in the inventory. The company uses a production batch size of units (select an integer value from the interval 50, 1001). As a company policy, a safety stock of units (select an integer value from the interval [5.20]) is hold for the end-item. A setup is incurred before production of each batch. The setup cost per production run is $100 and the inventory carrying cost per week per product is SS which is charged based on ending inventory level (Before solving the question, fill in the following table and copy it into your answer sheet) Parameter Value B C 3 5 6 Week Forecast (a Committed Customer Orders (0) Demand Projected Available Balance Net Requirements MPS ATP a) (16 points) Complete the MPS record for the end-item by filling in the table above Show all your work b) points) Compute total setup cost for the 6-week plan based on parta) c) 3 points) Compute total inventory holding cost for the 6-week plan based on purta) Suppose that werk is over and the following events occurred during weck 1: Actual demand during week I was so Marketing forecasted that 70 units will be demanded in week 7. There are no committed orders for week 7 yet. A wonder of 40 units for wock 2 was accepted, in addition to already committed onders A wonder of 20 units for wock 3 was scepted, in addition to ready committed orders. The forecast for weckt 6 were not changed The customer orders for weeks 4 to 6 were not changed d) pies Compute the beginning in for wack 2 based on the given .) (p) Update the MPS record by filling in the whole on the wel based on the gives up 5 3. (40 points) The MPS table for a specific end item is below. Suppose that you are in the marketing department and you send the forecasts and committed orders for that item to the manufacturing department (select different integer Fi and values from the interval [50, 100] for weeks 1,2,3,4,5,6 and copy in the first two rows of the MPS table, respectively). The company currently has A units of product select an intervale from the interval [50, 1001) in the inventory. The company uses a production batch size of units (select an integer value from the interval 50, 1001). As a company policy, a safety stock of units (select an integer value from the interval [5.20]) is hold for the end-item. A setup is incurred before production of each batch. The setup cost per production run is $100 and the inventory carrying cost per week per product is SS which is charged based on ending inventory level (Before solving the question, fill in the following table and copy it into your answer sheet) Parameter Value B C 3 5 6 Week Forecast (a Committed Customer Orders (0) Demand Projected Available Balance Net Requirements MPS ATP a) (16 points) Complete the MPS record for the end-item by filling in the table above Show all your work b) points) Compute total setup cost for the 6-week plan based on parta) c) 3 points) Compute total inventory holding cost for the 6-week plan based on purta) Suppose that werk is over and the following events occurred during weck 1: Actual demand during week I was so Marketing forecasted that 70 units will be demanded in week 7. There are no committed orders for week 7 yet. A wonder of 40 units for wock 2 was accepted, in addition to already committed onders A wonder of 20 units for wock 3 was scepted, in addition to ready committed orders. The forecast for weckt 6 were not changed The customer orders for weeks 4 to 6 were not changed d) pies Compute the beginning in for wack 2 based on the given .) (p) Update the MPS record by filling in the whole on the wel based on the gives up 5