Chets Pizza is one of only two home delivery pizza firms serving Smallton, a small suburb of
Question:
Chet’s Pizza is one of only two home delivery pizza firms serving Smallton, a small suburb of Big City, Colorado. The manager and owner of Chet’s Pizza, Ann Chovie, knows that her customers tend to be price-conscious. She competes for market share with Al’s Pizza Oven. There is a local McDonald’s that also provides fast food in her market area. Ann is concerned that she is losing market share to Al’s Pizza and is considering several options. She believes she can boost market share by lowering her prices and boosting her advertising to better tap the total market potential of Smallton. She hires you as a market analyst to help her decide on the best marketing strategy for her marketing plan.
You gather data on sales over the last 24 months for Chet’s Pizza from Ann’s records. You have quantity and price information. Ann has kept track of Al’s Pizza Oven’s prices as well. Ann has also kept track of McDonald’s prices via newspaper ads and what is posted on the drive through lane. You call the local Small Business Development Center and gather income figures for Smallton as well. Ann also got population figures over this time period as well. One night when you are getting started on your analysis for Ann, you wind up in a chance meeting with a disgruntled former manager of Al’s Pizza Oven. He provides you with the pizza sales for Al’s over the last 24 months.
The chart provided to answer the question:
Questions:
Qchet is the quantity of pizzas sold by Chet’s Pizza. Pchet is the deflated price for Chet’s Pizza. M is the deflated monthly average income for residents of Smallton. Pal is the deflated price for Al’s Pizza. Pbmac is the deflated price for Big Macs at McDonalds. Pop is the population of Smallton, and Qal is the quantity of pizzas that Al’s Pizza has sold over the 24-month period.
No other information was provided: I would just like help with the excel
questions about the Excel sheet
1. Has Chet’s Pizza lost market share to Al’s Pizza Oven? Use pie charts and or line graphs developed in Excel to support your answer.
2. A government report indicates that per capita consumption of pizzas is 8 per year. Given this information estimate the average total market potential for pizzas in Smallton on a monthly basis (using the latest population in month 24 for your forecast).
5. While working on the report for Ann, you find a newspaper article indicating that the opening of a credit card call center will provide jobs for 200 employees in Smallton. An economist predicts that average income of Smallton residents will increase by 1,000 and 500 new people will move to the community in 6 months. Forecast what the quantity demanded for Chet’s Pizza will be in six months, given this information. Use the latest population, price, and income information from month 24 for your forecast.
Marketing Research
ISBN: 978-1118156636
11th edition
Authors: David A. Aaker, V. Kumar, Robert Leone, George S. Day