Get documents about "943301-Sample-IT-Budgetxls - Incisive Spreadsheet Analysis
Document Sample
Software Licensing
Budget Purchases
Quantity Actual (+ or -) from
Unit Cost Quantity Total Subtotal Unit Cost Purchased Cost Subtotal Budget
Client 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)
H:\rabel\nymi\budget\fb4eaf32-fc29-417f-bd3f-ae1001125b92.xls 1 of 7 7/17/2010
IS Hardware Budget
Budget Purchases
Quantity Actual (+ or -) from
Unit Cost Quantity Cost Subtotal Unit Cost Purchased Cost Subtotal Budget
Desktop 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)
h:\rabel\nymi\budget\fb4eaf32-fc29-417f-bd3f-ae1001125b92.xls 2 of 7 7/17/2010
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\fb4eaf32-fc29-417f-bd3f-ae1001125b92.xls 3 of 7 7/17/2010
New Application Servers
Budget Purchases
(+ or -)
Quantity from
Unit Cost Quantity Total Subtotal Unit Cost Purchased Actual Cost Subtotal Budget
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
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 Memory
72.8 GB Hard Drive
Server Upgrades:
1,200.00
Backup Domain Controller / Main File Storage -- HP Pentium II LX Pro: 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 for
protection against intrusion by way of the Internet. Prices are still being negotiated for this piece and may change.
h:\rabel\nymi\budget\fb4eaf32-fc29-417f-bd3f-ae1001125b92.xls 4 of 7 7/17/2010
Software Licensing
Unit 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 Subtotal
Desktop 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
fb4eaf32-fc29-417f-bd3f-ae1001125b92.xls 5 of 7 7/17/2010
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
fb4eaf32-fc29-417f-bd3f-ae1001125b92.xls 6 of 7 7/17/2010
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 Memory
72.8 GB Hard Drive
Server Upgrades:
Backup Domain Controller / Main File Storage -- HP
Pentium II LX Pro: 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 for
protection against intrusion by way of the Internet. Prices are still being negotiated for this piece and may change.
Total Costs
Software Licensing $ 85,933.00
IS Hardware Budget $ 68,235.00
New Application Servers $ 149,200.00
Total IS Budget: $ 303,368.00
fb4eaf32-fc29-417f-bd3f-ae1001125b92.xls 7 of 7 7/17/2010
