Home / Questions / The following are budgeted and actual revenues and expenses for a hospital USE ATTACHED TE...
The following are budgeted and actual revenues and expenses for a hospital. USE ATTACHED TEMPLATE PLEASE!!!!!
Budgeted Actual
Revenues
Surgical Volume 2,300 2,600
Gift Shop Revenues $18,000 $19,000
Surgery Revenues $589,500 $852,750
Parking Revenues $17,000 $19,000
Expenses
Patients Days 26,000 25,000
Pharmacy $119,000 $158,000
Misc Supplies $68,000 $795,600
Fixed Overhead Costs $832,000 $890,000
Determine the total variance between the planned and actual budgets for Surgical Volume. Is the variance favorable or unfavorable?
Determine the total variance between the planned and actual budgets for Patient Days. Is the variance favorable or unfavorable?
Determine the service-related variance for Surgical Volume.
Determine the service-related variance for Patient Days.
Prepare a flexible budget estimate. Present a side-by-side budget, flexible budget estimate, and the actual Surgical Revenues.
Prepare a flexible budget estimate. Present a side-by-side budget, flexible budget estimate, and the actual Patient Expenses.
Determine what variances are due to change in volume and what variances are due to change in rates.
| Revenues | |||||||||||
| Givens: | Budgeted | Actual | |||||||||
| A | Surgical volume | ||||||||||
| B | Gift shop revenues | ||||||||||
| C | Surgery revenues | ||||||||||
| D | Parking revenues | ||||||||||
| Variance | Fav or Unfav | ||||||||||
| 1. Total variance between the planned and actual budgets. | |||||||||||
| E | Surgical volume | [A] | |||||||||
| F | Gift shop revenues | [B] | |||||||||
| G | Surgery revenues | [C] | |||||||||
| H | Parking revenues | [D] | |||||||||
| I | Total variance | [B+C+D] | |||||||||
| 3. Service-related revenues and variance still unexplained. | |||||||||||
| J | Total variance | [I] | |||||||||
| K | Gift shop revenue variance | [F] | |||||||||
| L | Parking revenue variance | [H] | |||||||||
| M | Unexplained service-related variance | [J-K-L] | |||||||||
| 5. Prepare a flexible budget estimate. | Budgeted | Flexible | Actual | ||||||||
| N | Surgical volume | [A] | |||||||||
| O | Surgical revenue per unit | [C / A] | |||||||||
| P | Surgical revenue | [C] | |||||||||
| 7. Variances are due to volume and due to rate. | Variance | ||||||||||
| Q | Budgeted surgical revenue | [P] | |||||||||
| R | Flexible surgical revenue | [P] | |||||||||
| S | Actual surgical revenue | [P] | |||||||||
| T | Volume variance | [R - Q] | |||||||||
| U | Rate variance | [S - R] | |||||||||
| Expenses | ||||||||||
| Givens: | Budgeted | Actual | ||||||||
| A | Patient days | |||||||||
| B | Pharmacy | |||||||||
| C | Miscellaneous supplies | |||||||||
| D | Fixed overhead costs | |||||||||
| Variance | Fav or Unfav | |||||||||
| 2. Total variance between the planned and actual budgets. | ||||||||||
| E | Patient days | [A] | ||||||||
| F | Pharmacy | [B] | ||||||||
| G | Miscellaneous supplies | [C] | ||||||||
| H | Fixed overhead costs | [D] | ||||||||
| I | Total variance | [B+C+D] | ||||||||
| 4. Service related costs and variance still unexplained. | ||||||||||
| J | Total variance | [I] | ||||||||
| K | Amt. explained by fixed overhead | [H] | ||||||||
| L | Other fixed expenses | |||||||||
| M | Service-related variance | [J-K-L] | ||||||||
| 6. Prepare a flexible budget estimate. | Budgeted | Flexible | Actual | |||||||
| N | Patient days | [A] | ||||||||
| O | Cost per patient day (Pharm + Misc) | [B+C]/[A] | ||||||||
| P | Total cost (Pharm+Misc) | [N x O] | ||||||||
Apr 03 2020 View more View Less
According to the reasoning of the court in the Bauer case, when do different employment standards for men and women satisfy Title VII's requirement of equality?
Jul 07 2021Ed's building company has the following production function q= 20L - L2 where q is the number of houses built and L is the quantity of labor Ed employs. a. Derive the MP ...
Apr 04 2020Write a C# program to help a local restaurant automate its breakfast billing system. The program should do the following: • Show the customer the different breakfast i...
Apr 17 2020Selected financial data of Future Technologies, Inc., at December 31, Year 1, are shown below: The following additional information is available for the year ended Dece...
Apr 15 2020Economists generally believe that full employment includes 4 to 6 percent unemployment. Would 0 percent unemployment be a better goal and a better definition of full employment?
Aug 23 2021The Mountain Springs Water Company has two departments.Purifying and Bottling. The Bottling Department received 62,000liters from the Purifying Department. During the per...
May 25 2021Write sentences using the conjunctions as described. Be sure to punctuate each sentence correctly.Write a complete sentence using the coordinating conjunction yet between...
Jul 09 2021Which of the following was probably the least important factor in bringing about the Cambrian explosion? a) The emergence of predator-prey relationships b) An increase ...
Jul 16 2021Perimeter Let Pxy) be a point on the parabola in the first quadrant. Consider the triangle PAO formed by P, A (0,1), and the origin 0(0,0), and the triangle PBO formed b...
Jul 28 20211. Why is the tool insulated in the ECM schematic?2. What is the nature of the surface obtained by electro discharge machining (EDM)?3. What is the principal advantage of...
May 23 2020