Required information

Tableau Dashboard Activity: Interpret and Communicate 4-1 (Static) [Exercise 4-5; LO4-5]

Skip to question

Piedmont Company segments its business into two regionsNorth and South. The company prepared the contribution format segmented income statement as shown:

	Total Company	North	South
Sales	$ 600,000	$ 400,000	$ 200,000
Variable expenses	360,000	280,000	80,000
Contribution margin	240,000	120,000	120,000
Traceable fixed expenses	120,000	60,000	60,000
Segment margin	120,000	$ 60,000	$ 60,000
Common fixed expenses	50,000
Net operating income	$ 70,000

Tableau Dashboard Activity 4-1 (Static) Part 2

2. The company used the above data to create a CVP graph for the North region and it wants your help interpreting the graph. Review the Tableau visualization that accompanies this requirement and answer the following questions:

a. The North segments traceable fixed expense is:

multiple choice 1

• $120,000

• $50,000

• $80,000

• $60,000

b. The North segments break-even point in dollar sales is:

multiple choice 2

• $200,000

• $36,000

• $180,000

• $170,000

c. The Norths segment margin when its sales are $300,000 is:

multiple choice 3

• $50,000

• $30,000

• $80,000

• $100,000

Hint: The Norths segment margin is determined by quantifying the gap between its total sales and total expense lines at a sales level