Budget Forecasting Assignment

The case study project we are doing is implementing hardware and software necessary to virtualize 90% of our 300 physical servers (270 servers).

Our goal is to virtualize 1/3 of the 270 servers in year 1 and the remaining 2/3 in year 2. This assignment will not adjust the budgeting to span multiple years. For now, the assignment is focused on having you budget the CapEx and OpEx costs for the entire project

Fill in the Project Budget spreadsheet provided BELOW. Be sure to put the costs in the correct column, based on whether a cost is capital or an operating cost. Show work.

salesperson	job	shipping method	shipping terms	delivery date	payment terms	due date
Jane Doe	Virtualization				Due on receipt

qty	item #	description		unit price	discount	line total
Server Section
2		Hewlett Packard C7000 Chassis (7 blade servers maximum)		$4500		$9,000
14		HP Proliant BL 465c Blade Server (384GB RAM, two 16 core CPUs, two 10GB Network Interfaces)		$2499		$34,986
2		3 year Maintenance on C7000 chassis (1 year warranty)		$2500		$5,000
14		3 year Maintenance on Proliant 465c Blade Server (1 year warranty)		$750		$10,500
14		VMware ESXi Licenses (to create virtualization platform)		$8295		$116,130
14		VMware ESXi Annual Maintenance		$2488		$34,832
6		Hours of Professional Services for Design Work		$175/hr		$1050
24		Hours of Installation Services		$150/hr		$3600
1		5 days of onsite training for HP hardware & VMware (Travel included)		$4000		$4000
Storage Section
2		EMC VNXe 64 TB SAN storage		$69,501		$139,002
2		Annual Maintenance on VNXe hardware		$14,000		$28,000
1		EMC VNXe Management Software (SW)		$695		$695
1		Annual Maintenance on EMC VMXe Management SW		$100		$100
1		3 Days Onsite Installation, Training & Travel		$5000		$5,000
			Total discount
			Subtotal			$391,895
			Sales Tax			$27,433
			Total			$419,327.65

Quotation prepared by: ________________________________________________________________________________________________________________

This is a quotation on the goods named, subject to the conditions noted below: [Describe any conditions pertaining to these prices and any additional terms of the agreement. You may want to include contingencies that will affect the quotation.]

To accept this quotation, sign here and return: ___________________________________________________________________________________________

Thank you for your business!