Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

FY11 YTD Expense Variances I II III IV Outpatient Product Line FY11 YTD Budget Actual OP Expenses (FY11 YTD) Expense Variance (I-II) Favorable / Unfavorable

FY11 YTD Expense Variances
I II III IV
Outpatient Product Line FY11 YTD Budget Actual OP Expenses (FY11 YTD) Expense Variance (I-II) Favorable / Unfavorable
CARDIOLOGY $ 1,965,852 $ 1,144,085
ENDOCRINOLOYGY $ 1,324,119 $ 650,444
FAMILY MED $ 6,737,188 $ 3,690,656
GYN $ 1,268,947 $ 672,136
ENT $ 4,202,356 $ 2,443,635
MENTAL HEALTH $ 714,283 $ 389,128
NEWBORN $ 4,256,926 $ 2,514,664
OB $ 8,717,115 $ 5,040,943
ORTHO $ 3,664,557 $ 1,591,266
PEDIATRICS $ 754,842 $ 418,066
PODIATRY $ 12,497,823 $ 4,646,031
Total Outpatient Expenses $ 48,069,860 $ 23,201,056

What would be the expense variance? and would it be favorable or unfavorable?

Unit Forecast (FY11) Unit Expence (Budget FY11) FY11 Budget (FY10+6% Inflation) Acutal Mid Year Units (FY11) Actual OP Expenses (FY11 YTD)
677 $5,807.54 $ 3,931,704 197 $ 1,144,085
228 $5,807.54 $ 1,324,119 112 $ 650,444
1,161 $5,802.92 $ 6,737,188 636 $ 3,690,656
219 $5,794.28 $ 1,268,947 116 $ 672,136
724 $5,804.36 $ 4,202,356 421 $ 2,443,635
1,351 $528.71 $ 714,283 736 $ 389,128
733 $5,807.54 $ 4,256,926 433 $ 2,514,664
1,501 $5,807.54 $ 8,717,115 868 $ 5,040,943
631 $5,807.54 $ 3,664,557 274 $ 1,591,266
130 $5,806.48 $ 754,842 72 $ 418,066
2,152 $5,807.54 $ 12,497,823 800 $ 4,646,031
9,507 $58,582 $48,069,860 4,665 $23,201,056

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Activity Accounting An Activity-Based Costing Approach

Authors: James A. Brimson

1st Edition

0471196282, 978-0471196280

More Books

Students also viewed these Accounting questions

Question

What are the diff erences between groups and teams?

Answered: 1 week ago

Question

If you were Dans friend, what might you say to alter his behaviors?

Answered: 1 week ago