You are working for Dire Wolf Industries $($DWI$),$ helping them run their Sales & Operations Planning $($S&OP$)$ program for a line of make to stock items. Specifically, you are running the aggregate planning model to help assist the Chief Operating Officer $($COO$)$ and the Vice President of Sales to agree upon the next $12$ months plan.

The aggregate model is attached here. The model provided here is offered without any input data. That data is provided below, and you must enter it by hand into the spreadsheet. When solving this model, while the number of workers must be an integer, the amounts of money, hours and items do not have to be integers. The solver settings can be seen here.