OTB FORMAT LIFSSTIL DEPARTMENT NAME WORKROOM COSTS CASH DISCOUNTS % SEASON STOCK T.O. AVERAGE STOCK MARKDOWN % MARKUP GOAL EMPLOYEE DISCOUNT SHRINKAGE FALL 2012
MONTH PERCENTAGE OF SALES BY MONTH LY PERCENTAGE OF SALES BY MONTH TY PERCENTAGE OF SALES BY MONTH % CHG
AUGUST
SEPTEMBER
OCTOBER
NOVEMBER
DECEMBER
PLAN TY 1% 8/10 net 30 1.01 $ 4,935,229 25% 65% 1% 10%
LY 1% 8/10 net 30 1.01 $ 4,840,000 25% 65% 1% 10%
JANUARY
TOTAL
3%
15%
19%
24%
25%
14%
100%
3%
15%
19%
24%
25%
14%
100%
0%
0%
0%
0%
0%
0%
$ 686,000 $ 700,000 2%
$ 4,900,000 $ 5,000,000 2%
0% #
1
SALES SALES DOLLARS $
LAST YR PLAN % HANGE RCEVISED
$ 147,000 $ 150,000 2%
$ 735,000 $ 750,000 2%
$ 931,000 $ 950,000 2%
$ 1,151,500 $ 1,200,000 4%
$ 1,225,000 $ 1,250,000 2%
STOCK BOM
LAST YEAR PLAN % CHANGE
$ 1,200,000 $ 1,224,000 2%
$ 2,200,000 $ 2,233,000 2%
$ 3,440,000 $ 3,508,800 2%
$ 5,200,000 $ 5,304,000 2%
$ 7,050,000 $ 6,900,000 $ 25,990,000 $ 7,191,000 $ 7,038,000 # $ 26,498,800 2% # 2% 2%
STOCK EOM
LAST YEAR PLAN % CHANGE
$ 2,200,000 $ 2,233,000 2%
$ 3,440,000 $ 3,508,800 2%
$ 5,200,000 $ 5,304,000 2%
$ 7,050,000 $ 7,191,000 2%
$ 6,900,000 $ 7,038,000 2%
$ 7,890,000 $ 8,047,800 2%
$ 32,680,000 $ 33,322,600 2%
MARKDOWNS
LAST YEAR PLAN % CHANGE
$ 36,750 $ 37,500 2%
$ 183,750 $ 187,500 2%
$ 232,750 $ 237,500 2%
$ 287,875 $ 300,000 4%
$ 306,250 $ 312,500 2%
$ 171,500 $ 175,000 2%
$ 1,225,000 $ 1,250,000 2%
EMPLOYEE DISCOUNT
LAST YEAR
$ 1,470
$ 7,350
$ 9,310
$ 11,515
$ 12,250
$ 6,860
$ 49,000
PLAN % CHANGE
$ 1,500 2%
$ 7,500 2%
$ 9,500 2%
$ 12,000 4%
$ 12,500 2%
$ 7,000 2%
$ 50,000 2%
WORKROOM
LAST YEAR PLAN % CHANGE
$ 1,470 $ 1,500 2%
$ 7,350 $ 7,500 2%
$ 9,310 $ 9,500 2%
$ 11,515 $ 12,000 4%
$ 12,250 $ 12,500 2%
$ 6,860 $ 7,000 2%
$ 49,000 $ 50,000 2%
SHRINK
LAST YEAR PLAN CHANGE %
$ 14,700 $ 15,000 2%
$ 73,500 $ 75,000 2%
$ 93,100 $ 95,000 2%
$ 115,150 $ 120,000 4%
$ 122,500 $ 125,000 2%
$ 68,600 $ 70,000 2%
$ 490,000 $ 500,000 2%
PURCHASES AT RETAIL
LAST YR PLAN % CHANGE
$ 798,610 $ 806,500 1%
$ 233,050 $ 237,710 2%
$ 484,530 $ 493,700 2%
$ 272,445 $ 243,000 -‐11%
$ 100,000 $ 100,000 0%
$ 50,180 # $ 1,938,815 $ 75,000 $ 1,955,910 49%
PURCHASES AT COST
LAST YEAR PLAN % CHANGE
$ 319,444.00 $ 322,600.00 1%
$ 93,220.00 $ 95,084.00 2%
$ 193,812.00 $ 197,480.00 2%
$ 108,978.00 $ 97,200.00 -‐11%
$ 40,000.00 $ 40,000.00 0%
$ 20,072.00 $ 30,000.00 49%
$ 775,526.00 $ 782,364.00 1%
MARKUP UP %
LAST YR PLAN % CHANGE
60% 60% 0%
60% 60% 0%
60% 60% 0%
60% 60% 0%
60% 60% 0%
60% 60% 0%
60% 60% 60%
ACTUAL MARKUP
LAST YR PLAN ACTUAL
60% 60% 0%
60% 60% 0%
60% 60% 0%
60% 60% 0%
60% 60% 0%
60% 60% 0%
60% 60% 0%
GM%
LAST YEAR PLAN % CHANGE
84% 84%
GMROI
LAST YEAR PLAN % CHANGE
2.13 2.13
ONLY TTL
TO
LAST YEAR PLAN % CHANGE
1.01 1.01
ONLY TTL
60%
ONLY TTL