In this exercise, you will use spreadsheet software to calculate the cost of desktop systems, printers,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Related Book For
Transportation A Global Supply Chain Perspective
ISBN: 9781337406642
9th Edition
Authors: Robert A. Novack, Brian Gibson, Yoshinori Suzuki, John J. Coyle
Posted Date:
Students also viewed these general management questions
-
The following transactions for Nielsen Architects occurred during December of the current year. Follow the step-by-step instructions to record the transactions, process the adjusting entries, and...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
During the 2015-16 period, Larry Energeria Ltd acquired a patent for heating glazing unit, as well as incurring expenses in relation to the development of a new power generation brick that it expects...
-
In a task assignment situation, in how many different ways can five jobs be assigned to five machines if each job must be assigned to each machine and each machine must be assigned one job? Multiple...
-
The following is a summary of all relevant transactions of Vicario Corporation since it was organized in 2019. In 2019, 15,000 shares were authorized and 7,000 ordinary shares ($50 par value) were...
-
The following symbolized arguments are missing a premise. Write the premise needed to derive the conclusion (last line ), and supply the justification for the conclusion. Try to construct the...
-
The capital gains received on stock sales is considered income, and you have to pay taxes on it. To encourage people to invest and to hold on to those investments, the U.S. government taxes capital...
-
Homepride Carpet Company manufactures carpets. Fiber is placed in process in the Spinning Department, where it is spun into yarn. The output of the Spinning Department is transferred to the Tufting...
-
Raven Company applies overhead based on direct labor hours. Thevariable overhead standard is 21 hours at $30 per hour. DuringJuly, Raven spent $117,069 for variable overhead. Assuming 9,840labor ho 2...
-
2 1 Complete client engagement acceptance form. Review correspondence files, prior year audit workpapers, permanent files, financial statements and NA auditor's reports. 3 Apollo Shoes, Inc. AUDIT...
-
Case : Under Armour's Willful Digital Moves 1. Write a positioning statement for the UA brand and evaluate the drivers of UA's initial brand-building success. Under Armour's positioning statement is...
-
What are the key components of a bank's business continuity plan (BCP), and how do banks ensure operational resilience in the face of unexpected disruptions?
-
S) A large block of butter measures 2.3 meters by 3.4 meters by 5 meters. How many tablespoons of butter are in this block? T) You wish to form a cube formed from 1,000,000 tablespoons of butter....
-
What impact did the casino closures have on EBITDA? Why do you think the EBITDA results for March and June 2020 are better than April and May 2020?
-
Describe the changes in the volume of the lungs during each of the following. Inspiration: Expiration: Which skeletal muscles contract during each of the following? Restful Inspiration: Forced...
-
Make believe you live in a cold climate. Tonight your spouse shakes you awake at 5 a.m. on a late January morning. The house is cold and it is snowing outside. You usually turn the thermostat back a...
-
Think of a product that you buy regularly ( cranberry juice ) . Now, describe who the members of the distribution channel might be . From what you notice as a consumer, are they doing a good enough...
-
Read Case Study Google: Dont Be Evil Unless and answer the following: Given its mission of providing information to the world, should Google censor searches in China?
-
What roles do individual states play in transportation regulation?
-
Describe the attributes of information quality and how they impact transportation decision making.
-
Sammy Killebrew is struggling to clear his head after a lengthy and unpleasant meeting with the CEO at Vital-E Nutrition (VEN). The company, a manufacturer of temperature-sensitive liquid and powder...
-
The accountant of Hook, Line and Sinker, a partnership of seven people, has asked your advice in dealing with the following items in the partnership accounts for the year to 31 May 2007. (a) (i)...
-
The chief accountant of Uncertain Ltd is not sure of the appropriate accounting treatment for a number of events occurring during the year 2005/6. (i) A significant number of employees have been made...
-
Identify which of the following numbers are irrational: \(\sqrt{441}, 4.33, \sqrt{70}, 5+9 \pi\)
Study smarter with the SolutionInn App