Dollar Plan Assignment

profilePastel12
Assingment12AnswerKey.pdf

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