please solve this operation management problem. use appropriate methods and show it properly.

3. With a relatively steady sales volume for years, a new product was introduced for potential additional sales. Losing sales is a concern, if product is not readily available. The current sales and operations plan is given below. Assume 20-day month for all days of supply calculations and that back orders are to be filled from current production. Plan History Nov Oct Dec Jan Feb Mar Apr May Jun Sales Forecast (in million $) (in units) (in units) 0.63 900 0.63 900 0.63 900 0.63 900 0.63 900 0.63 900 0.56 800 826 26 Actual Diff. month Diff. cumulative 0.60 850 851 1 27 0.63 900 949 49 76 800 34 23 800 42 19 800 42 19 900 45 20 900 43 21 900 39 23 900 45 20 900 41 22 900 41 22 Operations Plan (in units) (in employees) Number working days/mo. Actual (in units) Diff. month Diff. cumulative Inventory Plan (in units) (in 1,000 $) Actual (in units) Days of supply 758 -42 842 42 0 824 24 24 -52 0 -52 0 52 0 -52 0 -52 0 -52 0 150 74 82 2.3 100 49 73 1.6 0 0 -52 -1.0 a. Propose a revised production plan that brings the days of supply to the target of five days for the next six months. b. What would the plan look like if you had a hiring freeze at 45 employees maximum and still want to achieve the target five days of supply? c. What other options are available to not exceed the 45-employee limit and still not experience inventory shortages and related customer service problems? Screenshot 2022-05-15 at 00.08.33 3. With a relatively steady sales volume for years, a new product was introduced for potential additional sales. Losing sales is a concern, if product is not readily available. The current sales and operations plan is given below. Assume 20-day month for all days-of supply calculations and that back orders are to be filled from current production History Nov Plan Mar Apr May Oct Dec Jan Feb Jun Sales Forecast (in million ) (in units) (in units) 0.63 900 0.63 900 0.63 900 0.63 900 0.63 900 0.56 800 826 26 0.63 900 Actual Diff, month Diff. cumulative 0.60 850 851 1 27 0.63 900 949 49 76 800 34 23 800 42 19 800 42 19 900 45 20 900 43 21 900 39 23 900 45 20 900 41 22 900 41 22 Operations Plan (in units) (in employees) Number working days/mo. Actual (in units) Diff. month Diff. cumulative Inventory Plan (in units) (in 1,000 5) Actual in units) Days of supply 758 42 842 42 0 824 24 24 150 74 -52 0 100 49 73 1.6 -52 0 ? 52 0 ? 0 0 -52 -1.0 ? 52 0 -52 0 -52 0 82 2.3 a. Propose a revised production plan that brings the days of supply to the target of five days for the next six months. b. What would the plan look like if you had a hiring freeze at 45 employees maximum and still want to achieve the target five days of supply? c. What other options are available to not exceed the 45-employee limit and still not experience inventory shortages and related customer service problems? 3. With a relatively steady sales volume for years, a new product was introduced for potential additional sales. Losing sales is a concern, if product is not readily available. The current sales and operations plan is given below. Assume 20-day month for all days of supply calculations and that back orders are to be filled from current production. Plan History Nov Oct Dec Jan Feb Mar Apr May Jun Sales Forecast (in million $) (in units) (in units) 0.63 900 0.63 900 0.63 900 0.63 900 0.63 900 0.63 900 0.56 800 826 26 Actual Diff. month Diff. cumulative 0.60 850 851 1 27 0.63 900 949 49 76 800 34 23 800 42 19 800 42 19 900 45 20 900 43 21 900 39 23 900 45 20 900 41 22 900 41 22 Operations Plan (in units) (in employees) Number working days/mo. Actual (in units) Diff. month Diff. cumulative Inventory Plan (in units) (in 1,000 $) Actual (in units) Days of supply 758 -42 842 42 0 824 24 24 -52 0 -52 0 52 0 -52 0 -52 0 -52 0 150 74 82 2.3 100 49 73 1.6 0 0 -52 -1.0 a. Propose a revised production plan that brings the days of supply to the target of five days for the next six months. b. What would the plan look like if you had a hiring freeze at 45 employees maximum and still want to achieve the target five days of supply? c. What other options are available to not exceed the 45-employee limit and still not experience inventory shortages and related customer service problems? Screenshot 2022-05-15 at 00.08.33 3. With a relatively steady sales volume for years, a new product was introduced for potential additional sales. Losing sales is a concern, if product is not readily available. The current sales and operations plan is given below. Assume 20-day month for all days-of supply calculations and that back orders are to be filled from current production History Nov Plan Mar Apr May Oct Dec Jan Feb Jun Sales Forecast (in million ) (in units) (in units) 0.63 900 0.63 900 0.63 900 0.63 900 0.63 900 0.56 800 826 26 0.63 900 Actual Diff, month Diff. cumulative 0.60 850 851 1 27 0.63 900 949 49 76 800 34 23 800 42 19 800 42 19 900 45 20 900 43 21 900 39 23 900 45 20 900 41 22 900 41 22 Operations Plan (in units) (in employees) Number working days/mo. Actual (in units) Diff. month Diff. cumulative Inventory Plan (in units) (in 1,000 5) Actual in units) Days of supply 758 42 842 42 0 824 24 24 150 74 -52 0 100 49 73 1.6 -52 0 ? 52 0 ? 0 0 -52 -1.0 ? 52 0 -52 0 -52 0 82 2.3 a. Propose a revised production plan that brings the days of supply to the target of five days for the next six months. b. What would the plan look like if you had a hiring freeze at 45 employees maximum and still want to achieve the target five days of supply? c. What other options are available to not exceed the 45-employee limit and still not experience inventory shortages and related customer service problems