Please show the steps clearly

(Before solving the question, select an integer value from the given interval, fill in the following table and copy it into your answer sheet) Parameter Interval Selected value D [1.000:5.000 D. [1.000: 5,0001 D (1.000:5.0001 D [1,000: 5.0001 Wo 130.501 we 12.000: 3.0001 HC [3.000, 3.5001 LC [4.000: 4.5001 [10.50 D IC PC [200.3001 N [100.2001 1 F100,5001 (100.3001 Determine the constant work force aggregate plan for the company by filling in the table on the next page (Do not write magie numbers, show your computations outside of the table. If some computations are similar to each other, then it is enough to show the way only the first one as an example) Quarter 1 2 3 Forecasted forecast Net demand Units/worker/quarter Workers needed (cumulative) Workers used Workers hired Workers laid-off Capacity Units produced Beginning inventory level Ending inventory level Average inventory level Production cost Labor cost Hiring cost Lay-off cost Inventory holding cost Workers needed (cumulative) Workers used Workers hired Workers laid-off Capacity Units produced Beginning inventory level Ending inventory level Average inventory level Production cost Labor cost Hiring cost Lay-off cost Inventory holding cost Quarterly total cost TOTAL COST OF THE PLAN 2. (50 points) Suppose that a manufacturer produces ten different models of washing machines which have common production processes. Currently, assume that it is the end of December. The manufacturer wants to make an aggregate production plan for the next four quarters. The marketing department has provided the forecasts of demand over the next four quarters, say D., D., D, and D, respectively. Assume that there are currently W. employees in the company. Each worker is paid SWC per cach quarter. Employees are hired for at least one full quarter. Hiring costs amount to SHC per employee cach quarter interval and lay-off costs are SLC per employee cach quarter. Inventory costs are SIC per washing machine per quarter. Suppose that, cach quarter it costs SPC to produce a washing machine. It is estimated that one worker produces N washing machines cach quarter. Assume that the company currently has lo washing machines in inventory and would like to end the last quarter with an inventory of washing machines Assume that it is a competitive market and customers are not willing to wait for backorders, hence backordering is not allowed. Assume that the manufacturer charges the inventory holding cost not based on ending inventory, but based on average inventory level where: average inventory level for period beginning inventory level of period t + ending inventory level of period (Before solving the question, select an intenet value from the given interval, fill in the following table and copy it into your answer sheet Parameter Interval Selected value D 1.000.000 D. TOMS (Before solving the question, select an integer value from the given interval, fill in the following table and copy it into your answer sheet) Parameter Interval Selected value D [1.000:5.000 D. [1.000: 5,0001 D (1.000:5.0001 D [1,000: 5.0001 Wo 130.501 we 12.000: 3.0001 HC [3.000, 3.5001 LC [4.000: 4.5001 [10.50 D IC PC [200.3001 N [100.2001 1 F100,5001 (100.3001 Determine the constant work force aggregate plan for the company by filling in the table on the next page (Do not write magie numbers, show your computations outside of the table. If some computations are similar to each other, then it is enough to show the way only the first one as an example) Quarter 1 2 3 Forecasted forecast Net demand Units/worker/quarter Workers needed (cumulative) Workers used Workers hired Workers laid-off Capacity Units produced Beginning inventory level Ending inventory level Average inventory level Production cost Labor cost Hiring cost Lay-off cost Inventory holding cost Workers needed (cumulative) Workers used Workers hired Workers laid-off Capacity Units produced Beginning inventory level Ending inventory level Average inventory level Production cost Labor cost Hiring cost Lay-off cost Inventory holding cost Quarterly total cost TOTAL COST OF THE PLAN 2. (50 points) Suppose that a manufacturer produces ten different models of washing machines which have common production processes. Currently, assume that it is the end of December. The manufacturer wants to make an aggregate production plan for the next four quarters. The marketing department has provided the forecasts of demand over the next four quarters, say D., D., D, and D, respectively. Assume that there are currently W. employees in the company. Each worker is paid SWC per cach quarter. Employees are hired for at least one full quarter. Hiring costs amount to SHC per employee cach quarter interval and lay-off costs are SLC per employee cach quarter. Inventory costs are SIC per washing machine per quarter. Suppose that, cach quarter it costs SPC to produce a washing machine. It is estimated that one worker produces N washing machines cach quarter. Assume that the company currently has lo washing machines in inventory and would like to end the last quarter with an inventory of washing machines Assume that it is a competitive market and customers are not willing to wait for backorders, hence backordering is not allowed. Assume that the manufacturer charges the inventory holding cost not based on ending inventory, but based on average inventory level where: average inventory level for period beginning inventory level of period t + ending inventory level of period (Before solving the question, select an intenet value from the given interval, fill in the following table and copy it into your answer sheet Parameter Interval Selected value D 1.000.000 D. TOMS