Using Excel answer the following questions

SEASONALITY ASSIGNMENT

1) Determine if this SKU is Seasonal or not by graphing

2) Then Determine future profiles and future forecast as needed.

SKU

Basic Yoga Crop Pant

Company ID

EST

DC ID

NO NONE

Source ID

5720

HT

Lululemon

Store ID

004

Union Square

Style

325

Color

BLACK

Period

1

2

3

4

5

6

7

8

9

10

11

12

13

12/22

1/19

2/16

3/16

4/13

5/11

6/8

7/6

8/3

8/31

9/28

10/26

11/23

Summary

2016

19

25

21

20

18

19

16

17

19

21

23

19

17

254

2017

22

19

23

19

12

17

19

23

20

16

15

18

15

238

2018

16

18

19

21

15

20

18

19

18

20

19

17

21

241

2019

17

12

18

22

20

89

Composite

18

19

20

21

18

19

17

19

19

19

18

18

18

243

Profile

Demand

Exception Graph

Seasonality Graph

Adjustment Graph

Demand Table

Multiple Graphs

Demand Forecast

Order Control Factors

Manual Control

4.22

Weekly

93.4

Svc Gl

L-Lumpy

Sys Cls

W-Watch

Buyer Class

18.45

4-Weekly

100.0

Attained

23

SSTF

Demand

57.76

Quarterly

55

OUTL

88

OTLD

Buyer Max

229.24

Yearly

27

IOP

83

SOPD

2

Buyer Min

0

Trend

24

Track

51.9

MADP

0

Manual SS

A - Active

Assortment Code

0

Min Pres Stock