i need all the steps to put it in this excel sheet

2. Using last year's figures for a stereo entertainment department, plan a 5% decrease for this year, maintaining the same monthly sales percent's, the same stock-to-sale ratios, and the same markdown precents as last year. Last year's fall season figures were as follows (Round to the whole number.) Month August September October November December January Sales Volume $68,250 $126,000 $105,000 $89,250 $84,000 $52,500 BOM Stocks $128,475 $190,675 $198,250 $157,150 $157.150 $122,500 Markdowns $ 1.000 $ 1.500 $ 2,000 $ 2,500 S 7.500 $ 1,700 Last year's departmental markup was 42%, First, fill in last year's information on the six- month plan form and analyze the following statistics: (54 points.) Monthly sales percentages by month Last year's stock-to-sales ratio Last year's total markdown percentage Last year's monthly markdown percentage Then, Calculate last year's and this year's monthly purchases at retail and cost. Calculate last year's and this year's average stock and the stock turnover rate. Then using that information as the foundation, apply the percent of decrease to the overall sales and develop a plan with the same percents. Total Avg. Stock 20 Six Month Merchandise Plan 11 Department Name 12 From February 13 To: July 21 14 Department Financial Data 15 LY 26 17 rutal MUS 18 Markdown 29 Shrinkage 16 20 Worlroom Cost 21 Cash Discount) 22 Gross Margin) 23 Average Stock 24 Turnover Rate 25 26 27 Six Month Merchandise Plan Spring February March April June May July Fall August September October November December January LY Sales LY Monthly Sales TY Plan Monthly Sale TY Plan TY Plan Sales LY BOMS LY EOMS Stock/Sales Ratio TY Plan BOM TY Plan EOM LY Markdowns LY Monthly MD: TY Plan Monthly MDX TY Planned MDS LY Purchases at Retail TY Plan Purchase of Retail ILY Purchases at Cost TYPlan Purchase at Cost 23 +