Zoom Add Page oble COOL TORE Snope MOOI uominent Planned Sales LY Stock Sales TY Actual Planned Stock-Sales Ratio % of Plan Mardow NE LY Sales Curve (b) Increase LYC) LY MD's Sales (0) Ration Februar y 12 6% $ 600 2.26 225 19.00% 40 $ 20.00% 52 March 22% 5% $ 1.000 239 2.30 April 17% 8% $ 900 2.66 2.65 $ 40 22.00% May 10% 9% $ 882 2.12 2.10 17.00% 40 June 19% 4% $ 50 $ 1,111 2.02 2.00 10.00% July 75 $ 666 217 2.15 12.00% 53 Total 100% $ 275 $ 5,150 g. Calculate average stock for LY and Plan h. Calculate season turnover for LY and Plan 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 A D )) Numbers Fle Edit Insert Table Organize Format Arrange View Share Window Help Untitled 4 End T Ad Category Tatuite Chart Test Sune with a 121 Comment SIX-MONTH MERCHANDISING PLAN Last Year Plan Actual Department Name: Marsh Department Number: 435 Merchandise Manager intimkop i mandows Stones cash dont gross margis) operating expense ) net proft soon mover average stock OMRO FALL February SALES March 31001 3549 SEASON TOTALS April 5778 $424 May 5732 5798 June $809 $904 July $641 51.053 AT PUD 1900 3.10% 12.00 12 DON $1.000 537 22.00% 219 1900 9.17 17.00 $382 10:54 16.00 18:45 31 112 23.00% 19009 18 64% $680 2.82 14 00N EOM STOCK 1700 LYOU PLEOM 14134 Actu DOWNS A SO LY DOMO esc Format Autofi Formula B IA 2 3 $ 4 5 6 7 8 9 Zoom Add Page oble COOL TORE Snope MOOI uominent Planned Sales LY Stock Sales TY Actual Planned Stock-Sales Ratio % of Plan Mardow NE LY Sales Curve (b) Increase LYC) LY MD's Sales (0) Ration Februar y 12 6% $ 600 2.26 225 19.00% 40 $ 20.00% 52 March 22% 5% $ 1.000 239 2.30 April 17% 8% $ 900 2.66 2.65 $ 40 22.00% May 10% 9% $ 882 2.12 2.10 17.00% 40 June 19% 4% $ 50 $ 1,111 2.02 2.00 10.00% July 75 $ 666 217 2.15 12.00% 53 Total 100% $ 275 $ 5,150 g. Calculate average stock for LY and Plan h. Calculate season turnover for LY and Plan 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 A D )) Numbers Fle Edit Insert Table Organize Format Arrange View Share Window Help Untitled 4 End T Ad Category Tatuite Chart Test Sune with a 121 Comment SIX-MONTH MERCHANDISING PLAN Last Year Plan Actual Department Name: Marsh Department Number: 435 Merchandise Manager intimkop i mandows Stones cash dont gross margis) operating expense ) net proft soon mover average stock OMRO FALL February SALES March 31001 3549 SEASON TOTALS April 5778 $424 May 5732 5798 June $809 $904 July $641 51.053 AT PUD 1900 3.10% 12.00 12 DON $1.000 537 22.00% 219 1900 9.17 17.00 $382 10:54 16.00 18:45 31 112 23.00% 19009 18 64% $680 2.82 14 00N EOM STOCK 1700 LYOU PLEOM 14134 Actu DOWNS A SO LY DOMO esc Format Autofi Formula B IA 2 3 $ 4 5 6 7 8 9
