Assume that the manager of Fort Winston Hospital are setting the price on a new outpatient service. Here are relevant data estimates:

Variable cost per visit   $5.00Annual direct fixed costs   $500,000Annual overhead allocation   $50,000Expected annual utilization  10,000 visitsa. What per visit must be set for the service to break even? To earn an annual profit of $100,000?b. Repeat Part a, but assume that the variable cost per visit is $10.c. Return to the data given in the problem. Again repeat Part a, but assume that direct fixed costs are $1,000,000.d. Repeat Part a assuming both a $10 variable cost and $1,000,000 in direct fixed costs.Must be done on excel.