The table found in the worksheet Q$1$ DATA shows the income statement of BS Suppliers, a nuts and bolts manufacturing company. Use a pivot table to answer the following questions. PLEASE PLACE YOUR PIVOT TABLE IN CELL B$18.$

A $-$ What are the Total Net Income, Interest Expense, Operating Income, Gross Profit, and Revenue for BS Suppliers over each quarter of the $6$ years. Be sure to format your columns as Currency with $)$

B $-$ Add a column that calculates the percentage contribution each quarter's Net Income makes to the total Net Income over the $6$ years. Call this column "Share of Profits". Format your numbers as percentages with $2$ decimal place $($i$.$e $2\mathrm{.}94\%).$

C $-$ BS Suppliers has several UA Alumni and the CEO is a big Bama fan. They will contribute $2\mathrm{.}5\%$ of each quarter's total Net Income to the football program only if that quarter's Net Income exceeds $$1,800,000.$ Create a column, using the calculated field command with an appropriate $\text{'}$IF$\text{'}$ statement to show this. Call this column "Contribution" and add it to the Pivot table. The answer the question in the box to the left

D $-$ What is the total amount that BS Suppliers will contribute to UA in the $6$ years of data provided?

Contribution