Your company is about to purchase a set of equipment to upgrade its computing capabilities. A committee was formed to evaluate needs, and this committee has come back with a set of recommendations. They have recommended the purchase of two types of PCs: one for power users and one for all other employees. There are sixteen employees in your company. The committee is tentatively planning to order 6 high end PCs for power users, and 10 less powerful standard PCs for the other employees. However, at least 10 employees have requested the power PCs, so the committee would like to be able to look at the cost of increasing the number of power PCs that are purchased. The committee has also recommended the purchase of a high-speed laser printer and three ink jet color printers. The laser printer will be placed in a central location and used for final drafts requiring high print quality. The three ink jet printers will be placed at convenient locations around the work area and will be used for printing of draft work.
You have been asked to go out to the Internet and obtain pricing information for your company’s proposed purchase. You are asked to get at least three price quotes for each type of equipment that is to be purchased. You are also asked to investigate the technology specifications, warranty and servicing provided by each potential supplier. You are to gather this information into a spreadsheet file that can be presented to the screening committee at its next meeting.
Based on the description provided, go out to the Internet and get price quotes for all of the hardware described in this case from at least three vendors (PC manufacturers). Once you have obtained the needed information, use Excel to design and build a spreadsheet application that will allow you to show the costs of purchasing this hardware from each vendor and total cost for whole purchase. Also be sure that your application allows you to change a parameter value (the number of power PC units) to see the effect of changing the number of power PC units that are purchased.
In American Dollars please.
|Due By (Pacific Time)
||07/13/2013 12:30 pm