Could you please help with the attached following documents. I need to have this done by this afternoon or tomorrow morning.

Karla Bemiss

Revenues [A] [B] [C] [D] Givens: Surgical volume Gift shop revenues Surgery revenues Parking revenues Budgeted 2,500 $18,500 $592,600 $18,500 Actual 2,800 $21,200 $862,000 $21,600 1. Determine the total variance between the planned and actual budgets for Surgical Volume. Is the variance favorable or unfavorable? Budgeted Actual Variance [E] Surgical volume [A] 2,500 2,800 300 [F] Gift shop revenues [B] $18,500 $21,200 $2,700 [G] Surgery revenues [C] $592,600 $862,000 $506,400 [H] Parking revenues [D] $18,500 $21,600 $3,100 [I] Total variance [E] $632,100 $907,600 $275,500 3. Determine the service related variance for Surgical Volume. Variance [J] [K] [L] [M] Total variance [I] Gift shop revenue variance [F] Parking revenue variance [H] Service-related variance [J-K-L] 275,500 $2,700 3,100 33,300 5. Prepare a flexible budget estimate. Present side-by-side budget, flexible budget estimate, and the actual surgical revenues. Budgeted Flexible Actual [N] Surgical volume [A] 2,500 300 2,800 [O] Surgical revenue per unit [C / A] [P] Surgical revenue [C] 7. Determine what variances are due to change in volume and what variances are due to change in rates. Budgeted [Q] [R] [S] [T] [U] Budgeted surgical revenue [P] Flexible surgical revenue [P] Actual surgical revenue [P] Volume variance [R - Q] Rate variance [S - R] Flexible Actual Expenses [A] [B] [C] [D] me. Is the variance Givens: Patient days Pharmacy Miscellaneous supplies Fixed overhead costs Patient days [A] Pharmacy [B] Miscellaneous supplies [C] Fixed overhead costs [D] Total variance 4. Determine the service related variance for Patient Days. [J] [K] [L] [M] hange in rates. Variance Actual 26,000 $145,000 $795,000 $88,500 2. Determine the total variance between the planned and actual budgets for Patient Days. Is the variance unfavorable? [E] [F] [G] [H] [I] e, and the actual surgical Budgeted 28,000 $120,500 $695,000 $836,000 Total variance [I] Amt. explained by fixed overhead [F] Other fixed expenses Service-related variance [J-K-L] 28,000 $120,500 $695,000 $836,000 $1,679,500 $3,359,000 $28,000 26,000 $145,000 $795,000 $885,000 $1,851,000 $3,702,000 $3,359 $836,000 6. Prepare a flexible budget estimate. Present side-by-side budget, flexible budget estimate, and the actua Budgeted Flexible [N] Patient days [A] [O] Cost per patient day (Pharm + Misc) [B+C]/[A] [P] Total cost (Pharm+Misc) [N x O] nt Days. Is the variance favorable or Variance 2,000 $24,500 $10,000 $49,000 $171,500 Variance $3,702 $885,000 estimate, and the actual patient expenses. Actual Healthcare Financial Management and Economics Week 9 Assignment 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,800 Gift Shop Revenues $18,500 $21,200 Surgery Revenues $592,600 $862,000 Parking Revenues $18,500 $21,600 Patients Days 28,000 26,000 Pharmacy $120,500 $145,000 Misc Supplies $695,000 $795,000 Fixed Overhead Costs $836,000 $885,000 Expenses 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. 2015 Laureate Education, Inc. Page 1 of 1 Revenues [A] [B] [C] [D] Givens: Surgical volume Gift shop revenues Surgery revenues Parking revenues Budgeted 2,500 $18,500 $592,600 $18,500 Actual 2,800 $21,200 $862,000 $21,600 1. Determine the total variance between the planned and actual budgets for Surgical Volume. Is the variance favorable or unfavorable? Budgeted Actual Variance [E] Surgical volume [A] 2,500 2,800 300 [F] Gift shop revenues [B] $18,500 $21,200 $2,700 [G] Surgery revenues [C] $592,600 $862,000 $269,400 [H] Parking revenues [D] $18,500 $21,600 $3,100 [I] Total variance [E] $632,100 $907,600 $275,500 3. Determine the service related variance for Surgical Volume. Budgeted [J] Total variance [I] 632,100 [K] Gift shop revenue variance [F] $18,500 [L] Parking revenue variance [H] 18,500 [M] Service-related variance [J-K-L] 595,100 Actual $907,600 $21,200 $21,600 $864,800 Variance $275,500 $2,700 $3,100 $269,700 5. Prepare a flexible budget estimate. Present side-by-side budget, flexible budget estimate, and the actual surgical revenues. Budgeted Flexible Actual [N] Surgical volume [A] 2,500 300 2,800 [O] Surgical revenue per unit [C / A] $237.04 $70.82 $307.86 [P] Surgical revenue [C] $592,600 $663,712 $862,000 7. Determine what variances are due to change in volume and what variances are due to change in rates. [Q] [R] [S] [T] [U] Budgeted surgical revenue [P] Flexible surgical revenue [P] Actual surgical revenue [P] Volume variance [R - Q] Rate variance [S - R] Budgeted $592,600 Flexible Actual $663,712 $862,000 Expenses [A] [B] [C] [D] me. Is the variance Favourable Favourable Favourable Favourable Favourable Givens: Patient days Pharmacy Miscellaneous supplies Fixed overhead costs Budgeted 28,000 $120,500 $695,000 $836,000 2. Determine the total variance between the planned and actual budgets for Patient Days. Is the varianc unfavorable? [E] [F] [G] [H] [I] Patient days [A] Pharmacy [B] Miscellaneous supplies [C] Fixed overhead costs [D] Total variance Budgeted 28,000 $120,500 $695,000 $836,000 $1,679,500 4. Determine the service related variance for Patient Days. Favourable Favourable Favourable Favourable e, and the actual surgical hange in rates. Variance $71,112 $198,288 [J] [K] [L] [M] Total variance [I] Amt. explained by fixed overhead [F] Other fixed expenses Service-related variance [J-K-L] Budgeted $1,679,500 $836,000 695,000 148,500 6. Prepare a flexible budget estimate. Present side-by-side budget, flexible budget estimate, and the actu Budgeted [N] Patient days [A] 28,000 [O] Cost per patient day (Pharm + Misc) [B+C]/[A] $29.13 [P] Total cost (Pharm+Misc) [N x O] $815,500 es Actual 26,000 $145,000 $795,000 $885,000 dgets for Patient Days. Is the variance favorable or Actual 26,000 $145,000 $795,000 $885,000 $1,851,000 Variance (2,000) $24,500 $100,000 $49,000 $171,500 Favourable Unfavourable Unfavourable Unfavourable Unfavourable Actual $1,851,000 $885,000 $795,000 $171,000 Variance $171,500 $49,000 $100,000 $22,500 Unfavourable Unfavourable Unfavourable Unfavourable exible budget estimate, and the actual patient expenses. Flexible Actual (2,000) 26,000 $7.03 $36.15 $757,250 $940,000