Your company is about to open a new branch. You were selected to equip the office with 20 personal computers, 10 laptop computers, and 5 laser printers. Management has asked that you purchase all the equipment from a single online purchase all the equipment from a single online vendor. Each PC must be purchased complete with a 20-inch LCD monitor. After interviewing employees about their typical computing needs, you developed the following scale:

PCs: Every 1 MHz of clock rate receives 1 point; every 1 GB of RAM receives 10 points; every 1 GB of hard disk storage receives 1 point. For CD-RW, each 1X of reading speed receives 1 point (writing and rewriting speeds are not essential, but the capabilities are required).

LCD monitors: Every 1:100 of contrast radio gets 10 points. Other features are not essential.

Laptops: The same scoring as for PCs.

Printers: Every 1 PPM receives 100 points. Every 1 DPI receives 1 point.

Research three online vendor sites for this equipment. Prepare a spreadsheet table with 3 columns, one for each vender, and enter the information you found about each piece of equipment for each vendor. Enter a formula to add up the total number of points at the bottom of each column. Do not consider any factor that is not mentioned here. Find the vendor whose tool points per dollar is the highest.