Givens:   Budgeteda   Actual               A Patient days   27,000   26,000               B Pharmacy   $120,000   $160,000               C Miscellaneous supplies   $66,000   $77,500               D Fixed overhead costs   $808,000   $880,000               1.  Prepare a flexible expense estimate for variable costs.    . Flexible budget estimate.    Budgeted    Flexible   Actual       Patient days   27,000       26,000       Cost per patient day   $6.89       $9.13       Total cost   $186,000       $237,500     2.  Compute the volume variance. 3.  Compute the cost variance.   4.  Compute the per unit cost variance.   5.  Is the unfavorable variance caused by the volume of patients or the cost of services?.  Enter VOLUME or COST as your answer.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter23: Flexible Budgeting (flexbud)
Section: Chapter Questions
Problem 1R
icon
Related questions
icon
Concept explainers
Question

The administrator of Break-a-Leg Hospital is aware of the need to keep his costs down because he just negotiated a new capitated arrangement with a large insurance company.  Below are selected planned and actual expenses for the previous month. 

                         
    Givens:   Budgeteda   Actual            
  A Patient days   27,000   26,000            
  B Pharmacy   $120,000   $160,000            
  C Miscellaneous supplies   $66,000   $77,500            
  D Fixed overhead costs   $808,000   $880,000            

 



1.  Prepare a flexible expense estimate for variable costs. 
 

. Flexible budget estimate.    Budgeted    Flexible   Actual    
  Patient days   27,000       26,000    
  Cost per patient day   $6.89       $9.13    
  Total cost   $186,000       $237,500    



2.  Compute the volume variance.

3.  Compute the cost variance.  

4.  Compute the per unit cost variance.  

5.  Is the unfavorable variance caused by the volume of patients or the cost of services?.  Enter VOLUME or COST as your answer.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 7 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning