| Topic 6 |
| GOAL, Inc. IT Budget |
| | Annual Budget 2021 | Comments | | Actual Cost 2021 | Variance |
| Committed Expenditures |
| Service Contracts | 50,000 | | | | 50,000 |
| Repairs | 5,000 | | | | 5,000 |
| Leases | 15,000 | | | | 15,000 |
| Software | 20,000 | | | | 20,000 |
| Internal Support | 40,000 | | | | 40,000 |
| External Support | 23,000 | | | | 23,000 |
| Depreciation | 13,500 | | | | 13,500 |
| Supplies | 400 | | | | 400 |
| Training | 2,000 | | | | 2,000 |
| TOTAL COMMITED EXPENDITURES | 168,900 | | | - 0 | 168,900 |
| Upgrades |
| CPU Upgrades | 4,220 | | | | 4,220 |
| Memory Addition | 5,000 | | | | 5,000 |
| TOTAL UPGRADES | 9,220 | | | - 0 | 9,220 |
| Replacements |
| Depreciation | 4,000 | 12 servers @ $1,000 each depreciated over 3 years | | - 0 | 4,000 |
| Implementation Costs | 3,200 | | | | 3,200 |
| Leases | 3,000 | | | | 3,000 |
| TOTAL REPLACEMENTS | 10,200 | | | - 0 | 10,200 |
| | | | | | - 0 |
| New Projects | | | | | - 0 |
| Capital Cost of New Hardware | | | | | - 0 |
| Depreciation | 5,000 | 1 server @ $20,000 depreciated over 4 years | | - 0 | 5,000 |
| Implementation Costs | 3,200 | | | | 3,200 |
| Leases | 3,000 | | | | 3,000 |
| Internal Support | 20,000 | | | | 20,000 |
| TOTAL NEW PROJECTS | 31,200 | | | - 0 | 31,200 |
| | | | | | - 0 |
| TOTAL COSTS | 219,520 | | | - 0 | 219,520 |
| | | | | | - 0 |
| Internal charge-back | | | | | - 0 |
| Department A (25% utilization) | (54,880) | | | - 0 | (54,880) |
| Department A (25% utilization) | (109,760) | | | - 0 | (109,760) |
| Department A (50% utilization) | (54,880) | | | - 0 | (54,880) |
| | (219,520) | | | - 0 | (219,520) |
Loic@1313
MIS-640-RS-IT-Budget-21722.xlsx
