Excel Assignment: Procurement Expenditure Analysis. A company has prepared a spreadsheet that contains 3 years of procurement expenditures for its four sales groups: electronics,

Excel ® Assignment: Procurement Expenditure Analysis.

A company has prepared a spreadsheet that contains 3 years of procurement expenditures for its four sales groups: electronics, computers, appliances, and furniture. Several rows of this spreadsheet are illustrated.

Download the spreadsheet file titled “chapter_ 9_ 78” from the text-book Web site. Compute column totals for each year and the 3- year summary totals for each group/ category row. Then prepare an evalua-tion of these 3- year anevalua-tionofthese3-year summary totals by comparing each to the amounts in the following table and entering the descriptive result ( i. e., “ aver-age,” “ excellent,” etc.) into the spreadsheet column that is next to the column containing the 3- year summary totals for each group/ category that you calculated.

The evaluation can best be accomplished by using the VLOOKUPfunction.

Procurement Expenditures by Group/Category Group Category 2010 (in 2011 (n 2012 in dollars) dollars dollars) Electronics Televisions 1.750,000 2500,000 3,250,000 Computers Laptop1500,000 2.100,000 2.850.000 Appliances Kitchen 450,000 1,880,000 2.005,000 Furniture Family 1230,000 .500,000 .700,000 Room Amount (in dollars) Evaluation 500,000 1,000,000 2,000,000 5,000,000 8,000,000 Unacceptable Below Average Average Above Average Excellent