sample it budget
DESCRIPTION
Sample IT BudgetTRANSCRIPT
H:\rabel\nymi\budget\document.xls 1 of 7 04/07/2023
Software LicensingBudget Purchases
Unit Cost Quantity Total Subtotal Unit Cost SubtotalClient Machines:MS Office 2000 375.00 120 45,000.00 - (45,000.00)MS Project 2000 250.00 15 3,750.00 - (3,750.00)Visio Ver 5 400.00 8 3,200.00 - (3,200.00)Fiscal GUI license 59.00 32 1,888.00 - (1,888.00)
53,838.00 - - Server Software: - Windows NT Server 1,000.00 1 1,000.00 - (1,000.00)MS Exchange Server 1,000.00 1 1,000.00 - (1,000.00)SQL Server 1,000.00 1 1,000.00 - (1,000.00)
3,000.00 - - Client Access Licenses: - NT Server Connection 49.00 125 6,125.00 - (6,125.00)SQL Server 69.00 80 5,520.00 - (5,520.00)Exchange Server 50.00 125 6,250.00 - (6,250.00)UNIX License 100.00 32 3,200.00 - (3,200.00)Unibasic License 125.00 32 4,000.00 - (4,000.00)IQ Query License 125.00 32 4,000.00 - (4,000.00)
29,095.00 - - Total Licensing $ 85,933.00 $ - $(32,095.00)
Quantity Purchased
Actual Cost
(+ or -) from Budget
h:\rabel\nymi\budget\document.xls 2 of 7 04/07/2023
IS Hardware BudgetBudget Purchases
Unit Cost Quantity Cost Subtotal Unit Cost SubtotalDesktop Hardware:Replacement Desktop Computer 999.00 15 14,985.00 - (14,985.00)Monitor 17" 125.00 5 625.00 - (625.00)Hard Drive 6 GB 145.00 5 725.00 - (725.00)Keyboard 25.00 10 250.00 - (250.00)Mouse 25.00 10 250.00 - (250.00)Power Strip 40.00 25 1,000.00 - (1,000.00)Pentium Notebook Computer 1,200.00 1 1,200.00 - (1,200.00)LCD Projector 2,200.00 1 2,200.00 - (2,200.00)
21,235.00 - Misc Hardware:Server Shelving 900.00 1 900.00 - (900.00)UPS - Power Equipment 1,100.00 2 2,200.00 - (2,200.00)Fireproof Media Storage 2,500.00 1 2,500.00 - (2,500.00)
5,600.00 - Backup:8mm Tapes 30.00 10 300.00 - (300.00)DLT Tapes 75.00 12 900.00 - (900.00)Blank CDR Disks 1.50 50 75.00 - (75.00)Blank Zip Disks 11.00 10 110.00 - $(11,525.00)Backup Exec 8.0 720.00 1 720.00 Moved to supplies - Moved to supplies SQL Module for Backup Exec 795.00 1 795.00 - (795.00)UNIX Module for Backup Exec 900.00 1 900.00 - (900.00)Accelerator Agents 300.00 4 1,200.00 - (1,200.00)
5,000.00 - Telecom:*CallMaster Telephone 700.00 5 3,500.00 - (3,500.00)Amplifier 100.00 20 2,000.00 - (2,000.00)Headset 159.00 20 3,180.00 - (3,180.00)Admin Phone 510.00 5 2,550.00 - (2,550.00)
11,230.00 - Printers:HP4000 17ppm 1,400.00 1 1,400.00 - (1,400.00)Tektronics Color Printer 5,000.00 1 5,000.00 - (5,000.00)
6,400.00 -
Training:Computer Based Training (CBT) 1,200.00 1 1,200.00 - (1,200.00)Training Books 1,000.00 1 1,000.00 - (1,000.00)
2,200.00 - Resource Kits: - Back Office 250.00 1 250.00 - (250.00)Windows 95 50.00 1 50.00 - (50.00)
Quantity Purchased
Actual Cost
(+ or -) from Budget
h:\rabel\nymi\budget\document.xls 3 of 7 04/07/2023
Windows 98 70.00 1 70.00 - (70.00)Windows NT 300.00 1 300.00 - (300.00)
670.00 - Services: - Additional Cable Runs 120.00 30 3,600.00 - (3,600.00)
3,600.00 - Equipment And Tools: - LAN Network Analyzer 12,000.00 1 12,000.00 - (12,000.00)Hand Tools 300.00 1 300.00 - (300.00)
12,300.00 - Total Hardware 68,235.00 Total Hardware - (78,930.00)
h:\rabel\nymi\budget\document.xls 4 of 7 04/07/2023
New Application Servers Budget Purchases
Unit Cost Quantity Total Subtotal Unit Cost SubtotalPrimary Domain Controller -- Pentium III 500 MHz: 3,000.00 1 3,000.00 512 MB RAM Memory 3,000.00 incl.: Mirror Operating System Drives
SQL Servers -- Pentium III 500 MHz: 32,000.00 1 32,000.00 Quad Pentium Pro 77,800.00 incl.: 1 GB Memory Raid Disk Storage 100 GB
New FISCAL RS6000 Model 7026 H-70: 43,500.00 1 43,500.00 Quad Processor 43,500.00 1 GB Memory72.8 GB Hard Drive
Server Upgrades:
Backup Domain Controller / Main File Storage -- HP Pentium II 1,200.00 1 1,200.00 Memory Upgrade - 512 MB 500.00 1 500.00 Triple Ethernet 100 Mb Controller (NIC) 300.00 2 600.00 Mirror Operating System Drives 2,300.00
Firewall/Internet Protection:
Hardware: 5,000.00 1 5,000.00 Firewall Server 5,000.00
Software: 8,000.00 1 8,000.00 Rapter Software for operation w/100 users 4,500.00 1 4,500.00 Setup and Training 1,500.00 1 1,500.00 One-year patches, updates, and support 14,000.00
ISP/e-Mail: 300.00 12 3,600.00 * MCI Remote access to e-mail system (monthly charge) 3,600.00
Total Server Cost 149,200.00
* This is a prerequisite to Microsoft Exchange Server and Internet e-mail. Software and hardware devices to provide forprotection against intrusion by way of the Internet. Prices are still being negotiated for this piece and may change.
Quantity Purchased Actual Cost
(+ or -) from Budget
document.xls 5 of 7 04/07/2023
Software LicensingUnit Cost Quantity Total Subtotal
Client Machines:MS Office 2000 375.00 120 45,000.00 MS Project 2000 250.00 15 3,750.00 Visio Ver 5 400.00 8 3,200.00 Fiscal GUI license 59.00 32 1,888.00
53,838.00 Server Software:Windows NT Server 1,000.00 1 1,000.00 MS Exchange Server 1,000.00 1 1,000.00 SQL Server 1,000.00 1 1,000.00
3,000.00 Client Access Licenses:NT Server Connection 49.00 125 6,125.00 SQL Server 69.00 80 5,520.00 Exchange Server 50.00 125 6,250.00 UNIX License 100.00 32 3,200.00 Unibasic License 125.00 32 4,000.00 IQ Query License 125.00 32 4,000.00
29,095.00 Total Licensing: $ 85,933.00
IS Hardware Budget
Unit Cost Quantity Cost SubtotalDesktop Hardware:Replacement Desktop Computer 999.00 15 14,985.00 Monitor 17" 125.00 5 625.00 Hard Drive 6 GB 145.00 5 725.00 Keyboard 25.00 10 250.00 Mouse 25.00 10 250.00 Power Strip 40.00 25 1,000.00 Pentium Notebook Computer 1,200.00 1 1,200.00 LCD Projector 2,200.00 1 2,200.00
21,235.00 Misc Hardware:Server Shelving 900.00 1 900.00 UPS - Power Equipment 1,100.00 2 2,200.00 Fireproof Media Storage 2,500.00 1 2,500.00
5,600.00 Backup:8mm Tapes 30.00 10 300.00 DLT Tapes 75.00 12 900.00 Blank CDR Disks 1.50 50 75.00
document.xls 6 of 7 04/07/2023
Blank Zip Disks 11.00 10 110.00 Backup Exec 8.0 720.00 1 720.00 SQL Module for Backup Exec 795.00 1 795.00 UNIX Module for Backup Exec 900.00 1 900.00 Accelerator Agents 300.00 4 1,200.00
5,000.00 Telecom:*CallMaster Telephone 700.00 5 3,500.00 Amplifier 100.00 20 2,000.00 Headset 159.00 20 3,180.00 Admin Phone 510.00 5 2,550.00
11,230.00 Printers:HP4000 17ppm 1,400.00 1 1,400.00 Tektronics Color Printer 5,000.00 1 5,000.00
6,400.00
Training:Computer Based Training (CBT) 1,200.00 1 1,200.00 Training Books 1,000.00 1 1,000.00
2,200.00 Resource Kits:Back Office 250.00 1 250.00 Windows 95 50.00 1 50.00 Windows 98 70.00 1 70.00 Windows NT 300.00 1 300.00
670.00 Services:Additional Cable Runs 120.00 30 3,600.00
3,600.00 Equipment And Tools:LAN Network Analyzer 12,000.00 1 12,000.00 Hand Tools 300.00 1 300.00
12,300.00 Total Hardware: 68,235.00
New Application Servers
Unit Cost Quantity Total Subtotal Primary Domain Controller -- Pentium III 500 MHz: 3,000.00 1 3,000.00 512 MB RAM Memory 3,000.00 incl.: Mirror Operating System Drives
SQL Servers -- Pentium III 500 MHz: 32,000.00 1 32,000.00 Quad Pentium Pro 77,800.00
document.xls 7 of 7 04/07/2023
incl.: 1 GB Memory Raid Disk Storage 100 GB
New FISCAL RS6000 Model 7026 H-70: 43,500.00 1 43,500.00 Quad Processor 43,500.00 1 GB Memory72.8 GB Hard Drive
Server Upgrades:
1,200.00 1 1,200.00 Memory Upgrade - 512 MB 500.00 1 500.00 Triple Ethernet 100 Mb Controller (NIC) 300.00 2 600.00 Mirror Operating System Drives 2,300.00
Firewall/Internet Protection:
Hardware: 5,000.00 1 5,000.00 Firewall Server 5,000.00
Software: 8,000.00 1 8,000.00 Rapter Software for operation w/100 users 4,500.00 1 4,500.00 Setup and Training 1,500.00 1 1,500.00 One-year patches, updates, and support 14,000.00
ISP/e-Mail: 300.00 12 3,600.00 * MCI Remote access to e-mail system (monthly charge) 3,600.00
Total Server Cost: 149,200.00
* This is a prerequisite to Microsoft Exchange Server and Internet e-mail. Software and hardware devices to provide forprotection against intrusion by way of the Internet. Prices are still being negotiated for this piece and may change.
Total CostsSoftware Licensing $ 85,933.00
IS Hardware Budget $ 68,235.00
New Application Servers $ 149,200.00
Total IS Budget: $ 303,368.00
Backup Domain Controller / Main File Storage -- HP Pentium II LX Pro: