PLEASE DO THE WORK ON EXCEL AND PROVIDE ALL FORMULAS USED AND SHOW ALL WORK.

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?

Cubby Compressors Sales and Operations Planning Spreadsheet