Record 1-2-3 is a top-selling electronic spreadsheet product. Record is about to release version 5.0. It divides its customers into two groups: new customers and upgrade customers (those who previously purchased Record 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: (Click the icon to view the price and cost information.) The fixed costs of Record 1-2-3 5.0 are $13,500,000. The planned sales mix in units is 60% new customers and 40% upgrade customers. Read the requirements. Requirement 1. What is the Record 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, 3 units are sold to new customers, and 2 units are sold to customer who bought upgrades. Requirements - x Data table 1. What is the Record 1-2-3 5.0 breakeven point in units, assuming that the planned 60% / 40% sales mix is attained? New Customers Upgrade Customers 2. If the sales mix is attained, what is the operating income when 220,000 total units are sold? 3. Show how the breakeven point in units changes with the following customer mixes: a. New 50% and upgrade 50% b. New 80% and upgrade 20% c. Comment on the results. Selling price Variable costs Manufacturing Marketing $ 225 $ 120 $ 20 S 20 60 80 5 25 145 $ 95 Contribution margin Print Done Print Done