Final Project
Department Women's Activewear
Spring February March April May
Sales $
Sales % to total Last Year $685.00 $790.00 $650.00 $800.00 Plan % Inc/Dec Revised Actual
Stock-Sales Ratio Last Year 6.1 5.8 6.7 6.3 Plan 6.1 5.8 6.7 6.3
BOM Stock $ (Retail)
Last Year $4,200.00 $4,600.00 $4,350.00 $5,000.00 Plan Revised Actual
Markdowns $
Last Year $229.00 $288.00 $254.00 $348.00 Plan % to Sales % by Month Revised Actual
Purchases $ (Retail)
Last Year $1,478.00 $828.00 $1,554.00 $1,548.00 Plan Revised Actual
Season Total LAST YEAR PLAN Sales $4,500.00 CMU % 68.5%
Markdown % 42.5% Gross Margin % 55.1% Average Stock 4664.3
Turnover 0.96
�1
Women's Activewear
June July August Season Total Greyed out sections are retained as an exemplar of this document in an authentic setting, but these sections are not to be filled in for this project.
$950.00 $625.00 $4,500.00
Student Note: The percentages will vary February through July based on your analysis of the case study, but will need to average to be 6.8 % in the season total.
5.7 6.9 5.7 6.9
$5,400.00 $4,300.00 $4,800.00 $4,664.30
$420.00 $375.00 $1,914.00
Student Note: The monthly percentages may vary. It is important the average is 46.1.
$270.00 $1,500.00 $7,178.00
ACTUAL
�2