A beer distribution company compiled information on the behavior of craft beer sales for the past year. The record of sales in thousands of cases per month for three of their beers is presented below. We'll call them Beer A, Beer B, and Beer C.

For next year, a 15% increase in total beer sales is expected compared to this year. Here are the instructions for data analysis.

Calculate the station index per month. (fifteen)

Calculate the sales per month per beer for the next year. (25)

a. You must use the projection of total sales for the coming year.

b. Work the problem based on uniform sales per month and per brand of beer.

c. You must use the seasonal rate per beer per month.

Month	Boxes Sold	Percentage (%) of sales corresponding to each beer
		A	B	C
Enero	215000	10	35	55
Febrero	180000	20	30	50
Marzo	192000	25	30	45
Abril	220000	15	40	45
Mayo	200000	20	40	40
Junio	215000	15	15	70
Julio	225000	20	25	55
Agosto	220000	20	20	60
Septiembre	215000	20	30	50
Octubre	200000	25	35	45
Noviembre	198000	30	30	40
Diciembre	220000	20	15	65

Answer rating: 100% (QA)

Sales for next year 15 increase in total beer sales Total beer sales 15 x 12 months x total sales Total sales 15 x 12 x 215000 459 million Sales per m... View the full answer