insert Table Chart Text Shape Media Add Page Comment Planned Sales LY Stock Sales TY Actual Planned % of Plan Markdow LY Sales Curve (b) Increase vs LY (6) LY MDY'S Sales (0) Stock-Sales Ratio Ratio (1) Februar 5 40 12% 6% $ 600 2.26 2.25 19.00% March 22 5% $ 1,000 2.33 2.30 17% 6% April 2.66 $ 900 2.65 16% May 9% $ 882 2.10 2.12 20.00% 52 $ 22.00% 40 S 17.00% 40 $ 10.00% 50 $ 12.00% 53 $ June 19% 4% $ 1,111 2.02 2.00 July 14% 7% $ 666 2.17 2.15 Total 100% $ 5,159 275 9. Calculate average stock for LY and Plan h. Calculate season turnover for LY and Plan i. 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% 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 sty Numbers File Edit Insert Table Organize Format Arrange View Share Window Help Untitled 4 T Add Category Tale Chart Text with stole Media Convent 6 H C Last Year Plan Actual SIX-MONTH MERCHANDISING PLAN Department. Nama: Men's Shoes Department Number 495 int markop markdowns Ishration expense cash discount) 5. gross margin opening experte net ) on turnover average stock) IGURO (M) Merchandise Manager Buyer Period Spring SEASON TOTALS SALES FALL LYD FLS) February 5540 5582 March $1,007 $1,057 April 3778 $604 May $732 $798 June $850 $904 July 5641 5685 Actual Change (ACT. PLN NLY Sales 5600 3.10% 1200 12.00% $1.000 537% 22.00 2170 $800 9.17 17.00 17.00 SB2 10.54% 1600 16.45% $1,112 23 00 19.00% T 54 5660 2824 1400% 14199 EOM STOCK LYEOMBO BLEOMS Red MARKDOWNS LY Mare PL Mandows Ravisad AGB NLY BOM STOCK LYROM PLOM GY Format Autofi Formula A B U A 2 3 $ 4 5 6 & 7 8 8 C 9 Q W E R T Y insert Table Chart Text Shape Media Add Page Comment Planned Sales LY Stock Sales TY Actual Planned % of Plan Markdow LY Sales Curve (b) Increase vs LY (6) LY MDY'S Sales (0) Stock-Sales Ratio Ratio (1) Februar 5 40 12% 6% $ 600 2.26 2.25 19.00% March 22 5% $ 1,000 2.33 2.30 17% 6% April 2.66 $ 900 2.65 16% May 9% $ 882 2.10 2.12 20.00% 52 $ 22.00% 40 S 17.00% 40 $ 10.00% 50 $ 12.00% 53 $ June 19% 4% $ 1,111 2.02 2.00 July 14% 7% $ 666 2.17 2.15 Total 100% $ 5,159 275 9. Calculate average stock for LY and Plan h. Calculate season turnover for LY and Plan i. 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% 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 sty Numbers File Edit Insert Table Organize Format Arrange View Share Window Help Untitled 4 T Add Category Tale Chart Text with stole Media Convent 6 H C Last Year Plan Actual SIX-MONTH MERCHANDISING PLAN Department. Nama: Men's Shoes Department Number 495 int markop markdowns Ishration expense cash discount) 5. gross margin opening experte net ) on turnover average stock) IGURO (M) Merchandise Manager Buyer Period Spring SEASON TOTALS SALES FALL LYD FLS) February 5540 5582 March $1,007 $1,057 April 3778 $604 May $732 $798 June $850 $904 July 5641 5685 Actual Change (ACT. PLN NLY Sales 5600 3.10% 1200 12.00% $1.000 537% 22.00 2170 $800 9.17 17.00 17.00 SB2 10.54% 1600 16.45% $1,112 23 00 19.00% T 54 5660 2824 1400% 14199 EOM STOCK LYEOMBO BLEOMS Red MARKDOWNS LY Mare PL Mandows Ravisad AGB NLY BOM STOCK LYROM PLOM GY Format Autofi Formula A B U A 2 3 $ 4 5 6 & 7 8 8 C 9 Q W E R T Y
