Fall $20-$ AUG. SEPT. OCT. NOV. DEC. JAN.

SALES

Last year $30,03017,16017,16027,17030,03021,450$ $ $143,000$

Plan

Percent of total $0\mathrm{.}210\mathrm{.}120\mathrm{.}120\mathrm{.}190\mathrm{.}210\mathrm{.}15$

Actual

RETAIL

STOCK $($BOM$)$

Last year $108,10875,50475,504108,680108,10885,800$ $ $561,704$

Plan

STS $3\mathrm{.}64\mathrm{.}44\mathrm{.}44\mathrm{.}03\mathrm{.}64\mathrm{.}0$

Actual

RETAIL

REDUCTIONS

Last year $7,2642,5432,9062,1791,8161,453$ $ $18,161$

Plan $($dollars$)$

Plan $($percent$)0\mathrm{.}400\mathrm{.}140\mathrm{.}160\mathrm{.}120\mathrm{.}100\mathrm{.}08$

Actual

RETAIL

STOCK $($EOM$)$

Last year $75,50475,504108,680108,10885,80065,600$ $ $519,196$

Plan $65,600$

Actual

RETAIL

PURCHASES

Last year $4,69019,70353,24228,7779,5382,703$ $ $118,653$

Plan

Revised

Comments:$*$Ending Stock$=65,600$

Merchandise Manager $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ Buyer $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ Controller $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Directions:

$1$ Freeze first $8$ rows

$2$ Format sales $\%($D$11$:I$11)$ and reductions $\%($D$19$:I$19)$to a percentage including total $(0$ decimal places$)$

$3$ Use a function or formula to calculate total sales $\%($cell J$11)$ and total reductions $\%($cell J$19)$ and make sure the cell is formatted as a $\%$

$4$ Convert STS to $2$ decimal places

$5$ Calculate plan total sales $($cell J$10).$ Percent increase is $($cell J$6)$

$6$ Use a function or formula to calculate plan monthly sales $($cell D$10-$I$10).$ Format the cells as accounting, zero decimals and NO $ sign

$7$ Calculate retail reduction percent of last year sales and enter into cell K$6$

$8$ Calculate plan total retail reductions $($cell J$18)$ using percent calculated in cell K$6.$

$9$ Use a function or formula to calculate plan monthly retail reductions $($cells D$18-$I$18).$ Format the cells as accounting, zero decimals and NO $ sign

$10$ Use a function or formula to calculate BOM stock $($cells D$14-$I$14)$ and make sure that the cells are formtted as accounting, zero decimals and NO $

$11$ Use a function or formula to calculate EOM stock $($cells D$22-$I$22)$ and make sure the cells are formatted as accounting, zero decimals and NO $

$12$ Use a function or formula to calculate Purchases $($cells D$25-$I$25)$ and make sure the cells are formatted as accounting, zero decimals and NO $

$13$ Use a function or formula to calculate total BOM stock $($J$14),$ total EOM stock $($J$22),$ and total purchases $($J$25)$ and make sure the cells are formatted as accounting, zero decimals and i