ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBS
1
Mobile Device ForecastingYear2022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202220222022202320232023202320232023202320232023202320232023
2
Task A
Please forecast 10 week forward for iPhone 14 , Galaxy S22 and Galaxy 23
Week 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
# Forecast186730160910147100132680105710959907663077790756905307058660577406836065170954208546065190??????????
14
SAMGSMD211000SamsungEOLEOL - Mar 2022Galaxy S21# Actuals25630229402156022450214602100020780125809860758045203210
15
# Forecast268202882016930204501922025510196101591010540852044803520
16
SAMGSMD221000SamsungEOL < 8 weeksEOL - Mar 2023Galaxy S22# Actuals11526095440795905312052120427403968033680358403673029610298202935030520288603332034230343603124028960347003447030600488603004030240283703209034390348603284030440319402842030010411502702033320289803131027060293703021033420422601722019270
17
# Forecast11237092900780505336058850408903961039900380503778036550330303212026880252203845033360315202853030520304703778028080452003078027690294302742029960395002784034650368102590035290461202987029090298703121025430307103143038620415102033019330???????
18
SAMGSMD231000SamsungPre-launchPre Launch - Feb 2023Galaxy S23# Actuals
19
# Forecast??????
20
21
22
23
24
25
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