You are to create an IT budget for your company. Some employees will want desktop computers while other employees will want laptop computers.

Your manager wants the ability to enter and change the number of desktops, laptops, and printers to see how the changes alters the total for each vendor.

You are to create an IT budget for your company.  Some employees will want desktop computers while other employees will want laptop computers.  Some desktop computers, but not all, require printers and associated toner cartridges. All computer are to have Office 2016 Professional suite. The allocation of equipment to employees will be decided after the budget is approved. This new equipment will be an addition to the company’s current network.  You are to use the Internet to get prices for this equipment and supplies from two different vendors.  

Design a spreadsheet that allows the user to enter the number of desktop computers, the number of laptop computers, and the number of printers. This spreadsheet is to compute the Total Cost of Ownership for this equipment including both direct costs and indirect costs.  You are to estimate the costs associated with setting up the computers and any needed training. 

Your spreadsheet should look similar to the sample below.

Your Name

Enter number of desktops

Enter number of laptops

Enter number of printers

Prices

Costs

Vendor 1

Vendor 2

Vendor 1

Vendor 2

Desktop

Laptop

Printer

Software [Office]

Toner

Setup/Training [estimate]

XXXXXX

XXXXXX

TOTALS: