NAMES
Please complete the entire plan for each department and the total division page. Goals are at bottom of total page Don't forget to show all the turn numbers and the sales and Inv % changes to LY on each page
Womens DEPARTMENT FALL PLAN 4/29/15 13:12
Knit Tops TOTAL SEASON
AUG
SEPT
OCT
NOV
DEC
JAN
FEB
INVENTORY RETAIL RECEIPTS RETAIL SALES RETAIL MARKDOWN RETAIL sales per week
$ 4,870,029.1 $ 16,200,000.00 $ 13,055,328.00 $ 4,389,562.96
$ 4,576,853 $ 2,300,000.00 $1,760,328.00 $ 123,222.96 $ 440,082.00
$ 4,993,302 $ 3,100,000.00 $ 2,310,000.00 $ 346,500.00 $ 462,000.00
$ 5,436,802 $ 3,200,000.00 $ 1,944,000.00 $ 505,440.00 $ 486,000.00
$ 6,187,362 $ 3,500,000.00 $ 2,461,000.00 $ 984,400.00 $ 615,250.00
$ 6,241,962 $ 1,850,000.00 $ 3,180,000.00 $ 1,590,000.00 $ 636,000.00
$ $ $ $ $
3,321,962 2,250,000.00 1,400,000.00 840,000.00 350,000.00
$
INVENTORY COST RECEIPTS COST SALES COST
$ $ $
$ 2,242,657.87 $ 759,000.00 $ 922,939.97
$ 2,078,717.90 $ 1,023,000.00 $ 1,105,904.33
$ 1,995,813.58 $ 1,056,000.00 $ 899,173.03
$ 2,152,640.54 $ 1,155,000.00 $ 1,198,686.60
$ 2,108,953.94 $ 610,500.00 $ 1,611,626.37
$ $ $
1,107,827.57 742,500.00 747,008.51
$ 1,103,319.06
INVENTORY UNITS RECEIPTS UNITS SALES UNITS INVENTORY PP RECEIPT PP SALES PP MARKDOWN % IMU% TURNOVER RETAIL TURNOVER UNITS SELLING MARGIN $ SELLING MARGIN % STOCK-TO-SALES SALES % TO LY Inv % to LY
1,827,132.92 5,346,000.00 6,485,338.81 95036 307,280 337437
$ $ $
51.29 52.72 38.69
95351 46000 39241 $ $ $
48.00 50.00 44.86
102110 59615 54324 $ $ $
48.90 52.00 42.52
107402 59259 48388 $ $ $
50.62 54.00 40.18
118273 62500 65860 $ $ $
52.31 56.00 37.37
114913 34906 87815 $ $ $
54.32 53.00 36.21
62004 45000 41809 $ $ $
53.58 50.00 33.49
33.6% 67.0% 2.68 3.55
7.0% 67.0%
15.0% 67.0%
26.0% 67.0%
40.00% 67.0%
50.00% 67.0%
60.00% 67.0%
$6,569,989.19 50.32%
$837,388.03 48%
$1,204,095.67 52%
$1,044,826.97 54%
$1,262,313.40 51%
$1,568,373.63 49%
$652,991.49 47%
0.37
2.60
2.16
2.80
2.51
1.96
2.37
5% 0%
4% -5%
5% -1%
8% 9%
7% 9%
6% 5%
0% -15%
3,331,962
65195
LY FALL ACTUAL Knit Tops
TOTAL SEASON
AUG
SEPT
OCT
NOV
DEC
JAN
FEB
INVENTORY RETAIL RECEIPTS RETAIL SALES RETAIL MARKDOWN RETAIL sales per week
$ $ $ $
4,858,571 15,690,000 12,400,000 4,410,000
$ $ $ $ $
4,800,000 2,100,000 1,700,000 170,000 425,000
$ $ $ $ $
5,030,000 2,610,000 2,200,000 440,000 440,000
$ $ $ $ $
5,000,000 3,000,000 1,800,000 540,000 450,000
$ $ $ $ $
5,660,000 3,480,000 2,300,000 920,000 575,000
$ $ $ $ $
5,920,000 2,500,000 3,000,000 1,500,000 600,000
$ $ $ $ $
3,920,000 2,000,000 1,400,000 840,000 350,000
$
3,680,000
INVENTORY COST RECEIPTS COST SALES COST
$ $ $
1,838,563 5,177,700 6,310,048
$ $ $
2,352,000 693,000 916,300
$ $ $
2,128,700 861,300 1,117,250
$ $ $
1,872,750 990,000 876,447
$ $ $
1,986,303 1,148,400 1,130,017
$ $ $
2,004,686 825,000 1,523,832
$ $ $
1,305,854 660,000 746,202
$
1,219,652
INVENTORY UNITS RECEIPTS UNITS SALES UNITS INVENTORY PP RECEIPTS PP SALES PP
94,859 297,061 325,657 $ $ $
MARKDOWN% IMU % TURNOVER RETAIL TURNOVER UNITS SELLING MARGIN $ SELLING MARGIN %
51.22 52.82 38.08
$ $ $
35.6% 67.0% 2.55 3.43 $
6,089,952 $ 49.11%
STOCK-TO-SALES
DEPARTMENT FALL PLAN
100000 42000 38,958 48.00 50.00 43.64
$ $ $
10.00% 67.0% 0.35 0.39 783,700 $ 46.1% 2.82
Woven Tops TOTAL
103042 50192 54,082 48.82 52.00 40.68
99152 55556 46,403 $ $ $
50.43 54.00 38.79
108305 62143 61,615 $ $ $
52.26 56.00 37.33
108833 47170 82,727 $ $ $
54.40 53.00 36.26
73275 40000 41,871 $ $ $
20.00% 67.0% 0.44 0.52
30.00% 67.0% 0.36 0.47
40.00% 67.0% 0.41 0.57
50.00% 67.0% 0.51 0.76
1,082,750 $ 49.2%
923,553 $ 51.3%
1,169,983 $ 50.9%
1,476,168 $ 49.2%
2.29
2.78
2.46
1.97
53.50 50.00 33.44 60.00% 67.0% 0.36 0.57 653,798 46.7% 2.80
71404
$
51.54
4/29/15 13:12
SEASON
AUG
SEPT
OCT
NOV
DEC
JAN
FEB
INVENTORY RETAIL RECEIPTS RETAIL SALES RETAIL MARKDOWN RETAIL sales per week
$ 3,728,144.50 $ 11,150,000.00 $ 8,897,485.00 $ 2,201,224.25
$ $
3,142,061 1,800,000 $1,208,485.00 $ 60,424.25 $ 302,121.25
$ 3,673,152 $ 2,150,000.00 $ 1,565,500.00 $ 187,860.00 $ 313,100.00
$ 4,069,792 $ 2,200,000.00 $ 1,442,000.00 $ 245,140.00 $ 360,500.00
$ 4,582,652 $ 2,500,000.00 $ 1,632,000.00 $ 408,000.00 $ 408,000.00
$ 5,042,652 $ 500,000.00 $ 2,249,500.00 $ 899,800.00 $ 449,900.00
$
2,393,352
$ $ $ $
2,000,000.00 800,000.00 400,000.00 200,000.00
INVENTORY COST RECEIPTS COST SALES COST
$ $ $
$ 1,539,609.89 $ 684,000.00 $ 621,765.53
$ 1,601,844.36 $ 817,000.00 $ 764,632.12
$ 1,654,212.23 $ 836,000.00 $ 685,756.86
$ 1,804,455.37 $ 950,000.00 $ 803,266.13
$ 1,951,189.24 $ 190,000.00 $ 1,218,581.13
$ $ $
922,608.11 760,000.00 462,585.46
1,527,705.98 4,237,000.00 4,556,587.25
INVENTORY UNITS RECEIPTS UNITS SALES UNITS INVENTORY PP RECEIPT PP SALES PP
74104 218,483 218639 $ $ $
50.46 51.03 40.69
MARKDOWN % IMU%
48.00 49.00 45.71
75759 43000 36163 $ $ $
48.48 50.00 43.29
82596 40741 34240 $ $ $
49.27 54.00 42.11
89096 45455 39662 $ $ $
51.43 55.00 41.15
94889 10000 59261 $ $ $
53.14 50.00 37.96
3,193,352
$ 1,220,022.64
45628 42553 22877 $ $ $
65304
52.45 47.00 34.97
5.0% 62.00%
12.0% 62.00%
17.0% 62.00%
25.00% 62.00%
40.00% 62.00%
50.00% 62.00%
$4,340,897.75 48.79%
$586,719.47 49%
$800,867.88 51%
$756,243.14 52%
$828,733.87 51%
$1,030,918.87 46%
$337,414.54 42%
2.64
2.60
2.35
2.82
2.81
2.24
2.99
1.69% -1%
0.71% -10%
1% -3%
3% 11%
2% 9%
2% 9%
0% -28%
2.39 2.95
SELLING MARGIN $ SELLING MARGIN %
STOCK-TO-SALES SALES % TO LY Inv % to LY
INVENTORY RETAIL
$ $ $
24.7% 62.00%
TURNOVER RETAIL TURNOVER UNITS
LY FALL ACTUAL Woven Tops
65460 36735 26436
$
TOTAL SEASON
$
3,752,571
AUG
$
3,500,000
SEPT
$
3,780,000
OCT
$
3,678,000
NOV
$
4,210,000
DEC
$
4,620,000
JAN
$
3,340,000
FEB
$
3,140,000
RECEIPTS RETAIL SALES RETAIL MARKDOWN RETAIL sales per week
$ $ $
10,702,500 8,750,000 2,312,500
$ $ $ $
1,600,000 1,200,000 120,000 300,000
$ $ $ $
1,680,500 1,550,000 232,500 310,000
$ $ $ $
2,212,000 1,400,000 280,000 350,000
$ $ $ $
2,410,000 1,600,000 400,000 400,000
$ $ $ $
1,800,000 2,200,000 880,000 440,000
$ $ $ $
1,000,000 800,000 400,000 200,000
INVENTORY COST RECEIPTS COST SALES COST
$ $ $
1,585,296 4,066,950 4,683,928
$ $ $
1,820,000 608,000 686,400
$ $ $
1,741,600 638,590 821,270
$ $ $
1,558,920 840,560 712,068
$ $ $
1,687,412 915,800 801,621
$ $ $
1,801,591 684,000 1,201,061
$ $ $
1,284,530 380,000 461,508
INVENTORY UNITS RECEIPTS UNITS SALES UNITS INVENTORY PP RECEIPTS PP SALES PP
74,557 208,321 218,385 $ $ $
MARKDOWN% IMU % TURNOVER RETAIL TURNOVER UNITS SELLING MARGIN $ SELLING MARGIN % STOCK-TO-SALES
DEPARTMENT
50.33 51.38 40.07
72917 32653 27,500 $ $ $
26.4% 62.00% 2.33 2.93 $
4,066,072 $ 46.47%
48.00 49.00 43.64
78070 33610 36815 $ $ $
10.00% 62.00% 0.34 0.38 513,600 $ 42.8% 2.92
BOTTOMS (pants, leggings, skirts)
48.42 50.00 42.10
74865 40963 34196 $ $ $
49.13 54.00 40.94
81632 43818 38780 $ $ $
51.57 55.00 41.26
86670 36000 57780 $ $ $
53.31 50.00 38.08
64890 21277 23314 $ $ $
15.00% 62.00% 0.41 0.47
20.00% 62.00% 0.38 0.46
25.00% 62.00% 0.38 0.48
40.00% 62.00% 0.48 0.67
728,730 $ 47.0%
687,932 $ 49.1%
798,379 $ 49.9%
998,939 $ 45.4%
2.44
2.63
2.63
2.10
$
51.47 47.00 34.31 50.00% 62.00% 0.24 0.36 338,492 42.3% 4.18
1,203,022
62853
$
49.96
FALL PLAN 4/29/15 13:12
TOTAL SEASON
AUG
SEPT
OCT
NOV
DEC
JAN
FEB
INVENTORY RETAIL RECEIPTS RETAIL SALES RETAIL MARKDOWN RETAIL sales per week
$ $ $ $
3,152,192.00 9,550,000.00 7,714,512.00 2,529,844.00
$ 2,730,000.00 $ 1,900,000 $ 1,050,000.00 $ 52,500.00 $ 262,500.00
$ 3,527,500.00 $ 1,850,000.00 $ 1,356,800.00 $ 217,088.00 $ 271,360.00
$ 3,803,612.00 $ 1,700,000.00 $ 1,284,000.00 $ 346,680.00 $ 321,000.00
$ 3,872,932.00 $ 2,100,000.00 $ 1,372,800.00 $ 549,120.00 $ 343,200.00
$ 4,051,012.00 $ 800,000.00 $ 1,870,912.00 $ 935,456.00 $ 374,182.40
$ $ $ $ $
2,044,644.00 1,200,000.00 780,000.00 429,000.00 195,000.00
INVENTORY COST RECEIPTS COST SALES COST
$ $ $
1,248,918.64 3,438,000.00 4,038,633.77
$ 1,337,700.00 $ 684,000.00 $ 540,225.00
$ 1,481,475.00 $ 666,000.00 $ 660,999.50
$ 1,486,475.50 $ 612,000.00 $ 637,280.00
$ 1,461,195.50 $ 756,000.00 $ 725,109.78
$ 1,492,085.72 $ 288,000.00 $ 1,033,653.23
$ $ $
746,432.50 432,000.00 441,366.27
INVENTORY UNITS RECEIPTS UNITS SALES UNITS INVENTORY PP RECEIPT PP SALES PP MARKDOWN %
50138 149,088 161746 $ $
62.99 $64.06 47.70
45500 30645 18375 $ $
60.00 $62.00 57.14
57770 28906 25776 $ $
61.06 $64.00 52.64
60901 26154 26109 $ $
62.46 $65.00 49.18
60945 30882 30244 $ $
63.55 $68.00 45.39
61584 12500 42663 $ $
65.78 $64.00 43.85
$ $
5.0%
16.0%
27.0%
40.00%
50.00%
55.00%
64.0%
64.0%
64.0%
64.0%
64.0%
64.0%
$3,675,878.23 47.65%
$509,775.00 48.55%
$695,800.50 51.28%
$646,720.00 50.37%
$647,690.22 47.18%
$837,258.77 44.75%
$338,633.73 43.41%
STOCK-TO-SALES
2.63
2.60
2.60
2.96
2.82
2.17
2.62
SALES % TO LY Inv % to LY
4.5% 6%
5.0% -9%
6.0% 7%
7.0% 18%
4.0% 15%
3.9% 14%
0% -1%
DEPT BOTTOMS (pants, leggings, skirts) LY FALL ACT. TOTAL BOTTOMS (pants, leggings, skirts) SEASON AUG
SEPT
OCT
NOV
DEC
737,066.23
32842
65.07 $60.00 41.98
32.8%
SELLING MARGIN $ SELLING MARGIN %
$
31421 20000 18579
64.00% 2.45 3.23
IMU% TURNOVER RETAIL TURNOVER UNITS
$ 2,035,644.00
JAN
FEB
INVENTORY RETAIL RECEIPTS RETAIL SALES RETAIL MARKDOWN RETAIL sales per week
$ $ $ $
2,981,857 9,300,000 7,380,000 2,573,000
$ $ $ $ $
3,000,000 1,400,000 1,000,000 100,000 250,000
$ $ $ $ $
3,300,000 1,472,000 1,280,000 256,000 256,000
$ $ $ $ $
3,236,000 1,702,000 1,200,000 360,000 300,000
$ $ $ $ $
3,378,000 2,026,000 1,320,000 528,000 330,000
$ $ $ $ $
3,556,000 1,200,000 1,800,000 900,000 360,000
$ $ $ $ $
2,056,000 1,500,000 780,000 429,000 195,000
$
2,347,000
INVENTORY COST RECEIPTS COST SALES COST
$ $ $
1,160,394 3,348,000 3,850,954
$ $ $
1,350,000 504,000 495,000
$ $ $
1,359,000 529,920 632,553
$ $ $
1,256,367 612,720 605,665
$ $ $
1,263,422 729,360 691,179
$ $ $
1,301,603 432,000 988,281
$ $ $
745,322 540,000 438,275
$
847,046
INVENTORY UNITS RECEIPTS UNITS SALES UNITS
47,570 145,309 157,245
50000 22581 18,333
54247 23000 25,250
51998 26185 25,067
53115 29794 29,058
53852 18750 40,889
31713 25000 18,648
INVENTORY PP RECEIPTS PP SALES PP
$62.68 $64.00 $46.93
$60.00 $62.00 $54.55
$60.83 $64.00 $50.69
$62.23 $65.00 $47.87
$63.60 $68.00 $45.43
$66.03 $64.00 $44.02
$64.83 $60.00 $41.83
MARKDOWN% IMU % TURNOVER RETAIL
34.9% 64.00% 2.47
10.00% 64.0% 0.33
20.00% 64.0% 0.39
30.00% 64.0% 0.37
40.00% 64.0% 0.39
50.00% 64.0% 0.51
55.00% 64.0% 0.38
3.31
0.37
0.47
0.48
0.55
0.76
0.59
TURNOVER UNITS SELLING MARGIN $ SELLING MARGIN %
$
3,529,046 $ 47.8%
505,000 $ 50.5%
STOCK-TO-SALES
DEPARTMENT FALL PLAN 4/29/15 13:12 INVENTORY RETAIL
647,447 $ 50.6%
3.00
TOTAL TOTAL SEASON $
11,750,366
2.58
AUG $
10,448,914
594,335 $ 49.5% 2.70
SEPT $ $
12,193,954 12,193,954
628,821 $ 47.6% 2.56
OCT $ $
13,310,206 13,310,206
811,719 $ 45.1% 1.98
NOV $ $
14,642,946 14,642,946
15,335,626 15,335,626
$61.66
341,725 43.8% 2.64
DEC $ $
38065
$ $
JAN 7,759,958 7,759,958
FEB $ $
8,560,958 8,560,958
RECEIPTS RETAIL SALES RETAIL MARKDOWN RETAIL sales per week
$ $ $
36,900,000 29,667,325 9,120,631
$ $ $ $
6,000,000 4,018,813 236,147 1,004,703
$ $ $ $
7,100,000 5,232,300 751,448 1,046,460
$ $ $ $
7,100,000 4,670,000 1,097,260 1,167,500
$ $ $ $
8,100,000 5,465,800 1,941,520 1,366,450
$ $ $ $
3,150,000 7,300,412 3,425,256 1,460,082
$ $ $ $
5,450,000 2,980,000 1,669,000 745,000
INVENTORY COST RECEIPTS COST SALES COST
$ $ $
4,603,758 13,021,000 15,080,560
$ $ $
5,119,968 2,127,000 2,084,931
$ $ $
5,162,037 2,506,000 2,531,536
$ $ $
5,136,501 2,504,000 2,222,210
$ $ $
5,418,291 2,861,000 2,727,063
$ $ $
5,552,229 1,088,500 3,863,861
$ $ $
2,776,868 1,934,500 1,650,960
219,278 674,851 717,822
$ $ $
206,311 113,380 84,051
$ $ $
235,639 131,522 116,263
$ $ $
250,898 126,154 108,737
$ $ $
268,315 138,837 135,765
$ $ $
271,386 57,406 189,739
$ $ $
139,053 107,553 83,266
$
53.59 54.68 41.33
$ $ $
50.65 52.92 47.81
$ $ $
51.75 53.98 45.00
$ $ $
53.05 56.28 42.95
$ $ $
54.57 58.34 40.26
$ $ $
56.51 54.87 38.48
$ $ $
55.81 50.67 35.79
$
52.41
$ $
FEB 9,167,000 9,167,000
INVENTORY UNITS RECEIPTS UNITS SALES UNITS INVENTORY PP RECEIPT PP SALES PP
$ $ $
MARKDOWN % IMU% TURNOVER RETAIL TURNOVER UNITS SELLING MARGIN $ SELLING MARGIN %
30.7% 64.71% 2.52 3.27 $
14,586,765 $ 49.17%
STOCK-TO-SALES SALES % TO LY Inv % to LY TOTAL LY FALL ACTUAL 4/29/15 13:12 INVENTORY RETAIL RECEIPTS RETAIL SALES RETAIL MARKDOWN RETAIL
14.4% 64.70% 0.43 0.49
23.5% 64.73% 0.35 0.43
35.5% 64.68% 0.37 0.51
46.9% 65.44% 0.48 0.70
1,933,882 $ 48.12%
2,700,764 $ 51.62%
2,447,790 $ 52.42%
2,738,737 $ 50.11%
3,436,551 $ 47.07%
2.33
2.85
2.68
2.10
2.60
4% 1%
3% -8%
4% 1%
6% 12%
5% 11%
4% 9%
0% -17%
11,593,000 35,692,500 28,530,000 9,295,500
$ $ $ $
11,300,000 5,100,000 3,900,000 390,000
$ $ $ $ $
SEPT 12,110,000 12,110,000 5,762,500 5,030,000 928,500
$ $ $ $ $
OCT 11,914,000 11,914,000 6,914,000 4,400,000 1,180,000
$ $ $ $ $
NOV 13,248,000 13,248,000 7,916,000 5,220,000 1,848,000
$ $ $ $ $
DEC 14,096,000 14,096,000 5,500,000 7,000,000 3,280,000
163340 163,340
1,329,040 44.60%
2.60
AUG
3,060,408 3,060,408
56.0% 64.50% 0.38 0.60
0.40
DIVISION TOTAL SEASON $ $ $ $
5.9% 64.55% 0.38 0.41
$ $
$ $ $ $ $
JAN 9,316,000 9,316,000 4,500,000 2,980,000 1,669,000
sales per week INVENTORY COST RECEIPTS COST SALES COST
$ $ $
INVENTORY UNITS RECEIPTS UNITS SALES UNITS INVENTORY PP RECEIPT PP SALES PP
STOCK-TO-SALES GOALS:
975,000
$
1,006,000
$
1,100,000
$
1,305,000
$
1,400,000
$
745,000
$ $ $
5,522,000 1,805,000 2,097,700
$ $ $
5,229,300 2,029,810 2,571,073
$ $ $
4,688,037 2,443,280 2,194,180
$ $ $
4,937,137 2,793,560 2,622,817
$ $ $
5,107,880 1,941,000 3,713,174
$ $ $
3,335,706 1,580,000 1,645,985
216,985 650,691 701,286 $ $ $
MARKDOWN % IMU% TURNOVER RETAIL TURNOVER UNITS SELLING MARGIN $ SELLING MARGIN %
4,584,254 12,592,650 14,844,930
$
53.43 54.85 40.68
222917 97234 84792 $ $ $
32.6% 64.72% 2.46 3.23 $
13,685,070 $ 47.97%
50.69 52.45 46.00
235359 106802 116146 $ $ $
51.45 53.95 43.31
226015 122703 105666 $ $ $
52.71 56.35 41.64
243052 135755 129453 $ $ $
54.51 58.31 40.32
249354 101920 181396 $ $ $
56.53 53.96 38.59
$ $ $
18.5% 64.78% 0.42 0.49
26.8% 64.66% 0.37 0.47
35.4% 64.71% 0.39 0.53
46.9% 64.71% 0.50 0.73
1,802,300 $ 46.21%
2,458,927 $ 48.89%
2,205,820 $ 50.13%
2,597,183 $ 49.75%
3,286,826 $ 46.95%
2.41
2.71
2.54
2.01
SALES INCREASE 4% $29,671,200.00 MARGIN % 48.6-50.5% MARKDOWNS: 29--31.% RETAIL TURN 2.52-2.65 Each BOM in the individual departments needs to be a DIFFERENT number from LY, but the starting Inv cost should be same mu% as Ly So the TOTAL DIVISION starting mu% may vary but the individual depts starting INV cost should be the same mu% it was LY
54.84 52.16 35.55 56.0% 64.89% 0.32 0.49 1,334,015 44.77%
3.13
3,269,720 3,269,720
172321 172321
169878 86277 83834
10.0% 64.61% 0.35 0.38
2.90
$ $
$
53.20
$13,055,328.00
$0.00 $1,760,328.00 1.035487059 $ 16,474,500.00
3660000
0.373030009
$ 16,474,500.00
51%
2.52
$8,901,360.00
$3,875.00
$7,714,512.00
$0.00
Bottoms $7,714,512.00
We figured these out based on the percentages of sales for last year. We decreased Woven tops by 1% and increased knit tops by 1% and multiplied it by g Wovens $8,901,360.00 Knit $13,055,328.00
s by 1% and multiplied it by goal total sales