6-5 in google sheet or excel doc please

common fixed expenses in the company total $35,000 annually. Last year the company produce and sold 15,000 units of Weedban and 28,000 units of Greengrow. Required: Prepare a contribution format income statement segmented by product lines. EXERCISE 6-5 Companywide and Segment Break-Even Analysis LO6-5 Piedmont Company segments its business into two regions-North and South. The company prepared the contribution format segmented income statement as shown below: Total Company North South Sales . .. $600,000 $400,000 $200,000 Variable expenses. . . 360,000 280,000 80,000 Contribution margin . ........ 240,000 120,000 120,000 Traceable fixed expenses . .... . 120,000 60,000 60,000 Segment margin . ..... 120,000 $ 60,000 $ 60,000 Common fixed expenses . .... 50,000 Net operating income. .. $ 70,000 Required: 1. Compute the companywide break-even point in dollar sales. 2. Compute the break-even point in dollar sales for the North region. 3. Compute the break-even point in dollar sales for the South region. EXERCISE 6-6 Variable and Absorption Costing Unit Product Costs and Income Statements LO6-1, LO6-2