How is the Purchases $ Retail plan calculated?

 

Department Spring Sales $ Stock-Sales Ratio BOM Stock $ (Retail) Markdowns $ Purchases $ (Retail) Sales CMU% Markdown % Gross Margin % Average Stock Turnover 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 Plan Revised Actual Women's Activewear February March April May June July 15.22222 17.55556 14.44444 17.77778 21.11111 13.88889 $685.00 $790.00 $650.00 $800.00 $950.00 $625.00 $731.58 $843.72 $694.20 $854.40 $1,014.60 $667.50 6.80% 6.80% 6.80% 6.80% 6.80% 6.80% 6.1 6.1 5.8 5.8 6.7 6.7 LAST YEAR $4,500.00 68.5% 42.5% 6.3 6.3 46.10% 46.10% 46.10% 46.10% 55.1% 4664.3 0.96 $4,200.00 $4,600.00 $4,350.00 $5,000.00 $5,400.00 $4,300.00 $4,800.00 $4,462.64 $4,893.58 $4,651.14 $5,382.72 $5,783.22 $4,605.75 $229.00 $288.00 $254.00 $348.00 $420.00 $375.00 $105.57 $132.77 $117.09 $160.43 $193.62 $172.88 $1,478.00 $828.00 $1,554.00 $1,548.00 5.7 5.7 PLAN 6.9 6.9 46.10% 46.10% August $270.00 $1,500.00 ACTUAL Season Total 100 $4,500.00 $4,806.00 6.80% 6.25 6.25 $4,664.30 $4,963.17 $1,914.00 $882.35 46.10% $7,178.00