1 Topic 6 2 GOAL, Inc. IT Budget 3 A 4 Committed Expenditures 5 Service Contracts...

Transcribed Image Text:

1 Topic 6 2 GOAL, Inc. IT Budget 3 A 4 Committed Expenditures 5 Service Contracts 6 Repairs 7 Leases 8 Software 9 Internal Support 10 External Support 11 Depreciation 12 Supplies 13 Training 14 TOTAL COMMITED EXPENDITURES 15 16 Upgrades 17 CPU Upgrades 18 Memory Addition 19 TOTAL UPGRADES 20 21 Replacements 22 Depreciation 23 Implementation Costs 24 Leases 25 TOTAL REPLACEMENTS 26 27 New Projects 28 Capital Cost of New Hardware 29 Depreciation 30 Implementation Costs 31 Leases 32 Internal Support 33 TOTAL NEW PROJECTS 34 35 TOTAL COSTS 36 37 Internal charge-back 38 Department A (25% utilization) 39 Department A (25% utilization) 40 Department A (50% utilization) 41 42 43 44 45 46 B Annual Budget 2021 50,000 5,000 15,000 20,000 40,000 23,000 13,500 400 2,000 168,900 4,220 5,000 9,220 4,000 12 servers 3,200 3,000 10,200 Comments 219,520 (54,880) (109,760) (54,880) (219,520) servers @ $1,000 each depreciated over 3 years 5,0001 server @ $20,000 depreciated over 4 years 3,200 3,000 20,000 31,200 D E Actual Cost 2021 F Variance 50,000 5,000 15,000 20,000 40,000 23,000 13,500 400 2,000 168,900 4,220 5,000 9,220 4,000 3,200 3,000 10,200 5,000 3,200 3,000 20,000 31,200 219,520 (54,880) (109,760) (54,880) (219,520) 1 Topic 6 2 GOAL, Inc. IT Budget 3 A 4 Committed Expenditures 5 Service Contracts 6 Repairs 7 Leases 8 Software 9 Internal Support 10 External Support 11 Depreciation 12 Supplies 13 Training 14 TOTAL COMMITED EXPENDITURES 15 16 Upgrades 17 CPU Upgrades 18 Memory Addition 19 TOTAL UPGRADES 20 21 Replacements 22 Depreciation 23 Implementation Costs 24 Leases 25 TOTAL REPLACEMENTS 26 27 New Projects 28 Capital Cost of New Hardware 29 Depreciation 30 Implementation Costs 31 Leases 32 Internal Support 33 TOTAL NEW PROJECTS 34 35 TOTAL COSTS 36 37 Internal charge-back 38 Department A (25% utilization) 39 Department A (25% utilization) 40 Department A (50% utilization) 41 42 43 44 45 46 B Annual Budget 2021 50,000 5,000 15,000 20,000 40,000 23,000 13,500 400 2,000 168,900 4,220 5,000 9,220 4,000 12 servers 3,200 3,000 10,200 Comments 219,520 (54,880) (109,760) (54,880) (219,520) servers @ $1,000 each depreciated over 3 years 5,0001 server @ $20,000 depreciated over 4 years 3,200 3,000 20,000 31,200 D E Actual Cost 2021 F Variance 50,000 5,000 15,000 20,000 40,000 23,000 13,500 400 2,000 168,900 4,220 5,000 9,220 4,000 3,200 3,000 10,200 5,000 3,200 3,000 20,000 31,200 219,520 (54,880) (109,760) (54,880) (219,520)