Seasonality Calculation

Tayyabar

New Member
Joined
Dec 19, 2021
Messages
4
Office Version
  1. 2021
  2. 2019
  3. 2016
  4. 2013
Platform
  1. Windows
Yellow columns to be filled. Any help would be appreciated. Thank you
 

Attachments

  • excelProblem.png
    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.
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top