ou 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 hereis offered without any input data. That data is provided below, and you must enter it by hand into the spreadsheet. When solvingthis model, while the number of workers must be aninteger, the amounts of money, hours and items do not have to be integers. Thesolversettings can be seenhere.