Project #81222 - Hardware and Software Pricing Information

 

I need someone that will be able to complete asignment by 11:00pm ***No bids over $25***

 

Instructions

 

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.

 

 

 

Excel Tutorials Links (If Student Requires)

 

Choose Link below Based on Your current Excel Version:

 

http://www.gcflearnfree.org/excel2013/27   For MS Excel 2013 users – 28 Lessons in all subjects needed

 

http://www.tutorialspoint.com/excel/    For MS Excel 2010 users -  Lessons with examples in all subjects needed – click on training of interest from the Left Side Menu.

 

http://www.gcflearnfree.org/excel2007    For MS Excel 2007 users -  Lessons in all subjects needed – avoid the Ads, the training material is there as you scroll down the pages.

 

Subject Computer
Due By (Pacific Time) 09/06/2015 08:03 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy