Homework question.Please help.Thank you

ProblemRequirements 2

Chartz 1-2-3 is a top-selling electronic spreadsheet product. Chartz is about to release version 50. It divides its customers into two groups new customers and upgrade customers (those who previously purchased Chartz 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 Chartz 1-2-35.0 are 516,500,000. The planned sales mix in units in 60% new customers and 40% upgrade customers Read the requirements Requirement 1. What is the Chartz 1-2-3 5.0 breakoven point in units, astuming 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 Determine the formula used to calculate the breakeven point when there is more than one product sold, then enter the amounts in the formula to calculate the breakeven point in bundles Fed costs Contribution margin per bundle Elreakeven point in bundles $ 16 500 000 550 30 000 The breakeven points 30 000 units for new customers and 60.000 unts for upgrade customers Data table - X New Customers Upgrade Customers $ 195 $ 115 Selling price Variable costs Manufacturing 5 GA $ 15 15 $ 65 Marketing 50 20 35 ev $ $ 130 $ $ 80 Contribution margin th $ Print Done unit Requirements - X 1. 2. 3. What is the Chartz 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 170,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 80% and upgrade 20% C. Comment on the results. ul Print Done 0 Requirement 2. If the sales mix is attained, what is the operating income when 170,000 units are sold? New customers Upgrade customers Total Units sold 132000 88000 220000 Total revenue Total variable costs 130 80 Contribution margin Fixed costs Operating income