Please answer in Excel

Problem 54A Determine break-even point under varying assumptions (L.O. 4)

a. Determine the break-even point in sales dollars and units for Cowboys Company that has fixed costs of $63,000, variable cost of $24.50 per unit, and a selling price of $35.00 per unit.

b. Wildcats Company breaks even when sales are $280,000. In March, sales were $670,000, and variable costs were $536,000. Compute the amount of fixed costs.

c. Hoosiers Company had sales in June of $84,000; variable costs of $46,200; and fixed costs of $50,400. At what level of sales, in dollars, would the company break even?

d. What would the break-even point in sales dollars have been in (c) if variable costs had been 10% higher?

e. What would the break-even point in sales dollars have been in (c) if fixed costs had been 10% higher?

f. Compute the break-even point in sales dollars for Hoosiers Company in (c) under the assumptions of (d) and (e) together.