Problem regarding the budgeting and variance analysis

Assignment Help Accounting Basics

Reference no: EM13986443

Healthcare Financial Management and Economics-Budgeting and Variance Analysis

Instructions:

The following are budgeted and actual revenues and expenses for a hospital.

Budgeted Actual

Revenues

Surgical Volume 2,500 2,700

Gift Shop Revenues $19,000 $20,000

Surgery Revenues $600,500 $850,750

Parking Revenues $16,000 $18,000

Expenses

Patients Days 27,000 27,000

Pharmacy $120,000 $160,000

Misc Supplies $66,000 $77,500

Fixed Overhead Costs $808,000 $880,000

Using an Excel spreadsheet to show your calculations:

1. Determine the total variance between the planned and actual budgets for Surgical Volume. Is the variance favorable or unfavorable?

2. Determine the total variance between the planned and actual budgets for Patient Days. Is the variance favorable or unfavorable?

3. Determine the service-related variance for Surgical Volume.

4. Determine the service-related variance for Patient Days.

5. Prepare a flexible budget estimate. Present a side-by-side budget, flexible budget estimate, and the actual Surgical Revenues.

6. Prepare a flexible budget estimate. Present a side-by-side budget, flexible budget estimate, and the actual Patient Expenses.

7. Determine what variances are due to change in volume and what variances are due to change in rates.

Reference no: EM13986443

Questions Cloud

How far could she be from the bird : How far could she be from the bird and still be able to hear it? Assume no reflections or absorption of the sparrow's sound.

Determine under what circumstances it would be advantageous : Specifically, consider how either starting a business or going into the real estate business might fit into this strategy and explain the tax benefits of each strategy.

Where is the table center of mass : You have a 10-kg table with each leg of mass 1.0 kg Acˆ'total mass 14 kg. If you place a 5.0-kg pot of soup in the back right corner of the table (Figure 1) , where is the table's center of mass? Assume that the size of the soup bowl and thickness..

How fast is the berry going when it hits the ground : A bird flying straight upward at 7 m/s drops a berry when it is 200 m above the ground. How fast is the berry going when it hits the ground (neglect air resistance).

Problem regarding the budgeting and variance analysis : Healthcare Financial Management and Economics-Budgeting and Variance Analysis

Find the final image distance of the object : You are in biology class and wish to look at a slide of petrified wood. Find the final image distance of the object. Find the height of hte final image.

The government spends tax dollars : What choices does society make when the government spends tax dollars? What exactly is being obtained and at what cost to society? What is forgone when the choices are made?

Using the high low method and the willco data : Using the high-low method and the Willco data, calculate the variable maintenance cost per machine hour (round to three decimalplaces).

Journalize the entry to record the warranty work : a. Journalize the adjusting entry required at January 31, the end of the first month of the current fiscal year, to record the accrued product warranty. b. Journalize the entry to record the warranty work provided in February.

User Account

All Pages