Question
When the buyer for the activewear department started to develop the merchandise plan for the spring season, she reviewed the six-month plan in Figure 35.
When the buyer for the activewear department started to develop the merchandise plan for the spring season, she reviewed the six-month plan in Figure 35. The numbers that were achieved represent the departments 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.0%
Planned markdown % 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-Easter 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 activewear department, formulate the six-month plan:
1. Calculate each months percentage of sales for last year.
2. Calculate the total season sales planned. What will the planned sales be by
month taking into account the Easter shift?
3. Calculate the planned markdown dollars and percentage by month.
4. Calculate the BOM stock needed by month.
5. Calculate the receipt dollars needed to achieve the BOM stock.
6. Does this plan achieve the desired turnover necessary?
7. How will a buyer achieve the increased cumulative markup percentage?
What is the potential effect on gross margin given the higher markdown
percentage?
8.How should the buyer address her concern regarding sales potentially slowing down?
Figure 35. sing Plan for Women's Activewear Department Women's Activewear SPRING FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEASON TOTAL Sales % to total Last Year 685.0 790.0 650.0 800.0 950.0 625.0 4,500.0 Plan SALES $ STOCK-SALES RATIO 6.1 5.8 6.7 6.3 5.7 6.9 BOM STOCK $ (Retail) $ 4,200.0 4,600.0 4,350.0 5,000.0 5,400.0 4,300.0 4,800.0 4,664.3 MARKDOWNS $ % Inc/Dec Revised Actual Last Year Plan Last Year Plan Revised Actual Last Year Plan % to Sales % by Month Revised Actual Last Year Plan Revised Actual $ 229.0 288.0 254.0 348.0 420.0 375.0 1,914.0 100.0% $ 1,478.0 828.0 1,554.0 1,548.0 270.0 1,500.0 7.178.0 PURCHASES $ (Retail) PLAN ACTUAL SEASON TOT. Sales CMU % Markdown % Gross Margin % Average Stock Turnover LAST YEAR $4,500.00 68.5% 42.5% 55.1% 4,664.3 0.96 Figure 35. sing Plan for Women's Activewear Department Women's Activewear SPRING FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEASON TOTAL Sales % to total Last Year 685.0 790.0 650.0 800.0 950.0 625.0 4,500.0 Plan SALES $ STOCK-SALES RATIO 6.1 5.8 6.7 6.3 5.7 6.9 BOM STOCK $ (Retail) $ 4,200.0 4,600.0 4,350.0 5,000.0 5,400.0 4,300.0 4,800.0 4,664.3 MARKDOWNS $ % Inc/Dec Revised Actual Last Year Plan Last Year Plan Revised Actual Last Year Plan % to Sales % by Month Revised Actual Last Year Plan Revised Actual $ 229.0 288.0 254.0 348.0 420.0 375.0 1,914.0 100.0% $ 1,478.0 828.0 1,554.0 1,548.0 270.0 1,500.0 7.178.0 PURCHASES $ (Retail) PLAN ACTUAL SEASON TOT. Sales CMU % Markdown % Gross Margin % Average Stock Turnover LAST YEAR $4,500.00 68.5% 42.5% 55.1% 4,664.3 0.96Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started