The table found in the worksheet Q1 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 B18.
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 2 dps (i.e $1,422,828.00 )
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.94% ).
C - BS Suppliers has several UA Alumni and the CEO is a big Bama fan. They will contribute 2.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 'IF' 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
The table found in the worksheet Q1 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 B18
A-What are the Total Net Income,Interest Expense,Operating Income, Gross Profit,and Revenue for Bs Suppliers over each quarter of the 6years.Be sure to format your columns as Currency with 2 dps(i.e $1,422,828.00
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.94%
C-BS Suppliers has several UA Alumni and the CEO is a big Bama fan.They will contribute 2.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'IF' 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