Create a profit model in Excel for each of the three alternatives put all three models, side by side in one worksheet. Use your models to find the answers to the questions. Bullet Write answers to the questions in a separate worksheet in the Excel file bullet Label the worksheet tabs. A firm is considering three capacity alternatives: A, B, and C. Alternative A would have an animal fixed cost of S 100,000 and variable costs of S22 per unit. Alternative B would have annual fixed costs of $120,000 and variable costs of S20 per unit. Alternative C would have fixed costs of $80,000 and variable costs of $30 per unit. Revenue is expected to be $50 per unit. Which alternative has the lowest break-even quantity? Which alternative will produce the highest profits for an annual output of 10,000 units? Which alternative would require the lowest volume of output to generate an annual profit of S50.000? Create a profit model in Excel for each of the three alternatives put all three models, side by side in one worksheet. Use your models to find the answers to the questions. Bullet Write answers to the questions in a separate worksheet in the Excel file bullet Label the worksheet tabs. A firm is considering three capacity alternatives: A, B, and C. Alternative A would have an animal fixed cost of S 100,000 and variable costs of S22 per unit. Alternative B would have annual fixed costs of $120,000 and variable costs of S20 per unit. Alternative C would have fixed costs of $80,000 and variable costs of $30 per unit. Revenue is expected to be $50 per unit. Which alternative has the lowest break-even quantity? Which alternative will produce the highest profits for an annual output of 10,000 units? Which alternative would require the lowest volume of output to generate an annual profit of S50.000