Dollar Plan Assignment
Name Six- Month Plan (Basic Stock) Due Date
Season: Department: Buyer's Name:
Actual LY Plan TY Actual LY Plan TY
$5,527,116 $24,370,000 $26,319,600
21.00% 8.00%
61.98% $11,443,304
54.00% 2.3
6.00% $4,386,600
3.27 $7,056,704
Season: Aug/Feb Sep/March Oct/April Nov/May Dec/June Jan/July Season Totals
LY Sales ($)
% TT (LY)
TY Planned Sales ($) $3,421,548 $3,289,950 $3,553,146 $5,000,724 $6,711,498 $4,342,734 $26,319,600
% TT (Planned TY) 13.00% 12.50% 13.50% 19.00% 25.50% 16.50% 100.00%
LY Red ($)
% TT (LY)
TY Planned Red ($) $552,712 $497,440 $607,983 $884,339 $1,658,135 $1,326,508 $5,527,116
% TT (Planned TY) 10.00% 9.00% 11.00% 16.00% 30.00% 24.00% 100.00%
Red% (of $NS TY) 16.15% 15.12% 17.11% 17.68% 24.71% 30.55% 21.00%
Last Year ($)
Planned Year ($) $10,478,252 $10,346,654 $10,609,850 $12,057,428 $13,768,202 $11,399,438
Last Year ($)
Planned TY ($) $10,346,654 $10,609,850 $12,057,428 $13,768,202 $11,399,438 $12,230,000
LY Purchases @R ($)
TY Planned ($) $3,842,662 $4,050,586 $5,608,707 $7,595,837 $6,000,869 $6,499,803 $33,598,464
LY Purchases @C ($)
TY Planned ($) $1,460,847 $1,539,892 $2,132,236 $2,887,673 $2,281,322 $2,471,000 $12,772,970
OO @R $25,000 $20,300 $17,630 $25,170 $25,390 $13,480
OO @C $9,504 $7,717 $6,702 $9,569 $9,652 $5,125
OTB @R $3,817,662 $4,030,286 $5,591,077 $7,570,667 $5,975,479 $6,486,323
OTB @C $1,451,342 $1,532,175 $2,125,533 $2,878,105 $2,271,670 $2,465,875
Leave LY's cells Blank
Fill This Year's Cells
PLANNED
PURCHASES
PLANNED
PURCHASES
ON ORDER
OPEN TO BUY
GMROI Basic Stock
SALES
BOM STOCK
REDUCTIONS
EOM STOCK
Initial Mark-up % Average Retail Stock
GM% Stock Turnover
Profit% Average Monthly Sales
Total Retail Reductions $ Net Sales (Seasonal)
Total Retail Reductions % Sales Change (%) over LY