IMPROVING DECISION MAKING: USING A SPREADSHEET TO EVALUATE HARDWARE AND SOFTWARE OPTIONS Software skills: Spreadsheet formulas Business skills: Technology pricing 5-10 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/Compaq. (For the purposes of this exercise, ignore the fact that desktop systems usually come with preloaded software packages.) Obtain pricing on 15 desktop printers manufactured by HP, Canon, and Dell. Each desktop system must satisfy the minimum specifications shown in tables that you can find in MyMISLabTM. Also obtain pricing on 30 copies of the most recent versions of Microsoft Office, Lotus SmartSuite, and OpenOffice, and on 30 copies of Microsoft Windows 8 Professional. Each desktop productivity package should contain programs for word processing, spreadsheets, database, and presentations. Prepare a spreadsheet show- ing 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. For each exercise, write a Memo to your supervisor on the Exercise. Each Memo shall include ( A summary of the Exercise (Explanations of how you complete the Exercise (Explain and include each spreadsheet, tables, forms and reports (Include a formula sheet in case of an Excel Exercise Produce 5 Power Point slides for the presentation of your report and result (Print out the PowerPoint slides and save them in your USB for presentation to the class Have a cover page and staple all your printouts.
Purchase answer to see full attachment