# Seasonality Calculation

#### Tayyabar

##### New Member
Yellow columns to be filled. Any help would be appreciated. Thank you

#### Attachments

• excelProblem.png
72.9 KB · Views: 8

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Welcome to the MrExcel board!

You must think that we are very clever to know what all those headings mean and how to calculate each value.

So, as well as giving some detailed explanations, it would also likely get you more helpers if you make it a bit easier for them. For that you could investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out large amounts of sample data to test with.

SC Planner Test.xlsx
BCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
2
3Sales History QTYWhat is What is the expected ForecastClassifyWhat is the
4Article DescriptionPriceVolum CBMAvailable DateSepOctNovDecJanFebMarAprMayJunJulAugSales PatternSep FRC QTYOct FRC QTYNov FRC QTYLead Time DaysOH Stock QTYPipe Line QTYABCSafety stock QTYWhat to order QTYWhen to order
5 Nightstand Silver220.3955-Jan-19331876141524773995462770904554
6 Nightstand Black150.3095-Jan-197614463164209204166720113305490121145
7 Drawer Black 1270.6845-Jan-199341816484219133132018902530
8 Drawer Black 2421.0245-Jan-1926473042504382162491519903441
9 Dresser Black190.2875-Jan-1972811283941331433913902125
10 Drawer Silver 1300.7105-Jan-19414201111111912190110901214
11 Drawer Silver 2451.0305-Jan-19910322319326323231029901822
12 Dresser Silver200.2535-Jan-19107156606142521517901214
13 Buffet Black351.0165-Jan-194127131014133244181810901720
14 Tv Stand Grey480.53610-Jul-210000000000009067
15 TV Stand White540.52212-Jun-210000000000639067
16 Chair Light Blue40.10714-Jul-210000000000010901012
17 Chair Pink40.10714-Jul-210000000000022902226
18 Chair Black 120.05414-Jul-210000000000050905060
19 Chair Black 240.13214-Jul-210000000000033903340
20 Chair Red40.13214-Jul-210000000000013901316
21 Chair Black 340.0975-Jul-210000000000034903441
22 Chair Black 440.1205-Jul-210000000000010901012
23 Chair Grass Green40.1205-Jul-210000000000029067
24 Chair Orange40.1205-Jul-210000000000019067
25
Planning

Welcome to the MrExcel board!

You must think that we are very clever to know what all those headings mean and how to calculate each value.

So, as well as giving some detailed explanations, it would also likely get you more helpers if you make it a bit easier for them. For that you could investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out large amounts of sample data to test with.
Hi i attached a mini sheet. Sorry, this is my first time going through the forum. This is a job interview question and i am required to fill the yellow columns. so far i guess that it is concerned with seasonalibity calculation.

SC Planner Test.xlsx
BCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
2
3Sales History QTYWhat is What is the expected ForecastClassifyWhat is the
4Article DescriptionPriceVolum CBMAvailable DateSepOctNovDecJanFebMarAprMayJunJulAugSales PatternSep FRC QTYOct FRC QTYNov FRC QTYLead Time DaysOH Stock QTYPipe Line QTYABCSafety stock QTYWhat to order QTYWhen to order
5 Nightstand Silver220.3955-Jan-19331876141524773995462770904554
6 Nightstand Black150.3095-Jan-197614463164209204166720113305490121145
7 Drawer Black 1270.6845-Jan-199341816484219133132018902530
8 Drawer Black 2421.0245-Jan-1926473042504382162491519903441
9 Dresser Black190.2875-Jan-1972811283941331433913902125
10 Drawer Silver 1300.7105-Jan-19414201111111912190110901214
11 Drawer Silver 2451.0305-Jan-19910322319326323231029901822
12 Dresser Silver200.2535-Jan-19107156606142521517901214
13 Buffet Black351.0165-Jan-194127131014133244181810901720
14 Tv Stand Grey480.53610-Jul-210000000000009067
15 TV Stand White540.52212-Jun-210000000000639067
16 Chair Light Blue40.10714-Jul-210000000000010901012
17 Chair Pink40.10714-Jul-210000000000022902226
18 Chair Black 120.05414-Jul-210000000000050905060
19 Chair Black 240.13214-Jul-210000000000033903340
20 Chair Red40.13214-Jul-210000000000013901316
21 Chair Black 340.0975-Jul-210000000000034903441
22 Chair Black 440.1205-Jul-210000000000010901012
23 Chair Grass Green40.1205-Jul-210000000000029067
24 Chair Orange40.1205-Jul-210000000000019067
25
Planning

Replies
4
Views
141
Replies
1
Views
89
Replies
8
Views
191
Replies
0
Views
464
Replies
9
Views
610

1,203,760
Messages
6,057,202
Members
444,913
Latest member
ILGSE

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back