Question

planning budget actual results variance patient visits 2600 2700 revenue 52.90 q 137540 145190 7650 F...

planning budget actual results variance
patient visits 2600 2700
revenue 52.90 q 137540 145190 7650 F
expense
personnel expense (35,100+17.40q) 80340 79710 730 F
medical supplies (1,000+ 6.40q) 17740 18660 920 U
occupancy expenses (9,700+2.30q) 15780 16680 1000 U
administrative expenses (5,200 + .30q) 5980 5880 100 F
total expense 119840 120830 1090 U
net operating income 17800 24360 6560 F

Complete a flexible budget performance report for Janice Inc. Label each variance as favorable (F) or unfavorable (U). What should be brought to management’s attention regarding the flexible budget performance report?

Homework Answers

Answer #1
Particulars Cost formula Actual Spending variance Flexible budget Activity variance Planning budget
Patients 2700 2700 2600
Revenue 21.60q 145190 2360 F 142830 5290 F 137540
Expenses
Personal expenses 22600+6.60q 79710 2370 F 82080 1740 U 80340
Medical supplies 1000+2.60q 18660 380 U 18280 540 U 17740
Occupancy expense 6000+.90q 16680 770 U 15910 130 U 15780
Administrative expense 4300+.30q 5880 130 F 6010 30 U 5980
Total expense 120930 1350 F 122280 2440 U 119840
Net income 24260 3710 20550 2850 17700
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
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...
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...
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...
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...
Burget Clinic uses client-visits as its measure of activity. During July, the clinic budgeted for 2,100...
Burget Clinic uses client-visits as its measure of activity. During July, the clinic budgeted for 2,100 client-visits, but its actual level of activity was 2,110 client-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for July: Use the following data for questions 27-30 Data used in budgeting: Fixed element Variable element per month per client-visit Revenue - $47.10 Personnel expenses $22,700 $16.90 Medical supplies 1,600 6.50 Occupancy expenses 6,900 1.50...
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...
You are given the following static budget report: Budget            Actual              Variance Unit Sales  &nbsp
You are given the following static budget report: Budget            Actual              Variance Unit Sales                                           10,000               15,000             5,000 F Variable Expenses:     Commissions                                  $30,000 $33,000 $3,000 U     Advertising                                      $1,000 $1,200 $200 U     Travel                                              $10,000 $11,000 $1,000 U     Samples                                          $2,500 $2,300 $200 F Total Variable                                     $43,500 47,500 $4,000 U Fixed Expenses     Rent                                                 $5,000 $5,000 0     Salaries – Sales                               $2,000 $2,000 0     Salaries – Office                              $1,200 $1,200 0     Depreciation                                    $1,500 $1,500 0 Total Fixed                                          $9,700 $9,700             0 Total Expenses $53,200 $57,200 $4,000 U Prepare a flexible budget analysis and explain whether you believe that costs were controlled.  How do the results of...
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...
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...
Bartosiewicz Clinic uses client-visits as its measure of activity. During January, the clinic budgeted for 5,100...
Bartosiewicz Clinic uses client-visits as its measure of activity. During January, the clinic budgeted for 5,100 client-visits, but its actual level of activity was 5,120 client-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for January: Data used in budgeting: Fixed element per month Variable element per client-visit Revenue $ 0 $ 37.10 Personnel expenses $ 29,100 $ 13.10 Medical supplies 2,000 7.10 Occupancy expenses 11,000 1.00 Administrative expenses 6,600...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT