Aggregrate Planning Problem Student Name$($s$)$: Kelly

Month Working Days Forcast Cost and other Data: Solution level $($A$)$ Overall Rubric

Jan $22700$ Current workforce size $25$ Full$-$time $1.$ Optimal solution to $10\%$ above optimal solution Min $($A$,$B$)=1$ Exceeds expectations

Feb $20850$ Inventory carrying cost $$10$ per unit$/$month $2.10\%-25\%$ above optimal solution Min $($A$,$B$)=2$ Meets expectations

Mar $23900$ Backorder cost $$20$ per unit$/$month $3.$ Over $25\%$ of the optimal solution Min $($A$,$B$)=3$ Does Not Meet expectations

Apr $221000$ Hiring and traning cost $$400$ per employee Level of Excel Usage $($B$)$

May $241250$ Lay$-$off cost $$300$ per employee $1.$ Efficient use of Excel

Jun $221350$ Regular Time Production $$200$ per unit $2.$ Acceptable use of Excel

Jul $231450$ Over$-$time capacity $30\%$ of Regular Time Production $3.$ Inappropriate and inefficient use of Excel

Aug $171300$ Over$-$time cost $$300$ per unit

Sept $211000$ Subcontracting capacity $500$ units per month

Oct $22880$ Subcontract Cost $$350$ per unit

Nov $20720$ Production rate $2$ units$/$worker$/$day

Dec $20600$ Ignore Idle time of employees, if any