IT BUDGET EXAMPLE - INSTRUCTIONS Source: https://yenra.com/it-spending/ Companion: it-budget-example.csv All prices are invented USD amounts for one planning year, before taxes. This is a cash plan, not accounting or depreciation treatment. Internal staff time is excluded. Software excludes security/backup, which has its own line. Open the CSV in a spreadsheet or text editor. Numeric example values are fixed: changing an input will NOT update totals. Copy the six cost lines into your own planning tool and calculate quantity x unit USD x periods. Rows after the funding envelope provide source/context rather than costs. The reserve-rate value 0.10 means 10%; it is not a dollar amount. CHECKED BASE CASE Subscriptions: 50 x 18 x 12 = 10800 Devices: 10 x 900 x 1 = 9000 Hosting/connectivity: 1 x 600 x 12 = 7200 External support: 1 x 2000 x 12 = 24000 Security/backup: 1 x 400 x 12 = 4800 Migration/training: 1 x 6000 x 1 = 6000 Subtotal: 61800; illustrative reserve 10%: 6180; envelope: 67980. Reserve is available funding, not an assumption it will all be spent. GROWTH SCENARIO Ten users for final six months: 10 x 18 x 6 = 1080. Additional hosting: 200 x 6 = 1200; five devices: 5 x 900 = 4500. Increase: 6780; subtotal: 68580; reserve: 6858; envelope: 75438. Assumes support/security prices unchanged; verify actual contracts. ADAPT THE PLAN Replace quantities, prices, periods and service scope using dated contracts. Record owner, renewal/cancellation deadline, billing month and business need. Keep one-time and recurring costs distinct. Include overlap and exit costs. Assess internal staff capacity separately. Obtain finance-team treatment for tax/capitalization. Schedule cash by payment month. Compare actuals against approved budget and revise the remaining forecast without erasing the budget. Variance example: actual 750 - budget 600 = 150 unfavorable, or 25% of budget.