OTB

Page 1

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


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.