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...
-
On March 1, 2010, Penner Company acquired real estate on which it planned to construct a small office building. The company paid $80,000 in cash. An old warehouse on the property was razed at a cost...
-
Fuhito's marginal utility for burgers is equal to 3 times the number of sodas he is consuming, regardless of the number of sodas. a. What is Fuhito's utility function for burgers and sodas? b. What...
-
An \(R L C\) circuit consists of a \(48 \Omega\) resistor, a \(200 \mu \mathrm{F}\) capacitor, and an inductor. The rms current is \(2.5 \mathrm{~A}\) when the circuit is connected to a \(120...
-
On October 1, 2017, Vaughn, Inc., leased a machine from Fell Leasing Company for five years. The lease requires five annual payments of $10,000 beginning September 30, 2018. Vaughn's incremental...
-
A consumer's budget set for two goods (X and Y is 700 5X+2Y. a. The budget set is illustrated below. What are the values of A and B? Good Y Good X B A = B = b. Does the budget set change if the...
-
On January 30 of the current year, Ashton Corporation purchased from Cathy 10% of Todd Corporation stock for $250,000 in cash. On May 30 of the following year, Andrea and Bill each exchange one-half...
-
Suppose a team of software engineers working for a software firm was negligent, and that the teams faulty software caused a major accident involving loss of life. The company was sued and settled the...
-
Burien Family Market has two family-owned grocery stores that have been in business for years. Whole Foods decides that Burien Family Market would be an excellent place to build one of its...
-
Isobars are lines of equal atmospheric pressure drawn at 4 millibar intervals. If the center of a LOW PRESSURE is 992 mb and the center of a HIGH PRESSURE is 1024 mb, how many isobars must be drawn...
-
Was the sport attractive for the TV format, in your opinion? Why do you think it might not have lasted beyond that decade? https://youtu.be/mpithZbH5sI
-
1. Find the rate of return for the following cash flows: 125 0- 10 111 218 0- -3- -5- -6 30 40 50 60 +8 84. 80 80 813 84 2- 80 80 80 816 815 80 200 200 200
-
discuss the trade-offs between various threading models, such as user-level threading (ULT), kernel-level threading (KLT), and hybrid threading, in terms of performance, resource utilization, and...
-
Suppose that a country has 200 workers and that its technology requires 1 worker-hour per unit of food and 2 worker-hours per unit of cloth. In autarky, it employs 100 workers in each of the two...
-
Read Case Study Google: Dont Be Evil Unless and answer the following: Why do you think Google was adamant about not wanting to supply information requested by the government concerning the Child...
-
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...
-
What are the features of a legal risk management plan?
-
What is the special role of the courts in a federal country?
-
What are residual powers? Concurrent powers?
Study smarter with the SolutionInn App