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?
1 2 2 G ? 153.5 9 10 17 12 13 1570 14 16 8 Date Jul-2007 Aug 2007 Sep-2017 Oct-2007 Nov-2007 Dec-2017 Jan-2008 Feb-2008 Mar-2008 Apr-2018 May-2008 Jun 2008 Jul-2018 Aug-2008 Sep 2008 Oct-2018 Nov-2008 Dec-2008 Jan-2019 Feb-2009 Mar 2009 Apr-2010 May-2009 Jun-2009 Jul-2019 Aug-2009 Sep-2000 Oct-2009 Nov-2009 Dec-2009 Jan 2010 Feb-2010 Mar-2010 Apr 2010 Bob's Average Bob's Number of Bob's Average Bob's Average Restaurant Restaurant Retail Gasoline Retail Diesel Purchase Tickets CPI Prices (Cigall Prices (C/Gal) {$/Ticket) Tickets/Month 152.5 115 38 120.62 $928 12564.00 152.9 112.33 127.13 $10.47 11970.00 1832 111.08 129.38 $11.52 9199.00 153.71 108.72 130.65 $1159 8892.00 153.8 106.23 131.28 $8.72 13500.00 107.13 132.18 $10.11 12000.00 1544 10904 132.18 $1237 7596.00 154.9 108.93 127.65 $9.81 8874.00 155.7 113.70 127.64 $11.96 7794.00 156,3 12306 152.88 $9.95 10530.00 156.6 127.92 161.47 $11.491 10548.00 156.7 125.58 152.8% $12.42 9234.00 12272 147.00 $9.05 14490.00 1573 120.85 143.95 $12.04 11304001 1578 12022 148.68 $12.47 9162.00 158.3 120.40 148.53 $11.92 9144.001 158.6 123 23 147.05 $10.86 10B18.001 158.8 123.52 143.33 $12.12 9738.00 1.5.1 123.63 142.67 $10.46 8902.00 159.6 123.00 150.89 $11.72 7560.00 160.0 120.50 147.521 $1131 9180.00 160.2 119.90 148.651 $11.83 9054.001 160.1 120.03| 137.591 $11.41 9845.00 180.3 119.76 130.44 $11.95 9072.00 100.5 11743 126.64 $10.9 11179.00 160 31 122 35 133.70 $9.39 15572.00 18121 123.14 135.70 $10.88 9702.00 1618 119.68 124.14 $12.84 7984.00 1515 11708 139,031 $9.92 1200500 1613 113.14 133.98 $1327 9234.00 161.6 106.63 124.59 $10.71 B964.00 1619 104.90 122.63 $1243 6894.00 1622 101.68 117.40 $12.95 7668.00 162.5 103.02 121.65 $11.12 9308.00 Bob's Restaurant Revenue ($/Month) 5116,556.39 S125,340.03 $105.998.99 $103 058.03 S117,723.95 $121.3/1.12 $93 924.86 385,278.47 $92.573,20 S104 789 97 $121,174.22 S119.421.26 $131 203.26 S136,063.69 S114.290.24 S109.986.016 $117,143,80 $110.081.16 $92058.67 588,634.88 S103.801.42 $107.094.78 S112 613.87 S108.404.71 $120.648.40 S127 455.83 S105,380.20 S101205.29 $119076.29 S122,502.98 $98.008.03 $85 705.29 399,271.22 S103,515.93 Bob's Number Bob's Fuel of Fuel Sales Revenue (Sales/Month) ($/Month) 13,535.12 $1,718 419.54 20,586.74 $1,735,584.14 16.820.45 $1,380.911.21 15.923 471 $1,258023.32 17,849.94 $1,358,898.01 18.296.19 $1,403.992.97 14 286.58 $1,125 695.42 13,671.40 31,097,032.10 15.203.78 $1,303.407.34 13,594.11 $1,193 672.70 14,762.46 31,335,500.40 15,633.24 $1,407.699.80 18.040.60 $1,611 424.26 19,186.11 51,887,014.10 15,808.78 $1,362.294.84 14.592.84 $1,250.114.80 18,195.95 51,455,855.09 18,950.87 $1,550.693.11 13.335.51 $1,224.580.24 11,747.76 51,088 286.30 14,084.82 $1,219.143.81 14.319.29 $1,226.618.98 15,954 03 $1,515 958.41 17,682.97 $1,821,853.23 20.383.014 $1,942.223.39 20246 80 $1,893 91048 18,441.35 31,541,077.44 15.756.56 $1,419.08.68 17.404.92 $1,490 427.20 18,617.06 31,543.006.13 15,206.21 $1,210,279.87 14,345,25 $1,110 059.29 17.443.09 31,317,078.71 17.356.41 $1,312.080.06 Bab's Pre Tax Profit (S/Month 562.490.63 S85,832.00 S54,620.25 S52.087.36 S58,522 37 S60,398.90 547.227 64 S43,777.44 S48,480.00 S51,918 92 559,491.88 S59,389.24 S66,427.33 $69,081.35 S57,240.48 S54,134.55 $59,624.36 S80,992.81 $47,741.68 $14,265.06 S51,877.08 S53,140.BA $58,555.38 S58,367.601 S5,429.26 558,493.50 S56,328.49 S53,398.75 $60.52540 S82,489.68 S48,965.70 544,088.91 S51,444.68 S52,903.50 Month Bob's Real Gas Number Bob's Real Profit Price $40,877.46 75.86 2 S43,055.591 73.46 3 $28,642.90 72.50 4 $33,888 98 70.74 5 $38,100.50 89.18 $39,34642 69.79 7 $30,587 85 70.62 8 $28,281.74 70.32 9 S31,294.00 73.03 10 $33,2 18.12 78.73 11 $37,889.71 81.68 01.com 12 $27,099.32 B0.14 13 $42,310 40 78.17 14 $13,816 91 76.70 15 $26,274.07 76.18 16 $34,235 34 76.06 17 $37,591.17 77.70 18 $28,45701 77.88 19 $301,111.49 77.70 20 $27,735.00 77.07 21 $32,423.10 75.31 22 $33,171.601 23 $36.624 22 74.87 24 $38,424.14 74.71 29 $40,765 801 73.10 26 S42,595 341 76.09 27 $34.64 1.99 78.39 za $23,042.55 74.06 29 $37,539 55 72.49 30 $38,741 28 70.14 21 $20,312.99 67.22 32 $27,232.15 64.79 93 $31,716 82 62.69 $32,56800 83.40 Bob's Real Average Bob's Real Restaurant Purchase Diesel Price S/Ticket) 83.03 6.08 83.14 8.85 84.45 7.52 8501 7.54 85.47 5.88 86.00 6.59 8561 8.01 82.41 8.20 81.94 9781 6.37 103.11 7.34 97.54 B.18 93 67 5.77 91.51 7.65 92.95 7.91 93 8! 7.53 92.72 6.85 90 37 8967 6.57 94.51 7.35 9220 7.07 92.76 7.38 85 94 7.14 8137 7.45 78.92 6.72 83.15 5.84 84.16 6.74 83 34 7.95 DE 8608 6.14 83.05 8.22 79.66 6.83 75.74 7.68 72.38 7.98 74 88 0.85 7.84 20 21 . 23 2H 29 JU 21 92 33 34 95 DONJI ITIC PICJUIITIVE TUITINEI 34 ( 35 36 37 38 39 40 41 42 43 44 45 46 47 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 May-2012 162.5 162.8 163.0 163.2 163.4 163.6 164.0 164.0 163.9 164.3 164.5 165.0 166.2 166.2 166.2 166.7 167.1 167.9 168.2 168.3 168.3 168.8 169.8 171.2 171.3 171.5 THUCO lviya 103.03 106.35 106.44 105.53 102.60 100.93 101.88 99.54 94.50 93.90 92.05 98.20 113.10 113.06 111.43 115.75 122.08 125.55 124.43 125.14 127.25 128.88 137.70 151.63 146.48 148.68 T TUCS Tour 121.65 122.18 116.26 115.73 115.84 116.68 117.15 116.86 112.25 110.95 110.43 123.70 140.35 131.36 139.15 141.48 146.84 140.13 139.33 146.60 144.68 150.50 153.63 162.88 156.95 152.36 TURC $11.12 $9.62 $10.97 $9.59 $12.01 $11.00 $11.34 $10.25 $10.50 $13.56 $10.16 $12.36 $13.23 $13.03 $14.37 $9.88 $12.54 $11.54 $13.43 $12.61 $10.98 $10.26 $13.67 $11.66 $13.00 $11.71 TUNCESTIIVITI 9306.00 11916.00 10080.00 13014.00 11124.00 10206.00 9270.00 11664.00 11880.00 7182.00 8802.00 8910.00 8406.00 9090.00 8964.00 14364.00 11610.00 9630.00 7812.00 9702.00 11178.00 9648.00 6498.00 8352.00 7614.00 9198.00 TYTIVIUITCITY $103,515.93 $114,652.47 $110,527.66 $124,741.18 $133,628.77 $112,256.90 $105,121.77 $119,534.14 $124,773.98 $97,383.22 $89,442.75 $110,133.82 $111,192.45 $118,408.63 $128,793.43 $141,955.34 $145,607.94 $111,156.48 $104,898.29 $122,363.08 $122,731.59 $98,978.05 $88,802.73 $97,377.88 $98,949.75 $107,686.51 TUICOTIVIUIT) 17,358.41 19,434.13 20,201.17 22,866.44 24,116.54 19,848.53 18,569.57 20,916.82 22,609.08 17,901.76 16,378.91 17,518.70 15,738.02 18,549.77 18,306.38 20,090.19 20,033.11 16,684.14 15,815.58 17,093.84 17,651.62 13,485.63 12,170.00 12,825.03 13,549.31 15,541.19 TYTIVIUITCITY TTUITIIVITIC) $1,312,080.06 $52,903.50 $1,538,956.35 $59,631.74 $1,644,318.59 $59,419.93 $1,841,390.91 $66,889.03 $1,859,505.44 $70,295.66 $1,486,575.40 $58,141.11 $1,407,872.67 $54,636.49 $1,532,334.83 $61,297.74 $1,562,503.64 $63,537.55 $1,232,852.11 $49,751.31 $1,096,683.18 $45,262.32 $1,218,113.02 $54,123.20 $1,270,875.08 $55,144.90 $1,552,172.02 $61,135.70 $1,451,275.59 $63,620.09 $1,674,298.64 $71,031.72 $1,776,373.57 $73,576.33 $1,583,823.06 $58,919.78 $1,485,347.32 $55,491.02 $1,576,152.88 $62,840.17 $1,681,786.75 $64,247.81 $1,282,823.90 $50,925.80 $1,267,361.57 $47,096.17 $1,500,027.97 $52,966.75 $1,532,896.67 $53,925.92 $1,825,934.39 $60,570.26 $32,556.00 $36,628.84 $36,453.94 $40,985.92 $43,020.60 $35,538.57 $33,314.94 $37,376.67 $38,766.05 $30,280.77 $27,515.09 $32,801.94 $33,179.84 $36,784.42 $38,279.24 $42,610.51 $44,031.32 $35,092.19 $32,991.10 $37,338.19 $38,174.58 $30,169.31 $27,736.26 $30,938.52 $31,480.40 $35,317.94 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 63.40 65.33 65.30 64.66 62.79 61.69 62.12 60.70 57.66 57.15 55.96 59.52 68.05 68.03 67.04 69.44 73.06 74.78 73.97 74.36 75.61 76.35 81.10 88.57 85.51 86.69 74.86 75.05 71.33 70.91 70.89 71.32 71.43 71.26 68.49 67.53 67.13 74.97 84.45 79.04 83.72 84.87 87.88 83.46 82.83 87.11 85.96 89.16 90.47 95.14 91.62 88.84 6.85 5.91 6.73 5.87 7.35 6.72 6.91 6.25 6.41 8.25 6.18 7.49 7.96 7.84 8.64 5.93 7.51 6.87 7.98 7.49 6.52 6.08 8.05 6.81 7.59 6.83 48 49 50 51 52 53 54 55 56 57 58 59 60 CPI 60 61 62 63 64 65 66 67 68 69 70 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 Bob's Average Retail Gasoline Prices (C/gal) 148.68 163.33 155.10 146.45 155.03 153.22 151.73 144.28 144.72 144.98 140.93 155.16 170.18 161.63 142.06 142.08 152.15 131.54 117.05 108.60 110.73 111.38 124.93 139.70 139.18 138.23 171.5 172.4 172.8 172.8 173.7 174.0 174.1 174.0 175.1 175.8 176.2 176.9 177.7 178.0 177.5 177.5 178.3 177.7 177.4 176.7 177.1 177.8 178.8 179.8 179.8 179.9 71 Bob's Average Restaurant Purchase ($/Ticket) $11.71 $14.56 $10.63 $15.05 $14.16 $10.74 $10.63 $12.26 $10.92 $14.60 $14.44 $12.91 $12.75 $15.63 $14.40 $14.58 $13.81 $14.82 $15.16 $12.87 $15.15 $13.47 $14.79 $11.01 $11.63 $13.34 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 Bob's Number of Restaurant Tickets (Tickets/Month) 9198.00 6786.00 11538.00 9738.00 9108.00 11214.00 12600.00 11448.00 9216.00 6084.00 7308.00 7668.00 8082.00 7038.00 9432.00 9396.00 8316.00 7488.00 8586.00 10296.00 6714.00 6912.00 7146.00 9108.00 9612.00 8640.00 Bob's Restaurant Revenue ($/Month) $107,686.51 $98,776.89 $122,694.97 $146,528.10 $128,988.14 $120,459.60 $133,966.79 $140,341.99 $100,667.51 $88,823.32 $105,491.62 $99,031.39 $103,029.70 $110,029.97 $135,808.31 $137,030.37 $114,820.39 $111,003.15 $130,167.36 $132,526.28 $101,738.77 $93,101.75 $105,718.94 $100,268.75 $111,763.34 $115,234.70 Bob's Number of Fuel Sales (Sales/Month) 15,541.19 15,143.98 17,108.91 17,532.88 13,137.60 12,559.52 14,135.94 15,228.17 12,582.85 11,551.92 13,827.20 13,429.49 14,643.27 15,219.33 18,453.62 19,501.11 14,839.60 15,792.16 19,168.99 21,386.37 16,634.92 14,921.21 15,938.43 15,187.95 17,502.03 17,674.61 Bob's Fuel Revenue ($/Month) $1,825,934.39 $2,057,118.45 $2,103,211.15 $1,893,504.70 $1,447,277.88 $1,373,080.75 $1,531,707.77 $1,556,319.75 $1,357,545.90 $1,266,207.57 $1,463,469.09 $1,636,287.83 $2,049,538.64 $1,970,602.78 $1,998,327.36 $2,146,250.82 $1,732,817.43 $1,566,677.43 $1,645,124.28 $1,712,646.28 $1,373,219.15 $1,232,767.84 $1,505,799.59 $1,669,206.67 $1,935,464.69 $1,923,324.86 Bob's Pre Tax Profit ($/Month) $60,570.26 $60,082.11 $69,282.08 $75,323.85 $63,641.09 $59,695.43 $66,445.62 $69,019.34 $52,434.16 $47,089.61 $55,439.36 $55,189.89 $61,535.69 $63,136.16 $72,747.57 $74,958.81 $62,023.53 $58,658.86 $66,466.00 $68,127.33 $53,007.49 $48,219.40 $56,029.94 $56,028.47 $63,343.28 $64,450.30 Month Number Bob's Real Profit 59 $35,317.94 60 $34,850.41 61 $40,093.80 62 $43,590.19 63 $36,638.51 64 $34,307.72 65 $38,165.20 66 $39,666.29 67 $29,945.27 68 $26,785.90 69 $31,463.88 70 $31,198.36 71 $34,628.97 72 $35,469.75 73 $40,984.54 74 $42.230.32 75 $34,786.05 76 $33,010.05 77 $37,466.74 78 $38,555.37 79 $29,930.83 80 $27,120.02 81 $31,336.66 82 $31,161.55 83 $35,229.86 84 $35,825.63 Bob's Real Gas Price 86.69 94.74 89.76 84.75 89.25 88.06 87.15 82.92 82.65 82.47 79.98 87.71 95.77 90.80 80.03 80.04 85.33 74.02 65.98 61.46 62.52 62.64 69.87 77.70 77.41 76.83 72 Bob's Real Average Bob's Real Restaurant Purchase Diesel Price ($/Ticket) 88.84 6.83 87.51 8.44 91.44 6.15 99.13 8.71 111.70 8.15 109.40 6.17 108.10 6.11 104.37 7.05 94.73 6.24 92.05 8.30 90.41 8.19 91.00 7.30 90.53 7.17 90.55 8.78 87.95 8.11 85.28 8.22 92.57 7.74 83.02 8.34 78.00 8.55 71.90 7.28 71.65 8.56 72.47 7.58 77.95 8.27 80.32 6.12 78.46 6.47 79.32 7.41 73 74 75 76 77 78 79 80 81 82 83 84 85 85 86 87 88 89 90 91 92 93 94 95 96 97 Jun-2014 Jul-2014 Aug-2014 Sep-2014 Oct-2014 Nov-2014 Dec-2014 Jan-2015 Feb-2015 Mar-2015 Apr-2015 May-2015 Jun-2015 Jul-2015 Aug-2015 Sep-2015 Oct-2015 Nov-2015 Dec-2015 Jan-2016 Feb-2016 Mar-2016 Apr-2016 May-2016 Jun-2016 179.9 180.1 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 138.23 139.70 139.58 139.96 144.53 141.90 138.58 145.75 161.30 169.30 158.90 149.73 149.28 151.25 162.03 167.88 156.35 151.20 147.88 157.18 164.75 173.60 179.78 198.34 196.93 142.70 142.76 148.40 159.70 155.68 153.15 152.40 157.85 172.50 181.78 165.03 154.25 158.14 163.48 172.53 165.58 162.20 163.90 168.06 167.65 180.90 189.66 217.08 228.44 205.63 $13.34 $13.22 $15.59 $11.57 $15.09 $13.30 $12.98 $13.16 $12.13 $13.58 $14.52 $12.37 $17.00 $16.39 $17.28 $12.75 $14.01 $14.95 $16.71 $13.30 $17.16 $13.01 $16.64 $15.32 $14.82 8640.00 9702.00 8928.00 10602.00 7218.00 9126.00 9828.00 7506.00 7308.00 7704.00 7092.00 9378.00 7092.00 8460.00 8244.00 8496.00 7632.00 8298.00 8028.00 7452.00 5580.00 8334.00 7362.00 8712.00 8298.00 $115,234.70 $128,222.15 $139,146.34 $122,620.57 $108,927.76 $121,366.17 $127,571.51 $98,746.69 $88,675.44 $104,621.34 $102,949.71 $115,969.00 $120,573.51 $138,635.84 $142,476.67 $108,312.87 $106,889.42 $124,085.00 $134,149.23 $99,121.11 $95,779.34 $108,387.69 $122,529.63 $133,442.03 $122,944.78 17,674.61 19,765.98 20,230.12 15,946.07 14,977.48 16,959.43 17,730.66 13,358.18 11,058.41 12,361.15 13,617.97 16,468.06 16,492.49 18,113.91 17,789.58 14,662.27 14,402.76 16,160.58 16,636.82 12,725.82 11,247.96 12,154.23 11,369.54 12,087.37 13,006.38 $1,923,324.86 $2,185,114.97 $2,189,671.00 $1,667,833.92 $1,667,377.93 $1,851,827.04 $1,872,332.20 $1,495,487.17 $1,379,097.35 $1,614,680.62 $1,698,382.83 $1,943,181.32 $1,912,833.80 $2,106,646.61 $2,233,514.13 $1,982,783.61 $1,768,414.00 $1,875,997.31 $1,842,487.27 $1,548,542.75 $1,413,213.83 $1,613,352.03 $1,481,476.95 $1,782,659.41 $2,004,741.78 $64,450.30 $72,250.87 $76,239.86 $64,039.79 $59,121.76 $65,802.52 $68,276.50 $53,403.94 $48,390.80 $56,944.47 $57,342.47 $64,951.23 $66,248.97 $75,060.20 $77,961.01 $62,660.11 $59,597.66 $67,068.74 $70,277.53 $54,174.02 $51,353.02 $58,280.91 $61,751.94 $69,302.27 $68,198.26 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 $35,825.63 $40,117.09 $42,191.40 $35,381.10 $32,609.91 $36,294.82 $37,742.67 $29,391.27 $26,428.62 $30,914.48 $31,198.30 $35,395.77 $36,063.68 $40,815.77 $42,232.40 $33,833.75 $32,214.95 $36,351.62 $38,132.14 $29,251.63 $27,579.49 $31,099.74 $32,846.78 $36,648.48 $35,950.59 76.83 77.57 77.24 77.33 79.72 78.27 76.61 80.21 88.09 91.91 86.45 81.59 81.26 82.25 87.77 90.65 84.51 81.95 80.24 84.87 88.48 92.64 95.63 104.89 103.81 79.32 79.27 82.13 88.23 85.87 84.47 84.25 86.87 94.21 98.69 89.79 84.06 86.09 88.89 93.46 89.41 87.68 88.83 91.19 90.52 97.15 101.21 115.47 120.80 108.39 7.41 7.34 8.63 6.39 8.32 7.34 7.18 7.24 6.63 7.37 7.90 6.74 9.25 8.91 9.36 6.88 7.57 8.10 9.07 7.18 9.22 6.94 8.85 8.10 7.81 98 99 100 101 102 103 104 105 106 107 108 109 110 111 Averages 170.05 131.30 148.00 $12.55 9252.33 $113,619.55 16,280.06 $1,582,619.62 $59,777.65 54.50 $35,193.79 76.88 86.85 7.38 112 1 2 2 G ? 153.5 9 10 17 12 13 1570 14 16 8 Date Jul-2007 Aug 2007 Sep-2017 Oct-2007 Nov-2007 Dec-2017 Jan-2008 Feb-2008 Mar-2008 Apr-2018 May-2008 Jun 2008 Jul-2018 Aug-2008 Sep 2008 Oct-2018 Nov-2008 Dec-2008 Jan-2019 Feb-2009 Mar 2009 Apr-2010 May-2009 Jun-2009 Jul-2019 Aug-2009 Sep-2000 Oct-2009 Nov-2009 Dec-2009 Jan 2010 Feb-2010 Mar-2010 Apr 2010 Bob's Average Bob's Number of Bob's Average Bob's Average Restaurant Restaurant Retail Gasoline Retail Diesel Purchase Tickets CPI Prices (Cigall Prices (C/Gal) {$/Ticket) Tickets/Month 152.5 115 38 120.62 $928 12564.00 152.9 112.33 127.13 $10.47 11970.00 1832 111.08 129.38 $11.52 9199.00 153.71 108.72 130.65 $1159 8892.00 153.8 106.23 131.28 $8.72 13500.00 107.13 132.18 $10.11 12000.00 1544 10904 132.18 $1237 7596.00 154.9 108.93 127.65 $9.81 8874.00 155.7 113.70 127.64 $11.96 7794.00 156,3 12306 152.88 $9.95 10530.00 156.6 127.92 161.47 $11.491 10548.00 156.7 125.58 152.8% $12.42 9234.00 12272 147.00 $9.05 14490.00 1573 120.85 143.95 $12.04 11304001 1578 12022 148.68 $12.47 9162.00 158.3 120.40 148.53 $11.92 9144.001 158.6 123 23 147.05 $10.86 10B18.001 158.8 123.52 143.33 $12.12 9738.00 1.5.1 123.63 142.67 $10.46 8902.00 159.6 123.00 150.89 $11.72 7560.00 160.0 120.50 147.521 $1131 9180.00 160.2 119.90 148.651 $11.83 9054.001 160.1 120.03| 137.591 $11.41 9845.00 180.3 119.76 130.44 $11.95 9072.00 100.5 11743 126.64 $10.9 11179.00 160 31 122 35 133.70 $9.39 15572.00 18121 123.14 135.70 $10.88 9702.00 1618 119.68 124.14 $12.84 7984.00 1515 11708 139,031 $9.92 1200500 1613 113.14 133.98 $1327 9234.00 161.6 106.63 124.59 $10.71 B964.00 1619 104.90 122.63 $1243 6894.00 1622 101.68 117.40 $12.95 7668.00 162.5 103.02 121.65 $11.12 9308.00 Bob's Restaurant Revenue ($/Month) 5116,556.39 S125,340.03 $105.998.99 $103 058.03 S117,723.95 $121.3/1.12 $93 924.86 385,278.47 $92.573,20 S104 789 97 $121,174.22 S119.421.26 $131 203.26 S136,063.69 S114.290.24 S109.986.016 $117,143,80 $110.081.16 $92058.67 588,634.88 S103.801.42 $107.094.78 S112 613.87 S108.404.71 $120.648.40 S127 455.83 S105,380.20 S101205.29 $119076.29 S122,502.98 $98.008.03 $85 705.29 399,271.22 S103,515.93 Bob's Number Bob's Fuel of Fuel Sales Revenue (Sales/Month) ($/Month) 13,535.12 $1,718 419.54 20,586.74 $1,735,584.14 16.820.45 $1,380.911.21 15.923 471 $1,258023.32 17,849.94 $1,358,898.01 18.296.19 $1,403.992.97 14 286.58 $1,125 695.42 13,671.40 31,097,032.10 15.203.78 $1,303.407.34 13,594.11 $1,193 672.70 14,762.46 31,335,500.40 15,633.24 $1,407.699.80 18.040.60 $1,611 424.26 19,186.11 51,887,014.10 15,808.78 $1,362.294.84 14.592.84 $1,250.114.80 18,195.95 51,455,855.09 18,950.87 $1,550.693.11 13.335.51 $1,224.580.24 11,747.76 51,088 286.30 14,084.82 $1,219.143.81 14.319.29 $1,226.618.98 15,954 03 $1,515 958.41 17,682.97 $1,821,853.23 20.383.014 $1,942.223.39 20246 80 $1,893 91048 18,441.35 31,541,077.44 15.756.56 $1,419.08.68 17.404.92 $1,490 427.20 18,617.06 31,543.006.13 15,206.21 $1,210,279.87 14,345,25 $1,110 059.29 17.443.09 31,317,078.71 17.356.41 $1,312.080.06 Bab's Pre Tax Profit (S/Month 562.490.63 S85,832.00 S54,620.25 S52.087.36 S58,522 37 S60,398.90 547.227 64 S43,777.44 S48,480.00 S51,918 92 559,491.88 S59,389.24 S66,427.33 $69,081.35 S57,240.48 S54,134.55 $59,624.36 S80,992.81 $47,741.68 $14,265.06 S51,877.08 S53,140.BA $58,555.38 S58,367.601 S5,429.26 558,493.50 S56,328.49 S53,398.75 $60.52540 S82,489.68 S48,965.70 544,088.91 S51,444.68 S52,903.50 Month Bob's Real Gas Number Bob's Real Profit Price $40,877.46 75.86 2 S43,055.591 73.46 3 $28,642.90 72.50 4 $33,888 98 70.74 5 $38,100.50 89.18 $39,34642 69.79 7 $30,587 85 70.62 8 $28,281.74 70.32 9 S31,294.00 73.03 10 $33,2 18.12 78.73 11 $37,889.71 81.68 01.com 12 $27,099.32 B0.14 13 $42,310 40 78.17 14 $13,816 91 76.70 15 $26,274.07 76.18 16 $34,235 34 76.06 17 $37,591.17 77.70 18 $28,45701 77.88 19 $301,111.49 77.70 20 $27,735.00 77.07 21 $32,423.10 75.31 22 $33,171.601 23 $36.624 22 74.87 24 $38,424.14 74.71 29 $40,765 801 73.10 26 S42,595 341 76.09 27 $34.64 1.99 78.39 za $23,042.55 74.06 29 $37,539 55 72.49 30 $38,741 28 70.14 21 $20,312.99 67.22 32 $27,232.15 64.79 93 $31,716 82 62.69 $32,56800 83.40 Bob's Real Average Bob's Real Restaurant Purchase Diesel Price S/Ticket) 83.03 6.08 83.14 8.85 84.45 7.52 8501 7.54 85.47 5.88 86.00 6.59 8561 8.01 82.41 8.20 81.94 9781 6.37 103.11 7.34 97.54 B.18 93 67 5.77 91.51 7.65 92.95 7.91 93 8! 7.53 92.72 6.85 90 37 8967 6.57 94.51 7.35 9220 7.07 92.76 7.38 85 94 7.14 8137 7.45 78.92 6.72 83.15 5.84 84.16 6.74 83 34 7.95 DE 8608 6.14 83.05 8.22 79.66 6.83 75.74 7.68 72.38 7.98 74 88 0.85 7.84 20 21 . 23 2H 29 JU 21 92 33 34 95 DONJI ITIC PICJUIITIVE TUITINEI 34 ( 35 36 37 38 39 40 41 42 43 44 45 46 47 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 May-2012 162.5 162.8 163.0 163.2 163.4 163.6 164.0 164.0 163.9 164.3 164.5 165.0 166.2 166.2 166.2 166.7 167.1 167.9 168.2 168.3 168.3 168.8 169.8 171.2 171.3 171.5 THUCO lviya 103.03 106.35 106.44 105.53 102.60 100.93 101.88 99.54 94.50 93.90 92.05 98.20 113.10 113.06 111.43 115.75 122.08 125.55 124.43 125.14 127.25 128.88 137.70 151.63 146.48 148.68 T TUCS Tour 121.65 122.18 116.26 115.73 115.84 116.68 117.15 116.86 112.25 110.95 110.43 123.70 140.35 131.36 139.15 141.48 146.84 140.13 139.33 146.60 144.68 150.50 153.63 162.88 156.95 152.36 TURC $11.12 $9.62 $10.97 $9.59 $12.01 $11.00 $11.34 $10.25 $10.50 $13.56 $10.16 $12.36 $13.23 $13.03 $14.37 $9.88 $12.54 $11.54 $13.43 $12.61 $10.98 $10.26 $13.67 $11.66 $13.00 $11.71 TUNCESTIIVITI 9306.00 11916.00 10080.00 13014.00 11124.00 10206.00 9270.00 11664.00 11880.00 7182.00 8802.00 8910.00 8406.00 9090.00 8964.00 14364.00 11610.00 9630.00 7812.00 9702.00 11178.00 9648.00 6498.00 8352.00 7614.00 9198.00 TYTIVIUITCITY $103,515.93 $114,652.47 $110,527.66 $124,741.18 $133,628.77 $112,256.90 $105,121.77 $119,534.14 $124,773.98 $97,383.22 $89,442.75 $110,133.82 $111,192.45 $118,408.63 $128,793.43 $141,955.34 $145,607.94 $111,156.48 $104,898.29 $122,363.08 $122,731.59 $98,978.05 $88,802.73 $97,377.88 $98,949.75 $107,686.51 TUICOTIVIUIT) 17,358.41 19,434.13 20,201.17 22,866.44 24,116.54 19,848.53 18,569.57 20,916.82 22,609.08 17,901.76 16,378.91 17,518.70 15,738.02 18,549.77 18,306.38 20,090.19 20,033.11 16,684.14 15,815.58 17,093.84 17,651.62 13,485.63 12,170.00 12,825.03 13,549.31 15,541.19 TYTIVIUITCITY TTUITIIVITIC) $1,312,080.06 $52,903.50 $1,538,956.35 $59,631.74 $1,644,318.59 $59,419.93 $1,841,390.91 $66,889.03 $1,859,505.44 $70,295.66 $1,486,575.40 $58,141.11 $1,407,872.67 $54,636.49 $1,532,334.83 $61,297.74 $1,562,503.64 $63,537.55 $1,232,852.11 $49,751.31 $1,096,683.18 $45,262.32 $1,218,113.02 $54,123.20 $1,270,875.08 $55,144.90 $1,552,172.02 $61,135.70 $1,451,275.59 $63,620.09 $1,674,298.64 $71,031.72 $1,776,373.57 $73,576.33 $1,583,823.06 $58,919.78 $1,485,347.32 $55,491.02 $1,576,152.88 $62,840.17 $1,681,786.75 $64,247.81 $1,282,823.90 $50,925.80 $1,267,361.57 $47,096.17 $1,500,027.97 $52,966.75 $1,532,896.67 $53,925.92 $1,825,934.39 $60,570.26 $32,556.00 $36,628.84 $36,453.94 $40,985.92 $43,020.60 $35,538.57 $33,314.94 $37,376.67 $38,766.05 $30,280.77 $27,515.09 $32,801.94 $33,179.84 $36,784.42 $38,279.24 $42,610.51 $44,031.32 $35,092.19 $32,991.10 $37,338.19 $38,174.58 $30,169.31 $27,736.26 $30,938.52 $31,480.40 $35,317.94 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 63.40 65.33 65.30 64.66 62.79 61.69 62.12 60.70 57.66 57.15 55.96 59.52 68.05 68.03 67.04 69.44 73.06 74.78 73.97 74.36 75.61 76.35 81.10 88.57 85.51 86.69 74.86 75.05 71.33 70.91 70.89 71.32 71.43 71.26 68.49 67.53 67.13 74.97 84.45 79.04 83.72 84.87 87.88 83.46 82.83 87.11 85.96 89.16 90.47 95.14 91.62 88.84 6.85 5.91 6.73 5.87 7.35 6.72 6.91 6.25 6.41 8.25 6.18 7.49 7.96 7.84 8.64 5.93 7.51 6.87 7.98 7.49 6.52 6.08 8.05 6.81 7.59 6.83 48 49 50 51 52 53 54 55 56 57 58 59 60 CPI 60 61 62 63 64 65 66 67 68 69 70 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 Bob's Average Retail Gasoline Prices (C/gal) 148.68 163.33 155.10 146.45 155.03 153.22 151.73 144.28 144.72 144.98 140.93 155.16 170.18 161.63 142.06 142.08 152.15 131.54 117.05 108.60 110.73 111.38 124.93 139.70 139.18 138.23 171.5 172.4 172.8 172.8 173.7 174.0 174.1 174.0 175.1 175.8 176.2 176.9 177.7 178.0 177.5 177.5 178.3 177.7 177.4 176.7 177.1 177.8 178.8 179.8 179.8 179.9 71 Bob's Average Restaurant Purchase ($/Ticket) $11.71 $14.56 $10.63 $15.05 $14.16 $10.74 $10.63 $12.26 $10.92 $14.60 $14.44 $12.91 $12.75 $15.63 $14.40 $14.58 $13.81 $14.82 $15.16 $12.87 $15.15 $13.47 $14.79 $11.01 $11.63 $13.34 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 Bob's Number of Restaurant Tickets (Tickets/Month) 9198.00 6786.00 11538.00 9738.00 9108.00 11214.00 12600.00 11448.00 9216.00 6084.00 7308.00 7668.00 8082.00 7038.00 9432.00 9396.00 8316.00 7488.00 8586.00 10296.00 6714.00 6912.00 7146.00 9108.00 9612.00 8640.00 Bob's Restaurant Revenue ($/Month) $107,686.51 $98,776.89 $122,694.97 $146,528.10 $128,988.14 $120,459.60 $133,966.79 $140,341.99 $100,667.51 $88,823.32 $105,491.62 $99,031.39 $103,029.70 $110,029.97 $135,808.31 $137,030.37 $114,820.39 $111,003.15 $130,167.36 $132,526.28 $101,738.77 $93,101.75 $105,718.94 $100,268.75 $111,763.34 $115,234.70 Bob's Number of Fuel Sales (Sales/Month) 15,541.19 15,143.98 17,108.91 17,532.88 13,137.60 12,559.52 14,135.94 15,228.17 12,582.85 11,551.92 13,827.20 13,429.49 14,643.27 15,219.33 18,453.62 19,501.11 14,839.60 15,792.16 19,168.99 21,386.37 16,634.92 14,921.21 15,938.43 15,187.95 17,502.03 17,674.61 Bob's Fuel Revenue ($/Month) $1,825,934.39 $2,057,118.45 $2,103,211.15 $1,893,504.70 $1,447,277.88 $1,373,080.75 $1,531,707.77 $1,556,319.75 $1,357,545.90 $1,266,207.57 $1,463,469.09 $1,636,287.83 $2,049,538.64 $1,970,602.78 $1,998,327.36 $2,146,250.82 $1,732,817.43 $1,566,677.43 $1,645,124.28 $1,712,646.28 $1,373,219.15 $1,232,767.84 $1,505,799.59 $1,669,206.67 $1,935,464.69 $1,923,324.86 Bob's Pre Tax Profit ($/Month) $60,570.26 $60,082.11 $69,282.08 $75,323.85 $63,641.09 $59,695.43 $66,445.62 $69,019.34 $52,434.16 $47,089.61 $55,439.36 $55,189.89 $61,535.69 $63,136.16 $72,747.57 $74,958.81 $62,023.53 $58,658.86 $66,466.00 $68,127.33 $53,007.49 $48,219.40 $56,029.94 $56,028.47 $63,343.28 $64,450.30 Month Number Bob's Real Profit 59 $35,317.94 60 $34,850.41 61 $40,093.80 62 $43,590.19 63 $36,638.51 64 $34,307.72 65 $38,165.20 66 $39,666.29 67 $29,945.27 68 $26,785.90 69 $31,463.88 70 $31,198.36 71 $34,628.97 72 $35,469.75 73 $40,984.54 74 $42.230.32 75 $34,786.05 76 $33,010.05 77 $37,466.74 78 $38,555.37 79 $29,930.83 80 $27,120.02 81 $31,336.66 82 $31,161.55 83 $35,229.86 84 $35,825.63 Bob's Real Gas Price 86.69 94.74 89.76 84.75 89.25 88.06 87.15 82.92 82.65 82.47 79.98 87.71 95.77 90.80 80.03 80.04 85.33 74.02 65.98 61.46 62.52 62.64 69.87 77.70 77.41 76.83 72 Bob's Real Average Bob's Real Restaurant Purchase Diesel Price ($/Ticket) 88.84 6.83 87.51 8.44 91.44 6.15 99.13 8.71 111.70 8.15 109.40 6.17 108.10 6.11 104.37 7.05 94.73 6.24 92.05 8.30 90.41 8.19 91.00 7.30 90.53 7.17 90.55 8.78 87.95 8.11 85.28 8.22 92.57 7.74 83.02 8.34 78.00 8.55 71.90 7.28 71.65 8.56 72.47 7.58 77.95 8.27 80.32 6.12 78.46 6.47 79.32 7.41 73 74 75 76 77 78 79 80 81 82 83 84 85 85 86 87 88 89 90 91 92 93 94 95 96 97 Jun-2014 Jul-2014 Aug-2014 Sep-2014 Oct-2014 Nov-2014 Dec-2014 Jan-2015 Feb-2015 Mar-2015 Apr-2015 May-2015 Jun-2015 Jul-2015 Aug-2015 Sep-2015 Oct-2015 Nov-2015 Dec-2015 Jan-2016 Feb-2016 Mar-2016 Apr-2016 May-2016 Jun-2016 179.9 180.1 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 138.23 139.70 139.58 139.96 144.53 141.90 138.58 145.75 161.30 169.30 158.90 149.73 149.28 151.25 162.03 167.88 156.35 151.20 147.88 157.18 164.75 173.60 179.78 198.34 196.93 142.70 142.76 148.40 159.70 155.68 153.15 152.40 157.85 172.50 181.78 165.03 154.25 158.14 163.48 172.53 165.58 162.20 163.90 168.06 167.65 180.90 189.66 217.08 228.44 205.63 $13.34 $13.22 $15.59 $11.57 $15.09 $13.30 $12.98 $13.16 $12.13 $13.58 $14.52 $12.37 $17.00 $16.39 $17.28 $12.75 $14.01 $14.95 $16.71 $13.30 $17.16 $13.01 $16.64 $15.32 $14.82 8640.00 9702.00 8928.00 10602.00 7218.00 9126.00 9828.00 7506.00 7308.00 7704.00 7092.00 9378.00 7092.00 8460.00 8244.00 8496.00 7632.00 8298.00 8028.00 7452.00 5580.00 8334.00 7362.00 8712.00 8298.00 $115,234.70 $128,222.15 $139,146.34 $122,620.57 $108,927.76 $121,366.17 $127,571.51 $98,746.69 $88,675.44 $104,621.34 $102,949.71 $115,969.00 $120,573.51 $138,635.84 $142,476.67 $108,312.87 $106,889.42 $124,085.00 $134,149.23 $99,121.11 $95,779.34 $108,387.69 $122,529.63 $133,442.03 $122,944.78 17,674.61 19,765.98 20,230.12 15,946.07 14,977.48 16,959.43 17,730.66 13,358.18 11,058.41 12,361.15 13,617.97 16,468.06 16,492.49 18,113.91 17,789.58 14,662.27 14,402.76 16,160.58 16,636.82 12,725.82 11,247.96 12,154.23 11,369.54 12,087.37 13,006.38 $1,923,324.86 $2,185,114.97 $2,189,671.00 $1,667,833.92 $1,667,377.93 $1,851,827.04 $1,872,332.20 $1,495,487.17 $1,379,097.35 $1,614,680.62 $1,698,382.83 $1,943,181.32 $1,912,833.80 $2,106,646.61 $2,233,514.13 $1,982,783.61 $1,768,414.00 $1,875,997.31 $1,842,487.27 $1,548,542.75 $1,413,213.83 $1,613,352.03 $1,481,476.95 $1,782,659.41 $2,004,741.78 $64,450.30 $72,250.87 $76,239.86 $64,039.79 $59,121.76 $65,802.52 $68,276.50 $53,403.94 $48,390.80 $56,944.47 $57,342.47 $64,951.23 $66,248.97 $75,060.20 $77,961.01 $62,660.11 $59,597.66 $67,068.74 $70,277.53 $54,174.02 $51,353.02 $58,280.91 $61,751.94 $69,302.27 $68,198.26 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 $35,825.63 $40,117.09 $42,191.40 $35,381.10 $32,609.91 $36,294.82 $37,742.67 $29,391.27 $26,428.62 $30,914.48 $31,198.30 $35,395.77 $36,063.68 $40,815.77 $42,232.40 $33,833.75 $32,214.95 $36,351.62 $38,132.14 $29,251.63 $27,579.49 $31,099.74 $32,846.78 $36,648.48 $35,950.59 76.83 77.57 77.24 77.33 79.72 78.27 76.61 80.21 88.09 91.91 86.45 81.59 81.26 82.25 87.77 90.65 84.51 81.95 80.24 84.87 88.48 92.64 95.63 104.89 103.81 79.32 79.27 82.13 88.23 85.87 84.47 84.25 86.87 94.21 98.69 89.79 84.06 86.09 88.89 93.46 89.41 87.68 88.83 91.19 90.52 97.15 101.21 115.47 120.80 108.39 7.41 7.34 8.63 6.39 8.32 7.34 7.18 7.24 6.63 7.37 7.90 6.74 9.25 8.91 9.36 6.88 7.57 8.10 9.07 7.18 9.22 6.94 8.85 8.10 7.81 98 99 100 101 102 103 104 105 106 107 108 109 110 111 Averages 170.05 131.30 148.00 $12.55 9252.33 $113,619.55 16,280.06 $1,582,619.62 $59,777.65 54.50 $35,193.79 76.88 86.85 7.38 112
