This chart provides the variables and cost for each variable.

$\begin{array}{cc}\text{V}\text{a}\text{r}\text{i}\text{a}\text{b}\text{l}\text{e}\text{s}& \text{C}\text{o}\text{s}\text{t}\\ \text{I}\text{n}\text{v}\text{e}\text{n}\text{t}\text{o}\text{r}\text{y}\text{c}\text{a}\text{r}\text{r}\text{y}\text{i}\text{n}\text{g}cost& \text{\$}7\text{p}\text{e}\text{r}\text{u}\text{n}\text{i}\text{t}\text{p}\text{e}\text{r}\text{m}\text{o}\text{n}\text{t}\text{h}\\ \text{S}\text{u}\text{b}\text{c}\text{o}\text{n}\text{t}\text{r}\text{a}\text{c}\text{t}\text{i}\text{n}\text{g}cost& \text{\$}25\text{p}\text{e}\text{r}\text{u}\text{n}\text{i}\text{t}\\ \text{A}\text{v}\text{e}\text{r}\text{a}\text{g}\text{e}\text{p}\text{a}\text{y}\text{r}\text{a}\text{t}\text{e}& \text{\$}12\text{p}\text{e}\text{r}\text{h}\text{o}\text{u}\text{r}(8\text{h}\text{o}\text{u}\text{r}\text{s}\text{p}\text{e}\text{r}\text{d}\text{a}\text{y})\\ \text{O}\text{v}\text{e}\text{r}\text{t}\text{i}\text{m}\text{e}\text{p}\text{a}\text{y}\text{r}\text{a}\text{t}\text{e}& \text{\$}18\text{p}\text{e}\text{r}\text{h}\text{o}\text{u}\text{r}(above8\text{h}\text{o}\text{u}\text{r}\text{s}\text{p}\text{e}\text{r}\text{d}\text{a}\text{y})\\ \text{L}\text{a}\text{b}\text{o}\text{r}-\text{h}\text{o}\text{u}\text{r}\text{s}\text{n}\text{e}\text{e}\text{d}\text{e}\text{d}to\text{p}\text{r}\text{o}\text{d}\text{u}\text{c}\text{e}\text{o}\text{n}\text{e}\text{u}\text{n}\text{i}\text{t}& 1\mathrm{.}5\text{h}\text{o}\text{u}\text{r}\text{s}\text{p}\text{e}\text{r}\text{u}\text{n}\text{i}\text{t}\\ \text{U}\text{n}\text{i}\text{t}\text{s}\text{p}\text{e}\text{r}\text{d}\text{a}\text{y}\text{p}\text{r}\text{o}\text{d}\text{u}\text{c}\text{e}\text{d}& 50\\ \text{B}\text{e}\text{g}\text{i}\text{n}\text{n}\text{i}\text{n}\text{g}\text{i}\text{n}\text{v}\text{e}\text{n}\text{t}\text{o}\text{r}\text{y}& 0\\ \text{P}\text{l}\text{a}\text{n}\text{n}\text{e}\text{d}\text{e}\text{n}\text{d}\text{i}\text{n}\text{g}\text{i}\text{n}\text{v}\text{e}\text{n}\text{t}\text{o}\text{r}\text{y}& 0\\ \text{L}\text{o}\text{s}\text{t}\text{s}\text{a}\text{l}\text{e}\text{s}\text{p}\text{e}\text{r}\text{u}\text{n}\text{i}\text{t}& \text{\$}30\end{array}$

This chart provides the demand for the product and the number of production days per month.

$\backslash$table$[[$Months$,$Demand,Production Days$],[$January$,1200,22],[$February$,800,18],[$March$,600,21],[$April$,1500,21],[$May$,1300,22],[$June$,1200,20]]$

Complete the steps in each section and then submit your assignment for grading. Submit one spreadsheet containing a tab for each step.

Use the Excel OM Aggregate Planning spreadsheet and the data to prepare your aggregate plan. Prod

plan. The intent is to use a level strategy $($or level scheduling$)$ with no overtime, no safety stock, and n

Hint $1-$ Consider that it takes $1\mathrm{.}5$ hours to produce a unit when determining your cost per unit for ave

pay.

Hint $2-$ To determine regular time production, you need to multiply the units per day produced by the

production days.

Continue to Step $2$: Update Your Aggregate Plan Using Overtime

Step $2$: Update Your Aggregate Plan Using Overtime

In the plan produced in Step $1,$ the production rate did not meet the total demand. If you were able to

meet the shortfall, what would your aggregate plan look like?

Use the Excel OM Aggregate Planning spreadsheet and the data to prepare an updated aggregate pla

Continue to Step $3$: Update Your Aggregate Plan Using Outsourcing

Step $3$: Update Your Aggregate Plan Using Outsourcing

Instead of paying overtime, you might be able to outsource the shortfall in production. Use the Excel

Planning spreadsheet and the data to prepare an updated aggregate plan using outsources instead of