Data ​1-2-3 is a​ top-selling electronic spreadsheet product. is about to release version 5.0. It divides its customers into two​ groups: new customers and upgrades customers​ (those who previously purchased  Data ​1-2-3, 4.0, or earlier​ versions). Although the same physical product is provided to each customer​ group, sizable differences exist in selling prices and variable marketing​ costs:                                      New Customers                      Upgrade Customers Selling price                               $225                                               $125 Variable costs Manufacturing     $30                                          $30 Marketing              65                   95                     15                          45 Contribution margin                 $130                                                $80     The fixed costs of Data ​1-2-3 5.0 are $16,500,000. The planned sales mix in units is 60​% new customers and 40​% upgrade customers.   What is the Data ​1-2-3 5.0 breakeven point in​ units, assuming that the planned 60​% ​/ 40​% sales mix is​ attained? If the sales mix is​ attained, what is the operating income when 240,000 total units are​ sold? Show how the breakeven point in units changes with the following customer​ mixes: a. New 40​% and upgrade 60​% b. New 90​% and upgrade 10​%    c. Comment on the results.     Requirement 1. What is the Data ​1-2-3 5.0 breakeven point in​ units, assuming that the planned 60​% ​/ 40​% sales mix is​ attained? Begin by determining the sales mix. For every​ bundle, ▼ units are sold to new​ customers, and ▼  units are sold to customers who bought upgrades.

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

 Data ​1-2-3 is a​ top-selling electronic spreadsheet product. is about to release version 5.0. It divides its customers into two​ groups: new customers and upgrades customers​ (those who previously purchased  Data ​1-2-3, 4.0, or earlier​ versions). Although the same physical product is provided to each customer​ group, sizable differences exist in selling prices and variable marketing​ costs:

 

 

 

                               New Customers                      Upgrade Customers

Selling price                               $225                                               $125

Variable costs

Manufacturing     $30                                          $30

Marketing              65                   95                     15                          45

Contribution margin                 $130                                                $80

 

 

The fixed costs of Data ​1-2-3 5.0 are $16,500,000. The planned sales mix in units is 60​% new customers and 40​% upgrade customers.

 

  1. What is the Data ​1-2-3 5.0 breakeven point in​ units, assuming that the planned 60​% ​/ 40​% sales mix is​ attained?
  2. If the sales mix is​ attained, what is the operating income when 240,000 total units are​ sold?
  3. Show how the breakeven point in units changes with the following customer​ mixes:

a. New 40​% and upgrade 60​%

b. New 90​% and upgrade 10​%   

c. Comment on the results.

 

 

Requirement 1. What is the Data ​1-2-3 5.0 breakeven point in​ units, assuming that the planned 60​% ​/ 40​% sales mix is​ attained?

Begin by determining the sales mix. For every​ bundle, ▼ units are sold to new​ customers, and ▼  units are sold to customers who bought upgrades.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Cost control
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