AutoSave OFF Evo = CRUNCH THE NUMBERS Chapter 3 - Students (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments X Calibri (Body) 11 ' = = = no ab Wrap Text General PUL! HA Insert v Ayu O 5 Delete Paste av Av BI U 9 Merge & Center + $ % ) Ideas .00 0 .00 Sensitivity Conditional Format Cell Formatting as Table Styles Sort & Filter Format Find & Select V P29 x fx B D E E F H J K M N O P Q R S 39 40 41 Under a merit pay system scenario assume the goal is to provide Anne and John with the same annual pay increase measured in dollars. It has been determined that Anne's increase will be 5%. What should the rate for John? What will the annual salaries be at the end of 2020? 42 % 43 44 45 46 47 48 5% 2,500 $ 52,500.00 7% $ 37,500.00 Anne's 2015 $ 50,000.00 $ 2016 2017 2018 2019 2020 John 2015 $ 35,000.00 2016 2017 2018 2019 2020 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 Crunch1 Crunch2 + Ready P 120%