You can select any random integer in the given intervals.

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 Fand Ovalues from the interval [50, 100) for weeks t-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 integer value from the interval [50, 100]) in the inventory. The company uses a production batch size of B units (select an integer value from the interval [50, 100)). As a company policy, a safety stock of C units (select an integer value from the interval [5,20]) is hold for the end-item. A setup is incurred before production of cach batch. The setup cost per production run is $100 and the inventory carrying cost per week per product is $5 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 A B 2 3 4 5 6 Week Forecast (F) 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) (3 points) Compute total setup cost for the 6-week plan based on part a). c) (3 points) Compute total inventory holding cost for the 6-week plan based on part a). Suppose that, week I is over and the following events occurred during week 1: Actual demand during week 1 was 50. Marketing forecasted that 70 units will be demanded in week 7. There are no committed orders for week 7 yet. A new order of 40 units for week 2 was accepted, in addition to already committed orders. A new order of 20 units for week 3 was accepted, in addition to already committed orders. The forecasts for weeks 2 to 6 were not changed. The customer orders for weeks 4 to 6 were not changed. d) (2 points) Compute the beginning inventory for week 2, based on the given update. e) (16 points) Update the MPS record (by filling in the table on the next page), based on the given update. . Week 2 3 4 5 7 Forecast (F) Orders (0) Demand Projected Available Balance Net Requirements MPS ATP 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 Fand Ovalues from the interval [50, 100) for weeks t-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 integer value from the interval [50, 100]) in the inventory. The company uses a production batch size of B units (select an integer value from the interval [50, 100)). As a company policy, a safety stock of C units (select an integer value from the interval [5,20]) is hold for the end-item. A setup is incurred before production of cach batch. The setup cost per production run is $100 and the inventory carrying cost per week per product is $5 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 A B 2 3 4 5 6 Week Forecast (F) 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) (3 points) Compute total setup cost for the 6-week plan based on part a). c) (3 points) Compute total inventory holding cost for the 6-week plan based on part a). Suppose that, week I is over and the following events occurred during week 1: Actual demand during week 1 was 50. Marketing forecasted that 70 units will be demanded in week 7. There are no committed orders for week 7 yet. A new order of 40 units for week 2 was accepted, in addition to already committed orders. A new order of 20 units for week 3 was accepted, in addition to already committed orders. The forecasts for weeks 2 to 6 were not changed. The customer orders for weeks 4 to 6 were not changed. d) (2 points) Compute the beginning inventory for week 2, based on the given update. e) (16 points) Update the MPS record (by filling in the table on the next page), based on the given update. . Week 2 3 4 5 7 Forecast (F) Orders (0) Demand Projected Available Balance Net Requirements MPS ATP