Subject :- MANAGING INFORMATION ACROSS THE ENTERPRISE: Improving Decision Making
ID: 664942 • Letter: S
Question
Subject :- MANAGING INFORMATION ACROSS THE ENTERPRISE:
Improving Decision Making: Using a Spreadsheet to Evaluate
Hardware and Software Options
Software skills: Spreadsheet formulas (MS EXCEL)
Business skills: Technology pricing
In this exercise, you will use spreadsheet software to calculate the cost of desktop systems,
Printers, and software.
You have been asked to obtain pricing information on hardware and software for an office of 30 people. Using the Internet, get pricing for 30 PC desktop systems (monitors, Computers, and keyboards) manufactured by Lenovo, Dell, and HP/ Compaq as listed at Their respective corporate Web sites. (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 Dell. Each desktop system must satisfy the minimum specifications shown in the following table:
Minimum Desktop Specifications
Processor speed 1600 MHz Clock Speed
Dual Core Processor
Hard drive 1 TB
RAM 8 GB
Monitor (diagonal measurement) 21 inches LCD
Each desktop printer must satisfy the minimum speculations shown in the following
Table:
Laser Printer Black & White
15 ppm
After pricing the desktop systems and printers, obtain pricing on 30 copies of the most recent versions of Microsoft Office, Lotus SmartSuite, and Oracle Open Office desktop productivity packages, and on 30 copies of Microsoft Windows 7 Professional. The application software suite packages come in various versions, so be sure that each package contains programs for word processing, spreadsheets, database, and presentations.
Prepare a spreadsheet showing your research results for the desktop systems, for the printers, and for the software. Use your spreadsheet software to determine the desktop system, printer, and software combination that will offer both the best performance and the best pricing per worker. Because every two workers will share one printer (15 printers/ 30 systems), assume only half a printer cost per worker in the spreadsheet. Assume that your company will take the standard warranty and service contract offered by each Product’s manufacturer.
Explanation / Answer
MANAGING INFORMATION ACROSS THE ENTERPRISE
COMPUTER
Computer item
Lenovo C470
HP ENVY
1.70 GHz
Intel Core i3
Here If we search any brand who have above specification not getting any item.
Printer
5252B001AA
Dell 1720
Q5911A#ABA
Software
Computer item
specification Lenovo Dell HP/Compaq Model numberLenovo C470
5348 i5348-5555BLKHP ENVY
Processor speed 1600 MHz Clock Speed1.70 GHz
2.8GHz 2.9 GHz Processor Dual CoreIntel Core i3
core intel i5 Intel Core i5 ROM 1 TB 1 TB 1 TB 1 TB RAM 8 GB 8 GB 8 GB 8 GB Monitor 21 inches LCD 21.5 inches 23 inches 23 inches Cost $499.99 $869.00 $805.72 cost/unit * 30 $14999.7 $26070.00 $24171.6