Please use the Excel sheet provided, I just need the actual math portion figured out in the excel sheet.

Six Month Plan Project 100pts You first may choose your department as Juniors, Men's, Children's, or Home. I will provide you all with Last Year sales figures for a six-month plan. You will then plan your department up or down for the season by month. You must research how to figure your BOM stock by using a stock to sales ratio. You determine your BOM by using the provided S to S ration. Next you will plan your reductions by month with the overall provided Markdown percent. You will create the percent by month according to sales trends. (Ex. More markdowns are done in December due to Christmas) Finally you will figure your plan purchases using the plan purchases formula. Season MD Percent 36% Make sure you take into account all factors for your department. (Ex. Juniors back to school selling). You will need to research your department. You must turn the following items in: - 6-month plan worksheet - Write up by month explaining plan sales and plan markdown Remember you MAY NOT BE OVERBOUGHT. NO NEGATIVE NUMBERS. If you are it will be an automatic 0 . SIX-MONTH MERCHANDISE PLAN Spreadsheet 8-19 Chapter 8 Instructor Supplement Solution to Summary Problem \#19