In excel form

Please answer all thank you

Crossfire Company segments its business into two regions-East and West. The company prepared a contribution format segmented income statement as shown below: Sales Variable expenses Contribution margin Traceable fixed expenses Segment margin Common fixed expenses Net operating income Total Company $ 900,000 675,000 225,000 141,000 84,000 59,000 $ 25,000 East $ 600,000 480,000 120,000 50,000 $ 70,000 West $ 300,000 195,000 105,000 91,000 $ 14,000 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 you computed in requirements 2 and 3. What is Crossfire's net 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 West regions when computing the break- even points for each region? Complete this question by entering your answers in the tabs below. Reg 1 to 3 Reg 4 Req5 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. (Round intermediate calculations to 2 decimal places) Show less Break-Even point 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 you computed in requirements 2 and 3. What is Crossfire's net 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 West regions when computing the break- even points for each region? Complete this question by entering your answers in the tabs below. Reg 1 to 3 Reg 4 Reg 5 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. (Round Intermediate calculations to 2 decimal places) Show less Break-Even point Dollar sales Dollar sales for the East region Dollar sales for the West region Reg 4 > Complete this question by entering your answers in the tabs below. Req 1 to 3 Reg 4 Reg 5 Prepare a new segmented income statement based on the break-even dollar sales that you computed in requirements 2 and 3. What is Crossfire's net operating income (loss) in your new segmented income statement? Total Company East West Sales Variable expenses Contribution margin Traceable foxed expenses Product line segment margin Common fixed expenses not traceable to products Net operating loss Complete this question by entering your answers in the tabs below. Req 1 to 3 Reg 4 Reg 5 Do you think that Crossfire should allocate its common fixed expenses to the East and West regions when computing the break-even points for each region? Yes No