subject
Business, 06.04.2021 04:10 lbab

Suppose the Kalamazoo Brewing Company (KBC) currently sells its microbrews in a seven-state area: Illinoise, Indiana, Michigan, Minnesota, Mississippi, Ohio, and Wisconsin. The company's marketing department has collected data from its distributers 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. Excel Data File
Quantity Price Income
575 31.26 33.95
674 30.69 35.51
616 31.54 28.78
183 27.41 30.44
501 29.75 31.28
578 29.48 33.77
590 28.94 38.31
445 28.17 34.01
603 28.58 32.53
713 28.57 31.69
337 30.06 32.26
230 29.36 31.57
403 28.81 32.75
383 32.52 29.48
568 32.02 35.91
698 32.91 34.85
826 28.45 34.06
789 26.85 38.92
645 30.49 35.94
601 31.72 38.05
467 31.23 36.48
429 31.28 37.61
552 28.89 38.29
553 31.13 36.9
562 27.52 39.22
352 30.02 34.21
611 31.38 33.97
346 29.08 38.53
354 28.8 34.4
401 27.64 34.01
253 30.47 34.24
524 30.97 38.29
211 32.85 34.66
666 30.11 41.38
468 29.48 32.14
585 28.41 29.16
578 29.96 35.05
656 30.46 37.11
571 32.86 32.94
454 28.49 32.7
510 30.67 33.14
672 31.92 33.73
499 28.44 41.92
560 27.94 35.06
848 29.74 32.71
617 29.54 37.96
530 31.34 37.38
649 30.08 35.55
824 29.13 42.89
626 31.72 37.17
Assuming that the underlying demand relation is a linear function of price and income, use your spreadsheet program to obtain least squares estimates of Ohio’s demand for KBC microbrews. Instruction:
If the estimate is negative, enter a negative number (-) in the equation.

ansver
Answers: 3

Another question on Business

question
Business, 22.06.2019 02:00
Greater concern for innovation and quality has shifted the job trend to using more broadly defined jobs. t/f
Answers: 1
question
Business, 22.06.2019 10:30
6carla would like to buy a dress, a dresser for her bedroom, and a home theater system. she has one month's worth of living expenses in her emergency fund. carla decides to save for the home theater system. did carla make the right decision? why or why not? a. yes; her emergency fund is full and the other items will probably be less expensive. b. yes; she could save more for her emergency fund, but the home theater will be harder to save for. c. no; she should save more for her emergency fund because she has saved less than the recommended amount. d. no; she should have bought the dress and dresser first because she could afford them right away. reset next
Answers: 2
question
Business, 22.06.2019 12:10
Profits from using currency options and futures.on july 2, the two-month futures rate of the mexican peso contained a 2 percent discount (unannualized). there was a call option on pesos with an exercise price that was equal to the spot rate. there was also a put option on pesos with an exercise price equal to the spot rate. the premium on each of these options was 3 percent of the spot rate at that time. on september 2, the option expired. go to the oanda.com website (or any site that has foreign exchange rate quotations) and determine the direct quote of the mexican peso. you exercised the option on this date if it was feasible to do so. a. what was your net profit per unit if you had purchased the call option? b. what was your net profit per unit if you had purchased the put option? c. what was your net profit per unit if you had purchased a futures contract on july 2 that had a settlement date of september 2? d. what was your net profit per unit if you sold a futures contract on july 2 that had a settlement date of september 2
Answers: 1
question
Business, 23.06.2019 01:30
Vortex company operates a retail store with two departments. information about those departments follows. department a department b sales $ 800,000 $ 450,000 cost of goods sold 497,000 291,000 direct expenses salaries 125,000 88,000 insurance 20,000 10,000 utilities 24,000 14,000 depreciation 21,000 12,000 maintenance 7,000 5,000 the company also incurred the following indirect costs. salaries $36,000 insurance 6,000 depreciation 15,000 office expenses 50,000 indirect costs are allocated as follows: salaries on the basis of sales; insurance and depreciation on the basis of square footage; and office expenses on the basis of number of employees. additional information about the departments follows. department square footage number of employees a 28,000 75 b 12,000 50 required: 1. determine the departmental contribution to overhead and the departmental net income for department a and department b.
Answers: 2
You know the right answer?
Suppose the Kalamazoo Brewing Company (KBC) currently sells its microbrews in a seven-state area: Il...
Questions
question
Mathematics, 21.12.2020 19:20
question
Mathematics, 21.12.2020 19:20
question
Spanish, 21.12.2020 19:20
question
Mathematics, 21.12.2020 19:20
Questions on the website: 13722367