When the buyer for the activewear department started to develop the merchandise plan for the Spring season, they reviewed the six-month on the next sheet. The numbers that were achieved represent the department's performance last year for a fast-selling and up-trending department. The buyer was given the following information to plan the upcoming Spring season:

Planned Sales : +4% Planned Markdowns % : 45.1% Planned Turnover: 0.98 Cumulative Markup %: 68.7%

For next Spring, the buyer has to take into account a shift in Easter selling. Last year, Easter occurred on the first Sunday in April; therefore, pre-Ester sales happened the last two weeks in March. This year, Easter falls in the third week of April.

Based on the sales success this department has experienced over the last two years, the buyer is concerned about keeping that trend going.

Acting as the buyer for the acrivewear department, formulate the six-month plan:

TO EARN FULL CREDIT, I NEED TO ANSWER ALL OF THE FOLLOWING QUESTIONS, IN EXCEL SPREADSHEET FORM. I HAVE PROVIDED THE EXCEL SPREADSHEET PICTURE, AND NEED TO KNOW NOT ONLY THE ANSWER PUT THE FORMULA FOR EACH INPUT. THANKS IN ADVANCE.

Here are the things you will be solving on the spreadsheet:

a. Calculate each month's percentage of sales for last year. b. Calculate the total season sales planned. What will the planned sales by by taking into account the Easter shift. c. Calculate the planned markdown dollars and percentage by month. d. Calculate the BOM stock needed by month. e. Calculate the receipts dollars needed to achieve the BOM stock.

here is the spreadsheet.

Plan for Women's Activewear Figure 35. SA-MU Department Women's Activewear SPRING FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEASON TOTAL 6850 790.0 650.0 800.0 9600 625.0 4,500.0 SALESS STOCK-SALES RATIO 6.1 5.8 6.7 6.3 5.7 6.9 $4,200.0 BOM STOCK $ (Retail) 4,600.0 4,350.0 5,000.0 5,400,0 4,300.0 4.800.0 4,664.3 Sales %to total Last Year Plan % Inc/Dec Revised Actual Last Year Plan Last Year Plan Revised Actual Last Year Plan % to Sales by Month Revised Actual Last Year Pan Revised Actual MARKDOWNSS $ 229,0 288.0 254.0 348.0 375.0 1914.0 100.0% $1,478.0 828.0 1,554.0 1,5480 270.0 1.500.0 7.178.0 PURCHASESS (Retail) PLAN ACTUAL SEASON TOT Sales CMU % Markdown % Gross Margin% Average Stock Turnover LAST YEAR $4,500.00 68.5% 425% 55.1% 4,664.3 0.98 Plan for Women's Activewear Figure 35. SA-MU Department Women's Activewear SPRING FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEASON TOTAL 6850 790.0 650.0 800.0 9600 625.0 4,500.0 SALESS STOCK-SALES RATIO 6.1 5.8 6.7 6.3 5.7 6.9 $4,200.0 BOM STOCK $ (Retail) 4,600.0 4,350.0 5,000.0 5,400,0 4,300.0 4.800.0 4,664.3 Sales %to total Last Year Plan % Inc/Dec Revised Actual Last Year Plan Last Year Plan Revised Actual Last Year Plan % to Sales by Month Revised Actual Last Year Pan Revised Actual MARKDOWNSS $ 229,0 288.0 254.0 348.0 375.0 1914.0 100.0% $1,478.0 828.0 1,554.0 1,5480 270.0 1.500.0 7.178.0 PURCHASESS (Retail) PLAN ACTUAL SEASON TOT Sales CMU % Markdown % Gross Margin% Average Stock Turnover LAST YEAR $4,500.00 68.5% 425% 55.1% 4,664.3 0.98