Strategic IS Plan - IT Budget
SHAN10
ExampleSpreadsheetforBudget.docx
Example Spreadsheet
Your spreadsheet should look, roughly, like this:
Annual IT Budget for Reynolds Tool and Die
|
|
JAN |
FEB |
MAR |
APR |
MAY |
JUN |
JUL |
AUG |
SEPT |
OCT |
NOV |
DEC |
|
Capital Purchases - Hardware |
||||||||||||
|
Servers |
5000 |
|
|
|
|
|
|
|
|
|
|
|
|
Switches |
|
600 |
|
|
|
|
|
|
|
|
|
|
|
Routers |
|
|
|
|
|
|
|
|
|
|
|
|
|
Desktops |
|
2300 |
|
|
|
|
|
|
|
|
|
|
|
Laptops |
|
500 |
|
|
|
|
|
|
|
|
|
|
|
Mobile Devices |
|
|
|
|
|
|
|
|
|
|
|
|
|
Printers |
|
|
|
|
|
|
|
|
|
|
|
|
( Page 2 of 5 )
|
|
JAN |
FEB |
MAR |
APR |
MAY |
JUN |
JUL |
AUG |
SEPT |
OCT |
NOV |
DEC |
|
Capital Purchases - Hardware |
||||||||||||
|
Firewalls |
|
|
|
|
|
|
|
|
|
|
|
|
|
Capital Purchases – Software |
||||||||||||
|
CRM |
|
|
|
|
|
|
|
|
|
|
|
|
|
ERP |
|
|
|
|
|
|
|
|
|
|
|
|
|
MS Office |
|
|
|
|
|
|
|
|
|
|
|
|
|
Security (endpoint) |
|
|
|
|
|
|
|
|
|
|
|
|
|
Security (servers) |
|
|
|
|
|
|
|
|
|
|
|
|
|
Mobile Management |
|
|
|
|
|
|
|
|
|
|
|
|
|
Desktop Management |
|
|
|
|
|
|
|
|
|
|
|
|
|
Virtualization |
|
|
|
|
|
|
|
|
|
|
|
|
|
Specialty Software |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
JAN |
FEB |
MAR |
APR |
MAY |
JUN |
JUL |
AUG |
SEPT |
OCT |
NOV |
DEC |
|
Maintenance - Hardware |
||||||||||||
|
Servers |
|
|
|
|
|
|
|
|
|
|
|
|
|
Desktops |
|
|
|
|
|
|
|
|
|
|
|
|
|
Routers |
|
|
|
|
|
|
|
|
|
|
|
|
|
Switches |
|
|
|
|
|
|
|
|
|
|
|
|
|
Firewalls |
|
|
|
|
|
|
|
|
|
|
|
|
|
Mobile |
|
|
|
|
|
|
|
|
|
|
|
|
|
Printers |
|
|
|
|
|
|
|
|
|
|
|
|
|
Firewalls |
|
|
|
|
|
|
|
|
|
|
|
|
|
Maintenance/Licensing - Software |
||||||||||||
|
CRM |
|
|
|
|
|
|
|
|
|
|
|
|
|
ERP |
|
|
|
|
|
|
|
|
|
|
|
|
|
MS Office |
|
|
|
|
|
|
|
|
|
|
|
|
|
Mobile Management |
|
|
|
|
|
|
|
|
|
|
|
|
|
Desktop Management |
|
|
|
|
|
|
|
|
|
|
|
|
|
Virtualization |
|
|
|
|
|
|
|
|
|
|
|
|
|
Special Projects |
||||||||||||
|
Outsourcing |
|
|
|
|
|
|
|
|
|
|
|
|
|
Cloud |
|
|
|
|
|
|
|
|
|
|
|
|
|
Managed Services |
|
|
|
|
|
|
|
|
|
|
|
|
|
Monthly Totals |
||||||||||||
|
TOTALS: |
|
|
|
|
|
|
|
|
|
|
|
|
