Question: In this exercise, you will use spreadsheet software to calculate the cost of desktop systems, printers, and software. Use the Internet to obtain pricing

In this exercise, you will use spreadsheet software to calculate the cost

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. Desktop and Printer Specifications Each desktop system must satisfy the minimum specifications shown in the following table: MINIMUM DESKTOP SPECIFICATIONS Processor speed 3 GHz 500 GB 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) Print resolution Network ready? Maximum price/unit Hard drive. RAM 20 pages per minute 600 600 Yes $700 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.

Step by Step Solution

3.39 Rating (149 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!