Please Help me these 3 Questions!!

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.

1. For overtime, choose the more appropriate value: $25,000 or $40,000.
2. For PTO, calculate the average of 2016 actual and 2017 actual to use for 2018.
3. Calculate benefits using the 2018 total base salaries and formula in the reading.

HTM Budget Document 2015 Actual 2016 Actual 2017 Actual Variances Budget 2018 Budget Variance % Instructions Compensation Expenses 5 11 For Technicans with a 2017 base salary budget variance of less than +/- 10%, assume the 2018 Budget will be their 2017 actual plus 4% to account for merit increases. $ S Base Salaries Technician A Technician Technician Technician Technician Technician Technician Technician Technician Technician I (NEW) Total Base Salaries 52,123 $ 43 949 70.248 $ 50,232 $ 53,939 39,245 $ 63,019 $ 50,393 $ 52,020 $ 5 $ S 5 5 S 54,208 45,702 73,056 52,241 56,017 40,815 65,551 62,809 53,061 s $ $ $ S $ $ $ $ 56,375$ 47,535 S 75,980s 54,331 $ 58,340 $ 42,447 S 68,183 $ 65,321 $ 55,183 S 52,929 5 45,013 S 65,030 $ 54,939 s 45,373 42,929 $ 67,292 $ 62.929 $ S5,200 $ 3,447 2,532 10,950 1508) 11,167 (482) 191 2,392 (17) 5.5% 5.6% 16.2% -1.1% % 25.8% -1.1% 1.3% 3.8% 0.0% 21 For Technicians with a 2017 base salary budget variance of greater than -/- 10% assume their 2018 Budget will be equal to the 2017 Budget amount plus 4X to account for merit increase 31 You have approval to add an additional technician in 2018. Their base rate will be $27/hr Estimate the annual amount sing the formular in the reading. Enter that 2018 budget amount For the new Technician $ 484,188 $ 503,556 $ $ 523,698 $ 492,624 $ 31.074 6.3% 5 Overtime PTO Benefits S 5 5 40.393 20.261 145.256 40,234 20,528 151,057 $ $ 26,185 S 21,500 $ 157,109 $ 39,299 $ 20,292 s 172,2829 (13,114) 1,308 (15.173) -33.4% 5.4% -3.8% 4 For overtime, choose the more appropriate visue: $25,000 or $40,000. 51 For PTO calculate the average of 2016 Actual and 2017 Actual to use for 2018. 61 Calculate benefits using the 2018 Total Base Saleries and the formula in the reading $ Total Compensation $ 590,101 $ 715,435 5 728,592 $ 724,497 5 4,095 0.6% $ Department Expenses Tools and Test Equipment Mileage Expenses Office Supplies Training and Education Communication expense Supplies $ S 5 $ S $ 15,4M $ 119 $ 5,033 $ 50,292 $ 2,428 $ 5,030 $ 17,929 592 4,016 80,292 4,040 5,819 s $ $ $ $ 20,292 $ 719S 2,019 $ 50,292 $ 1,919 S 5,202 $ 70.1915 1,262 S 4,039 $ 65,003 $ 4,2025 5,303 $ 101 (543) (2,020) (14,711) {2,283) (101) 0.5% -43.0% -50.0% -22.6% 54.3% 1.9% 7 Your organization announced that your 2018 Department Expenses Budget cannot exceed your current 2017 Actual Department Expense. Create a logical 2018 budget for these expenses whos sum is equal to the 2017 Actual Total Departement Expenses $ 79,796 $ 107,690 $ 80,443 $ 100,000 $ [19,557) -19.6% $ Service Expenses Vendor Contracts Vendor Labor Repair Parts 5 5,494,292 $ 4,992,929 $ 1,404,999 $ 1,4999,392 $ 4920292 $ 7,430,53D $ 4,802.929 $ 4,829,299 $ (26,370) $ 1,949,397 $ 1,829,299 $ 120,093 S 7952.020 $ 5,339,393 $ 2,512.527 -0.5% t. 48.9K 81 You plan to reduce contract by 10% from the 2017 Actual. 91 After reducing contracts you anticipato a 2K increase in vendor Labor for 2017 Actual. 10) Due to variantion an unpredictablity you calculate 2018 Parts budge by taking the average lor vesars 2015. 2016 and 2017 Pictuals. Then you add 5% more as a result of contract reductions Assignment + HTM Budget Document 2015 Actual 2016 Actual 2017 Actual Variances Budget 2018 Budget Variance % Instructions Compensation Expenses 5 11 For Technicans with a 2017 base salary budget variance of less than +/- 10%, assume the 2018 Budget will be their 2017 actual plus 4% to account for merit increases. $ S Base Salaries Technician A Technician Technician Technician Technician Technician Technician Technician Technician Technician I (NEW) Total Base Salaries 52,123 $ 43 949 70.248 $ 50,232 $ 53,939 39,245 $ 63,019 $ 50,393 $ 52,020 $ 5 $ S 5 5 S 54,208 45,702 73,056 52,241 56,017 40,815 65,551 62,809 53,061 s $ $ $ S $ $ $ $ 56,375$ 47,535 S 75,980s 54,331 $ 58,340 $ 42,447 S 68,183 $ 65,321 $ 55,183 S 52,929 5 45,013 S 65,030 $ 54,939 s 45,373 42,929 $ 67,292 $ 62.929 $ S5,200 $ 3,447 2,532 10,950 1508) 11,167 (482) 191 2,392 (17) 5.5% 5.6% 16.2% -1.1% % 25.8% -1.1% 1.3% 3.8% 0.0% 21 For Technicians with a 2017 base salary budget variance of greater than -/- 10% assume their 2018 Budget will be equal to the 2017 Budget amount plus 4X to account for merit increase 31 You have approval to add an additional technician in 2018. Their base rate will be $27/hr Estimate the annual amount sing the formular in the reading. Enter that 2018 budget amount For the new Technician $ 484,188 $ 503,556 $ $ 523,698 $ 492,624 $ 31.074 6.3% 5 Overtime PTO Benefits S 5 5 40.393 20.261 145.256 40,234 20,528 151,057 $ $ 26,185 S 21,500 $ 157,109 $ 39,299 $ 20,292 s 172,2829 (13,114) 1,308 (15.173) -33.4% 5.4% -3.8% 4 For overtime, choose the more appropriate visue: $25,000 or $40,000. 51 For PTO calculate the average of 2016 Actual and 2017 Actual to use for 2018. 61 Calculate benefits using the 2018 Total Base Saleries and the formula in the reading $ Total Compensation $ 590,101 $ 715,435 5 728,592 $ 724,497 5 4,095 0.6% $ Department Expenses Tools and Test Equipment Mileage Expenses Office Supplies Training and Education Communication expense Supplies $ S 5 $ S $ 15,4M $ 119 $ 5,033 $ 50,292 $ 2,428 $ 5,030 $ 17,929 592 4,016 80,292 4,040 5,819 s $ $ $ $ 20,292 $ 719S 2,019 $ 50,292 $ 1,919 S 5,202 $ 70.1915 1,262 S 4,039 $ 65,003 $ 4,2025 5,303 $ 101 (543) (2,020) (14,711) {2,283) (101) 0.5% -43.0% -50.0% -22.6% 54.3% 1.9% 7 Your organization announced that your 2018 Department Expenses Budget cannot exceed your current 2017 Actual Department Expense. Create a logical 2018 budget for these expenses whos sum is equal to the 2017 Actual Total Departement Expenses $ 79,796 $ 107,690 $ 80,443 $ 100,000 $ [19,557) -19.6% $ Service Expenses Vendor Contracts Vendor Labor Repair Parts 5 5,494,292 $ 4,992,929 $ 1,404,999 $ 1,4999,392 $ 4920292 $ 7,430,53D $ 4,802.929 $ 4,829,299 $ (26,370) $ 1,949,397 $ 1,829,299 $ 120,093 S 7952.020 $ 5,339,393 $ 2,512.527 -0.5% t. 48.9K 81 You plan to reduce contract by 10% from the 2017 Actual. 91 After reducing contracts you anticipato a 2K increase in vendor Labor for 2017 Actual. 10) Due to variantion an unpredictablity you calculate 2018 Parts budge by taking the average lor vesars 2015. 2016 and 2017 Pictuals. Then you add 5% more as a result of contract reductions Assignment +