ssignment 2 Modified (Fall 2021)

Questions # 4 Modified Deliverables

(Using the demand & other data provided on Page 114 of your Textbook Please use this information

Questions # 14 Modified Deliverables

a. Propose a revised production plan that brings the days of supply to the target of 6(Six) 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 6(Six 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 (Theory Response)

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-ofsupply calculations are based on a 20-day month and that back orders are to be filled from current production. 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 othgy options are available to not exceed the 45employee limit and still not experience inventory shortages and related customer service problems? Cubby Compressors Sales and Operations Planning Spreadsheet 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-ofsupply calculations are based on a 20-day month and that back orders are to be filled from current production. 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 othgy options are available to not exceed the 45employee limit and still not experience inventory shortages and related customer service problems? Cubby Compressors Sales and Operations Planning Spreadsheet