Explore BrainMass
Share

FoodKing

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

You have been retained to assist a regional food marketer, FoodKing, to forecast the demand for pies that are mass-produced and marketed under the name Ms. Smith's Homemade Pies. To assists with your analysis, you are provided with data that was collected for 8 consecutive quarters and 6 geographic markets. If you use Excel or any other statistical packet, be sure to attach a copy of the output. See the attached excel file with data & address the following:

1) Can you estimate a regression model that expresses sales as a function of price, income and competitors Price and population? Is so, give a clear interpretation of the R-square, discuss the statistical significant of the overall regression and indicate whether each coefficient is statistically significant or not.

2) Can you provide a clear, concise interpretation for the slope coefficients on price and on income?

(3) FoodKing is considering entering the market in a new city. In this market, the population is 2,200,000, the average income is $42,400 and the competitor's product sells for $4.15. You expect to spend $5,000 on advertising. Using this regression model, if you price your product at $6.00, how many pies will you sell?

(4) Given the information in (3), at what price would you maximize the TOTAL REVENUE that the firm receives? (hint: one approach is to use SOLVER). Based on this answer, was demand elastic or inelastic in a neighborhood of the original $6 price? Explain your answer.

(5) One of your managers says that pie sales are higher during the fourth quarter of the year. Based on the data that you have, does that appear to be true? If so, how much higher are they in the fourth quarter than for a typical quarter?

© BrainMass Inc. brainmass.com October 24, 2018, 10:06 pm ad1c9bdddf
https://brainmass.com/economics/regression/foodking-148276

Attachments

Solution Summary

Full solution in excel file.

$2.19
See Also This Related BrainMass Solution

Revenue Management

You have been retained by a regional food marketer, FoodKing, to forecast the demand for small cakes that are mass-produced and marketed under the name Johnny's Pies. To assist with your analysis, you are provided with data that was collected for 8 consecutive quarters and 6 geographic markets.

(a) Estimate a regression model that expresses sales as a function of price, income and competitor's price and population? Once you have estimates the regression model, (a) provide a clear interpretation of the "R2" and (b) the statistical significant of the overall regression. Be sure to explain if the overall regression is statistically significant at a 5% level and how you know that.

b) Can you provide a clear, concise interpretation for the slope coefficient on price?
Is that coefficient significantly different from zero? How do you know that?

c) Can you provide a clear, concise interpretation for the slope coefficient on income?

d) FoodKing is considering entering a new market. In this market, the population is
2,650,000, the average (or per capita) income is $42,500 and the competitor's product sells for $4.85. Using this regression model, if you price your product at $5.25, how many pies will you sell?

If you price your product at $5.25, what would be the price elasticity of demand for your product at that price? Is this elastic or inelastic? If you raised the price of the product by a very small amount, would the profit rise or fall?

(f) At what price would you maximize the TOTAL REVENUE that the firm receives?

Assume that if your firm enters the market, is will be able to produce pies at a constant marginal cost of $3.25 per pie, at what price would it maximize PROFITS? Do you need to know the fixed cost to answer this question? What is the price elasticity of demand at that price?

) One of your assistants notes that market that you are considering entering is located in the southern part of the nation and asserts that "everyone knows that southerners eat lots of snack cakes." You note that in your data set, Atlanta and Dallas are the only two cities that are in the "South" census district. Can you test you assistant's hypothesis that "southerners eat lots of snack cakes" - is she correct?

View Full Posting Details