Question #1) How to calculate Bubble up company forecast? Steps: Calculate Bubble Up company's forecast by taking market share percentage of the industry sales. For example, if the industry sales for a quarter are 100,000 units and Bubble Up market share for the same quarter is 7%, then Bubble Up sales forecast for that quarter will be 7,000 units. Note: Please assist using excel with formulas and show up the formulas each cell.

The Bubble Up Bottling Company of Budapest, Hungary, is interested in forecasting sales of Bubble Up over the next two years. The company has analyzed Bubble Up's market share for its service area over the past 20 quarters. Market share has generally been growing as indicated in the table B below.

During this same five year period, total soft drink sales in the region (as measured in 100,000s of cases) have been as in the table A below.

			Table A
			Year
Season	1	2	3	4	5
Winter	114	114	124	132	134
Spring	130	146	151	160	166
Summer	158	177	175	184	205
Fall	131	142	146	144	148

The company would like to forecast Bubble Up soft drink sales for years 6 and 7. To do so, use a linear trend model to forecast market share for each quarter of years 6 and 7 and seasonal model to forecast total soft drink sales in these periods. Then multiply the forecast of total soft drink sales by Bubble Up's sales during this period.

Prepare a business report to Bubble Up management containing your forecast and explaining your approach.

		Table B
Year		Season	Bubble Up's Market Share (in Percent)
1		Winter	6.42
1		Spring	6.58
1		Summer	6.99
1		Fall	6.82
2		Winter	6.64
2		Spring	6.46
2		Summer	6.7
2		Fall	7
3		Winter	6.7
3		Spring	6.84
3		Summer	6.78
3		Fall	6.48
4		Winter	6.93
4		Spring	6.79
4		Summer	6.83
4		Fall	7.21
5		Winter	7.73
5		Spring	8.16
5		Summer	8.36
5		Fall	8.23