Please submit all 3 types in excel with formulas only Will upvote!! :D 
\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{3}{|c|}{ Aggregrate Planning Problem } & \multicolumn{2}{|l|}{ Student Name[s]: } & & & \\ \hline Month & orking Da & Forcast & Cost and & other Data: & Solution level [A] & & Overall Rubric \\ \hline Jan & 22 & 700 & Current workforce size & 25 Full-time & 1. Optimal solution to 10% above optimal solu & Min(A,B) & Erceeds expectations \\ \hline Feb & 20 & 850 & Inventory carrying cost & $10 per unitimonth & 2.10\%-25\% above optimal solution & Min(A,B) & Meets expectations \\ \hline Mar & 23 & 900 & Backorder cost & $20 per unitimonth & 3. Over 25% of the optimal solution & Min(A,B) & Does Not Meet expectations \\ \hline A.pr & 22 & 1000 & Hiring and traning cost & $400 per employee & Level of Excel Usage [B] & & \\ \hline May & 24 & 1250 & Lay-off cost & $300 per employee & 1. Efficient use of Excel & & \\ \hline Jun & 22 & 1350 & Regular Time Production & $200 per unit & 2. Acceptable use of Encel & & \\ \hline Jul & 23 & 1450 & Over-time capacity & 30% of Regular Time Productio & 3. Inappropriate and inefficient use of Excel & & \\ \hline Aug & 17 & 1300 & Over-time cost & $300 per unit & & & \\ \hline Sept & 21 & 1000 & Subcontracting capacity & 500 units per month & & & \\ \hline Dot & 22 & 880 & Subcontract Cost & $350 per unit & & & \\ \hline Nov & 20 & 720 & Production rate & 2 unitstworkerlday & & & \\ \hline Dec & 20 & 600 & lanore lde time of employ & es,if any & & & \\ \hline \end{tabular} I have labeled the three vorksheets below for gour solutions. Use them in this same file and just change the file name to put gour last name[s] 1. Use Level Production Strategy (Constant Froduction, will have inventory and backorder--see explanation below) 2. Use Chase Production strategy (Hire and Fire) 3. Use your unique strategy--a combination of different strategies--explain the strategy in a couple of sentences structions: 1. Solution for each strategy needs to be on different spreadsheets labeled below as Level, Chase and Unique. 2. Show the formulae and calculation for each strategy. In other words, cannot use calculator and type answers in. I want to see your Excel skills also. Backorder Example: Back Order is like negative inventory. Let's assume John Doe orders 10 tractors from a tractor dealer in the month of January. The retailer has only four to ship and is short by sin to meet the demand. The retailer met the demand for 4 tractors and had the remaining six on backorder. Let's assume that John received the tractor in April, three months after it was ordered. The tractor dealer incurred a backorder cost for 3 months ( $203 months =$60 per unit). Obviously, you cannot have inventory and backorders in the same month, just like you cannot have hiring and laying off in the same month! Keep in mind, Stockout means you lose the demand completely while backorder means you meet the demand late
