Updating Salary Survey Data As a newly hired compensation analyst, you've been asked by the Director of Compensation to assist with the preparation of next year's compensation plan for accounting jobs. The period for the compensation plan is January 1-December 31, 2018. Your assignment is to update salary survey data using the CPI-U to estimate new salary information. Also, assume that it is July 1, 2017, and you have been asked to submit your analysis within the next two days. The salary survey data were current through the end of 2016, and the initial average salary reported for accountant jobs in the survey was $50,000. The salary data will be 12 and 24 months old at the pay plan's implementation (on January 1, 2018) and end (December 31, 2018), respectively. You have been provided with national CPI-U data, which were obtained from the U.S. Bureau of Labor Statistics website. Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2012 2013 2014 2015 2016 2017 238.84 242.67 246.34 245.83 248.99 255.02 239.32 243.93 246.52 246.27 248.53 255.10 239.80 243.28 246.95 246.95 249.02 254.71 240.18 242.79 247.46 247.16 249.84 255.08 239.71 242.89 247.86 247.95 250.43 254.91 239.52 239.59 240.91 243.44 243.90 244.45 248.18 248.48 248.43 248.61 248.99 248.98 251.07 251705 251.56 255.03 242.01 244.54 248.45 248.46 252.01 242.63 244.66 248.44 248.76 252.66 242.24 245.10 248.04 249.07 253.08 242.22 245.71 247.27 248.82 253.78 The percent change in the cost of goods and services between December 2016 and June 2017 is 0.49% (Round your answers to the nearest hundredths place.) (a) The percent change might you expect the average cost of goods and services over the second 6-month period of 2017 is 0.47% (Round vour answers to the nearest hundredths place 2 Enter your answer in the edit fields and then click Check Answer. A A Final Check (Round your answers to the nearest hundredths place.) Hint First, calculate the percentage cost change for the period July through December for each of the previous years: 2012 through 2016. Second, take the average of these five figures. This calculation gives us the average percent cost change. Estimates based on multiple years gives us a more stable picture of percent cost changes. (b) The estimated average salary for December 31, 2017 is $ 50235 (Round your answers to the nearest hundredths place.) Hint: [(initial average salary x average percent cost change)+ initial average salaryl, (a) The percent change might you expect the average cost of goods and services change between January 1, 2018 and December 31, 2018 is 1% (Round your answers to the nearest hundredths place.) Hint: First, calculate the percent cost change for the period January through December for each of the previous years: 2012 through 2016. Second, take the average of these five figures to calculate the average percent cost change. (b) The estimated average salary for December 31, 2018 is $ (Round your answers to the nearest hundredths place.) Hint: ((December 2017 average salary * average percentage cost change) + December 2017 average salaryl
