Last Year $$4,412$ $$5,672$ $$5,042$ $$5,987$ $$6,933$ $$3,466$

Plan First Step: plan sales $=$ last year sales $*(1+$sales increase$\%)$

Planned $\%$ of Season plan total season sales $=$ Feb plan sales $+$ March plan sales $+...+$ July plan sales

Revised Plan plan $\%$ of season $=$ monthly plan sales $/$ plan total season sales

Actual

EOM STOCK Last Year $$10,778$ $$11,093$ $$11,975$ $$11,786$ $$10,399$ $$12,353$ Third Step: EOM stock $=$ BOM stock of next month

Plan $$13,033$

Revised

Actual

REDUCTIONS Last Year $$221$ $$454$ $$303$ $$898$ $$1,387$ $$347$ Fourth step: plan reduction $=$ plan monthly sales $*\%$ of plan Markdown

Plan

Revised

Actual

$\%$ of Plan MD $5\%8\%6\%15\%20\%10\%$

BOM STOCK Last Year $$12,354$ $$10,777$ $$11,092$ $$11,974$ $$11,786$ $$10,398$ Second Step: plan BOM stock $=$ monthly plan sales $*$ stock$-$sales ratio

Plan

Revised

Actual

Stock$-$Sale Ratio $2\mathrm{.}81\mathrm{.}92\mathrm{.}22\mathrm{.}01\mathrm{.}73\mathrm{.}0$

PLANNED Last Year $$3,057$ $$6,442$ $$6,227$ $$6,697$ $$6,933$ $$5,768$ Fifth step: plan purchase at retail $=$ plan monthly sales $+$ EOM $+$ reduction $-$ BOM

PURCHASES Plan

AT RETAIL Revised

Actual

PLANNED Last Year $$1,681$ $$3,543$ $$3,425$ $$3,683$ $$3,813$ $$3,172$

PURCHASES Plan Sixth step: plan purchase at cost $=$ plan purchase at retail $*(1-$initial markup$\%)$

AT COST Revised

Actual