Assignment Instructions: 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 20 people.
• You will need to price 20 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.
• Obtain pricing on 20 desktop printers manufactured by HP, Canon, and Dell. Each desktop system must satisfy the minimum specifications shown below in the desktop and printer specifications.
• Obtain pricing on 30 copies of the most recent versions of Microsoft Office and Apache OpenOffice (formerly Oracle Open Office) and on 30 copies of Microsoft Windows 10.
• Each desktop productivity package should contain programs for word processing, spreadsheets, database, and presentations.

Prepare a spreadsheet showing your research results for the software and the desktop system, printer, and software combination offering the best performance and pricing per worker. Include the relevant web links to the specific desktop systems, printers, and software shown in the spreadsheet. Submit assignment as a spreadsheet

Desktop and Printer Specifications

Each desktop system must satisfy the minimum specifications shown in the following table:

MINIMUM DESKTOP SPECIFICATIONS

CPU Quad core Hard drive 1 TB RAM 16 GB Monitor 18 inches (diagonal measurement)

Each desktop printer must satisfy the minimum specifications shown in the following table:

MINIMUM MONOCHROME PRINTER SPECIFICATIONS

Print speed (black and white) 20 pages per minute Print resolution 600 600 Network ready? Yes Maximum price/unit $800