ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBS
1
Mobile Device ForecastingYear2022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202320232023202320232023202320232023202320232023
2
Task APlease forecast 10 week forward for iPhone 14 , Galaxy S22 and Galaxy 23Week ID12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152123456789101112
3
Task BTake account of New Device Launch, Campaign & Holidays DataStart week2-Jan9-Jan16-Jan23-Jan30-Jan6-Feb13-Feb20-Feb27-Feb6-Mar13-Mar20-Mar27-Mar3-Apr10-Apr17-Apr24-Apr1-May8-May15-May22-May29-May5-Jun12-Jun19-Jun26-Jun3-Jul10-Jul17-Jul24-Jul31-Jul7-Aug14-Aug21-Aug28-Aug4-Sep11-Sep18-Sep25-Sep2-Oct9-Oct16-Oct23-Oct30-Oct6-Nov13-Nov20-Nov27-Nov4-Dec11-Dec18-Dec25-Dec1-Jan8-Jan15-Jan22-Jan29-Jan5-Feb12-Feb19-Feb26-Feb5-Mar12-Mar19-Mar
4
Task CImprove current forecast errorsEnd week8-Jan15-Jan22-Jan29-Jan5-Feb12-Feb19-Feb26-Feb5-Mar12-Mar19-Mar26-Mar2-Apr9-Apr16-Apr23-Apr30-Apr7-May14-May21-May28-May4-Jun11-Jun18-Jun25-Jun2-Jul9-Jul16-Jul23-Jul30-Jul6-Aug13-Aug20-Aug27-Aug3-Sep10-Sep17-Sep24-Sep1-Oct8-Oct15-Oct22-Oct29-Oct5-Nov12-Nov19-Nov26-Nov3-Dec10-Dec17-Dec24-Dec31-Dec7-Jan14-Jan21-Jan28-Jan4-Feb11-Feb18-Feb25-Feb4-Mar11-Mar18-Mar25-Mar
5
Task DBuild Dashboard/UI to render forecasting results & trending
6
Note:
1. EOF : End of Life of device, iPhone13 & Galaxy S21 has already EOL and replaced by New model
2. All data are non-real, however depicts the real world simulations
7
8
9
SKUMakeStatusStatus NoteDevice Name
10
APPLMD211000AppleEOLEOL - Dec 2022iPhone 13# Actuals52360503604834045390667805740049490542304506046270544605072050110540404840050490460805199048180488605095046470498905229051530455905309051780539804917054260543503724038320323403320039130363503295033100362803348032130368902671015630114805790
11
# Forecast56230543105008045270555105645046120555004607052470574405317048910492004730052020456404955043980458304793041850489505801053440496604937055570557004613055400587703317040200383103913042760426903026034150353303007033120412003228016410108206680
12
APPLMD221000AppleActiveNew Launch - Sept 2022iPhone 14# Actuals188380168930142680126960108280931107726075390720305721059290618106362059030901308028069850
13
# Forecast18673016091014710013268010571095990766307779075690530705866057740683606517095420854606519053399.552569.952310.149839.250011.349344.849819.350120.550964.150633.7
14
SAMGSMD211000SamsungEOLEOL - Mar 2022Galaxy S21# Actuals25630229402156022450214602100020780125809860758045203210
15
# Forecast268202882016930204501922025510196101591010540852044803520
16
SAMGSMD221000SamsungEOL < 8 weeksEOL - Mar 2023Galaxy S22# Actuals11526095440795905312052120427403968033680358403673029610298202935030520288603332034230343603124028960347003447030600488603004030240283703209034390348603284030440319402842030010411502702033320289803131027060293703021033420422601722019270
17
# Forecast1123709290078050533605885040890396103990038050377803655033030321202688025220384503336031520285303052030470377802808045200307802769029430274202996039500278403465036810259003529046120298702909029870312102543030710314303862041510203301933021415.121419.321493.421129.319258.410508.17221.8
18
SAMGSMD231000SamsungPre-launchPre Launch - Feb 2023Galaxy S23# Actuals
19
# Forecast93939.386524.771681.653602.147661.343172.0
20
21
22
23
24
GALAXY S23- march EOL, feb release
galaxy- EOL mar
25
new galaxy 1 months pror
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100