Question

Managerial Accounting Exercise 2. Almana Hospital uses patient-visits as its measure of activity. The hospital has...

Managerial Accounting

Exercise 2. Almana Hospital uses patient-visits as its measure of activity. The hospital has provided the following report:

Almana Hospital
Comparison of Actual Results to Planning Budget
For the Month Ended May 31

Actual Results

Planning Budget

Flexible Budget

Variances

Patient-visits

2,000

2,300

Revenue ($36.40q)

$76,110

  $83,720

Expenses:

    Personnel expenses ($20,400 + $10.40q)

43,240

44,320

    Medical supplies ($1,100 + $6.60q)

13,990

16,280

    Occupancy expenses ($6,400 + $1.50q)

9,800

9,850

    Administrative expenses ($2,400 + $0.40q)

    3,080

    3,320

Total expense

   70,110

   73,770

Net operating income

   $6,000

  $9,950

Required:

  1. Prepare a flexible budget.
  2. Prepare a report showing the hospital's revenue and spending variances for May.
  3. Label each variance as favorable (F) or unfavorable (U). Fill in the last column of the table above.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Coody Clinic uses patient-visits as its measure of activity. The clinic has provided the following report:...
Coody Clinic uses patient-visits as its measure of activity. The clinic has provided the following report: Coody Clinic Comparison of Actual Results to Flexible Budget For the Month Ended July 31 Static Budget Flexible Budget Actual Results Variances Patient-visits 2,300 2,000 Revenue ($36.40q) $83,720 $76,110 Expenses: Personnel expenses ($20,400 + $10.40q) 44,320 43,240 Administrative expenses ($2,400 + $0.40q) 3,320 3,080 Total expense 47,640 46,320 Net operating income $36,080 $29,790 Required: Complete the report showing the clinic's revenue and spending variances...
A clinic uses patient-visits as its measure of activity. During July, the clinic budgeted for 2,700...
A clinic uses patient-visits as its measure of activity. During July, the clinic budgeted for 2,700 patient-visits, but its actual level of activity was 3,200 patient-visits. The clinic uses the following revenue and cost formulas in its budgeting, where q is the number of patient-visits: Revenue: $49.60q Personnel expenses: $31,200 + $15.10q Medical supplies: $700 + $9.60q Occupancy expenses: $10,000 + $2.00q Administrative expenses: $7,000 + $0.20q The clinic reported the following actual results for July: Revenue $165,680 Personnel expenses...
Boston Clinic uses patient-visits as its measure of activity. The clinic has provided the following report:...
Boston Clinic uses patient-visits as its measure of activity. The clinic has provided the following report: Boston Clinic Comparison of planning budget to actual results For the month ended December 31 Planing Budget Actual Reults Variances Patiens Visits 2,000 2,400 Revenue ($58.10/ patient) $116,200 $142,080 $25,880 F Expenses:    Personnel expenses ($30,000 + $17.40/patient) 65,200 74,250 9,050 U    Medical supplies ($1,300 + $9.6/patient) 20,500 24,670 4,170 U    Occupancy expenses ($9,000 + $1.9/patient) 12,800 14,020 1,220 U    Administrative...
aizure Clinic uses patient-visits as its measure of activity. The clinic bases its budgets on the...
aizure Clinic uses patient-visits as its measure of activity. The clinic bases its budgets on the following information: Revenue should be $64.90 per patient-visit. Personnel expenses should be $36,600 per month plus $16.70 per patient-visit. Medical supplies should be $2,900 per month plus $12.10 per patient-visit. Occupancy expenses should be $9,300 per month plus $6.50 per patient-visit. Administrative expenses should be $4,800 per month plus $4.60 per patient-visit. The clinic reported the following actual results for November: Patient-visits 2,890 Revenue...
Privett Hospital bases its budgets on patient-visits. The hospital's static planning budget for November appears below:...
Privett Hospital bases its budgets on patient-visits. The hospital's static planning budget for November appears below: Budgeted number of patient-visits 3,600 Supplies (@ $3.50 per patient-visit) $ 12,600 Laundry (@ $5.10 per patient-visit) 18,360 Salaries 18,960 Occupancy costs 21,360 Total $ 71,280 Actual results for the month were: Actual number of patient-visits 3,860 Supplies $ 12,300 Laundry $ 19,407 Salaries $ 19,635 Occupancy costs $ 22,545 The spending variance for laundry costs in the flexible budget performance report for the...
Laizure Clinic uses patient-visits as its measure of activity. The clinic bases its budgets on the...
Laizure Clinic uses patient-visits as its measure of activity. The clinic bases its budgets on the following information: Revenue should be $73.90 per patient-visit. Personnel expenses should be $37,500 per month plus $17.60 per patient-visit. Medical supplies should be $3,800 per month plus $13.00 per patient-visit. Occupancy expenses should be $10,200 per month plus $11.00 per patient-visit. Administrative expenses should be $5,700 per month plus $9.10 per patient-visit. The clinic reported the following actual results for November: Patient-visits 2,980 Revenue...
Laizure Clinic uses patient-visits as its measure of activity. The clinic bases its budgets on the...
Laizure Clinic uses patient-visits as its measure of activity. The clinic bases its budgets on the following information: Revenue should be $56.90 per patient-visit. Personnel expenses should be $35,800 per month plus $15.90 per patient-visit. Medical supplies should be $2,100 per month plus $11.30 per patient-visit. Occupancy expenses should be $8,500 per month plus $2.50 per patient-visit. Administrative expenses should be $4,000 per month plus $0.60 per patient-visit. The clinic reported the following actual results for November: Patient-visits 2,810 Revenue...
Laizure Clinic uses patient-visits as its measure of activity. The clinic bases its budgets on the...
Laizure Clinic uses patient-visits as its measure of activity. The clinic bases its budgets on the following information: Revenue should be $68.90 per patient-visit. Personnel expenses should be $37,000 per month plus $17.10 per patient-visit. Medical supplies should be $3,300 per month plus $12.50 per patient-visit. Occupancy expenses should be $9,700 per month plus $8.50 per patient-visit. Administrative expenses should be $5,200 per month plus $6.60 per patient-visit. The clinic reported the following actual results for November: Patient-visits 2,930 Revenue...
Ibsen Clinic uses client-visits as its measure of activity. During December, the clinic budgeted for 3,300...
Ibsen Clinic uses client-visits as its measure of activity. During December, the clinic budgeted for 3,300 client-visits, but its actual level of activity was 3,340 client-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for December: Data used in budgeting: Fixed Element per Month Variable element per client-visit Revenue $ 0 $40.00 Personnel expenses $32,400 $13.40 Medical supplies 1,500 4.80 Occupancy expenses 9,100 2.10 Administrative expenses 6,700 0.40 Total expenses...
Laizure Clinic uses patient-visits as its measure of activity. The clinic bases its budgets on the...
Laizure Clinic uses patient-visits as its measure of activity. The clinic bases its budgets on the following information: Revenue should be $71.90 per patient-visit. Personnel expenses should be $37,300 per month plus $17.40 per patient-visit. Medical supplies should be $3,600 per month plus $12.80 per patient-visit. Occupancy expenses should be $10,000 per month plus $10.00 per patient-visit. Administrative expenses should be $5,500 per month plus $8.10 per patient-visit. The clinic reported the following actual results for November: Patient-visits 2,960 Revenue...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT