The sport dress classification of a specialty store was given the following figures to use in developing a merchandise plan for the spring/summer season: Month August September October November December January % of Season's Sales 14.5 16.5 19.5 17.0 16.0 16.5 BOM Stock-Sales Ratio 3.8 4.2 4.0 % of Season Markdowns 16.3 14.8 15.3 15.6 16.8 21.2 3.3 3.7 3.6 Develop a merchandise plan, using the form provided on the following page. (a) Distribute total season's sales of $860,000 over each month. (b) Calculate monthly dollar markdowns and total season dollar markdowns if the planned season markdown percent is 14.6% (c) Plan BOM stock values. (d) Enter EOM values. Use $510,000 for the January EOM. (e) Calculate monthly planned purchases at retail. (f) Calculate monthly planned purchases at cost if the initial markup percent is 52%. (g) Calculate turnover for the season. Last Year Plan Actal SIX-MONTH MERCHANDISING PLAN Department Name: il markup maridowns shention perse Soos discount gross maris operating pense Department Number: Merchandise Manager Buyer: Season trover vene stock GUROS Period: SEASON At Szember Nomber December Janar TOTALS SALES 170047 EOM STOCK MARKDOWNS FALL LY Sales PL Sales Revised Actual % Change % of LY Sales % of PL Sales LY EOM Stock PLEOM Stock Revised Actual LY Markdowns PL Markdowns Revised Actual % Change W of LY Markdowns % of PL Markdowns LY BOM Stock PL BOM Stock Revised Actual LY Stock/Sales Radio PL Stock Sales Ratio LY Purchases Retail PL Purchases Retail Revised Actual LY Purchases Cost PL Purchases @ Cost Revised Actual BOM STOCK PLANNED PURCHASES AT RETAIL PLANNED PURCHASES AT COST AUTHORIZATION DATE: AUTHORIZATION SIGNATURES: Buyer Merchandise Manager Controller The Dollar Merchandise Plan The sport dress classification of a specialty store was given the following figures to use in developing a merchandise plan for the spring/summer season: Month August September October November December January % of Season's Sales 14.5 16.5 19.5 17.0 16.0 16.5 BOM Stock-Sales Ratio 3.8 4.2 4.0 % of Season Markdowns 16.3 14.8 15.3 15.6 16.8 21.2 3.3 3.7 3.6 Develop a merchandise plan, using the form provided on the following page. (a) Distribute total season's sales of $860,000 over each month. (b) Calculate monthly dollar markdowns and total season dollar markdowns if the planned season markdown percent is 14.6% (c) Plan BOM stock values. (d) Enter EOM values. Use $510,000 for the January EOM. (e) Calculate monthly planned purchases at retail. (f) Calculate monthly planned purchases at cost if the initial markup percent is 52%. (g) Calculate turnover for the season. Last Year Plan Actal SIX-MONTH MERCHANDISING PLAN Department Name: il markup maridowns shention perse Soos discount gross maris operating pense Department Number: Merchandise Manager Buyer: Season trover vene stock GUROS Period: SEASON At Szember Nomber December Janar TOTALS SALES 170047 EOM STOCK MARKDOWNS FALL LY Sales PL Sales Revised Actual % Change % of LY Sales % of PL Sales LY EOM Stock PLEOM Stock Revised Actual LY Markdowns PL Markdowns Revised Actual % Change W of LY Markdowns % of PL Markdowns LY BOM Stock PL BOM Stock Revised Actual LY Stock/Sales Radio PL Stock Sales Ratio LY Purchases Retail PL Purchases Retail Revised Actual LY Purchases Cost PL Purchases @ Cost Revised Actual BOM STOCK PLANNED PURCHASES AT RETAIL PLANNED PURCHASES AT COST AUTHORIZATION DATE: AUTHORIZATION SIGNATURES: Buyer Merchandise Manager Controller The Dollar Merchandise Plan
