Kalamazoo brewing company microbrews

Assignment Help Business Economics
Reference no: EM133130248

Suppose the Kalamazoo Brewing Company (KBC) currently sells its microbrews in a seven-state area: Illinois, Indiana, Michigan, Minnesota, Mississippi, Ohio, and Wisconsin. The company's marketing department has collected data from its distributors in each state. This data consists of the quantity and price (per case) of microbrews sold in each state, as well as the average income (in thousands of dollars) of consumers living in various regions of each state. The data for each state are available via the link below--please note there are multiple tabs at the bottom of the spreadsheet, each refers to one of the seven states selling the Kalamazoo Brewing Company's microbrews.

Assuming that the underlying demand relation is a linear function of price and income, use your spreadsheet program to obtain least squares estimates if Indiana's demand for KBC microbrews.

Instruction: if the estimate is negative, enter a negative number in the equation. Enter your response rounded to two decimal places.

Q=___ +___Price +___Income

Quantity

Price

Income

83

30.85

31.9

83

31.94

31.77

97

30.69

36.86

103

32.27

40.79

101

32.39

37.06

88

30.01

34.03

81

30.35

33.52

99

30.58

32.78

98

30.1

37.02

103

27.43

35.88

102

27.02

36.01

88

30.24

32.55

105

28.84

37.14

98

29.57

33.84

93

31.17

35.82

88

32.17

35.68

92

32.21

36.24

92

29.43

33.66

86

34.07

34.85

93

29.79

32.51

86

35.54

34.97

87

30.13

33.81

108

26.26

35.24

88

33.13

37

98

30.3

38.6

92

27.94

30.02

93

32.07

36.88

99

30.51

36.15

105

27.23

36.09

88

33.37

36.44

97

29.75

34.99

93

29.44

31.71

101

28.6

34.46

90

30.71

32.6

106

32.35

40.61

87

32.57

36.37

98

31.61

37.34

89

30.08

32.81

83

34.49

34.1

104

27.52

32.3

97

30.08

35.26

76

34.35

32.25

98

28.59

33.53

82

34.75

34.15

94

29.51

33.95

99

30.72

35.66

89

35.61

34.48

75

36.19

34.09

92

30.78

35.15

97

32.75

37.34

Reference no: EM133130248

Questions Cloud

Absolute advantage in the production : The table below shows the number of umbrellas and bushels of corn produced in the United Kingdom and the rest of the world per labor hour. The rest of the world
Comparative advantage in the production : The table below shows the number of labor hours required to produce one gallon of wine and one pound of cheese in the United States and France. The United State
HCM-500 21st Century Healthcare Systems Assignment : HCM-500 21st Century Healthcare Systems Assignment Help and Solution, Thomas Edison State University - Assessment Writing Service
What is interdependence : 1. What is Interdependence? 2. Give example in a Philippine Set up
Kalamazoo brewing company microbrews : Suppose the Kalamazoo Brewing Company (KBC) currently sells its microbrews in a seven-state area: Illinois, Indiana, Michigan, Minnesota, Mississippi, Ohio, and
Calculate the unit contribution margin ratio : 1. A store sold 900 units of product earning a revenue of $17765. The total variable cost is $883. Calculate the Unit Contribution Margin Ratio in percentage.
Proposed dissertation research study : A doctoral learner has decided to do a phenomenological study for his/her proposed dissertation research study topic because it is believed to be the best appro
What is steve''s additional tax due as a result : Steve, a single individual with a marginal tax rate of 32% in 2021, What is Steve's additional tax due as a result of these capital gains and losses
Key elements of an e-commerce business model : 1. What are the key elements of an e-commerce business model ?

Reviews

Write a Review

Business Economics Questions & Answers

  Economics assignment

This document contains various important questions and their appropriate answers in the subject field of Economics.

  Demand and supply curves

Economics is the study of the principles governing the allocation of scarce means among competing ends when the objective of the allocation is to maximize the attainment of the ends.

  Long-run perfectly competitive equilibrium for the firm

Evaluate Government intervene and correct this situation?(a) Explain the concept of a concentration ratio. A rise in the price of magarine Explain the impact of external costs and external benefits on resource allocation long-run perfectly c..

  Supply and demand diagrams

Explain each of the following using supply and demand diagrams,  With the use of a graph, explain how these two programs affect cigarette consumption and the price of cigarettes.

  Case study: fisher-price toys

The case study of the Fisher-Price Toys, Inc., a popular case in basic economics and management from the prestigious Harvard Business School.

  Draw the production possibility curve

Draw the production possibility curve and a. Define consumer surplus and producer surplus.

  Tax revenue

The Australian government administers two programs that affect the market for cigarettes

  Maximize total welfare

How many tickets to sell to maximize total welfare.

  Difference between the cv and the ev

The change in consumer surplus (?CS) is not "theoretically" justifiable like the CV and EV but it continues to be the most widely used measure of consumer welfare change. Explain how this can be reconciled

  Depict von neumann-morgenstern utility index u in a diagram

Depict the von Neumann-Morgenstern utility index u in a diagram

  What is the market solution

What is the market solution (market price and quantity) and What is the total surplus of the society under the market solution

  Calculate gross national product and net national product

Calculate gross national product and net national product

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd