14. Cubby Compressors has had relatively steady sales volume for years. The introduction of a new high-end "biscuit" model for the professional contractor market has added the potential for additional sales. The operations manager is also concerned about losing sales if product is not readily available. The current sales and operations plan is given below. Assume all days-of- supply calculations are based on a 20-day month and that back orders are to be filled from current production. Sales Forecast a. Propose a revised production plan that brings the days of supply to the target of five days for the next six months. Actual Diff, month Diff. cumulative 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? Cubby Compressors Sales and Operations Planning Spreadsheet History Oct Nov Dec c. What other options are available to not exceed the 45-employee limit and still not experience inventory shortages and related customer service problems? (in million $) (in units) (in units) 0.60 0.63 850 900 800 826 851 949 26 0.56 1 27 49 76 Plan Jan Feb Apr May Jun 0.63 0.63 0.63 0.63 0.63 0.63 900 900 900 900 900 900 Mar