Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. the table found in the worksheet q1 data shows the

The table found in the worksheet Q1 DATA shows the income statement of BS Suppliers,...

50.1K

Verified Solution

Question

Accounting

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 )
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
D - What is the total amount that BS Suppliers will contribute to UA in the 6 years of data provided?
Contribution
image

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Over exploitation for food and commercial use are some of the key challenges to conservation in...

Biology
Q

Looking at a football match, which of the following describes an event CONSISTENT with the study...

Physics
Q

Find the volume of each object 1 the rectangular prism part of the milk container...

Geometry
Q

Question 18 5 two and 2 with multiplicity one There is an ellipse with equation...

Geometry
Q

Each individual letter of the word Mississippi is placed on a piece of paper, and...

Basic Math
Q

3 3 Homework K Erik Allen repairs photocopy r O A 7

Statistics
Q

Directions Consider the following function f z at a 2 Part 1 Difference Quotient It...

Calculus
Q

use excel formula please Tanya Cartman invests $24,000 each year in a...

Accounting
Q

The note is due in equal annual payments of principle and interest. Incorrect income statement,...

Accounting
Q

Tennis Apparel has two classes of stock authorized: 6%, $10 par preferred, and $1 par...

Accounting
Q

please breakdown your answer I need detailed explaination A transportation company...

Finance
Q

The risk premium on the market portfolio depends on the average level of risk aversion...

Finance