Estimating Demand for New Type Of Frozen Snack Food
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
Estimating Demand for New Type Of Frozen Snack Food
In this project, you are asked to take sales data, estimate a demand function, and make a management decision based on your calculations.
Background
Your company has tasked you with estimating demand for a new type of frozen snack food that the company has developed. The existing snacks your company is competing with are well established in the market and rarely change price. However, you are not sure how much your consumer will be willing to pay relative to the existing snacks.
One thing you are confident in is that people will want to buy more of your new frozen snack on hot days.
Your company has varied the price of the product each of the last 10 weeks in a test location and collected data on sales. The results are in Elasticity Exercise.xlsx, and include price charged, units sold per hour, and the average temperature for that day.
Your manager has informed you that your company has another team working on minimizing production costs, so you don’t have that data yet. “Just find the best price to charge to drive the highest revenue—we’ll deal with cost data later.”
Instructions
Use the data in ‘Elasticity exercise.xlsx’ to perform a multiple regression analysis, with Sales per Hour as your dependent variable and ‘Price’ and ‘Avg Temp’ as independent variables (See the Elasticity Lecture Video for tips). Use the results to answer the following questions. When you have completed the exercise, upload a word document with your answers.
Questions
- You have hypothesized that the general form of the demand function is Qd = f(P, T) where P is the price of ice cream cones and T is average temperature. Based on your regression analysis, write out your estimate of the specific form of the demand for your company’s new snack. In other words, if Qd=a + b1P + b2T, what values do a, b1 and b2 take? (Hint: what should the sign on b1 be, based on the Law of Demand?) (30 pts)
1.
- Assume the average high temperature will be 80 next year. Draw the demand curve. Be careful to put P on the vertical axis and Q on the horizontal axis.This will probably require rearranging your data so that P looks like a function of Q. Excel, for example, will by default assume that if your data is in two columns, the first column is your X or independent variable.
Please label the vertical intercept (above what price will 0 units be sold) and the horizontal intercept (if P=0, how many units are ‘sold’).
Create a graph in Excel or some other software, and embed the image in the space provided below. Do not submit a photo or any separate file (.jpg or similar). (30 pts)
Embed Image:
- A co-worker suggests charging $2.50 per snack. Do you agree? Calculate the price elasticity of demand if you charge $2.50 (still assuming an average temperature of 80 degrees). Use that calculation to argue whether you should charge a price of $2.50, more than $2.50, or less than $2.50. (20 pts)
- What price would maximize revenue if your estimate of demand is correct? How did you arrive at this price? (20 pts)
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow Estimating Demand for New Type Of Frozen Snack Food