The Stackpole Company retails two products, a standard and deluxe version of a luggage carrier.The standard carrier sells for $38, has variable costs of $23, and direct fixed costs of $8000,000. The deluxe model sells for $56, has variable costs of $34, and direct fixed costs of $1,500,000. The company has common fixed costs of $250,000. The anticipated sales mix for the company is 4:1 or 80/20. The actual level of sales units currently is 250,000 (total for both products) and your target income is $1,250,000. You expect sales to rise 10% in the coming year. Directions: You have been hired to build a CVP model to help the company understand the impact of business conditions on operating income. Your model should include breakeven in units with a pro forma income statement, units sales for a target income of $1,250,000 with a pro forma income statement, an income statement reflecting actual current sales, margin of safety in dollars

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

The Stackpole Company retails two products, a standard and deluxe version of a luggage carrier.The standard carrier sells for $38, has variable costs of $23, and direct fixed costs of $8000,000. The deluxe model sells for $56, has variable costs of $34, and direct fixed costs of $1,500,000. The company has common fixed costs of $250,000. The anticipated sales mix for the company is 4:1 or 80/20. The actual level of sales units currently is 250,000 (total for both products) and your target income is $1,250,000. You expect sales to rise 10% in the coming year.

Directions: You have been hired to build a CVP model to help the company understand the impact of business conditions on operating income. Your model should include breakeven in units with a pro forma income statement, units sales for a target income of $1,250,000 with a pro forma income statement, an income statement reflecting actual current sales, margin of safety in dollars and %, and degree of operating leverage. Your model should have the capability of computing B/E, target income, MOS, DOL, and predicting change in income based on a change in sales. Create a dashboard to show the these variables.

Once you have built the model, use the model to determine changes to the dashboard variables. In a report to me, your CEO, show the original variables, the changed variables and explain why the change occurred.

  • Sales mix changes to 30/70
  • Common fixed costs increase by $100,000
  • Increase VC of the standard carrier by $8 per unit
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Special order decisions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education