excel format thank you

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 seginented 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. 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) 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. Prepare a new segmented income statement based on the break-even dollar sales that you computed in requireme 3. What is Crossfire's net operating income (loss) in your new segmented income statement? 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. Do you think that Crossfire should allocate its common fixed expenses to the East and West regions when computi break-even points for each region