il LL M human You Prestige We Free MacBook Pro WHI LL General Paste Merge Center Conditional Format Cel 015 A D G Growth Rate (Year Assumptions (Data) 1 Year 25 Instructions: Full out the IT Budget by writing formules that begin within the light orange colle omia cum 2 Firm Budget 14 1. First Figure out the growth rates format as with decimal for various expense cafegades by willing fomu 3 Total IT Budget 2. Then, write formulas to forecast the future IT budget for the next years (Yows Years) in the projected budget 13 4 IT Salaries 13N 3. Note that the growth rate for one of your extemal expense categories Puctute for Your 4 and Yugrowth in 5 Wages (hourly employees) 13 growth rate to forecast Year 3 for that expense category. Use your growth rate in cod 10 ta forecast for Words G Software Maintenance Contracts 4. Write a formula to calculate the average Expenses over the years in Column 10N 7 Hardware and Network Upgrades 5. Write formulas to calculate the IT Budget Revenue, Total Internal and Exam Expenses. Totes and 3 Training fixed amount each year) 315.000 expenses 6. Make a ple chart (called Hardware and Network Upgrades Over Time showing penes for the salary were Growth Rate Year side of the ple, Place chart to right of the Average Expenses column 9 4 & Year 5) 7. Make a line chart (called TT Budget Verse IT Salaries showing Total Hudget le grand IT Sales Mange 10 Software Maintenance Contracts -1,3% years on the hortiontal axis and place chart to right of the ple chart 31 Information Technology (Year 1 Year 5) Projected Budget Year 3 Average Year 1 Year 2 this year Year 4 Years Expenses 13 Firm Budoet 118000000 135000000 19449152.54 #Employees 24 27 3889830600 15 Total IT Budget 2400000 2500000 16 Intamal Expenses: Salaries 17 IT Series 2026000 2025650 18 Wages. Chourly employees 21050 21500 16 Total Internal Expenditures 20 Extemal Expenses VENDOR Expenses 21 Training 22 Software Maintenance Contracts 115000 124000 23 Hardware and Network Upgrades 355000 315000 24 Total External Expenditures 25 Total IT Budget Revenues Total IT Expenditures (Intemal 26 and External) 27 Balance 20 30 31 12 33 35 36 17 39 Your Work with instructional Ready il LL M human You Prestige We Free MacBook Pro WHI LL General Paste Merge Center Conditional Format Cel 015 A D G Growth Rate (Year Assumptions (Data) 1 Year 25 Instructions: Full out the IT Budget by writing formules that begin within the light orange colle omia cum 2 Firm Budget 14 1. First Figure out the growth rates format as with decimal for various expense cafegades by willing fomu 3 Total IT Budget 2. Then, write formulas to forecast the future IT budget for the next years (Yows Years) in the projected budget 13 4 IT Salaries 13N 3. Note that the growth rate for one of your extemal expense categories Puctute for Your 4 and Yugrowth in 5 Wages (hourly employees) 13 growth rate to forecast Year 3 for that expense category. Use your growth rate in cod 10 ta forecast for Words G Software Maintenance Contracts 4. Write a formula to calculate the average Expenses over the years in Column 10N 7 Hardware and Network Upgrades 5. Write formulas to calculate the IT Budget Revenue, Total Internal and Exam Expenses. Totes and 3 Training fixed amount each year) 315.000 expenses 6. Make a ple chart (called Hardware and Network Upgrades Over Time showing penes for the salary were Growth Rate Year side of the ple, Place chart to right of the Average Expenses column 9 4 & Year 5) 7. Make a line chart (called TT Budget Verse IT Salaries showing Total Hudget le grand IT Sales Mange 10 Software Maintenance Contracts -1,3% years on the hortiontal axis and place chart to right of the ple chart 31 Information Technology (Year 1 Year 5) Projected Budget Year 3 Average Year 1 Year 2 this year Year 4 Years Expenses 13 Firm Budoet 118000000 135000000 19449152.54 #Employees 24 27 3889830600 15 Total IT Budget 2400000 2500000 16 Intamal Expenses: Salaries 17 IT Series 2026000 2025650 18 Wages. Chourly employees 21050 21500 16 Total Internal Expenditures 20 Extemal Expenses VENDOR Expenses 21 Training 22 Software Maintenance Contracts 115000 124000 23 Hardware and Network Upgrades 355000 315000 24 Total External Expenditures 25 Total IT Budget Revenues Total IT Expenditures (Intemal 26 and External) 27 Balance 20 30 31 12 33 35 36 17 39 Your Work with instructional Ready