Purchase Solution

Variance analysis in the service industry

Not what you're looking for?

Ask Custom Question

17. Detailed variance analysis. The following are planned and actual revenues for Cutting Edge Surgery Center. Because they are one of four surgery centers in the community, the administrator is concerned with his rates in relation to those of his competitors.
Planned Actual
Surgical volume 1,500 1,700
Gift shop revenues $15,000 $17,000
Surgery revenues $500,500 $750,500
Parking revenues $15,000 $17,000

a. Determine the total variance between the planned and actual budgets.
b. Determine the service-related revenues and calculate service-related variance still unexplained.
c. Prepare a flexible budget estimate. Present side by side the budget, flexible budget estimate, and actual surgical revenue (and related volumes).
d. Determine what variance is due to change in volume and what variance is due to change in rates.
e. Determine the volume variance and rate variance based on per unit rates.

Attachments
Purchase this Solution

Solution Summary

A variance analysis in a service industry is discussed. The expert determines the volume variances and rate variances based on per unit rates.

Solution Preview

Dear student,

The solution is attached and all work is shown.

Thank you for asking BrainMass!

17. Detailed variance analysis. The following are planned and actual revenues for Cutting Edge Surgery Center. Because they are one of four surgery centers in the community, the administrator is concerned with his rates in relation to those of his competitors.
Planned Actual
Surgical volume 1,500 1,700
Gift shop revenues $15,000 $17,000
Surgery revenues $500,500 $750,500
Parking revenues $15,000 $17,000

a. Determine the total variance between the planned and actual budgets.
Total
Planned Actual Variance
Surgical volume 1500 1700
Gift shop revenues $15,000 $17,000 $2,000
Surgery ...

Solution provided by:
Education
  • MPhil, Madurai Kamaraj University
  • MCom, Annamalai University
  • IATA, International Air Transport Association
Recent Feedback
  • "Great explanations on how the answers were obtained."
  • "Love the way she explains everything step by step."
  • "Solutions were thoroughly explained."
  • "Excellent explanations of how problems are solved"
  • "Thanks"
Purchase this Solution


Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce