5-11 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 tables that you can find in MyLab MIS.

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.