Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions