Final Project

[Your Name] FMM 225

[Replace all bracketed content with your own.]

[Presentation Title] 


Department: Women’s dresses [Add an image to the right to add visual excitement to your analysis.]

Six-Month Spring Plan

● Calculate the monthly percentage of sales for last year. ● Calculate the total planned season sales. What will the sales be by month taking

into account the Easter shift?

Monthly Sales

Spring February March April May June July August Season Total

Sales $

Sales % to total                

Last Year $685.00 $790.00 $650.00 $800.00 $950.00 $625.00   $4,500.00

Plan                

% Inc/Dec                

Revised                

Actual                

● Calculate the planned markdown dollars and percentage by month.

Planned Markdown

Spring February March April May June July August Season Total

Markdowns $

Last Year $229.00 $288.00 $254.00 $348.00 $420.00 $375.00   $1,914.00

Plan                

% to Sales                

% by Month                

Revised                

Actual                

● HINT: Keeping stock-sales ratio consistent: Multiply the new sales plan by the stock-sales ratio for each month.

● Calculate the receipt dollars needed to achieve the BOM stock. ● HINT: Take next month BOM + current month sales + current month

markdowns - current month BOM for both “Last Year” and “Plan”.

BOM Stock Needed by Month

Spring February March April May June July August Season Total

Stock-Sales Ratio Last Year 6.1 5.8 6.7 6.3 5.7 6.9    

Plan                

BOM Stock $ (Retail)

Last Year $4,200.00 $4,600.00 $4,350.00 $5,000.00 $5,400.00 $4,300.00 $4,800.00 $4,664.30

Plan                

Revised                

Actual                

● On this slide: [Explain the rationale behind the monthly percentages calculated for the planned monthly sales.] [Explain the rationale behind the planned mark down percentages by month.]

Summary and Recommendations

● On this slide:  [Evaluate whether there is sufficient inventory at the beginning of each month to achieve your sales plan, and explain why or why not.]

Summary and Recommendations

● On this slide: [Explain how the buyer should address their concern regarding sales potentially slowing down. Use data and examples to support your response.]

Summary and Recommendations

● On this slide: [Explain how the buyer should address inventory levels with an increase in sales. Use data and examples to support your response.]

Summary and Recommendations

● On this slide: [Examine the potential effect of a higher markdown percentage on gross margin.]

Summary and Recommendations