You need to calculate:

a. the sales dollars per month

b. the stock to sales ratio per month

c. the turnover rate for the season

What is highlighted in BLUE is given to you, you must complete all cells given to you in Yellow.

AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER JANUARY SALES FALL Last Year Plan Planned % of Season SEASON TOTAL $132,000 $140,000 100.0% 16.0% 17.0% 13.0% 18.0% 22.0% 14.0% Istila EOM STOCK 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Plan $48,000 $35,000 $50,400 $63,000 $39,200 $32,500 MARKDOWNS (Reductions) Plan $3,724 $3,920 $4,312 $3,332 $1,960 $2,352 $19,600 % of Plan MD 19.0% 20.0% 22.0% 17.0% 10.0% 12.0% 100.0% BOM STOCK Plan $45,800 $48,000 $35,000 $50,400 $63,000 $39,200 37 38 39 UN CONM Humanon Plan Stock/Sales Ratio PLANNED PURCHASES @ Plan RETAIL 13 PLANNED PURCHASES @ Plan COST rationale + 6 month plan Ready Normal View Sumo Plan Actual 14.0% 1.3% %IMU % Reductions % MMU % Alt Exp % Cash Discount % Gross Margin % Expenses % Net Profit Turnover Avg Stock Basic Stock 44.9% 7.4%