Please Help me this three questions !!! I dont know how to start and what to do !!!
Thank in advance!!
In the file, the shaded boxes under the 2018 Budget column must be filled in per the instructions to the right of the worksheet. Please read the instructions carefully. You will need a couple formulas from the reading to complete the assignment. The document provides the historical actual amounts from 2015 and 2016. It also provides the 2017 Budget and the 2017 Actual (assume this is a 12 month projection or annualized amount). You are also given the 2017 variances.
- For technician with a 2017 base salary budget variance of less that +/-10%, assume the 2018 budget will be their 2017 actual plus to account for merit increase.
- For technician with a 2017 base salary budget variance of greater than +/-10% assume their 2018 budget will be equal to the 2017 budget amount plus 4% to account merit increase.
- You have approval to add an additional technician in 018. Their base rate will be $27/hr. estimate the annual amount sing the formula in the reading. Enter that budget amount for the new technician J.
A B C p E F G H K M N HTM Budget Document 2015 Actual 2016 Actual Budget 2017 Actual Variances Budget 2018 Variance Compensation Expenses Instructions 1) For Technicans with a 2017bae salary budget varance of less than +/- 10%, assume the 2018 Budget will be their 2017 actual plus 4% to account for merit ncreases. Haar Salarins Technician Technician Technician Technician D Technician E Technician Technician G Technician Technician Technician I (NEW! Total Base 5alarles $ 9 S S S $ S 5 $ 5 52,124 43,949 $ 70,249 $ 50,232 $ 53,939 $ $ 39,245 $ 63,039 $ 60,393 $ 51,020 $ 54,20 45,707 73,068 52,241 56,097 40,915 65,561 62.BOS 53.051 $ $ S $ $ $ $ $ $ 54,876 S 47,535 75,990 S 54,31 S 58,340 S 42,447 S 68,103 65,3215 55,183 S 52,999 $ 45,00 $ 65,020 $ 54,999 $ 46,373 $ 42.929 $ 67,292 5 62.9295 55,200 $ 3,447 2,532 10,950 1609) 11,967 1482) 991 2.392 (17) 6.5% 5.6 ) 16.8% -1.1% 25.8% -1.1% 1.3% 3.8% 0.0% 2) For Technicians wth a 2017 sese so ary budget variance of greater than +/- 10% assume their 2018 Budget will be equal to the 2017 Budget around us 4% to account for me it increase . 3) You have approval to add an additional technician in 2016. Their best rate will be $27/hr. Estimate the annual arount sing the formuar in the reading. Enter that 2018 budget amount for the new Technician J. 5 484,188 $ 503,556 $ 523,698 5 492,624 $ 31/074 6.3% 5 5 Overtime TO Henriis $ $ S 40,393 20,264 $ 145,250 $ 40,284 20,528 151,067 $ $ $ S 25,185 $ 21,600 $ 157, 109 S 39,299 $ 20,292 S 172,77 113,114) 1,308 115,173) 33,494 6.4% -8.8 4) For overtime, choose the more appropriate vlauc: $25,000 or $40,000 5) For PTC, calculate the average of 2016 Actual and 2017 Actual to use for 2018 6) calculate benefits using the 2018 Total Base Saleries and the formula in the reading Total Compensation $ 690, 101 $ 715,435 $ 728,592 $ 724,497 $ 4,095 0.6% $ Department Expenses Tools and Test Equipment Mileage Expenses Cuffice Supplies Training and Education Communication Expanse Suaalies 5 5 $ $ $ S 15,494 $ 119 $ 5.33 $ 50,792 $ 2,429 $ 5030$ 12,929 592 4,01% 20,797 4,040 5,919 $ S S S S $ 20,292 $ 719 $ 2,019 S 501,742 S 1,919 $ 5,202 S 20,191 1,262 $ 4.1995 65. CD3 $ 4,202 $ 5,303 $ 101 1543) 07.120) 114,711) (2,287) (101) 0.5% 43.0 50.00 -22.6% 7) Yaur arganization announced that your 2018 Deatment Exsenses Budget cannot exceed your current 2017 Actual Department Expense. Create a logical 2018 budget for these expenses was sun is equal to the 2017 Actual -1.9% Total Departement Expenses $ 79,796 $ 107,690 $ 90,443 $ 100,000 $ (19,557) -19.6% $ A B C p E F G H K M N HTM Budget Document 2015 Actual 2016 Actual Budget 2017 Actual Variances Budget 2018 Variance Compensation Expenses Instructions 1) For Technicans with a 2017bae salary budget varance of less than +/- 10%, assume the 2018 Budget will be their 2017 actual plus 4% to account for merit ncreases. Haar Salarins Technician Technician Technician Technician D Technician E Technician Technician G Technician Technician Technician I (NEW! Total Base 5alarles $ 9 S S S $ S 5 $ 5 52,124 43,949 $ 70,249 $ 50,232 $ 53,939 $ $ 39,245 $ 63,039 $ 60,393 $ 51,020 $ 54,20 45,707 73,068 52,241 56,097 40,915 65,561 62.BOS 53.051 $ $ S $ $ $ $ $ $ 54,876 S 47,535 75,990 S 54,31 S 58,340 S 42,447 S 68,103 65,3215 55,183 S 52,999 $ 45,00 $ 65,020 $ 54,999 $ 46,373 $ 42.929 $ 67,292 5 62.9295 55,200 $ 3,447 2,532 10,950 1609) 11,967 1482) 991 2.392 (17) 6.5% 5.6 ) 16.8% -1.1% 25.8% -1.1% 1.3% 3.8% 0.0% 2) For Technicians wth a 2017 sese so ary budget variance of greater than +/- 10% assume their 2018 Budget will be equal to the 2017 Budget around us 4% to account for me it increase . 3) You have approval to add an additional technician in 2016. Their best rate will be $27/hr. Estimate the annual arount sing the formuar in the reading. Enter that 2018 budget amount for the new Technician J. 5 484,188 $ 503,556 $ 523,698 5 492,624 $ 31/074 6.3% 5 5 Overtime TO Henriis $ $ S 40,393 20,264 $ 145,250 $ 40,284 20,528 151,067 $ $ $ S 25,185 $ 21,600 $ 157, 109 S 39,299 $ 20,292 S 172,77 113,114) 1,308 115,173) 33,494 6.4% -8.8 4) For overtime, choose the more appropriate vlauc: $25,000 or $40,000 5) For PTC, calculate the average of 2016 Actual and 2017 Actual to use for 2018 6) calculate benefits using the 2018 Total Base Saleries and the formula in the reading Total Compensation $ 690, 101 $ 715,435 $ 728,592 $ 724,497 $ 4,095 0.6% $ Department Expenses Tools and Test Equipment Mileage Expenses Cuffice Supplies Training and Education Communication Expanse Suaalies 5 5 $ $ $ S 15,494 $ 119 $ 5.33 $ 50,792 $ 2,429 $ 5030$ 12,929 592 4,01% 20,797 4,040 5,919 $ S S S S $ 20,292 $ 719 $ 2,019 S 501,742 S 1,919 $ 5,202 S 20,191 1,262 $ 4.1995 65. CD3 $ 4,202 $ 5,303 $ 101 1543) 07.120) 114,711) (2,287) (101) 0.5% 43.0 50.00 -22.6% 7) Yaur arganization announced that your 2018 Deatment Exsenses Budget cannot exceed your current 2017 Actual Department Expense. Create a logical 2018 budget for these expenses was sun is equal to the 2017 Actual -1.9% Total Departement Expenses $ 79,796 $ 107,690 $ 90,443 $ 100,000 $ (19,557) -19.6% $
