After intervicwing employees about their typical computing needs, you develop the following scale for the analysis: - PCs: - Every I MHz of cloek rate receives 1 point; (so a 2.4G Ghz computer received 2400 points) o Every I GB of RAM receives 100 points; (so a 16GB computer receives 1600 points o Every 1GB of hard disk storage receives 3 points. (so 512GB coinguter receives 1536 points) - LCD moniters: Every 100:1 of contrast ratio gets 10 points, Oiher features are aod extential. * Lapteps: The same scoting as for PCs. - Printers! YOUR TASKS: 1) Opea a new spreadsheet workbook. 2) Define the following tems is a worksheet tab labeled as DEFINITIONS. a. Clock rate b. RAM c. Contrast ratio d. PPM 3) Research three different online vendor sites for this equipment, (Best Buy, Stables, CDW, cte) 4) In a worksheet tab labeled ANAL.YSIS add a table with three columns, one for cach vendor, and enter the information you found about cach picce of eqaipment 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 formala to caleulate the points for each picce of equipment from each vendor. 6) Enter a formuls 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: 8) Find the vendor whose total points per dollar is the highest. This is your "wianing" vendor. 9) Clearly identify the "winning" vesdor. 10) Make the spreadsheet professiooal-looking using the spreadsheet creation and formatling skilis you have leamed from Mind Thap 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 z calculated PC Poekts: You find a PC that has a clock rate of 3.06 Cdy, 32Gs RAM, 218kDD. Baved on the PC conflguratioo and conversion factors, apply the points: - for clock rate 1 point for eveny 1 Miter 3060 points - RAM. 100 point for every Ge: 3200 points - HDD: 1 point for every 08:3000 points So for this particular PC, the total points asiened would be 9,260 points MONITOR POINTS: The Dell 32" ICo Monitor you found has a 1000I contrant fate. - 1000:1/100:1 = 1n (muttiply this by 10 peints for a total score of 100 points for the Monitoel PAinta points, the peintecyou found has a FPM (paces per minute) of 24 . Thus, wour printer hat a total ucore of 2400 - 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 d. PPM 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. 8) 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 bave learned from MindTap Modules 1,2,&3. 11) Saye 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.06Gbz,32GB RAM, 2TB HDD. Note: 3.06GHz=3060MHz (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 1MHz3060 points - RAM: 100 point for every G8: 3200 points - HDD: 1 point for every GB:3000 points Sa 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
