Franklin College
Summer 2003
Erich Prisner,


Project 3

First download this Excel file.

A) Use a Pivot table to compare prices for the same product from different vendors.



D) Use another Pivot table to compare average (actual) transit times.

E) Use another Pivot table to have both information, average (actual) transit time, and prices per unit in the same table. What is your conclusion here?

F) Next make the assumption that delay of more than 8 days (difference between promised transit time and actual transit time) is inacceptable, and we want to find out those vendors who had at least once a delay of at least 8 days for a certain product. Again create a Pivot table, use "Maximum" and conditional formatting to highlight those vendor-product combinations that should be avoided in the future.

G) Next assume we want a detailed analysis for different months. For some reason we want to disregard orders placed in October. First add a column where you automatically create the month in which the order was placed. Then do the same Pivot table with month as third parameter (for the pages). What is your conclusion if October orders won't count? (you may exclude October).

Up to main page Erich Prisner, June 2003