Scribd
Upload
26 views25 pages

Round 1

The document provides a detailed overview of various products, their market shares, growth rates, customer satisfaction (CSAT) scores, and pricing information. It includes forecasts for production and inventory, as well as performance metrics across different market segments. Additionally, it highlights trends in customer satisfaction across various product categories.

Uploaded by

vikas joshi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
26 views25 pages

Round 1

The document provides a detailed overview of various products, their market shares, growth rates, customer satisfaction (CSAT) scores, and pricing information. It includes forecasts for production and inventory, as well as performance metrics across different market segments. Additionally, it highlights trends in customer satisfaction across various product categories.

Uploaded by

vikas joshi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 25

Product Segment Period Previous Round

Total market share 5426


Growth rate 16
Product market share 18
Ark Elite
CSAT 0.344537815126
Andrew Forecasr
Price 28
Total market share 6976
Growth rate 11
Product market share 26
Able Thrift
CSAT 0.248927038627
Andrew Forecasr
Price 21
Total market share 8886
Growth rate 10
Product market share 18
Acre Core
CSAT 0.156779661017
Andrew Forecasr
Price 38
Total market share 5,405
Growth rate 14
Product market share 19
Awe Nano
CSAT 0.170818505338
Andrew Forecasr
Price 33
Total market share 5426
Growth rate 16
Product market share 15
Axe elite
CSAT 0.394957983193
Andrew Forecasr
Price 33
Total market share 5,405
Growth rate 14
Product market share 17
Awf Nano
CSAT 0.213523131673
Andrew Forecasr
Price 33
Total market share 5426
Growth rate 16
Product market share 17
Arc Elite
CSAT 0.260504201681
Andrew Forecasr
Price 33
Next Round 2 3 4 5 6
6294.16 7301.2256 8469.421696 9824.52917 11396.4538 13219.8864
1467.546346 1702.353761 1974.73036 2290.68722 2657.19718
1132.9488

1523.292504 1973.171557 2288.879006 2655.09965 3079.91559 3572.70209


27.5 27 26.5 26 25.5 25
7743.36 8595.1296 9540.593856 10590.0592 11754.9657 13048.0119
1727.62105 1917.659365 2128.6019 2362.7481 2622.6504
2013.2736

2706.922487 2322.851831 2578.365533 2861.98574 3176.80417 3526.25263


20.5 20 19.5 19 18.5 18
9774.6 10752.06 11827.266 13009.9926 14310.9919 15742.091
2161.16406 2377.280466 2615.00851 2876.50936 3164.1603
1759.428

2365.617479 2905.766803 3196.343484 3515.97783 3867.57562 4254.33318


37.5 37 36.5 36 35.5 35
6161.7 7024.338 8007.74532 9128.82966 10406.8658 11863.827
1411.891938 1609.556809 1834.89476 2091.78003 2384.62923
1170.723

1574.081345 1898.342102 2164.109996 2467.0854 2812.47735 3206.22418


32.5 32 31.5 31 30.5 30
6294.16 7301.2256 8469.421696 9824.52917 11396.4538 13219.8864
1467.546346 1702.353761 1974.73036 2290.68722 2657.19718
944.124

1269.41042 1973.171557 2288.879006 2655.09965 3079.91559 3572.70209


32.5 32 31.5 31 30.5 30
6269.8

1065.866

1433.097143
32.5
6294.16

1070.0072

1438.665143
32.5
7 8 Stock Out
15335.0683 17788.6792
3082.34872 3575.52452
market share down
csat very up
4144.33442 4807.42793 no
24.5 24
14483.2932 16076.4555
2911.14194 3231.36755
market share slight down
csat down
3914.14042 4344.69587 no
17.5 17
17316.3002 19047.9302
3480.57633 3828.63396
market up
csat down
4679.76649 5147.74314 Yes
34.5 34
13524.7628 15418.2296
2718.47733 3099.06415
market slight up
csat slight down
3655.09556 4166.80894 no
29.5 29
15335.0683 17788.6792
3082.34872 3575.52452
mark up
csat shoot
4144.33442 4807.42793
29.5 29

mar up
csat shoot
Awf- nano
Arc elite

mark up
csat drop
Product Actual forecast Marketing forecast @90%

Ark 1523 1370.7

Able 2706 2435.4

Acre 2365 2128.5

Awe 1574 1416.6

1269 1142.1
Axe

1433 1289.7
Awf

1438 1294.2
Arc
Production forecast @120%Inventory on Hand

1644.84 0

2922.48 0

2554.2 0

1699.92 619

1370.52 0

1547.64 0

1553.04 0
Adjusted Production

1644.84

2922.48

2554.2

1080.92

1370.52

1547.64

1553.04
Segment Spot
Thrift Core
Round Thrift Performance Thrift Size Core Performance
0 6 14.1 7.7
1 6.5 13.6 8.5
2 7 13.1 9.3
3 7.5 12.6 10.1
4 8 12.1 10.9

Ideal Spot
Able Thrift Acre Core
Round Thrift Performance Thrift Size Core Performance
0 6 14.1 8.1
1 6.5 13.6 8.9

2 7 13.1 9.7
3 7.5 12.6 10.5
4 8 12.1 11.3
Segment Spots
Core Nano Elite
Core Size Nano Performance Nano Size Elite Performance Elite Size
12.4 9.2 9.2 10.9 10.9
11.6 10 8.1 12 10.1
10.8 10.8 7 13.1 9.3
10 11.6 5.9 14.2 8.5
9.2 12.4 4.8 15.3 7.7

Ideal Spot
Acre Core Awe Nano Ark Elite
Core Size Nano Performance Nano Size Elite Performance Elite Size
12 10 8.1 12 10.1
11.2 10.8 7 13.1 9.3

10.4 11.6 5.9 14.2 8.5


9.6 12.4 4.8 15.3 7.7
8.8 13.2 3.7 16.4 6.9
Ideal Spots offset
Segment
thrift
core
nano
elite
Ideal Spots offset
Performance Size
0 0
0.4 -0.4
0.8 -1.1
1.1 -0.8
Traditional Low End

Customer Customer
Name Name
Satisfaction Satisfaction

Able 40 Acre 21
Baker 47 Bead 28
Cake 44 Cedar 15
Daze 54 Dell 45
Eat 37 Ebb 16
Fast 37 Feat 21
Acre 1 Daze 0
Bead 1 Fast 0
Cedar 0 Cake 1
Dune 0 Baker 0
Ebb 0 Eat 0
Feat 0

261 0 0 147 0
High End Performance

Customer Customer
Name Name
Satisfaction Satisfaction

Adam 29 Aft 20
Bid 30 Coat 33
Cid 7 Dot 29
Duck 37 Edge 33
Echo 29 Bold 32
Fist 14 Cake 0
Aft 0 Baker 0
Bold 1 Eat 0
Coat 0 0
Dot 2 0
Edge 0 0
Foam 0 0
Able 0
0 149 0 0 147 0
Size

Customer
Name
Satisfaction

Agape 33
Buddy 38
Cure 38
Dune 46
Egg 33
Baker 1
Able 3
C ake 0

Eat 3
Fast 1

0 196

You might also like