Q. 1 and Q. 2 and Q. 3 What are correct equations used in excel for these questions and guide on how it is formulated.link for data below:https://docs.google.com/file/d/14MODWbPGQs7Wu8z-0vBA8QaZOpXVnaIk/edit?usp=docslist_api&filetype=msexcel
GARY'S GRUB AND GASOLINE QUESTIONS In constructing your report, the following questions are provided as a guide through the analysis portion. 0.1. Q .2. Q. 3. Q. 4. Q. 5. Adjusting for ination, what are Gary's prots? How do you make this adjustment? Create a scatter diagram of monthly real prots over the 108-month period. What conclusion can be made from looking at the graph? Use simple regression to see if there is any signicant change in real prots over time. Estimate the demand curves for fuel sales and for restaurant sales. HINT: Use simple regression to estimate the relation between number of sales (or tickets) and price for diesel fuel, gasoline, and nally for restaurant sales. You will need to do three simple regressions. Determine and discuss the impact of diesel prices on fuel revenues and the impact of gasoline prices on fuel revenues. What is the relationship between meal prices and meals? Dene, measure, and discuss the price elasticities. HINT: Find price elasticity of demand by multiplying the slope of the regression line from Excel by the mean real price then divide by the mean quantity demanded. Use simple regression to estimate the marginal prot contribution from fuel sales. Use it again to estimate the marginal prot contribution from food sales. Compare and interpret your estimates. A B C D E G M N O Gary's Gary's Average Gary's Average Average Retail Restaurant Gary's Number of | Gary's Restaurant Gary's Number Retail Gasoline Gary's Fuel Diesel Prices Purchase ($/ Restaurant Tickets Date Revenue ($/ CPI of Fuel Sales Prices (C/gal) (c/Gal) Revenue ($/ Ticket) Gary's PreTax Month (Tickets/Month) Gary's Real Jul-2007 152.50 Month) Gary's Real 24.38 (Sales/Month) Gary's Real Gary's Real 128.62 Month) Profit ($/Month) .28 Number Profit 12,580 116,714.83 Gas Price Diesel Price Meal Price Aug-2007 152.90 19,560 119.33 129.13 1,719,894.54 64,014.63 10.47 41,976.81 84.34 Sep-2007 1,993 81.56 6.08 153.20 185,531.71 11.08 20,610 136.38 1,736,262.14 11.52 67,422.00 9,223 44,095.49 78.04 Oct-2007 153.70 115,471.96 84.45 15.72 16,838 1,381,473.21 6.85 141.66 55,966.25 11.59 36,531.49 3,903 138,797.77 72.50 89.02 15,933 7.52 Nov-2007 153.60 07.23 138.28 1,258,611.32 3.72 53,802.36 13,525 35,004.79 131,463.00 75.29 92.17 7.54 Dec-2007 153.50 120.13 137.15 17,869 1,357,700.91 10.11 60,010.37 12,022 121,542.42 39,069.25 69.81 90.02 Jan-2008 18,311 120.04 136.18 1,404,348.87 5.68 154.40 61,398.90 12.37 7,608 39,999.28 78.26 109,326.96 14,295 89.35 Feb-2008 123.93 1,127,405.42 6.59 154.90 138.65 9.61 47,841.64 30,985.52 3,894 77.75 88.20 Mar-2008 155.70 112,153.34 115.70 13,687 134.58 1,097,424.10 8.01 44,897.44 1.88 28,984.79 7,811 80.00 89.51 6.2 Apr-2008 156.30 124,038.68 136.06 15,216 167.88 1,303,471.34 9.95 49,195.60 10,547 31,596.40 126,036.65 74.31 May-2008 156.60 137.92 172.47 13,617 36.43 1,193,779.70 7.63 52,211.92 10 11.49 10,552 33,404.94 174,002.48 87.05 107.41 6.37 Jun-2008 156.70 138.58 14,783 164.85 1,336,275.40 60,678.88 12.82 9,245 11 38,747.69 88.07 110.13 157.00 118,520.90 132.72 15,541 1,408,495.80 7.34 Jul-2008 148.06 9.05 60,815.24 14,506 12 203,809.30 38,809.98 88.44 18,057 105.20 8.18 Aug-2008 157.30 120.65 157.95 1,611,563.26 12.04 67,007.33 11,310 13 42,679.83 84.54 94.30 5.77 Sep-2008 157.80 192,722.40 22.22 19,184 155.68 12.47 1,687,856.10 70,658.35 14 9,162 44,919.49 76.70 100.41 7.65 Oct-2008 158.30 132,574.14 135.40 15,619 154.63 1,353,022.64 11.92 57,306.48 9,161 15 36,315.89 77.45 98.66 7.91 Nov-2008 158.60 123.23 155,004.12 14,601 159.05 1,258,552.80 10.86 56,006.55 10,822 149,992.92 16 35,380.01 85.53 97.68 7.53 Dec-2008 158.60 134.52 16,211 152.33 12.12 1,455,954.09 60,288.36 17 9,751 38,012.84 77.70 Jan-2009 159.10 66,937.12 123.63 16,953 1,551,011.11 100.28 6.85 146.67 10.46 62,686.81 18 8,802 39,525.10 84.82 Feb-2009 109,672.92 96.04 124.00 13,355 1,224,619.24 7.64 159.60 64.89 11.72 19,599.68 19 7,564 26,470.08 31,175.16 77.70 11,768 92.18 6.57 Mar-2009 160.00 27.50 157.52 1,038,719.30 11.31 46,198.06 9,181 20 28,946.15 77.69 7.35 Apr-2009 160.20 113,018.11 103.31 130.90 14,088 149.61 1,219,287.81 11.83 53,549.06 9,078 33,468.16 May-2009 160.10 125,548.74 21 79.69 124.03 14,325 98.45 147.59 1,227,365.88 7.07 11.44 53,635.88 9,864 22 33,480.57 81.71 93.39 7.38 Jun-2009 160.30 132,572.16 124.76 16,979 134.44 1,517,722.41 11.95 59,358.38 23 9,084 117,637.80 37,075.82 77.47 17,704 92.18 7.14 1,622,700.23 59,780.89 24 37,293.13 77.83 83.87 7.45