Electricity (kilowatt hours) 93,877 OR, operating room. 3. Using Table 11.7, Chapter 11.xlsx, 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? TABLE 11.7 Monthly Variance Report Variance Variance 2018 2018 June Object Description YTD Actual 2018 YTD Budget 2018 Variance Code Variance $31,256 $30,000 $1,2564 2 4010 Management and clerical staff $176,543 $180.000 $3.457 $184, 167 $196,333 $12,166 6.8 4020 Staff salaries and wages $1,235,642 $130,842 $1,105,000 11.8 $2,065 $3,000 -12 $35 4040 Overtime $23.833 324 $18,000 $5.8.38 $26,897 $34,000 $7.103 -20.9 4050 Agency and temporary $156, 115 $204,000 $10,175 $17.637 $16,613 $1,024 102 62 $109,855 FICA $09,580 4110 $151,500 4120 $149,857 $25,601 -$1,843 Health Insurance $25,250 $351 -11 14 $6,651 $71,801 $65,150 102 Retirement $11,528 4130 $10,858 $669 6.2 $14,333 $15.796 $1,463 102 $2,667 $2.389 Unemployment 4140 $278 $13.589 $12.775 $2,213 $2,129 Floor medications 584 4210 $9,000 $3.202 -35.6 $5,798 4212 Medical instruments $1,016 $484 $1,500 -32.3 Aa Bookmarks Window Help File Edit View History DO GED Fri 12:58 PM $859 $852 $7 0.9 4214 Bandages, gauze, etc. $5,843 $5,110 3533 10.4 $5,269 $4,897 $372 4216 Latex gloves, gowns, etc. $32.145 $29.383 $4,762 $458 $426 4218 Sterile Wipes $2,659 $2.555 $104 $713 $767 $54 4250 Orice supplies $4268 $4,809 -$331 -72 $102 $83 $19 4280 Cleaning supplies 5569 $500 $60 13.8 $599 $500 $99 4350 Biomed repairs/maintenance $3,889 $3,000 $889 200 $235 $200 Sas 4410 Electricity $1,156 $1.200 344 $480 $30 $610 4440 Telephone $2,845 $2,880 -$235 -82 $12.000 4930 $12,000 $0 Housekeeping $72.000 $72.000 $0 0.0 Trave professional S4940 $17.850 $14.623 $2,975 -$3,327 $3,017 $42 -18.6 -19,8 $912 $4,600 $595 $767 $172 224 $4950 $3.688 Education and training -240 S1258 Othor expenses $1.655 $4960 $296 $276 $2.103.252 $2,004,769 $88,483 4.9 $342,786 5334,128 $8,637 2.6 A reader chegg.com $342,766 $334,128 $8,637 2.6 $2,103,252 $2,004,789 $98,483 4.9 June 2018 June 2018 Variance Statistics YTD Actual 2018 YTD Budget 2018 Variance Variance 108 108 Admissions (output) 650 531 538 Patient days (activity 3.295 3.213 920 9200 Management and clerical hours crout 1,040 1,040 00 8,174 7,790 384 Staff hoursdnout 51378 46,743 4,836 9.9 81 B3 (2) Overtime hours input 662 497 165 33.2 672 850 (178) -20.0 Agency hours (nout 3,003 5.100 (1.1977 -23.5 FICA Fed e Contribution Statistics are provided at the bottom of the report to guide assessment. The question, Did the manager take steps to reduce staff utilization was asked. Statistics show that stall hours are 4.9% overbudget for the month compared to 9.9% for the year, that is June's overage is an improvement over past months The statistics on output (admissions up 43%) and activity levels patient days up 2.6%) indicate that some of unarticipated increase in staff hours may be due to the higher volume of patients treated. The reader should use the previously provided variances to determine how much these variance are due to changes in prices, efficiency, intensity, and volume data is available in the Table 11.7 tab Chapteris Table 11.7 provides a wealth of information for managers to assess departmental performance it shows how for each in tem varies from its budgets, provides Information to determine whether variances are increasing or decreasing compared to prior months, and supplies output, activity, and input use statistics to Electricity (kilowatt hours) 93,877 OR, operating room. 3. Using Table 11.7, Chapter 11.xlsx, 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? TABLE 11.7 Monthly Variance Report Variance Variance 2018 2018 June Object Description YTD Actual 2018 YTD Budget 2018 Variance Code Variance $31,256 $30,000 $1,2564 2 4010 Management and clerical staff $176,543 $180.000 $3.457 $184, 167 $196,333 $12,166 6.8 4020 Staff salaries and wages $1,235,642 $130,842 $1,105,000 11.8 $2,065 $3,000 -12 $35 4040 Overtime $23.833 324 $18,000 $5.8.38 $26,897 $34,000 $7.103 -20.9 4050 Agency and temporary $156, 115 $204,000 $10,175 $17.637 $16,613 $1,024 102 62 $109,855 FICA $09,580 4110 $151,500 4120 $149,857 $25,601 -$1,843 Health Insurance $25,250 $351 -11 14 $6,651 $71,801 $65,150 102 Retirement $11,528 4130 $10,858 $669 6.2 $14,333 $15.796 $1,463 102 $2,667 $2.389 Unemployment 4140 $278 $13.589 $12.775 $2,213 $2,129 Floor medications 584 4210 $9,000 $3.202 -35.6 $5,798 4212 Medical instruments $1,016 $484 $1,500 -32.3 Aa Bookmarks Window Help File Edit View History DO GED Fri 12:58 PM $859 $852 $7 0.9 4214 Bandages, gauze, etc. $5,843 $5,110 3533 10.4 $5,269 $4,897 $372 4216 Latex gloves, gowns, etc. $32.145 $29.383 $4,762 $458 $426 4218 Sterile Wipes $2,659 $2.555 $104 $713 $767 $54 4250 Orice supplies $4268 $4,809 -$331 -72 $102 $83 $19 4280 Cleaning supplies 5569 $500 $60 13.8 $599 $500 $99 4350 Biomed repairs/maintenance $3,889 $3,000 $889 200 $235 $200 Sas 4410 Electricity $1,156 $1.200 344 $480 $30 $610 4440 Telephone $2,845 $2,880 -$235 -82 $12.000 4930 $12,000 $0 Housekeeping $72.000 $72.000 $0 0.0 Trave professional S4940 $17.850 $14.623 $2,975 -$3,327 $3,017 $42 -18.6 -19,8 $912 $4,600 $595 $767 $172 224 $4950 $3.688 Education and training -240 S1258 Othor expenses $1.655 $4960 $296 $276 $2.103.252 $2,004,769 $88,483 4.9 $342,786 5334,128 $8,637 2.6 A reader chegg.com $342,766 $334,128 $8,637 2.6 $2,103,252 $2,004,789 $98,483 4.9 June 2018 June 2018 Variance Statistics YTD Actual 2018 YTD Budget 2018 Variance Variance 108 108 Admissions (output) 650 531 538 Patient days (activity 3.295 3.213 920 9200 Management and clerical hours crout 1,040 1,040 00 8,174 7,790 384 Staff hoursdnout 51378 46,743 4,836 9.9 81 B3 (2) Overtime hours input 662 497 165 33.2 672 850 (178) -20.0 Agency hours (nout 3,003 5.100 (1.1977 -23.5 FICA Fed e Contribution Statistics are provided at the bottom of the report to guide assessment. The question, Did the manager take steps to reduce staff utilization was asked. Statistics show that stall hours are 4.9% overbudget for the month compared to 9.9% for the year, that is June's overage is an improvement over past months The statistics on output (admissions up 43%) and activity levels patient days up 2.6%) indicate that some of unarticipated increase in staff hours may be due to the higher volume of patients treated. The reader should use the previously provided variances to determine how much these variance are due to changes in prices, efficiency, intensity, and volume data is available in the Table 11.7 tab Chapteris Table 11.7 provides a wealth of information for managers to assess departmental performance it shows how for each in tem varies from its budgets, provides Information to determine whether variances are increasing or decreasing compared to prior months, and supplies output, activity, and input use statistics to