Please help on excel

Aserecrate Flandins Moblem Studem Namefo) 2. Whe Ohase haduction sertegr (1isie ald Fire) Estructiont Dackender fiample: meet the demand latel 1 Aggregrate Planning Problem Student Name(s): I have labeled the three worksheets below for your solutions. Use them in this same file and just change the file name to put your last name(s) 1. Use Level Production Strategy (Constant Production, 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 Instructions: 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 al 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 six 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 ( $203months=$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 monthl Keep in mind, Stockout means you lose the demand completely while backorder means you meet the demand latel \begin{tabular}{|l|l|} \hline \multicolumn{1}{|c|}{ Solution level (A) } & \multicolumn{1}{|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 \begin{tabular}{l} 1. Efficient use of Excel \\ 2. Acceptable use of Excel \end{tabular} & \\ \hline 3. Inappropriate and inefficient use of Excel & \\ \hline \end{tabular} the file name to put your last name(s) n below) que. swers in. I want to see your Excel skills also