See attachment for the spreadsheet.
Draw two break-even graphs-one for a conservative firm using labor-intensive production and another for a
capital-intensive firm. Assuming these companies compete within the same industry and have identical sales,
explain the impact of changes in sales volume on both firms' profits.
Although no example is provided in the textbook problem, we suggest you use these assumptions to
create an Excel line chart (break-even chart).
Selling price $12.00 $12.00
Variable cost per unit $8.00 $5.00
Fixed costs $250,000 $300,000
The solution explains the breakeven for labor intensive and capital intensive firms.