Hands-On Project 5-10 (Revised for 6 systems) Prepare a spreadsheet showing your
ID: 409101 • Letter: H
Question
Hands-On Project 5-10 (Revised for 6 systems)
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 pricing per worker (30 total workers). 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.
This project requires students to use their Web research skills to obtain hardware and software pricing information, and then use spreadsheet software to calculate costs for various system configurations. Answers may vary, depending on when students accessed the vendors’ Web sites to obtain pricing information. The sample solution files provided are for purposes of illustration and may not reflect the most recent prices for desktop hardware and software products.
Desktop and Printer Specifications
Each desktop system must satisfy the minimum specifications shown in the following table:
MINIMUM PC SPECIFICATIONS
Processor speed 3 GHz or higher
Hard drive 500 GB or higher
RAM 4 GB or higher
DVD-ROM drive DVD-RW
Monitor (diagonal measurement) 18 inches
Each desktop printer must satisfy the minimum specifications shown in the
MINIMUM PRINTER SPECIFICATIONS
Print speed (black and white) 20 pages per minute
Print resolution 600 × 600
Network ready? Yes
Maximum price/unit No Maximum
An Example Solution file can be found in the Microsoft Excel file attached to this learning module
Software skills: Spreadsheet formulas Business skills: Technology pricing
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 three (3) models of PC systems (monitors, computers, and keyboards) manufactured by different manufacturers -Lenovo, Dell, and HP/ Compaq. (For the purposes of this exercise, ignore the fact that desktop systems usually come with preloaded software packages.) Obtain pricing on 3 desktop printers manufactured by HP, Canon, and Dell. Each desktop system must satisfy the minimum specifications shown in tables that you can find attached in the Blackboard Learning Module for this project. Also obtain pricing on copies of the most recent versions of Microsoft Office, Lotus SmartSuite, and OpenOffice, and on 3 copies of Microsoft Windows 8 Professional. 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. Because every two workers share one printer (15 printers/ 30 systems), your calculations should assume only half a printer cost per worker.
Could someone PLEASE HELP! I need to show the formula. An Example is listed how the spreadsheet should look, but without the formula.
Hardware and Software Pricing Information - Example ComputerItem Minimum
Specs Lenovo
Specs Dell
Specs HP
Specs Model No. ThinkCentre M72e Tower Desktop Inspiron 660s Pavilion 500-000t Processor 3 GHz 3.3 3 3.3 Hard Drive 500 GB 500 500 1TB RAM 4 GB 4 4 6 DVD-ROM drive DVD-RW DVD Recordable W8 16X CD/DVD burner (DVD+/-RW) Super Multi DVD Burner Monitor 18 inches 21.5 18.5 20 Cost/Unit $709.99 $448.99 $599.98 x 30 Units Enter Formula Enter Formula Enter Formula Printer
Item Minimum
Specs Hewlett
Packard Canon Dell* Model No. HP LaserJet Pro P1606dn imageCLASS MF4770n B1160w Wireless Mono Laser Printer Print Speed 20 ppm 26 ppm 24 ppm 20 ppm Print Quality 600 x 600 dpi 600 x 600 dpi 600 x 600 dpi 600 x 600 dpi Network Ready? Yes Yes Yes Yes Maximum
Price/Unit $700 Cost/Unit $179.99 $199.00 109.99 x 15 Units Enter Formula Enter Formula Enter Formula Software MS Office 2013 Apache Open Office IBM Lotus SmartSuite Software Version Home & Student 4 Millennium Edition 9.8.2 Cost/Unit $139.99 Free $29.99 x 30 Units Enter Formula Free Enter Formula Best Choice Computer Operating System Office Productivity Software Printer Cost/Unit Total Cost Inspiron 660s Windows Apache Open Office B1160w Wireless Mono Laser Printer $448.99 included Free Enter Reference Cell Enter Formula Enter Formula
Explanation / Answer
This is a simple excel question. You need 30 Laptops, 15 printers
The first formula is supoosed to be given under lenovo specs
The answer is supposed to be there 30 units *$709.99
In the bottom of Minimum specs you type 30 (THat is cell B11)
iN CELL B12 , please Type = b11*c9 (C9 is the column where price is given)
IN Cell C12 =B11*D9
IN CELL D12 =B11*E9
Calculation on Printer
Please type 15 in B21
Please type the formula in cell C21
=C19*B21
pLEASE TYPE THE FORMULA IN cELL d21
=D19*B21
pLEASE TYPE THE FORMULA IN CELL E21
=E19*B21
Similaly all office requires 3*139.93=
Put the unit (30') in cell, find cell reference number (E.g B26 (B26=30)) AND MULTIPLEY BY COST
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.