3. Calculate price, efficiency, intensity, and volume variances for the month of June if the variance is more than $5000 and 5% above or below the budget. Discuss significant changes between June and YTD performance, that is, which line items are moving closer or away from their budget targets?

June 2018 June 2018 $31,256 196,333 2,965 26,897 17,637 25,601 11,528 2,667 2,213 1,016 859 5,269 458 713 102 599 235 510 12,000 3,017 595 296 $342,766 184,167 3,000 34,000 16,613 25,250 10,858 2,389 2,129 1,500 852 4,897 Object YTD Actual YTD Budget $ Variance % Variance Code Description 2018 2018 4.2% 4010 Management & clerical $176,543 $180,000 12,166 6.6% 4020 Staff salaries & wages 1,235,642 1,105,000 -35 -1.2% 4040 Overtime 23,833 18,000 -7,103 -20.9% 4050 Agency & Temporary 156,115 204,000 1,024 6.2% 4110 FICA 109,855 99,680 351 1.4% 4120 Health insurance 149,857 151,500 669 6.2% 4130 Retirement 71,801 65,150 278 11.6% 4140 Unemployment 15,796 14,333 84 3.9% 4210 Floor Medications 13,589 12,775 484 -32.3% 4212 Medical instruments 5,798 9,000 0.9% 4214 Bandages, gauze... 5,643 5,110 372 7.6% 4216 Latex gloves, gowns... 32,145 29,383 7.6% 4218 Sterile wipes 2,659 2,555 -7.0% 4250 Office supplies 4,268 4,599 22.4% 4280 Cleaning supplies 569 500 19.8% 4350 Biomedical repairs/main 3,869 3,000 35 17.5% 4410 Electricity 1,156 1,200 30 6.3% 4440 Telephone 2,645 2,880 0 0.0% 4930 Housekeeping 72,000 72,000 42 1.4% 4940 Travel/prof meetings/me 14,523 17,850 172 -22.4% 4950 CME 3,688 4,600 7.3% 4960 Other expenses 1,258 1,655 $8,637 2.6% $2,103,252 $2,004,769 $ Variance % Variance ($3,457) -1.9% 130,642 11.8% 5,833 32.4% -47,885 -23.5% 10,175 10.2% -1,643 -1.1% 6,651 10.2% 1,463 10.2% 814 6.4% -3,202 -35.6% 533 10.4% 2,762 9.4% 104 4.1% -331 -7.2% 13.8% 869 29.0% -44 -3.7% -235 -8.2% 0.0% 3,327 -18.6% -912 -19.8% -397 -24.0% $98,483 4.9% 426 32 69 767 83 500 200 480 12,000 2,975 767 276 $334,128 0 20 28 June 2018 108 531 920 8174 81 672 June 2018 108 536 920 7790 (5) $ Variance % Variance 0.0% -0.9% 0.0% 384 4.9% -2.4% (178) -20.9% Statistics Admissions (Output) Patient days (Activity) Mgt & clerical hours (Inp Staff hours (Input) Overtime hours (Input) Agency hours (Input) YTD Actual YTD Budget 2018 2018 678 650 3,295 3,213 1040 1040 51378 46743 662 497 3903 5100 $ Variance % Variance 4.3% 82 2.6% 0.0% 4,635 9.9% 165 33.2% (1,197) -23.5% 83 (2) 850 June 2018 June 2018 $31,256 196,333 2,965 26,897 17,637 25,601 11,528 2,667 2,213 1,016 859 5,269 458 713 102 599 235 510 12,000 3,017 595 296 $342,766 184,167 3,000 34,000 16,613 25,250 10,858 2,389 2,129 1,500 852 4,897 Object YTD Actual YTD Budget $ Variance % Variance Code Description 2018 2018 4.2% 4010 Management & clerical $176,543 $180,000 12,166 6.6% 4020 Staff salaries & wages 1,235,642 1,105,000 -35 -1.2% 4040 Overtime 23,833 18,000 -7,103 -20.9% 4050 Agency & Temporary 156,115 204,000 1,024 6.2% 4110 FICA 109,855 99,680 351 1.4% 4120 Health insurance 149,857 151,500 669 6.2% 4130 Retirement 71,801 65,150 278 11.6% 4140 Unemployment 15,796 14,333 84 3.9% 4210 Floor Medications 13,589 12,775 484 -32.3% 4212 Medical instruments 5,798 9,000 0.9% 4214 Bandages, gauze... 5,643 5,110 372 7.6% 4216 Latex gloves, gowns... 32,145 29,383 7.6% 4218 Sterile wipes 2,659 2,555 -7.0% 4250 Office supplies 4,268 4,599 22.4% 4280 Cleaning supplies 569 500 19.8% 4350 Biomedical repairs/main 3,869 3,000 35 17.5% 4410 Electricity 1,156 1,200 30 6.3% 4440 Telephone 2,645 2,880 0 0.0% 4930 Housekeeping 72,000 72,000 42 1.4% 4940 Travel/prof meetings/me 14,523 17,850 172 -22.4% 4950 CME 3,688 4,600 7.3% 4960 Other expenses 1,258 1,655 $8,637 2.6% $2,103,252 $2,004,769 $ Variance % Variance ($3,457) -1.9% 130,642 11.8% 5,833 32.4% -47,885 -23.5% 10,175 10.2% -1,643 -1.1% 6,651 10.2% 1,463 10.2% 814 6.4% -3,202 -35.6% 533 10.4% 2,762 9.4% 104 4.1% -331 -7.2% 13.8% 869 29.0% -44 -3.7% -235 -8.2% 0.0% 3,327 -18.6% -912 -19.8% -397 -24.0% $98,483 4.9% 426 32 69 767 83 500 200 480 12,000 2,975 767 276 $334,128 0 20 28 June 2018 108 531 920 8174 81 672 June 2018 108 536 920 7790 (5) $ Variance % Variance 0.0% -0.9% 0.0% 384 4.9% -2.4% (178) -20.9% Statistics Admissions (Output) Patient days (Activity) Mgt & clerical hours (Inp Staff hours (Input) Overtime hours (Input) Agency hours (Input) YTD Actual YTD Budget 2018 2018 678 650 3,295 3,213 1040 1040 51378 46743 662 497 3903 5100 $ Variance % Variance 4.3% 82 2.6% 0.0% 4,635 9.9% 165 33.2% (1,197) -23.5% 83 (2) 850