SCENARIO: Your company is about to open a new customer support location in Lawrenceville. You, as the business analyst in the customer support center, have been selected by senior management (from the Atlanta corporate headquarters) to equip the office with 20 personal computers, 10 laptop computers, and 5 laser printers. The CIO has asked that you purchase all the equipment from a single online vendor. Each PC must be purchased complete with a 32- inch LCD monitor. You decide using Excel would be a great way to do the analysis. After interviewing employees about their typical computing needs, you develop the following scale for the analysis: . PCs: Every 1 MHz of clock rate receives 1 point; (so a 2.4Ghz computer received 2400 points) Every 1 GB of RAM receives 100 points; (so a 16GB computer receives 1600 points Every 1 GB of hard disk storage receives 3 points. (so 512 GB computer receives 1536 points) LCD monitors: Every 100:1 of contrast ratio gets 10 points. Other features are not essential. Laptops: The same scoring as for PCs. Printers: o Every 1 PPM receives 100 points YOUR TASKS: 1) Open a new spreadsheet workbook. 2) Define the following terms in a worksheet tab labeled as DEFINITIONS. a. Clock rate b. RAM C. Contrast ratio PPM DPI (not used) 3) Research three different online vendor sites for this equipment. (Best Buy, Stables, CDW, etc) 4) In a worksheet tab labeled ANALYSIS add a table with three columns, one for each vendor, and enter the information you found about each piece of equipment for each vendor. You will need rows for each of the items you are purchasing and their characteristics / features that you are scoring- 5) Enter a formula to calculate the points for each piece of equipment from each vendor. 6) Enter a formula to add up the total number of points at the bottom of each column. 7) Do not consider any factor that is not mentioned here. B) Find the vendor whose total points per dollar is the highest. This is your "winning" vendor. 9) Clearly identify the "winning" vendor. 10) Make the spreadsheet professional-looking using the spreadsheet creation and formatting skills you have learned from MindTap Modules 1, 2, & 3. 11) Save and upload your spreadsheet back into the HW2 assignment dropbox. Here's a simplified example to demonstrate how points are to be used & calculated PC POINTS: You find a PC that has a clock rate of 3.06 Ghz, 32GB RAM, 2TB HDD Note: 3.06 GHz = 3060 MHz (using the conversion factor of 1Ghz = 1000MHz) and 2TB = 2000GB Based on the PC configuration and conversion factors, apply the points: for clock rate: 1 point for every 1MHz : 3060 points RAM: 100 point for every GB: 3200 points HDD: 1 point for every GB: 3000 points So for this particular PC, the total points assigned would be 9,260 points MONITOR POINTS: The Dell 32" LCD Monitor you found has a 1000:1 contrast ratio 1000:1/ 100:1 = 10 (multiply this by 10 points for a total score of 100 points for the Monitor) PRINTER POINTS: The printer you found has a PPM (pages per minute) of 24. Thus, your printer has a total score of 2400