Level and chase and unique please

Actererate Hamsing hellem Stadem hamela) 9 We Chate froturtion itraterv pere and fire ? sabouder comple liater Aggregrate Planning Problem Student Name(s): \begin{tabular}{|c|c|c|} \hline Month & Working Days & Forcast \\ \hline Jan & 22 & 700 \\ \hline Feb & 20 & 850 \\ \hline Mar & 23 & 900 \\ \hline Apr & 22 & 1000 \\ \hline May & 24 & 1250 \\ \hline Jun & 22 & 1350 \\ \hline Jul & 23 & 1450 \\ \hline Aug & 17 & 1300 \\ \hline Sept & 21 & 1000 \\ \hline Oct & 22 & 880 \\ \hline Nov & 20 & 720 \\ \hline Dec & 20 & 600 \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ Cost and other Data: } \\ \hline Current workforce size & 25 Full-time \\ \hline Inventory carrying cost & $10 per unit/month \\ \hline Backorder cost & $20 per unit/month \\ \hline Hiring and traning cost & $400 per employee \\ \hline Lay-off cost & $300 per employee \\ \hline Regular Time Production & $200 per unit \\ \hline Over-time capacity & 30% of Regular Time Production \\ \hline Over-time cost & $300 per unit \\ \hline Subcontracting capacity & 500 units per month \\ \hline Subcontract Cost & $350 per unit \\ \hline Production rate & 2 units/worker/day \\ \hline ignore Idle time of employees, if any \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} \hline \multicolumn{1}{|c|}{ Solution level (A) } & \multicolumn{2}{|c|}{ Overall Rubric } \\ \hline 1. Optimal solution to 10% above optimal solution & Min (A,B)=1 & Exceeds expectations \\ \hline 2. 10%25% above optimal solution & Min(A,B)=2 & Meets expectations \\ \hline 3. Over 25\% of the optimal solution & Min(A,B)=3 & Does Not Meet expectations \\ \hline \multicolumn{1}{|c|}{ Level of Excel Usage (B) } & & \\ \hline 1. Efficient use of Excel & & \\ \hline 2. Acceptable use of Excel & & \\ \hline 3. Inappropriate and inefficient use of Excel & & \\ \hline \end{tabular} Back Order is the negative inventory. Let's ausume fohn Doe orders 10 tractors fiom a tractor dealer in the month of ianuary. The retaler has only four to ship and is short by sx to meet the demand. The retaler met the demand for 4 tractors and had the remainine sir an backorder. Let's asume that /ohn received the tractae in Aprib three months after it was ordered. The tractor dealer incurred a backorder cont for 3 manths ($20) months $60 per unit). Obviously, vou cannot in mind, stockout means you lose the demand completely while backorder means vou meet the demand latel