Please prepare the homework problems in the form of a Word and/or Exce

QUESTION

Please prepare the homework problems in the form of a Word and/or Excel file. Try to use only one file to submit your answers, if possible, and include the questions with your answers. You must show your calculations. A dermatology clinic expects to contract with an HMO for an estimated 80,000 enrol
Budgeted Actual Variance Rating Enrollees 80000 84000 4000 Favorable Dermatology services 20000 28000 8000 Favorable Monthly revenues $260,000 $450,000 $190,000 Favorable Monthly expenses $200,000 $270,000 $70,000 Favorable Working: Estimated enrollees 80000 Estimated dermatology services (80000*1/4) 20000 Monthly revenue estimated $260,000 Monthly expenses budgeted $200,000 Actual enrollees (80000*104%) 84000 Actual dermatology services (84000/3) 28000 Actual monthly revenue $450,000 Actual monthly expenses $270,000 Reasons: Enrollees are increased to 84000, there a chance to increase firm profitabiliy with this enrollees, so it is Favorable.Dermatology services increased to 28000, with increasing services levels we can get more profits than previous so it is also Favorable to firm. Monthly revenues increased to $450000: Monthly revenues: Budgeted revenues = $260,000 Budgeted revenue per service =

260000/20000 Budgeted revenue per service = $13 Actual revenue = $450,000 Actual revenue per service = 450000/28000 = $16 As per budget monthly revenue per service is only $13, but actually service revenue per service is $16 so it is Favorable. Monthly expenses increased to $270000: Monthly expenses: Budgeted expenses = $200,000 Budgeted expense per service = 200000/20000 = $10 Actual expenses = $270,000 Actual expense per service = 270000/28000 = $9.64 Monthly expenses increased to $270000, but per service cost is decreased from $10 to $9.64 so it is also favorable condition to the firm.Thank you

ANSWER:

CLICK REQUEST FOR  AN EXPERT SOLUTION