In this exercise, you will use spreadsheet software to calculate the cost of desktop systems, printers, and software. Use the Internet to obtain pricing information on hardware and software for an office of 30 people. You will need to price 30 PC desktop systems (monitors, computers, and keyboards) manufactured by Lenovo, Dell, and HP. (For the purposes of this exercise, ignore the fact that desktop systems usually come with preloaded software packages). Also obtain pricing on 15 desktop printers manufactured by HP, Canon, and Brother. Each desktop system must satisfy the minimum specifications shown in table.

Also obtain pricing on 30 licenses or copies of the most recent versions of Microsoft Office 365 Business and Apache Open Office (formerly Oracle Open Office) and on 30 copies of Microsoft Windows 10 Pro. Each desktop productivity solution should contain software for word processing, spreadsheets, database, and presentations. Prepare a spreadsheet showing your research results for the desktop system, printer, and software combination offering the best performance and pricing per worker over a two-year period. Because every two workers share one printer (15 printers/30 systems), your calculations should assume only half a printer cost per worker.

Desktop and Printer Specifications Each desktop system must satisfy the minimum specifications shown in the following table: MINIMUM DESKTOP SPECIFICATIONS Processor speed 3 GHz Hard drive 500 GB RAM 4 GB DVD-ROM drive DVD-RW Monitor (diagonal measurement) 18 inches Each desktop printer must satisfy the minimum specifications shown in the MINIMUM MONOCHROME PRINTER SPECIFICATIONS Print speed (black and white) 20 pages per minute Print resolution 600 X 600 Network ready? Yes Maximum price/unit $700