BOBS SERVICE STATION AND DINER

Sylvia, we have been operating this service station and diner for many years. Lately, I have the feeling that my income has declined. I think that there are opportunities out there that I have not taken advantage of. I want to pass this business on to my sons and am not comfortable with our current position and strategy.

The words above, spoken to Sylvia, the primary accountant for Bobs, reveal a number of concerns Bob has concerning his operation. Bobs Service Station and Diner (Bobs) is an independently owned service station and restaurant on a major interstate highway. Bob has been in operation for over a decade and customers have liked to frequent his business. Often they choose their routes to stop at places like his with low fuel prices and to enjoy food like the juicy burgers and good food Bobs provides. He has a great reputation with his customers, especially truckers, and enjoys their business. Bob has noticed, however, that when busiest with truckers, fewer families stop by. Bob has made a pretty good living running the place. However, even though his income continues to seem satisfactory, it does not seem to buy as much as before. This perception, as well as the maturity of his sons, Jason and Bob Jr., has heightened Bobs concern over the future of his operation. Bob wants to know what he can do to make this a more profitable business and pass on a more effective operation to his sons. Bob knows that his operation attracts many commercial truckers. However, he is also popular with families stopping to use the facilities and eat in the restaurant after filling up the family vehicle on vacations. Over the past decade Bobs typical markup on diesel is about 1 cent and on gasoline is about 1.5 cents. This fuel pricing follows the typical process in this business of taking the delivery price and marking it up between 1 and 5 cents per gallon. Bob has also noticed an ebb and flow by season summer and winter being highest and spring and fall being lower. (Winter is December, January, February. Summer is June, July and August.) Bob knows that he has some control over fuel prices and can alter the prices of his typical meal. The dilemma he faces is to know in what direction he should change them or whether or not he should modify his pricing practice at all. Also, he does not know what other activities or attractions he could add that might increase his profits. If he raises prices, he knows that he will reduce sales. At lower prices, he will sell more but incur greater costs. Bob is getting ready to step back from his business and turn the operation over to his sons. Before he does that, he wants to be comfortable in leaving his sons with a well-defined pricing strategy, based upon data.

Following up on the expression of Bobs future concerns, Sylvia, his accountant, has gathered a substantial amount of information regarding his firms performance over the past decade. This data is available... see attached images. Thank you

Adjusting for inflation, what are Bobs profits? How do you make this adjustment? Create a scatter diagram of monthly real profits over the 108-month period. What conclusion can be made from looking at the graph?

I A G L M N CPI Date Jul-2007 Aug-2007 Sep-2007 Oct-2007 Nov-2007 Dec-2007 Jan-2008 Feb-2008 Mar-2008 Apr-2008 May-2008 Jun-2008 Jul-2008 Aug-2008 Sep-2008 Oct-2008 Nov-2008 Dec-2008 Jan-2009 Feb-2009 Mar-2009 Apr-2009 May-2009 Jun-2009 Jul-2009 Aug-2009 Sep-2009 Oct-2009 Nov-2009 H Bob's Average Bob's Number Bob's Bob's Average Bob's Average Restaurant of Restaurant | Restaurant Bob's Number Bob's Fuel Bob's Pre Tax Retail Gasoline Retail Diesel Purchase Tickets Revenue of Fuel Sales Revenue Profit Prices (C/gal) Prices (C/Gal) ($/Ticket) (Tickets/Month) ($/Month) (Sales/Month) ($/Month) ($/Month) 152.5 115.38 126.62 9.28 12564.00 116566.39 19535.12 1719419.54 62490.63 152.9 112.33 127.13 10.47 11970.00 125340.03 20586.74 1735584.14 65832.00 153.2 111.08 129.38 11.52 9198.00 105988.89 16820.46 1380911.21 54620.25 153.7 108.72 130.66 11.59 8892.00 103068.03 15923.471 1258023.32 52087.36 153.6 106.23 131.28 8.72 13500.00 117723.95 17849.94 1356895.91 58522.37 153.5 107.13 132.15 10.11 12006.00 121371.12 18296.19 1403992.87 60396.90 154.4 109.04 132.18 12.37 7596.00 93924.96 14286.58 1126695.42 47227.64 154.9 108.93 127.65 9.61 8874.001 85278.47 13671.40 1097032.10 43777.44 155.7 113.70 127.58 11.88 7794.00 92573.20 15203.78 1303407.34 48880.60 156.3 123.06 152.88 9.95 10530.00 104789.97 13594.11 1193672.70 51919.92 156.6 127.92 161.47 11.49 10548.00 121174.22 14762.46 1335500.40 59491.88 156.7 125.58 152.85 12.82 9234.00 118421.25 15533.24 1407689.80 59388.24 157.0 122.72 147.06 9.05 14490.00 131203.26 18040.69 1611424.26 66427.33 157.3 120.65 143.95 12.04 11304.00 136063.69 19166.11 1687014.10 69081.35 157.8 120.22 146.68 12.47 9162.00 114290.24 15608.78 1352294.64 57240.48 158.3 120.40 148.63 11.92 9144.00 108966.06 14592.84 1258114.80 54194.55 158.6 123.23 147.05 10.86 10818.00 117443.80 16195.95 1455855.09 59624.36 158.6 123.52 143.33 12.12 9738.00 118061.16 16950.87 1550693.11 60992.81 159.1 123.63 142.67 10.46 8802.00 92058.67 13335.51 1224580.24 47746.68 159.6 123.00 150.89 11.72 7560.00 88634.88 11747.76 1038286.30 44265.06 160.00 120.50 147.52 11.31 9180.00 103801.42 14064.62 1219143.81 51877.06 160.2 119.90 148.61 11.83 9054.00 107084.78 14319.29 1226668.88 53140.88 160.1 120.03 137.59 11.44 9846.00 112613.97 16954.03 1516958.41 58635.38 160.3 119.76 130.44 11.95 9072.00 108404.71 17682.97 1621853.23 58387.89 160.5 117.43 126.68 10.79 11178.00 120648.40 20383.04 1842223.39 65429.26 160.8 122.35 133.70 9.39 13572.00 127455.83 20246.80 1893910.48 68493.30 161.2 123.14 135.70 10.86 9702.00 105360.20 16441.35 1541077.44 56326.49 161.6 119.68 134.68 12.84 7884.00 101265.29 15756.56 1419568.68 53396.75 161.5 117.08 139.03 9.92 12006.00 119076.29 17404.92 1490427.20 60626.40 Bob's Bob's Bob's Real Month Real Real Gas Diesel Number Profit | Price Price 1 40977.46 75.66 83.03 2 43055.59 73.46 83.14 335652.90 72.50 84.45 433888.98 70.74 85.01 5 38100.50 69.16 85.47 6 39346.52 69.79 86.09 730587.85 70.62 85.61 8 28261.74 70.32 82.41 9 31394.09 73.03 81.94 1033218.12 78.73 97.81 11 37989.71 81.68 103.11 12 37899.32 80.14 97.54 13 42310.40 78.17 93.67 14 43916.94 76.70 91.51 15 36274.07 76.18 92.95 1634235.34 76.06 93.89 17 37594.17 77.70 92.72 1838457.01 77.88 90.37 19 30010.49 77.70 89.67 20 27735.000 77.07 94.54 21 32423.16 75.31 92.20 22 33171.59 74.84 92.76 2336624.22 74.97 85.94 24 36424.14 74.71 81.37 25 40765.89 73.16 78.93 26 42595.34 76.09 83.15 2734941.99 76.39 84.18 28 33042.55 74.06 83.34 29 37539.56 72.49 86.08 18 30 36 37 Date Dec-2009 Jan-2010 Feb-2010 Mar-2010 Apr-2010 May-2010 Jun-2010 Jul-2010 Aug-2010 Sep-2010 Oct-2010 Nov-2010 Dec-2010 Jan-2011 Feb-2011 Mar-2011 Apr-2011 May-2011 Jun-2011 Jul-2011 Aug-2011 Sep-2011 Oct-2011 Nov-2011 Dec-2011 Jan-2012 Feb-2012 Mar-2012 Apr-2012 Bob's Average Retail Gasoline | Prices (C/gal) 161.3 113.14 161.6 108.63 161.9 104.90 162.2 101.68 162.5 103.03 162.8 106.35 163.01 106.44 163.2 105.53 163.4 102.60 163.6 100.93 164.0 101.88 164.00 99.54 163.9 94.50 164.3 93.90 164.5 92.05 165.0 98.20 166.2 113.10 166.2 113.06 166.2 111.43 166.7 115.75 167.1 122.08 167.9 125.55 168.2 124.43 168.3 125.14 168.3 127.25 168.8 128.88 169.8 137.70 171.2 151.63 171.3 146.48 Bob's Average Bob's Number Bob's Average Restaurant of Restaurant Retail Diesel Purchase Tickets Prices (C/Gal) ($/Ticket) (Tickets/Month) 133.96 13.27 9234.00 128.58 10.71 8964.00 122.63 12.43 6894.00 117.40 12.95 7668.00 121.65 11.12 9306.00 122.18 9.62 11916.00 116.26 10.97 10080.00 115.73 9.59 13014.00 115.84 12.01 11124.00 116.68 11.00 10206.00 117.15 11.34 9270.00 116.86 10.25 11664.00 112.25 10.50 11880.00 110.95 13.56 7182.00 110.43 10.16 8802.00 123.70 12.36 8910.00 140.35 13.23 8406.00 131.36 13.03 9090.00 139.15 14.37 8964.00 141.48 9.88 14364.00 146.84 12.54 11610.00 140.13 11.54 9630.00 139.33 13.43 7812.00 146.60 12.61 9702.00 144.68 10.98 11178.00 150.50 10.26 9648.00 153.63 13.67 6498.00 162.88 11.66 8352.00 156.95 13.00 7614.00 Bob's Restaurant Bob's Number Revenue of Fuel Sales ($/Month) (Sales/Month) 122502.98 18617.06 96008.03 15206.21 85705.29 14345.25 99271.22 17443.09 103515.93 17358.41 114652.47 19434.13 110527.66 20201.17 124741.18 22866.44 133628.77 24116.54 112256.90 19848.531 105121.77 18569.57 119534.14 20916.82 124773.98 22609.08 97383.22 17901.76 89442.75 16378.91 110133.82 17518.70 111192.45 15738.02 118408.63 18549.77 128793.43 18306.38) 141955.34 20090.19 145607.94 20033.11 111156.48 16684.14 104898.29 15815.58 122363.08 17093.84 122731.59 17651.62 98978.05 13485.63 88802.73 12170.00 97377.88 12825.03 98949.75 13549.31 Bob's Fuel Bob's Pre Tax Bob's Bob's Bob's Real Revenue Profit | Month | Real Real Gas Diesel ($/Month) ($/Month) Number Profit Price Price 1543088.13 62489.69 3038741.28 70.14 83.05 1210279.67 48985.79 31 30312.99 67.22 79.56 1110069.29 44088.91 32 27232.19 64.79 75.74 1317078.71 51444.68 33 31716.82 62.69 72.38 1312080.06 52903.50 34 32556.00 63.40 74.86 1538956.35 59631.74 35 36628.84 65.33 75.05 1644318.59 59419.93 36 36453.94 65.30 71.33 1841390.91 66889.03 3740985.92 64.66 70.91 1859505.44 70295.66 38 43020.60 62.79 70.89 1486575.40 58141.11 3935538.57 61.69 71.32 1407872.67 54636.49 4033314.94 62.12 71.431 1532334.83 61297.74 4137376.67 60.70 71.26 1562503.64 63537.55 42 38766.05 57.66 68.49 1232852.11 49751.31 4330280.77 57.15 67.53 1096683.18 45262.32 44 27515.09 55.96 67.131 1218113.02 54123.20 45 32801.94 59.52 74.97 1270875.08 55144.90 4633179.84 68.05 84.45 1552172.02 61135.70 4736784.42 68.03 79.04 1451275.59 63620.09 48 38279.24 67.04 83.72 1674298.64 71031.72 4942610.51 69.44 84.871 1776373.57 73576.33 50 44031.32 73.06 87.88 1583823.06 58919.78 5135092.19 74.78 83.46 1485347.32 55491.02 52 32991.10 73.971 82.83 1576152.88 62840.17 5337338.19 74.36 87.11 1681786.75 64247.81 54 38174.58 75.61 85.96 1282823.90 50925.80 55 30169.31 76.35 89.16 1267361.57 47096.17 56 27736.26 81.10 90.471 1500027.97 52966.75 5730938.52 88.57 95.14 1532896.67 53925.92 58 31480.40 85.51 91.62 59 60 62 63 71 72 Date May-2012 Jun-2012 Jul-2012 Aug-2012 Sep-2012 Oct-2012 Nov-2012 Dec-2012 Jan-2013 Feb-2013 Mar-2013 Apr-2013 May 2013 Jun-2013 Jul-2013 Aug-2013 Sep-2013 Oct-2013 Nov-2013 Dec-2013 Jan-2014 Feb-2014 Mar-2014 Apr-2014 May-2014 Jun-2014 Jul-2014 Aug-2014 Sep-2014 Bob's Average Retail Gasoline | Prices (C/gal) 171.5 148.68 172.4 163.33 172.8 155.10 172.8 146.45 173.7 155.03 174.0 153.22 174.1 151.73 174.0 144.28 175.1 144.72 175.81 144.98 176.2 140.93 176.9 155.16 177.7 170.18 178.0 161.63 177.5 142.06 177.5 142.08 178.3 152.15 177.7 131.54 177.4 117.05 176.7 108.60 177.1 110.73 177.8 111.38 178.8 124.93 179.8 139.70 179.8 139.18 179.9 138.23 180.1 139.70 180.7 139.58 181.0 139.96 Bob's Average Retail Diesel Prices (C/Gal) 152.36 150.88 158.00 171.30 194.03 190.36 188.20 181.60 165.88 161.83 159.30 160.98 160.88 161.18 156.12 151.38 165.05 147.52 138.38 127.04 126.90 128.85 139.38 144.42 141.08 142.70 142.76 148.40 159.70 Bob's Average Bob's Number Restaurant of Restaurant Purchase Tickets ($/Ticket) (Tickets/Month) 11.71 9198.00 14.56 6786.00 10.63 11538.00 15.05 9738.00 14.16 9108.00 10.74 11214.00 10.63 12600.00 12.26 11448.00 10.92 9216.00 14.60 6084.00 14.44 7308.00 12.91 7668.00 12.75 8082.00 15.63 7038.00 14.40 9432.00 14.58 9396.00 13.81 8316.00 14.82 7488.00 15.16 8586.00 12.87 10296.00 15.15 6714.00 13.47 6912.00 14.79 7146.00 11.01 9108.00 11.63 9612.00 13.34 8640.00 13.22 9702.00 15.59 8928.00 11.57 10602.00 Bob's Restaurant Bob's Number Bob's Fuel Bob's Pre Tax Revenue of Fuel Sales Revenue Profit ($/Month) (Sales/Month) ($/Month) ($/Month) 107686.51 15541.19 1825934.39 60570.26 98776.89 15143.98 2057118.45 60082.11 122694.97 17108.91 2103211.15 69282.08 146528.10 17532.88 1893504.70 75323.85 128988.14 13137.60 1447277.88 63641.09 120459.60 12559.52 1373080.75 59695.43 133966.79 14135.94 1531707.77 66445.62 140341.99 15228.17 1556319.75 69019.34 100667.51 12582.85 1357545.90 52434.16 88823.32 11551.92 1266207.57 47089.61 105491.62 13827.20 1463469.09 55439.36 99031.39 13429.49 1636287.83 55189.89 103029.70 14643.27 2049538.64 61535.69 110029.97 15219.33 1970602.78 63136.16 135808.31 18453.62 1998327.36 72747.57 137030.37 19501.11 2146250.82 74958.81 114820.39 14839.60 1732817.43 62023.53 111003.15 15792.16 1566677.43 58658.86 130167.36 19168.99 1645124.28 66466.00 132526.28 21386.37 1712646.28 68127.33 101738.77 16634.92 1373219.15 53007,49 93101.75 14921.21 1232767.84 48219.40 105718.94 15938.43 1505799.59 56029.94 100268.75 15187.95 1669206.67 56028.47 111763.34 17502.03.1935464.69 63343.28 115234.70 17674.61 1923324.86 64450.30 128222.15 19765.98 2185114.97 72250.87 139146.34 20230.12 2189671.00 76239.86 122620.57 15946.07 1667833.92 64039.79 Bob's Bob's Bob's Real Month Real Real Gas Diesel Number Profit Price Price 59 35317.94 86.69 88.84 6034850.41 94.74 87.51 6140093.80 89.76 91.44 62 43590.19 84.751 99.13 63 36638.51 89.25 111.70 64 34307.72 88.06 109.40 65 38165.20 87.15 108.10 66 39666.29 82.92 104.37 6729945.27 82.65 94.73 68 26785.90 82.47 92.05 69 31463.88 79.98 90.41 70 31198.36 87.71 91.00 71 34628.97 95.77 90.53 72 35469.75 90.80 90.55 7340984.54 80.03 87.95 74 42230.32 80.04 85.28 75 34786.05 85.33 92.57 7633010.05 74.02 83.02 77 37466.74 65.98 78.00 78 38555.37 61.46 71.90 7929930.83 62.52 71.65 80 27120.02 62.64 72.47 81 31336.66 69.87 77.95 82 31161.55 77.70 80.32 83 35229.86 77.41 78.46 84 35825.63 76.83 79.32 85 40117.09 77.57 79.27 86 42191.40 77.24 82.13 87 35381.10 77.33 88.23 74 86 87 88 87 89 90 Date Aug-2014 88 Sep-2014 Oct-2014 Nov-2014 91 Dec-2014 Jan-2015 Feb-2015 Mar-2015 Apr-2015 May-2015 Jun-2015 98 Jul-2015 99 Aug-2015 100 Sep-2015 101 Oct-2015 102 Nov-2015 103 Dec-2015 104 Jan-2016 105 Feb-2016 106 Mar-2016 107 Apr-2016 108 May-2016 109 Jun-2016 110 Averages CPI 180.7 181.0 181.3 181.3 180.9 181.7 183.1 184.2 183.8 183.5 183.7 183.9 184.6 185.2 185.0 184.5 184.3 185.2 186.2 187.4 188.0 189.1 189.7 170.05 97 Bob's Average Bob's Number Restaurant of Restaurant Purchase Tickets ($/Ticket) (Tickets/Month) 15.59 8928.00 11.57 10602.00 15.09 7218.00 13.30 9126.00 12.98 9828.00 13.16 7506.00 12.13 7308.00 13.58 7704.00 14.52 7092.001 12.37 9378.00 17.00 7092.00 16.39 8460.00 17.28 8244.00 12.75 8496.00 14.01 7632.00 14.95 8298.00 16.71 8028.00 13.30 7452.00 17.16 5580.00 13.01 8334.00 16.64 7362.00 15.32 8712.00 14.82 8298.00 12.55 9252.33 Bob's Average Bob's Average Retail Gasoline Retail Diesel Prices (C/gal) Prices (C/Gal) 139.58 148.40 139.96 159.70 144.53 155.68 141.90 153.15 138.58 152.40 145.75 157.85 161.30 172.50 169.30 181.78 158.90 165.03 149.73 154.25 149.28 158.14 151.25 163.48 162.03 172.53 167.88 165.58 156.35 162.20 151.20 163.90 147.88 168.06 157.18 167.65 164.75 180.90 173.60 189.66 179.78 217.08 198.34 228.44 196.93 205.63 131.30 148.00 Bob's Restaurant Bob's Number Bob's Fuel Bob's Pre Tax Revenue of Fuel Sales Revenue Profit ($/Month) (Sales/Month) ($/Month) ($/Month) 139146.34 20230.12 2189671.00 76239.86 122620.57 15946.07 1667833.92 64039.79 108927.76 14977.48 1667377.93 59121.76 121366.17 16959.431 1851827.04 65802.52 127571.51 17730.66 1872332.20 68276.50 98746.69 13358.18 1495487.17 53403.94 88675.44 11058.41 1379097.35 48390.80 104621.34 12361.15 1614680.62 56944.47 102949.71 13617.97 1698382.83 57342.47 115969.00 16468.06 1943181.32 64951.23 120573.51 16492.49 1912833.80 66248.97 138635.84 18113.91 2106646.61 75060.20 142476.67 17789.58 2233514.13 77961.01 108312.87 14662.27 1982783.61 62660.11 106889.42 14402.76 1768414.00 59597.66 124085.00 16160.58 1875997.31 67068.74 134149.23 16636.82 1842487.27 70277.53 99121.11 12725.82 1548542.75 54174.02 95779.34 11247.96 1413213.83 51353.02 108387.69 12154.23 1613352.03 58280.91 122529.63 11369.54 1481476.95 61751.94 133442.03 12087.37 1782659.41 69302.27 122944.78 13006.38 2004741.78 68198.26 113619.55 16280.06 1582619.62 59777.65 Bob's Bob's Bob's Real Month Real Real Gas Diesel Number | Profit Price Price 86 42191.40 77.24 82.13 87 35381.100 77.33 88.23 88 32609.91 79.72 85.87 8936294.82 78.27 84.47 90 37742.67 76.61 84.25 91 29391.27 80.21 86.87 92 26428.62 88.09 94.21 93 30914.48 91.91 98.69 94 31198.30 86.45 89.79 95 35395.77 81.59 84.06 96 36063.68 81.26 86.09 9740815.77 82.25 88.89 9842232.401 87.77 93.46 99 33833.75 90.65 89.41 100 32214.95 84.51 87.68 101 36351.62 81.95 88.83 102 38132.14 80.24 91.19 103 29251.63 84.87 90.52 104 27579.49 88.48 97.15 105 31099.74 92.64 101.21 106 32846.78 95.63 115.47 107 36648.48 104.89 120.80 108 35950.59 103.81 108.39 54.50 35193.79 76.88 86.85 I A G L M N CPI Date Jul-2007 Aug-2007 Sep-2007 Oct-2007 Nov-2007 Dec-2007 Jan-2008 Feb-2008 Mar-2008 Apr-2008 May-2008 Jun-2008 Jul-2008 Aug-2008 Sep-2008 Oct-2008 Nov-2008 Dec-2008 Jan-2009 Feb-2009 Mar-2009 Apr-2009 May-2009 Jun-2009 Jul-2009 Aug-2009 Sep-2009 Oct-2009 Nov-2009 H Bob's Average Bob's Number Bob's Bob's Average Bob's Average Restaurant of Restaurant | Restaurant Bob's Number Bob's Fuel Bob's Pre Tax Retail Gasoline Retail Diesel Purchase Tickets Revenue of Fuel Sales Revenue Profit Prices (C/gal) Prices (C/Gal) ($/Ticket) (Tickets/Month) ($/Month) (Sales/Month) ($/Month) ($/Month) 152.5 115.38 126.62 9.28 12564.00 116566.39 19535.12 1719419.54 62490.63 152.9 112.33 127.13 10.47 11970.00 125340.03 20586.74 1735584.14 65832.00 153.2 111.08 129.38 11.52 9198.00 105988.89 16820.46 1380911.21 54620.25 153.7 108.72 130.66 11.59 8892.00 103068.03 15923.471 1258023.32 52087.36 153.6 106.23 131.28 8.72 13500.00 117723.95 17849.94 1356895.91 58522.37 153.5 107.13 132.15 10.11 12006.00 121371.12 18296.19 1403992.87 60396.90 154.4 109.04 132.18 12.37 7596.00 93924.96 14286.58 1126695.42 47227.64 154.9 108.93 127.65 9.61 8874.001 85278.47 13671.40 1097032.10 43777.44 155.7 113.70 127.58 11.88 7794.00 92573.20 15203.78 1303407.34 48880.60 156.3 123.06 152.88 9.95 10530.00 104789.97 13594.11 1193672.70 51919.92 156.6 127.92 161.47 11.49 10548.00 121174.22 14762.46 1335500.40 59491.88 156.7 125.58 152.85 12.82 9234.00 118421.25 15533.24 1407689.80 59388.24 157.0 122.72 147.06 9.05 14490.00 131203.26 18040.69 1611424.26 66427.33 157.3 120.65 143.95 12.04 11304.00 136063.69 19166.11 1687014.10 69081.35 157.8 120.22 146.68 12.47 9162.00 114290.24 15608.78 1352294.64 57240.48 158.3 120.40 148.63 11.92 9144.00 108966.06 14592.84 1258114.80 54194.55 158.6 123.23 147.05 10.86 10818.00 117443.80 16195.95 1455855.09 59624.36 158.6 123.52 143.33 12.12 9738.00 118061.16 16950.87 1550693.11 60992.81 159.1 123.63 142.67 10.46 8802.00 92058.67 13335.51 1224580.24 47746.68 159.6 123.00 150.89 11.72 7560.00 88634.88 11747.76 1038286.30 44265.06 160.00 120.50 147.52 11.31 9180.00 103801.42 14064.62 1219143.81 51877.06 160.2 119.90 148.61 11.83 9054.00 107084.78 14319.29 1226668.88 53140.88 160.1 120.03 137.59 11.44 9846.00 112613.97 16954.03 1516958.41 58635.38 160.3 119.76 130.44 11.95 9072.00 108404.71 17682.97 1621853.23 58387.89 160.5 117.43 126.68 10.79 11178.00 120648.40 20383.04 1842223.39 65429.26 160.8 122.35 133.70 9.39 13572.00 127455.83 20246.80 1893910.48 68493.30 161.2 123.14 135.70 10.86 9702.00 105360.20 16441.35 1541077.44 56326.49 161.6 119.68 134.68 12.84 7884.00 101265.29 15756.56 1419568.68 53396.75 161.5 117.08 139.03 9.92 12006.00 119076.29 17404.92 1490427.20 60626.40 Bob's Bob's Bob's Real Month Real Real Gas Diesel Number Profit | Price Price 1 40977.46 75.66 83.03 2 43055.59 73.46 83.14 335652.90 72.50 84.45 433888.98 70.74 85.01 5 38100.50 69.16 85.47 6 39346.52 69.79 86.09 730587.85 70.62 85.61 8 28261.74 70.32 82.41 9 31394.09 73.03 81.94 1033218.12 78.73 97.81 11 37989.71 81.68 103.11 12 37899.32 80.14 97.54 13 42310.40 78.17 93.67 14 43916.94 76.70 91.51 15 36274.07 76.18 92.95 1634235.34 76.06 93.89 17 37594.17 77.70 92.72 1838457.01 77.88 90.37 19 30010.49 77.70 89.67 20 27735.000 77.07 94.54 21 32423.16 75.31 92.20 22 33171.59 74.84 92.76 2336624.22 74.97 85.94 24 36424.14 74.71 81.37 25 40765.89 73.16 78.93 26 42595.34 76.09 83.15 2734941.99 76.39 84.18 28 33042.55 74.06 83.34 29 37539.56 72.49 86.08 18 30 36 37 Date Dec-2009 Jan-2010 Feb-2010 Mar-2010 Apr-2010 May-2010 Jun-2010 Jul-2010 Aug-2010 Sep-2010 Oct-2010 Nov-2010 Dec-2010 Jan-2011 Feb-2011 Mar-2011 Apr-2011 May-2011 Jun-2011 Jul-2011 Aug-2011 Sep-2011 Oct-2011 Nov-2011 Dec-2011 Jan-2012 Feb-2012 Mar-2012 Apr-2012 Bob's Average Retail Gasoline | Prices (C/gal) 161.3 113.14 161.6 108.63 161.9 104.90 162.2 101.68 162.5 103.03 162.8 106.35 163.01 106.44 163.2 105.53 163.4 102.60 163.6 100.93 164.0 101.88 164.00 99.54 163.9 94.50 164.3 93.90 164.5 92.05 165.0 98.20 166.2 113.10 166.2 113.06 166.2 111.43 166.7 115.75 167.1 122.08 167.9 125.55 168.2 124.43 168.3 125.14 168.3 127.25 168.8 128.88 169.8 137.70 171.2 151.63 171.3 146.48 Bob's Average Bob's Number Bob's Average Restaurant of Restaurant Retail Diesel Purchase Tickets Prices (C/Gal) ($/Ticket) (Tickets/Month) 133.96 13.27 9234.00 128.58 10.71 8964.00 122.63 12.43 6894.00 117.40 12.95 7668.00 121.65 11.12 9306.00 122.18 9.62 11916.00 116.26 10.97 10080.00 115.73 9.59 13014.00 115.84 12.01 11124.00 116.68 11.00 10206.00 117.15 11.34 9270.00 116.86 10.25 11664.00 112.25 10.50 11880.00 110.95 13.56 7182.00 110.43 10.16 8802.00 123.70 12.36 8910.00 140.35 13.23 8406.00 131.36 13.03 9090.00 139.15 14.37 8964.00 141.48 9.88 14364.00 146.84 12.54 11610.00 140.13 11.54 9630.00 139.33 13.43 7812.00 146.60 12.61 9702.00 144.68 10.98 11178.00 150.50 10.26 9648.00 153.63 13.67 6498.00 162.88 11.66 8352.00 156.95 13.00 7614.00 Bob's Restaurant Bob's Number Revenue of Fuel Sales ($/Month) (Sales/Month) 122502.98 18617.06 96008.03 15206.21 85705.29 14345.25 99271.22 17443.09 103515.93 17358.41 114652.47 19434.13 110527.66 20201.17 124741.18 22866.44 133628.77 24116.54 112256.90 19848.531 105121.77 18569.57 119534.14 20916.82 124773.98 22609.08 97383.22 17901.76 89442.75 16378.91 110133.82 17518.70 111192.45 15738.02 118408.63 18549.77 128793.43 18306.38) 141955.34 20090.19 145607.94 20033.11 111156.48 16684.14 104898.29 15815.58 122363.08 17093.84 122731.59 17651.62 98978.05 13485.63 88802.73 12170.00 97377.88 12825.03 98949.75 13549.31 Bob's Fuel Bob's Pre Tax Bob's Bob's Bob's Real Revenue Profit | Month | Real Real Gas Diesel ($/Month) ($/Month) Number Profit Price Price 1543088.13 62489.69 3038741.28 70.14 83.05 1210279.67 48985.79 31 30312.99 67.22 79.56 1110069.29 44088.91 32 27232.19 64.79 75.74 1317078.71 51444.68 33 31716.82 62.69 72.38 1312080.06 52903.50 34 32556.00 63.40 74.86 1538956.35 59631.74 35 36628.84 65.33 75.05 1644318.59 59419.93 36 36453.94 65.30 71.33 1841390.91 66889.03 3740985.92 64.66 70.91 1859505.44 70295.66 38 43020.60 62.79 70.89 1486575.40 58141.11 3935538.57 61.69 71.32 1407872.67 54636.49 4033314.94 62.12 71.431 1532334.83 61297.74 4137376.67 60.70 71.26 1562503.64 63537.55 42 38766.05 57.66 68.49 1232852.11 49751.31 4330280.77 57.15 67.53 1096683.18 45262.32 44 27515.09 55.96 67.131 1218113.02 54123.20 45 32801.94 59.52 74.97 1270875.08 55144.90 4633179.84 68.05 84.45 1552172.02 61135.70 4736784.42 68.03 79.04 1451275.59 63620.09 48 38279.24 67.04 83.72 1674298.64 71031.72 4942610.51 69.44 84.871 1776373.57 73576.33 50 44031.32 73.06 87.88 1583823.06 58919.78 5135092.19 74.78 83.46 1485347.32 55491.02 52 32991.10 73.971 82.83 1576152.88 62840.17 5337338.19 74.36 87.11 1681786.75 64247.81 54 38174.58 75.61 85.96 1282823.90 50925.80 55 30169.31 76.35 89.16 1267361.57 47096.17 56 27736.26 81.10 90.471 1500027.97 52966.75 5730938.52 88.57 95.14 1532896.67 53925.92 58 31480.40 85.51 91.62 59 60 62 63 71 72 Date May-2012 Jun-2012 Jul-2012 Aug-2012 Sep-2012 Oct-2012 Nov-2012 Dec-2012 Jan-2013 Feb-2013 Mar-2013 Apr-2013 May 2013 Jun-2013 Jul-2013 Aug-2013 Sep-2013 Oct-2013 Nov-2013 Dec-2013 Jan-2014 Feb-2014 Mar-2014 Apr-2014 May-2014 Jun-2014 Jul-2014 Aug-2014 Sep-2014 Bob's Average Retail Gasoline | Prices (C/gal) 171.5 148.68 172.4 163.33 172.8 155.10 172.8 146.45 173.7 155.03 174.0 153.22 174.1 151.73 174.0 144.28 175.1 144.72 175.81 144.98 176.2 140.93 176.9 155.16 177.7 170.18 178.0 161.63 177.5 142.06 177.5 142.08 178.3 152.15 177.7 131.54 177.4 117.05 176.7 108.60 177.1 110.73 177.8 111.38 178.8 124.93 179.8 139.70 179.8 139.18 179.9 138.23 180.1 139.70 180.7 139.58 181.0 139.96 Bob's Average Retail Diesel Prices (C/Gal) 152.36 150.88 158.00 171.30 194.03 190.36 188.20 181.60 165.88 161.83 159.30 160.98 160.88 161.18 156.12 151.38 165.05 147.52 138.38 127.04 126.90 128.85 139.38 144.42 141.08 142.70 142.76 148.40 159.70 Bob's Average Bob's Number Restaurant of Restaurant Purchase Tickets ($/Ticket) (Tickets/Month) 11.71 9198.00 14.56 6786.00 10.63 11538.00 15.05 9738.00 14.16 9108.00 10.74 11214.00 10.63 12600.00 12.26 11448.00 10.92 9216.00 14.60 6084.00 14.44 7308.00 12.91 7668.00 12.75 8082.00 15.63 7038.00 14.40 9432.00 14.58 9396.00 13.81 8316.00 14.82 7488.00 15.16 8586.00 12.87 10296.00 15.15 6714.00 13.47 6912.00 14.79 7146.00 11.01 9108.00 11.63 9612.00 13.34 8640.00 13.22 9702.00 15.59 8928.00 11.57 10602.00 Bob's Restaurant Bob's Number Bob's Fuel Bob's Pre Tax Revenue of Fuel Sales Revenue Profit ($/Month) (Sales/Month) ($/Month) ($/Month) 107686.51 15541.19 1825934.39 60570.26 98776.89 15143.98 2057118.45 60082.11 122694.97 17108.91 2103211.15 69282.08 146528.10 17532.88 1893504.70 75323.85 128988.14 13137.60 1447277.88 63641.09 120459.60 12559.52 1373080.75 59695.43 133966.79 14135.94 1531707.77 66445.62 140341.99 15228.17 1556319.75 69019.34 100667.51 12582.85 1357545.90 52434.16 88823.32 11551.92 1266207.57 47089.61 105491.62 13827.20 1463469.09 55439.36 99031.39 13429.49 1636287.83 55189.89 103029.70 14643.27 2049538.64 61535.69 110029.97 15219.33 1970602.78 63136.16 135808.31 18453.62 1998327.36 72747.57 137030.37 19501.11 2146250.82 74958.81 114820.39 14839.60 1732817.43 62023.53 111003.15 15792.16 1566677.43 58658.86 130167.36 19168.99 1645124.28 66466.00 132526.28 21386.37 1712646.28 68127.33 101738.77 16634.92 1373219.15 53007,49 93101.75 14921.21 1232767.84 48219.40 105718.94 15938.43 1505799.59 56029.94 100268.75 15187.95 1669206.67 56028.47 111763.34 17502.03.1935464.69 63343.28 115234.70 17674.61 1923324.86 64450.30 128222.15 19765.98 2185114.97 72250.87 139146.34 20230.12 2189671.00 76239.86 122620.57 15946.07 1667833.92 64039.79 Bob's Bob's Bob's Real Month Real Real Gas Diesel Number Profit Price Price 59 35317.94 86.69 88.84 6034850.41 94.74 87.51 6140093.80 89.76 91.44 62 43590.19 84.751 99.13 63 36638.51 89.25 111.70 64 34307.72 88.06 109.40 65 38165.20 87.15 108.10 66 39666.29 82.92 104.37 6729945.27 82.65 94.73 68 26785.90 82.47 92.05 69 31463.88 79.98 90.41 70 31198.36 87.71 91.00 71 34628.97 95.77 90.53 72 35469.75 90.80 90.55 7340984.54 80.03 87.95 74 42230.32 80.04 85.28 75 34786.05 85.33 92.57 7633010.05 74.02 83.02 77 37466.74 65.98 78.00 78 38555.37 61.46 71.90 7929930.83 62.52 71.65 80 27120.02 62.64 72.47 81 31336.66 69.87 77.95 82 31161.55 77.70 80.32 83 35229.86 77.41 78.46 84 35825.63 76.83 79.32 85 40117.09 77.57 79.27 86 42191.40 77.24 82.13 87 35381.10 77.33 88.23 74 86 87 88 87 89 90 Date Aug-2014 88 Sep-2014 Oct-2014 Nov-2014 91 Dec-2014 Jan-2015 Feb-2015 Mar-2015 Apr-2015 May-2015 Jun-2015 98 Jul-2015 99 Aug-2015 100 Sep-2015 101 Oct-2015 102 Nov-2015 103 Dec-2015 104 Jan-2016 105 Feb-2016 106 Mar-2016 107 Apr-2016 108 May-2016 109 Jun-2016 110 Averages CPI 180.7 181.0 181.3 181.3 180.9 181.7 183.1 184.2 183.8 183.5 183.7 183.9 184.6 185.2 185.0 184.5 184.3 185.2 186.2 187.4 188.0 189.1 189.7 170.05 97 Bob's Average Bob's Number Restaurant of Restaurant Purchase Tickets ($/Ticket) (Tickets/Month) 15.59 8928.00 11.57 10602.00 15.09 7218.00 13.30 9126.00 12.98 9828.00 13.16 7506.00 12.13 7308.00 13.58 7704.00 14.52 7092.001 12.37 9378.00 17.00 7092.00 16.39 8460.00 17.28 8244.00 12.75 8496.00 14.01 7632.00 14.95 8298.00 16.71 8028.00 13.30 7452.00 17.16 5580.00 13.01 8334.00 16.64 7362.00 15.32 8712.00 14.82 8298.00 12.55 9252.33 Bob's Average Bob's Average Retail Gasoline Retail Diesel Prices (C/gal) Prices (C/Gal) 139.58 148.40 139.96 159.70 144.53 155.68 141.90 153.15 138.58 152.40 145.75 157.85 161.30 172.50 169.30 181.78 158.90 165.03 149.73 154.25 149.28 158.14 151.25 163.48 162.03 172.53 167.88 165.58 156.35 162.20 151.20 163.90 147.88 168.06 157.18 167.65 164.75 180.90 173.60 189.66 179.78 217.08 198.34 228.44 196.93 205.63 131.30 148.00 Bob's Restaurant Bob's Number Bob's Fuel Bob's Pre Tax Revenue of Fuel Sales Revenue Profit ($/Month) (Sales/Month) ($/Month) ($/Month) 139146.34 20230.12 2189671.00 76239.86 122620.57 15946.07 1667833.92 64039.79 108927.76 14977.48 1667377.93 59121.76 121366.17 16959.431 1851827.04 65802.52 127571.51 17730.66 1872332.20 68276.50 98746.69 13358.18 1495487.17 53403.94 88675.44 11058.41 1379097.35 48390.80 104621.34 12361.15 1614680.62 56944.47 102949.71 13617.97 1698382.83 57342.47 115969.00 16468.06 1943181.32 64951.23 120573.51 16492.49 1912833.80 66248.97 138635.84 18113.91 2106646.61 75060.20 142476.67 17789.58 2233514.13 77961.01 108312.87 14662.27 1982783.61 62660.11 106889.42 14402.76 1768414.00 59597.66 124085.00 16160.58 1875997.31 67068.74 134149.23 16636.82 1842487.27 70277.53 99121.11 12725.82 1548542.75 54174.02 95779.34 11247.96 1413213.83 51353.02 108387.69 12154.23 1613352.03 58280.91 122529.63 11369.54 1481476.95 61751.94 133442.03 12087.37 1782659.41 69302.27 122944.78 13006.38 2004741.78 68198.26 113619.55 16280.06 1582619.62 59777.65 Bob's Bob's Bob's Real Month Real Real Gas Diesel Number | Profit Price Price 86 42191.40 77.24 82.13 87 35381.100 77.33 88.23 88 32609.91 79.72 85.87 8936294.82 78.27 84.47 90 37742.67 76.61 84.25 91 29391.27 80.21 86.87 92 26428.62 88.09 94.21 93 30914.48 91.91 98.69 94 31198.30 86.45 89.79 95 35395.77 81.59 84.06 96 36063.68 81.26 86.09 9740815.77 82.25 88.89 9842232.401 87.77 93.46 99 33833.75 90.65 89.41 100 32214.95 84.51 87.68 101 36351.62 81.95 88.83 102 38132.14 80.24 91.19 103 29251.63 84.87 90.52 104 27579.49 88.48 97.15 105 31099.74 92.64 101.21 106 32846.78 95.63 115.47 107 36648.48 104.89 120.80 108 35950.59 103.81 108.39 54.50 35193.79 76.88 86.85