Planned Sales TY Actual LY Stock- Sales Planned % of Plan LY Sales Curve (b) Increase vs. LY (6) Sales (0) Ratio Stock-Sales Ratio Markdow ns Februar LY MO's $ 40 12% 6% $ 600 2 26 2.25 19.00% March 22% 5% $ 1,000 2.33 2.30 20.00% $ 52 April 17% 6% $ 900 2.66 2.65 22.00% 40 May 16% 9% $ 882 2.12 2.10 17.00% $ 40 June 19% 4% $ $ 1,111 2.02 2.00 10.00% 50 $ 53 July 14% 7% $ 666 2.17 2.15 12.00% Total 100% $ 5,159 $ 275 9. Calculate average stock for LY and Plan h. Calculate season turnover for LY and Plan 1. Calculate planned markdowns, given total markdowns for the season are $250 Calculate % markdowns for LY and Plan (top grid), and the percentage each month represents of the total (main grid) k. Calculate initial markup for LY and Plan, given the following information: LY Plan Operating Expense 35.00% 35.00% Net Profit 8.55% 10.00% Alteration Expense 0.00% 0.00% Cash Discounts 5.00% 5.00% 1. Calculate Gross Margin % for LY and Plan m. Calculate GRMOI for LY and Plan n. Calculate LY purchases at retail o Calculate planned purchases as retail p. Calculate LY purchases at cost 4. Calculate planned purchases as cost I tv Numbers File Edit Insert Table Organize Format Arrange View Share Window Help Untitled 4 Edited Ve Loon Insert Table Chart Shape Media Comment SIX-MONTH MERCHANDISING PLAN Last Year Plan Actual Department Name Men's shoes Department Number: 15 Merchandise Manager in map (K) markedowns Station expense cash discount) gross margin operating expense net proto son tumove it! average stock to GNROL Parade WALL SALES SEASON TOTALS 1519 February March April May LY June July 5549 51001 $778 57:32 5669 5641 124 Raised 3788 565 Act $500 31000 Norge ACT 31 Dec 19 235 $900 $882 $600 LYS 92.00% decrea82 22.00% SOS 1700 1600% 1900 12.00 14004 LYEOM 21.79% 18.04 14134 LEOS EOM STOCK MARKDOWN LYM Raad Change OLY SOM STOCH LYBOS IVANRED MacBook Pro 2 3 $ 4 % 5 0 > & 7 8 C 9 Q W E 20 T Y U Planned Sales TY Actual LY Stock- Sales Planned % of Plan LY Sales Curve (b) Increase vs. LY (6) Sales (0) Ratio Stock-Sales Ratio Markdow ns Februar LY MO's $ 40 12% 6% $ 600 2 26 2.25 19.00% March 22% 5% $ 1,000 2.33 2.30 20.00% $ 52 April 17% 6% $ 900 2.66 2.65 22.00% 40 May 16% 9% $ 882 2.12 2.10 17.00% $ 40 June 19% 4% $ $ 1,111 2.02 2.00 10.00% 50 $ 53 July 14% 7% $ 666 2.17 2.15 12.00% Total 100% $ 5,159 $ 275 9. Calculate average stock for LY and Plan h. Calculate season turnover for LY and Plan 1. Calculate planned markdowns, given total markdowns for the season are $250 Calculate % markdowns for LY and Plan (top grid), and the percentage each month represents of the total (main grid) k. Calculate initial markup for LY and Plan, given the following information: LY Plan Operating Expense 35.00% 35.00% Net Profit 8.55% 10.00% Alteration Expense 0.00% 0.00% Cash Discounts 5.00% 5.00% 1. Calculate Gross Margin % for LY and Plan m. Calculate GRMOI for LY and Plan n. Calculate LY purchases at retail o Calculate planned purchases as retail p. Calculate LY purchases at cost 4. Calculate planned purchases as cost I tv Numbers File Edit Insert Table Organize Format Arrange View Share Window Help Untitled 4 Edited Ve Loon Insert Table Chart Shape Media Comment SIX-MONTH MERCHANDISING PLAN Last Year Plan Actual Department Name Men's shoes Department Number: 15 Merchandise Manager in map (K) markedowns Station expense cash discount) gross margin operating expense net proto son tumove it! average stock to GNROL Parade WALL SALES SEASON TOTALS 1519 February March April May LY June July 5549 51001 $778 57:32 5669 5641 124 Raised 3788 565 Act $500 31000 Norge ACT 31 Dec 19 235 $900 $882 $600 LYS 92.00% decrea82 22.00% SOS 1700 1600% 1900 12.00 14004 LYEOM 21.79% 18.04 14134 LEOS EOM STOCK MARKDOWN LYM Raad Change OLY SOM STOCH LYBOS IVANRED MacBook Pro 2 3 $ 4 % 5 0 > & 7 8 C 9 Q W E 20 T Y U
