Show Work Via Excel

The ABC Company is considering buying a special equipment. There are four alternatives and the cost data for these appears in the table below. a. Draw a breakeven point chart, b. State the range for annual production volume in which each equipment would be preferred. Cost Fixed costs per year Variable costs per unit Equipment A $30,000 $9 Equipment B $60,000 $6 Equipment C Equipment D 90,000 120,000 $4 $3