Hi I'm trying to forecast my unit sales for the following year. I have last years data but I'm at a loss as to where i begin. My data is below along with what i expect the market changes to be.
<colgroup><col><col span="12"></colgroup><tbody>
</tbody>
Monthly Data | ||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
2019 Market | 20,886 | 18,820 | 19,724 | 19,970 | 17,397 | 17,235 | 16,918 | 18,166 | 26,109 | 29,878 | 33,118 | 21,992 |
My Market Share | 9.5% | 15.3% | 18.5% | 18.4% | 11.4% | 14.5% | 14.9% | 13.8% | 11.0% | 11.0% | 12.0% | 10.9% |
Total Sales | 1,989 | 2,878 | 3,654 | 3,667 | 1,985 | 2,501 | 2,528 | 2,515 | 2,882 | 3,272 | 3,968 | 2,390 |
Standard | 462 | 988 | 1,137 | 1,034 | 756 | 809 | 774 | 773 | 831 | 906 | 880 | 376 |
Plus | 1,071 | 1,350 | 1,320 | 1,741 | 905 | 1,234 | 1,228 | 1,352 | 1,411 | 1,655 | 2,152 | 1,335 |
Plus Pro | 456 | 540 | 1,197 | 892 | 324 | 458 | 526 | 390 | 640 | 711 | 936 | 679 |
The overall market will shrink by 10% in 2020 | ||||||||||||
Q1 2020 will be down 25% vs previous year | ||||||||||||
My target market share for full year 2020 = 15% | ||||||||||||
Plus range to be 45% of My total volume |
<colgroup><col><col span="12"></colgroup><tbody>
</tbody>