Job Profitability Using Excel problem is also available on the website. Hint. Add columns to the Data sheet to separate out account amounts $($revenue$,$ direct material, etc.$).$ The If function is useful here.

Create PivotTables to answer the following questions.

a$.$

$1.$ Which customer was the most profitable for Harvard:

$2.$ What was the job number for the most profitable job for that customer? $\backslash (2340\backslash$div $\backslash )$

$3.$ What was the average revenue on jobs for that customer $?$

Note: Round your answer to the nearest whole dollar.

$4.$ What was the average revenue for all jobs?

Note: Round your answer to the nearest whole dollar.