Unpaid order, please place your bids mini cases must include the following: 1) a formal memo addressed to your boss that includes answers to the questions detailed in the case and 2) the completed data spreadsheet that you used to answer the questions. I have attached a spreadsheet template that will help you with your analysis. You only need to enter data/calculations in the yellow highlighted cells. DO NOT alter the spreadsheet. If you feel like you need to alter the spreadsheet to answer the questions, you are not doing it correctly. Also, please note that all calculated numbers must include the formula in that cell (e.g., C4-C5) rather than calculating the number elsewhere and then inputting the number manually. If the cell does not include the formula, you will not be given credit for the analysis even if your numbers are correct.