budget total is $16200

3b Now, from the CPI values and Years in columns F and H, find the slope and y-intercept of the best-fit line for your CPI values. 3C Finally, project the CPI forward an additional 5 years using your slope and intercept; calculate the 5 -year inflation rate from your last CPI value and the calculated value; and apply the inflation rate to your budget total to find a 5 -year budget projection. 3 a Below, you will generate a 5 -year projected cost for your budget, starting with your budget total. You will base your projection on CPI values that you look up. Use this procedure to look up the CPI value: 1. Go to Bureau of Labor Statistics page link https://data.bls.gov/cgi-bin/surveymost?cu 2. Check the box to the left of text "U.S, city average, All items - CUUROOOOSAO" 3. Press the "Retrieve Data" button at the bottom of the list. This should take you to a CPI table for about the last 10 years. First, fill in the CPI value for the given month and year. Then, fill in the CPI values for the next 6 years, advancing exactly one year for each value. For example, if you start in february 2011, your next CPI value will come from february 2012, Format your CPI values as Numbers with 3 decimals of precision. 3b Now, from the CPI values and Years in columns F and H, find the slope and y intercept of the best-fit line for your CPI values. 3b Now, from the CPI values and Years in columns F and H, find the slope and y-intercept of the best-fit line for your CPI values. 3C Finally, project the CPI forward an additional 5 years using your slope and intercept; calculate the 5 -year inflation rate from your last CPI value and the calculated value; and apply the inflation rate to your budget total to find a 5 -year budget projection. 3 a Below, you will generate a 5 -year projected cost for your budget, starting with your budget total. You will base your projection on CPI values that you look up. Use this procedure to look up the CPI value: 1. Go to Bureau of Labor Statistics page link https://data.bls.gov/cgi-bin/surveymost?cu 2. Check the box to the left of text "U.S, city average, All items - CUUROOOOSAO" 3. Press the "Retrieve Data" button at the bottom of the list. This should take you to a CPI table for about the last 10 years. First, fill in the CPI value for the given month and year. Then, fill in the CPI values for the next 6 years, advancing exactly one year for each value. For example, if you start in february 2011, your next CPI value will come from february 2012, Format your CPI values as Numbers with 3 decimals of precision. 3b Now, from the CPI values and Years in columns F and H, find the slope and y intercept of the best-fit line for your CPI values