Six Month Plan

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