6-10 in google sheet or excel doc please Required:1.Compute the companywide break-even point in dollar sales.2.Compute the break-even point in dollar sales for the East region.3.Compute the break-even point in dollar sales for the West region.4.Prepare a new segmented income statement based on the break-even dollar sales that youcomputed in requirements 2 and 3. Use the same format as shown above. What is Crossfire'snet operating income (loss) in your new segmented income statement?5.Do you think that Crossfire should allocate its common fixed expenses to the East and Westregions when computing the break-even points for each region? Why?

thig and absorption costing net operating InCollie in Year 1. Also, explain why the two net operating incomes differ in Year 2. EXERCISE 6-10 Companywide and Segment Break-Even Analysis LO6-5 Crossfire Company segments its business into two regions-East and West. The company prepared a contribution format segmented income statement as shown below: Total Company East West Sales . .... $900,000 $600,000 $300,000 Variable expenses. . 675,000 480,000 195,000 Contribution margin . ... 225,000 120,000 105,000 Traceable fixed expenses . .. .. 141,000 50,000 91,000 Segment margin ..... 84,000 $ 70,000 $ 14,000 Common fixed expenses . . .... 59,000 Net operating income. $ 25,000