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.
 

Observation Qchet 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 2672 2883 2888 2862 2855 2829 3052 3072 3053 3103 2947 2955 2847 2530 2516 2515 2570 2599 2636 2646 2734 2742 2804 2834 Pchet M 10.65 10.65 10.65 10.65 10.65 10.65 45500 45600 45700 45970 45970 45750 9.5 45750 9.5 45950 9.5 45950 9.5 46120 10.5 46120 10.5 46120 10.5 46200 11.99 46350 11.99 46450 11.99 46350 11.99 46850 12.25 47350 12.25 47350 12.25 47950 11.75 48159 11.75 48264 11.75 48444 11.75 48500 Pal 11.55 11.45 11.35 11.3 11.3 11.25 11.25 11.15 11 11 11.25 11.25 10.75 10.75 10.65 10.6 11 11.25 11.2 11 11.1 11.1 11.1 11.25 Pbmac Pop 4.25 4.35 4.55 4.05 3.95 3.95 3.85 4.15 4.25 4.75 4.75 4.85 4.5 4.1 4.05 4.25 3.55 3.55 4.15 4.15 3.55 3.55 4.2 4.2 6412 6700 6713 6680 6672 6639 6936 6965 6940 7007 6793 6804 6672 6249 6237 6240 6299 6331 6384 6404 6519 6529 6612 6643 Qal 2065 2070 2075 2076 2077 2078 2078 2080 2080 2080 2076 2076 2085 2085 2090 2093 2082 2077 2080 2085 2083 2083 2083 2076