Question: The Pottery Barn sells three products: The Basic, The Luxe, and The Ultimate. Budgeted sales and totals for the coming month are as follows: The

The Pottery Barn sells three products: The Basic, The Luxe, and The Ultimate. Budgeted sales and totals for the coming month are as follows:

 

The Basic

The Luxe

The Ultimate

Total

% total sales

48%


20%


32%


100%


Sales

$240,000

100%

$100,000

100%

$160,000

100%

$500,000

100%

Variable exp.

72,000

30%

80,000

80%

88,000

55%

240,000

48%

Contribution margin

$168,000

70%

$20,000

20%

$72,000

45%

$260,000

52%

Fixed expense
 

 

 
 


223,600


Operating income
 
 
 
 


$36,400



 
 
 
 


 


Budgeted break-even sales = $430,000

As shown from the data, the data anticipates earning an operating income of $36,400 and have calculated their break-even sales at $430,000.

Assume that actual sales for the month total $500,000 as planned. The actual sales generated by product are:

 
Sales
The Basic

$160,000

The Luxe

200,000

The Ultimate

140,000

Total

$500,000

  • Required:
  • Prepare a contribution income statement for the month based on actual sales data. Assume that variable expenses are a percentage of sales and total fixed expenses remain the same as the budgeted amounts. Include the percentage amounts for each category in your statement.
  • Calculate the break-even sales for the month based on actual data.
  • Explain why the company did not meet the budgeted results or break-even in sales even though it met its $500,000 sales budget.

Step by Step Solution

3.45 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Requirement 1 Contribution Income Statement The Basic The Luxe The Ultimate Total Percentage of Tota... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!