Please calculate the following and explain the answers with favorable or Unfavorable.

1) Complete the Flexible budget column. Please explain how the answers were obtained?

2) Calculate the following for part 2.

Profit Variance?

Total Revenue Variance?

Revenue Volume Variance?

Revenue Price Variance?

Total cost Variance?

Green Valley Hospital Flexible Budget Static budge Actual Results Number of visits 36,000 $2,880,000 38,000 $2,964,000 Patient Revenue Variable Costs: Supplies Salary Expense Marketing Exp. Other Expenses Total Variable Costs 432,000 604,800 540,000 201,600 1,778,400 447,640 655,500 566,200 218500 1,887,840 1,101,600 1,076,160 Contribution Margin Fixed Costs: Rent Other Total Fixed Costs Net Income 403,200 180,000 583,200 $518,400 420,000 170000 590,000 $486,160