(Click the icon to vira the pricen and cast informshon) Hiegried Descrmane the formila ursed to calcidato the breakeven point when thete n more than com prodxit soid then, noter f Data table of Data 1-2-3 version 5.0 are $10,500,000. The planned sales mix in units is 60% new customers and 40% upgrade customers. Requirements 1. What is the Data 123 version 5.0 breakeven point in units, assuming that the planned 60/40 sales mix is attaned? 2. If the sales mix is attained, what is the operating income when 210,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 90% and upgrade 10% c. Comment on the results Requirement 3. Show how the breakevon point in unts changas whth the tollowing customer moos a. New 50% and Upgrade 50% and b. New fo\%s and Upgrade 10% a. Begin by intentining the sales mix for scenano "a- Calculate the breakeven point in bundles for 5 cenarie "a"; then, dotermene the treakeven paint for new custoiners and upgiade cistornors The breakeven point is tor new cirstomers and b. Now, determune the sales max for scenano "o" For every bundle. unt(s) reiare sold to new customers and unitis) rase sold to customers who bought uparades Calculate the breakeven peint in bundies for scenarso "b", then, determine the breakeven point for new cirtomers and upgrase cinsomers The breakeven point is bundies. Ths transtates to a broakeven point of units toe new customers and units for upgrade customnts. c. Commen on the resuls As Bata increases ts percentage of new cirstomers. which hawe a contribution maigin per unit than upgrade custorners, the number of bundtes reguired to break aven Time Remaining: 0049-50' (Gak the koen lo vicw the price and cost intormation) The foed costs of Dala 12.3 werson 5.0 are $10,500000. The plsnned sales mix in unts is 6os, new customers and tos upgrade customers. Fienned The brambeyen pout in. urits for naw roustomers and Levis tor uperase cistumerie iew the price and cost information.) 1-2-3 version 5.0 are $10,500,000. The planned sales mix in units is 60% new customers and 40% upgrade customers. Data table shim hed? customers who sales mix is a in the formula