Mountain Springs is expanding its operations in the markets of Canada, Mexico, and Brazil.

Required: Prepare a seasonal sales forecasting model using the historical sales data provided. Hint: use multiple regression analysis. Predict the next year's sales and compute standard errors of the forecasts.

Historical Sales Data:

Sales, thousands of liters	Year	Calendar Month
4900	1	1
4950	1	2
5000	1	3
5050	1	4
5100	1	5
5150	1	6
5200	1	7
5250	1	8
5300	1	9
5350	1	10
5400	1	11
5450	1	12
5500	2	13
5550	2	14
5600	2	15
5650	2	16
5700	2	17
5750	2	18
5800	2	19
5850	2	20
5900	2	21
5950	2	22
6000	2	23
6050	2	24
6100	2	25
6150	3	26
6200	3	27
6250	3	28
6300	3	29
6350	3	30
6400	3	31
6450	3	32
6500	3	33
6550	3	34
6600	3	35
6650	3	36