Using the methods of allocating costs found in the textbook, determine the costs of each of the ED level charges provided.
What method was used in allocating costs? Why was this method used? What are the advantages of this approach? What are the disadvantages?
(let me know if you need more information and what type of information)
7230_Emergency Dept ED_Services_Provided_2013 8560 HR Emergency Department Charges By Service Code 2013 SERVICE HC EMERGENCY DEPARTMENT VISIT HIGH/URGENT SEVERITY - L4 HC EMERGENCY DEPT VISIT HIGH SEVERITY&THREAT FUNCJ - L5 HC EMERGENCY DEPARTMENT VISIT MODERATE SEVERITY - L3 HC EMERGENCY DEPARTMENT VISIT LOW/MODER SEVERITY - L2 HC EMERGENCY DEPARTMENT VISIT LIMITED/MINOR PROB-L1 VOLUME PRICE 43,642 $2,172.00 16,415 $2,908.00 29,091 $1,394.00 4,945 $619.00 2,843 $372.00 TOTAL $94,791,286.15 $47.734.239.67 $40,552.712.05 $3,060,710.95 $1,057,726.18 $187.196,675.00 Done Attachment [t 7230_Emergency_Dept ED_Services_Provided_2013 8560_HR 8431 IS Dpt_Bud_Act 08/15/13 12:11 PM Valley Medical Center Dept # 7230 - EMERGENCY DEPARTMENT For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budget Prior Year PATIENT SERVICE REVENUES HOSPITAL IP REV HOSPITAL OP REV $3,496,545 11,781,412 $3,723,135 12,250,524 $3,735,300 12,045,534 $42.381,555 144,815,116 $44.190,657 1 45,407,886 $36,232,075 120,693.546 GROSS PATIENT REVENUES 15,277,956 15,973,659 15,780,834 187.196,672 189,598,543 156,925,620 DEDUCTIONS FROM REVENUE CONTRACTUAL ADJUSTMENTS (10,081,561) (11.017.753) (10.318.149) (128.342.493) (130,843.579) (103.083.072) TOTAL DED FROM REV (10,081,561) (11.017.753) (10.318,149) (128.342.493) (130.843.579) (103.083.072) NET PATIENT SERVICE REV 5.196.395 4.955.906 5.462.685 58.854.179 5 8,754,964 $3.842.548 OTHER OPERATING REVENUES 0 3,168 0 0 38,000 38,000 25.777 NET OPERATING REVENUE 5,196,395 4,959,074 5,462,685 58.854,179 58,792,964 53,868,325 8 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PHYSICIAN FEES SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION 742,028 298,865 10,000 68,956 23.255 3.746 14,962 751,892 260,037 9.998 87,539 25,912 6.399 32.744 737,211 296,612 69,724 74,037 25,908 9,171 32.462 8,778,071 3,249,201 120,000 898,582 290,788 72.527 299.588 9,194,193 3,130,217 120,000 1,036,373 309.140 76,809 392.928 .794,104 3,042,988 823.466 978,212 314,053 85.006 401.823 TOTAL OP EXPENSES 1,161,813 1,174,520 1,245,123 13,708,758 1 4,259,661 14.439,652 NET INCOME FROM OPERATIONS 4,034,583 3,784,554 4,217,561 45.145.420 44,533,303 39,428,673 NET INCOME $4.034,583 53,784,554 $4,217,561 $45,145,420 $44,533,303 $39,428,673 7230_Emergency_Dept ED_Services_Provided_2013 8560_HR IS_Dpt_Bud_Act 08/15/13 12:11 PM Valley Medical Center Dept #8650 - HUMAN RESOURCES For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budget Prior Year OTHER OPERATING REVENUES SO $107 $0 $255 $1,286 $1,055 NET OPERATING REVENUE 0 107 255 1,286 1,055 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION 100,300 29,955 25,129 1.098 2,518 100.046 30,702 2,974 2,517 10,556 7,058 3,351 92,054 32,015 1,650 4,219 15,140 5,850 3,350 1.201.074 340,914 33,208 14.111 50,877 27,087 39,495 1,217,183 370,077 35,765 30,201 126,675 84,977 40,208 1.203,997 375,179 4,182 28.227 91,361 121,974 40,375 267 2.997 TOTAL OP EXPENSES 162,264 157,203 154,277 1,706,766 1,905,086 1,865,295 NET INCOME FROM OPERATIONS (162,264) (157,096) (154,277) (1.706,511) (1,903,800) (1,864,240) NET INCOME ($162,264) ($157,096) ($154,277) ($1,706,511) ($1,903,800) (81,864,240) 7230_Emergency_Dept ED_Services Provided_2013 8560_HR 8431Pla IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 8431 - PLANT MAINTENANCE For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budget Prior Year OTHER OPERATING REVENUES $0 $214 SO S O $2,564 $41.537 NET OPERATING REVENUE 0 214 2,564 41.537 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES UTILITIES OTHER EXPENSES DEPRECIATION 282,330 122,885 7,225 (171) 219,566 335,998 5,947 173,481 294,729 106,859 24,031 7,493 318,097 292,680 12,005 156,124 264,554 118.539 (121) 3,372 346,606 361,117 8,171 237,606 3,323,462 1.345.551 4,932 41,778 2,438.622 3,524,128 65,064 2,093,717 3,547.255 1.275,782 288,373 89,916 3.817.200 3,512,171 144,064 1,873,488 3.311.554 1.242.495 231.998 58,264 3,802,906 3,530,500 117.962 1.945.280 TOTAL OP EXPENSES 1.147.261 1.212,019 1,339.843 12,837.254 14,548,247 14.240.959 NET INCOME FROM OPERATIONS (1,147,261) (1.211.805) (1,339,843) (12,837,254) (14,545,683) (14.199,422) OTHER NON-OP REVENUES OTHER NON-OP INCOME 0 798 NET NON-OP REVENUES 0 798 NET INCOME (S1,147,261) ($1,211,805) ($1,339.843) ($12.837,254) ($14,545,683) ($14,198,625) 7230_Emergency_Dept ED_Services Provided_2013 8560_HR 8431Pla IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 8431 - PLANT MAINTENANCE For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budget Prior Year OTHER OPERATING REVENUES $0 $214 SO S O $2,564 $41.537 NET OPERATING REVENUE 0 214 2,564 41.537 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES UTILITIES OTHER EXPENSES DEPRECIATION 282,330 122,885 7,225 (171) 219,566 335,998 5,947 173,481 294,729 106,859 24,031 7,493 318,097 292,680 12,005 156,124 264,554 118.539 (121) 3,372 346,606 361,117 8,171 237,606 3,323,462 1.345.551 4,932 41,778 2,438.622 3,524,128 65,064 2,093,717 3,547.255 1.275,782 288,373 89,916 3.817.200 3,512,171 144,064 1,873,488 3.311.554 1.242.495 231.998 58,264 3,802,906 3,530,500 117.962 1.945.280 TOTAL OP EXPENSES 1.147.261 1.212,019 1,339.843 12,837.254 14,548,247 14.240.959 NET INCOME FROM OPERATIONS (1,147,261) (1.211.805) (1,339,843) (12,837,254) (14,545,683) (14.199,422) OTHER NON-OP REVENUES OTHER NON-OP INCOME 0 798 NET NON-OP REVENUES 0 798 NET INCOME (S1,147,261) ($1,211,805) ($1,339.843) ($12.837,254) ($14,545,683) ($14,198,625) IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 8437 - BIOMEDICAL ENGINEERING For the Twelve Months Ending June 30, 2013 June Year To Date 1 Actual Actual Budget Prior Year Budget Prior Year OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION $43,624 17,188 690 202,043 $51,704 17.559 1,182 239,580 1.530 1.887 S42,682 18,844 991 184,264 889 1,887 $564,162 215.639 3.911 2,106,068 589 22,473 $623.916 210.991 14,185 2,874,996 18,453 22,644 $558,022 201.585 (6,637) 2,438,721 21.222 22.642 1.853 TOTAL OP EXPENSES 265,398 313,442 249,556 2912.842 3,765,184 3.235.555 NET INCOME FROM OPERATIONS (265,398) (313,442) (249,556) (2,912.842) (3,765,184) (3,235,555) NET INCOME ($265.398) ($313.442) ($249,556) (52,912.842) (83,765,184) (53.235.555) IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 8611 - ADMINISTRATION For the Twelve Months Ending June 30, 2013 1 June Actual Year To Date Actual Budget Prior Year Budget Prior Year OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION $242,259 29.561 144,547 1.538 19,480 49.746 4,013 $172,073 18.952 166,668 3.569 34,625 44,374 4,038 $82,220 24.470 109.821 2.541 59,943 123,100 4,039 S3.105.956 374,845 936,664 17,304 331,026 612.075 48,330 $2,093,386 248.276 2,000,000 42,815 415,496 533.156 48,456 S1, 109,936 318.948 1,841,547 39,069 370,775 706,368 53.036 TOTAL OP EXPENSES 491,144 444.298 406,134 5.426,201 5 ,381,586 4.439,679 NET INCOME FROM OPERATIONS (491.144) (444.298) (406,134) (5,426,201) (5,381,586) (4,439,679) NET INCOME (5491.144) ($444.298) (5406.134) (S5.426.201) (55.381.586) ($4,439.679) IS Dpt Bud Act 08/13/13 12:11 PM Valley Medical Center Dept # 8422 - MATERIALS MANAGEMENT For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budget Prior Year OTHER OPERATING REVENUES $0 $1,186 $250 $5,875 $14,229 $14.550 NET OPERATING REVENUE 0 1,186 250 5,875 14,229 14.550 48,942 20,744 50.469 46,751 590,329 226,534 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION 613,678 557,976 5.000 29,391 262.223 258,139 7.274 12,549 72,520 121.726 61,171 5,000 2,403 7.682 (19.760) 337 2,400 21.859 21,496 9.617 258,898 203.087 4,045 1.483.534 628,527 5.000 19,621 325,569 245,391 5,333 337 337 TOTAL OP EXPENSES 162,366 143,312 178,559 1.292,509 1,730,451 2.712,974 NET INCOME FROM OPERATIONS (162,366) (142,126) (178,309) (1,286,634) (1.716,221) (2,698,424) NET INCOME ($162,366) ($142,126) ($178,309) (S1,286,634) ($1,716,221) (S2,698,424) IS Dpt_Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 8460 - ENVIRONMENTAL SERVICES For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budest Prior Year OTHER OPERATING REVENUES $175 $536 $1.844 $3.101 S6,432 $6,404 NET OPERATING REVENUE 175 536 1.844 3.101 6,432 6,404 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION 321,229 187.286 46,864 10,527 3 00 220 150.327 30,861 75.647 285,222 177,349 29,092 77,010 3,661 995 2,026,673 350,845 699,622 200 1.399 3,677,933 1.810,170 370,325 904,223 1.920 1,392 3.425 449 1.780,178 351,628 788,021 1.239 7,124 160 116 TOTAL OP EXPENSES 566,065 557,330 568,790 6,740,734 6,765,962 6,353,639 NET INCOME FROM OPERATIONS (565,890) (556,794) (566,946) (6,737,632) (6.759,530) (6,347,235) NET INCOME (5565,890) ($556,794) (5566,946) (S6,737,632) (56,759,530) (S6,347,235) IS Dpt Bud Act Valley Medical Center Dept # 8510 - FINANCIAL PLANNING AND PRODUCTIVITY 12:11 PM For the Twelve Months Ending June 30, 2013 June Year To Date Actual Actual Budget Prior Year Budget Prior Year $57.266 19,659 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES OTHER EXPENSES S65 345 23,477 7,500 $70,115 21.686 18,337 448 3,745 2,538 SN19037 255,875 7,500 1.900 0 19,757 S XS2.894 255,737 61,000 5,380 44.943 31,132 $791.317 245,379 30,904 38,058 150 22,242 6,153 TOTAL OP EXPENSES 83.078 116,870 96,321 1.104.969 1.251,086 1.128,050 NET INCOME FROM OPERATIONS (83,078) (116,870) (96,321) (1.104,969) (1.251,086) (1,128,050) NET INCOME (583,078) ($116,870) (596,321) ($1.104.969) ($1.251,086) (S1.128.050) IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 8562 - EMERGENCY ROOM ADMITTING For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budest Prior Year S110,529 60.226 $109.976 62,439 S1.334.416 652,831 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES OTHER EXPENSES DEPRECIATION $118,600 55,502 231 4.337 0 439 $1.419.445 655,425 1.620 47,707 3,600 36,527 $1.458,840 668,378 3,101 51,387 0 5.268 3,392 0 439 439 5.271 5,271 TOTAL OP EXPENSES 174,795 179,110 176,247 2,029,120 2,186,974 2.129,468 NET INCOME FROM OPERATIONS (174,795) (179,110) (176,247) (2,029,120) (2,186,974) (2.129,468) NET INCOME ($174,795) ($179,110) ($176.247) ($2,029,120) (S2,186,974) (S2,129,468) IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept #8550 - IT ADMINISTRATION For the Twelve Months Ending June 30, 2013 1 June Actual Year To Date Actual Budget Prior Year Budget Prior Year S1,206,593 298,820 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES UTILITIES OTHER EXPENSES DEPRECIATION $87,089 23.071 65,880 (1,940) (5,867) (94) 11.489 940,065 S102.218 27.042 0 6,754 50,459 250 8.014 1,321,850 $56,098 34,699 13.598 7,164 38,486 15 9.638 377,000 $1,120,126 263,290 452,231 58.134 1.108,145 4,284 137.422 10.928,957 $630,782 168,504 34.751 113,585 474.456 81,049 605,458 3.000 1.068 96,163 14,880,771 97.813 9,675,593 TOTAL OP EXPENSES 1,119,693 1.516,587 536,698 14,072,589 17,171,854 11.196,552 NET INCOME FROM OPERATIONS (1,119,693) (1.516,587) (536,698) (14,072,589) (17.171,854) (11.196,552) NET INCOME ($1,119,693) ($1.516,587) (S536,698) ($14,072,589) ($17,171,854) ($11.196,552) IS Dpt Bud Act Valley Medical Center Dept # 8510 - FINANCIAL PLANNING AND PRODUCTIVITY 12:11 PM For the Twelve Months Ending June 30, 2013 June Year To Date Actual Actual Budget Prior Year Budget Prior Year $57.266 19,659 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES OTHER EXPENSES S65 345 23,477 7,500 $70,115 21.686 18,337 448 3,745 2,538 SN19037 255,875 7,500 1.900 0 19,757 S XS2.894 255,737 61,000 5,380 44.943 31,132 $791.317 245,379 30,904 38,058 150 22,242 6,153 TOTAL OP EXPENSES 83.078 116,870 96,321 1.104.969 1.251,086 1.128,050 NET INCOME FROM OPERATIONS (83,078) (116,870) (96,321) (1.104,969) (1.251,086) (1,128,050) NET INCOME (583,078) ($116,870) (596,321) ($1.104.969) ($1.251,086) (S1.128.050) IS Dpt Bud Act Valley Medical Center 08/15/13 Dept # 8512 - FINANCIAL REPORTING AND ACCOUNTING 12:11 PM For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budget Prior Year $38,450 18,333 21.310 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION 733 $40,380 18.012 33.549 1,884 13,331 43,355 2,350 S40.193 17,009 88,070 438 3,000 28.057 2,232 $471.280 201,278 204,810 11.106 38,335 $23.850 25,161 S491.223 216,705 402.611 22,592 160,000 520,507 28,200 S536.566 215,609 378,891 13,837 34,271 361613 28,573 3,000 53,189 1.913 TOTAL OP EXPENSES 136,929 152,861 178.999 1.475,821 1,841,837 1.569,380 NET INCOME FROM OPERATIONS (136,929) (152,861) (178,999) (1,475,821) (1,841,837) (1,569,380) NET INCOME ($136,929) ($152.861) ($178,999) ($1,475.821) (91,841.837) ($1.569,380) IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 8531 - PATIENT ACCOUNTS For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budget Prior Year OTHER OPERATING REVENUES $154.147 1,915 $7.883 $873.219 $22.983 $35,433 NET OPERATING REVENUE 154,147 1.915 7 ,883 873.219 22,983 35,433 185.318 73.275 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES UTILITIES OTHER EXPENSES DEPRECIATION 522 243,804 1.279 52.937 1,553 1 98.498 66,405 SO 2,118 138,045 1.256 56,230 2.699 1 80.460 70.971 0 1.131 116,465 1,279 77,665 2,772 2.095.829 746,444 0 13.210 1,744,261 15,348 678.247 24,166 2.426.530 794.953 600 25,028 1,656,584 15,072 674,745 32,379 32 379 2.258.621 767,566 694 25.464 1,542,689 15,161 639,488 32,683 TOTAL OP EXPENSES 558,687 465,301 450,742 5.317,504 5,625,891 5.282.367 NET INCOME FROM OPERATIONS (404,540) (463,386) (442.859) (4,444,285) (5,602.908) (5.246,934) NET INCOME (5404.540) (S463.386) (S442.859) (S4.444.285) (55.602.908) (55.246,934) IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept #8630 - MARKETING For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budest Prior Year Budget Pror Year OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS SUPPLIES PURCHASED SERVICES UTILITIES OTHER EXPENSES DEPRECIATION $37.863 14,861 (361) 19.307 $38,519 11,423 1,856 32,078 $37,243 14,310 887 11.755 $458,442 157.882 4,493 78,081 3,972 1.256,521 124,873 S468,548 135,158 22.843 384,936 3,972 1,633,396 11,220 $449,064 131,076 16,743 272,670 3,857 1.999,409 12.290 331 331 331 104,333 10,465 136,116 935 97,116 1,702 TOTAL OP EXPENSES 186,798 221.258 163,344 2,084,264 2,660,074 2,885,110 NET INCOME FROM OPERATIONS (186,798) (221.258) (163,344) (2,084.264) (2,660,074) (2,885,110) NET INCOME ($186,798) ($221,258) (S163,344) (52,084,264) (S2,660,074) (52,885,110) 7230_Emergency Dept ED_Services_Provided_2013 8560 HR Emergency Department Charges By Service Code 2013 SERVICE HC EMERGENCY DEPARTMENT VISIT HIGH/URGENT SEVERITY - L4 HC EMERGENCY DEPT VISIT HIGH SEVERITY&THREAT FUNCJ - L5 HC EMERGENCY DEPARTMENT VISIT MODERATE SEVERITY - L3 HC EMERGENCY DEPARTMENT VISIT LOW/MODER SEVERITY - L2 HC EMERGENCY DEPARTMENT VISIT LIMITED/MINOR PROB-L1 VOLUME PRICE 43,642 $2,172.00 16,415 $2,908.00 29,091 $1,394.00 4,945 $619.00 2,843 $372.00 TOTAL $94,791,286.15 $47.734.239.67 $40,552.712.05 $3,060,710.95 $1,057,726.18 $187.196,675.00 Done Attachment [t 7230_Emergency_Dept ED_Services_Provided_2013 8560_HR 8431 IS Dpt_Bud_Act 08/15/13 12:11 PM Valley Medical Center Dept # 7230 - EMERGENCY DEPARTMENT For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budget Prior Year PATIENT SERVICE REVENUES HOSPITAL IP REV HOSPITAL OP REV $3,496,545 11,781,412 $3,723,135 12,250,524 $3,735,300 12,045,534 $42.381,555 144,815,116 $44.190,657 1 45,407,886 $36,232,075 120,693.546 GROSS PATIENT REVENUES 15,277,956 15,973,659 15,780,834 187.196,672 189,598,543 156,925,620 DEDUCTIONS FROM REVENUE CONTRACTUAL ADJUSTMENTS (10,081,561) (11.017.753) (10.318.149) (128.342.493) (130,843.579) (103.083.072) TOTAL DED FROM REV (10,081,561) (11.017.753) (10.318,149) (128.342.493) (130.843.579) (103.083.072) NET PATIENT SERVICE REV 5.196.395 4.955.906 5.462.685 58.854.179 5 8,754,964 $3.842.548 OTHER OPERATING REVENUES 0 3,168 0 0 38,000 38,000 25.777 NET OPERATING REVENUE 5,196,395 4,959,074 5,462,685 58.854,179 58,792,964 53,868,325 8 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PHYSICIAN FEES SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION 742,028 298,865 10,000 68,956 23.255 3.746 14,962 751,892 260,037 9.998 87,539 25,912 6.399 32.744 737,211 296,612 69,724 74,037 25,908 9,171 32.462 8,778,071 3,249,201 120,000 898,582 290,788 72.527 299.588 9,194,193 3,130,217 120,000 1,036,373 309.140 76,809 392.928 .794,104 3,042,988 823.466 978,212 314,053 85.006 401.823 TOTAL OP EXPENSES 1,161,813 1,174,520 1,245,123 13,708,758 1 4,259,661 14.439,652 NET INCOME FROM OPERATIONS 4,034,583 3,784,554 4,217,561 45.145.420 44,533,303 39,428,673 NET INCOME $4.034,583 53,784,554 $4,217,561 $45,145,420 $44,533,303 $39,428,673 7230_Emergency_Dept ED_Services_Provided_2013 8560_HR IS_Dpt_Bud_Act 08/15/13 12:11 PM Valley Medical Center Dept #8650 - HUMAN RESOURCES For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budget Prior Year OTHER OPERATING REVENUES SO $107 $0 $255 $1,286 $1,055 NET OPERATING REVENUE 0 107 255 1,286 1,055 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION 100,300 29,955 25,129 1.098 2,518 100.046 30,702 2,974 2,517 10,556 7,058 3,351 92,054 32,015 1,650 4,219 15,140 5,850 3,350 1.201.074 340,914 33,208 14.111 50,877 27,087 39,495 1,217,183 370,077 35,765 30,201 126,675 84,977 40,208 1.203,997 375,179 4,182 28.227 91,361 121,974 40,375 267 2.997 TOTAL OP EXPENSES 162,264 157,203 154,277 1,706,766 1,905,086 1,865,295 NET INCOME FROM OPERATIONS (162,264) (157,096) (154,277) (1.706,511) (1,903,800) (1,864,240) NET INCOME ($162,264) ($157,096) ($154,277) ($1,706,511) ($1,903,800) (81,864,240) 7230_Emergency_Dept ED_Services Provided_2013 8560_HR 8431Pla IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 8431 - PLANT MAINTENANCE For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budget Prior Year OTHER OPERATING REVENUES $0 $214 SO S O $2,564 $41.537 NET OPERATING REVENUE 0 214 2,564 41.537 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES UTILITIES OTHER EXPENSES DEPRECIATION 282,330 122,885 7,225 (171) 219,566 335,998 5,947 173,481 294,729 106,859 24,031 7,493 318,097 292,680 12,005 156,124 264,554 118.539 (121) 3,372 346,606 361,117 8,171 237,606 3,323,462 1.345.551 4,932 41,778 2,438.622 3,524,128 65,064 2,093,717 3,547.255 1.275,782 288,373 89,916 3.817.200 3,512,171 144,064 1,873,488 3.311.554 1.242.495 231.998 58,264 3,802,906 3,530,500 117.962 1.945.280 TOTAL OP EXPENSES 1.147.261 1.212,019 1,339.843 12,837.254 14,548,247 14.240.959 NET INCOME FROM OPERATIONS (1,147,261) (1.211.805) (1,339,843) (12,837,254) (14,545,683) (14.199,422) OTHER NON-OP REVENUES OTHER NON-OP INCOME 0 798 NET NON-OP REVENUES 0 798 NET INCOME (S1,147,261) ($1,211,805) ($1,339.843) ($12.837,254) ($14,545,683) ($14,198,625) 7230_Emergency_Dept ED_Services Provided_2013 8560_HR 8431Pla IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 8431 - PLANT MAINTENANCE For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budget Prior Year OTHER OPERATING REVENUES $0 $214 SO S O $2,564 $41.537 NET OPERATING REVENUE 0 214 2,564 41.537 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES UTILITIES OTHER EXPENSES DEPRECIATION 282,330 122,885 7,225 (171) 219,566 335,998 5,947 173,481 294,729 106,859 24,031 7,493 318,097 292,680 12,005 156,124 264,554 118.539 (121) 3,372 346,606 361,117 8,171 237,606 3,323,462 1.345.551 4,932 41,778 2,438.622 3,524,128 65,064 2,093,717 3,547.255 1.275,782 288,373 89,916 3.817.200 3,512,171 144,064 1,873,488 3.311.554 1.242.495 231.998 58,264 3,802,906 3,530,500 117.962 1.945.280 TOTAL OP EXPENSES 1.147.261 1.212,019 1,339.843 12,837.254 14,548,247 14.240.959 NET INCOME FROM OPERATIONS (1,147,261) (1.211.805) (1,339,843) (12,837,254) (14,545,683) (14.199,422) OTHER NON-OP REVENUES OTHER NON-OP INCOME 0 798 NET NON-OP REVENUES 0 798 NET INCOME (S1,147,261) ($1,211,805) ($1,339.843) ($12.837,254) ($14,545,683) ($14,198,625) IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 8437 - BIOMEDICAL ENGINEERING For the Twelve Months Ending June 30, 2013 June Year To Date 1 Actual Actual Budget Prior Year Budget Prior Year OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION $43,624 17,188 690 202,043 $51,704 17.559 1,182 239,580 1.530 1.887 S42,682 18,844 991 184,264 889 1,887 $564,162 215.639 3.911 2,106,068 589 22,473 $623.916 210.991 14,185 2,874,996 18,453 22,644 $558,022 201.585 (6,637) 2,438,721 21.222 22.642 1.853 TOTAL OP EXPENSES 265,398 313,442 249,556 2912.842 3,765,184 3.235.555 NET INCOME FROM OPERATIONS (265,398) (313,442) (249,556) (2,912.842) (3,765,184) (3,235,555) NET INCOME ($265.398) ($313.442) ($249,556) (52,912.842) (83,765,184) (53.235.555) IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 8611 - ADMINISTRATION For the Twelve Months Ending June 30, 2013 1 June Actual Year To Date Actual Budget Prior Year Budget Prior Year OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION $242,259 29.561 144,547 1.538 19,480 49.746 4,013 $172,073 18.952 166,668 3.569 34,625 44,374 4,038 $82,220 24.470 109.821 2.541 59,943 123,100 4,039 S3.105.956 374,845 936,664 17,304 331,026 612.075 48,330 $2,093,386 248.276 2,000,000 42,815 415,496 533.156 48,456 S1, 109,936 318.948 1,841,547 39,069 370,775 706,368 53.036 TOTAL OP EXPENSES 491,144 444.298 406,134 5.426,201 5 ,381,586 4.439,679 NET INCOME FROM OPERATIONS (491.144) (444.298) (406,134) (5,426,201) (5,381,586) (4,439,679) NET INCOME (5491.144) ($444.298) (5406.134) (S5.426.201) (55.381.586) ($4,439.679) IS Dpt Bud Act 08/13/13 12:11 PM Valley Medical Center Dept # 8422 - MATERIALS MANAGEMENT For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budget Prior Year OTHER OPERATING REVENUES $0 $1,186 $250 $5,875 $14,229 $14.550 NET OPERATING REVENUE 0 1,186 250 5,875 14,229 14.550 48,942 20,744 50.469 46,751 590,329 226,534 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION 613,678 557,976 5.000 29,391 262.223 258,139 7.274 12,549 72,520 121.726 61,171 5,000 2,403 7.682 (19.760) 337 2,400 21.859 21,496 9.617 258,898 203.087 4,045 1.483.534 628,527 5.000 19,621 325,569 245,391 5,333 337 337 TOTAL OP EXPENSES 162,366 143,312 178,559 1.292,509 1,730,451 2.712,974 NET INCOME FROM OPERATIONS (162,366) (142,126) (178,309) (1,286,634) (1.716,221) (2,698,424) NET INCOME ($162,366) ($142,126) ($178,309) (S1,286,634) ($1,716,221) (S2,698,424) IS Dpt_Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 8460 - ENVIRONMENTAL SERVICES For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budest Prior Year OTHER OPERATING REVENUES $175 $536 $1.844 $3.101 S6,432 $6,404 NET OPERATING REVENUE 175 536 1.844 3.101 6,432 6,404 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION 321,229 187.286 46,864 10,527 3 00 220 150.327 30,861 75.647 285,222 177,349 29,092 77,010 3,661 995 2,026,673 350,845 699,622 200 1.399 3,677,933 1.810,170 370,325 904,223 1.920 1,392 3.425 449 1.780,178 351,628 788,021 1.239 7,124 160 116 TOTAL OP EXPENSES 566,065 557,330 568,790 6,740,734 6,765,962 6,353,639 NET INCOME FROM OPERATIONS (565,890) (556,794) (566,946) (6,737,632) (6.759,530) (6,347,235) NET INCOME (5565,890) ($556,794) (5566,946) (S6,737,632) (56,759,530) (S6,347,235) IS Dpt Bud Act Valley Medical Center Dept # 8510 - FINANCIAL PLANNING AND PRODUCTIVITY 12:11 PM For the Twelve Months Ending June 30, 2013 June Year To Date Actual Actual Budget Prior Year Budget Prior Year $57.266 19,659 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES OTHER EXPENSES S65 345 23,477 7,500 $70,115 21.686 18,337 448 3,745 2,538 SN19037 255,875 7,500 1.900 0 19,757 S XS2.894 255,737 61,000 5,380 44.943 31,132 $791.317 245,379 30,904 38,058 150 22,242 6,153 TOTAL OP EXPENSES 83.078 116,870 96,321 1.104.969 1.251,086 1.128,050 NET INCOME FROM OPERATIONS (83,078) (116,870) (96,321) (1.104,969) (1.251,086) (1,128,050) NET INCOME (583,078) ($116,870) (596,321) ($1.104.969) ($1.251,086) (S1.128.050) IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 8562 - EMERGENCY ROOM ADMITTING For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budest Prior Year S110,529 60.226 $109.976 62,439 S1.334.416 652,831 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES OTHER EXPENSES DEPRECIATION $118,600 55,502 231 4.337 0 439 $1.419.445 655,425 1.620 47,707 3,600 36,527 $1.458,840 668,378 3,101 51,387 0 5.268 3,392 0 439 439 5.271 5,271 TOTAL OP EXPENSES 174,795 179,110 176,247 2,029,120 2,186,974 2.129,468 NET INCOME FROM OPERATIONS (174,795) (179,110) (176,247) (2,029,120) (2,186,974) (2.129,468) NET INCOME ($174,795) ($179,110) ($176.247) ($2,029,120) (S2,186,974) (S2,129,468) IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept #8550 - IT ADMINISTRATION For the Twelve Months Ending June 30, 2013 1 June Actual Year To Date Actual Budget Prior Year Budget Prior Year S1,206,593 298,820 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES UTILITIES OTHER EXPENSES DEPRECIATION $87,089 23.071 65,880 (1,940) (5,867) (94) 11.489 940,065 S102.218 27.042 0 6,754 50,459 250 8.014 1,321,850 $56,098 34,699 13.598 7,164 38,486 15 9.638 377,000 $1,120,126 263,290 452,231 58.134 1.108,145 4,284 137.422 10.928,957 $630,782 168,504 34.751 113,585 474.456 81,049 605,458 3.000 1.068 96,163 14,880,771 97.813 9,675,593 TOTAL OP EXPENSES 1,119,693 1.516,587 536,698 14,072,589 17,171,854 11.196,552 NET INCOME FROM OPERATIONS (1,119,693) (1.516,587) (536,698) (14,072,589) (17.171,854) (11.196,552) NET INCOME ($1,119,693) ($1.516,587) (S536,698) ($14,072,589) ($17,171,854) ($11.196,552) IS Dpt Bud Act Valley Medical Center Dept # 8510 - FINANCIAL PLANNING AND PRODUCTIVITY 12:11 PM For the Twelve Months Ending June 30, 2013 June Year To Date Actual Actual Budget Prior Year Budget Prior Year $57.266 19,659 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES OTHER EXPENSES S65 345 23,477 7,500 $70,115 21.686 18,337 448 3,745 2,538 SN19037 255,875 7,500 1.900 0 19,757 S XS2.894 255,737 61,000 5,380 44.943 31,132 $791.317 245,379 30,904 38,058 150 22,242 6,153 TOTAL OP EXPENSES 83.078 116,870 96,321 1.104.969 1.251,086 1.128,050 NET INCOME FROM OPERATIONS (83,078) (116,870) (96,321) (1.104,969) (1.251,086) (1,128,050) NET INCOME (583,078) ($116,870) (596,321) ($1.104.969) ($1.251,086) (S1.128.050) IS Dpt Bud Act Valley Medical Center 08/15/13 Dept # 8512 - FINANCIAL REPORTING AND ACCOUNTING 12:11 PM For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budget Prior Year $38,450 18,333 21.310 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION 733 $40,380 18.012 33.549 1,884 13,331 43,355 2,350 S40.193 17,009 88,070 438 3,000 28.057 2,232 $471.280 201,278 204,810 11.106 38,335 $23.850 25,161 S491.223 216,705 402.611 22,592 160,000 520,507 28,200 S536.566 215,609 378,891 13,837 34,271 361613 28,573 3,000 53,189 1.913 TOTAL OP EXPENSES 136,929 152,861 178.999 1.475,821 1,841,837 1.569,380 NET INCOME FROM OPERATIONS (136,929) (152,861) (178,999) (1,475,821) (1,841,837) (1,569,380) NET INCOME ($136,929) ($152.861) ($178,999) ($1,475.821) (91,841.837) ($1.569,380) IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 8531 - PATIENT ACCOUNTS For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budget Prior Year Budget Prior Year OTHER OPERATING REVENUES $154.147 1,915 $7.883 $873.219 $22.983 $35,433 NET OPERATING REVENUE 154,147 1.915 7 ,883 873.219 22,983 35,433 185.318 73.275 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PROFESSIONAL SERVICES SUPPLIES PURCHASED SERVICES UTILITIES OTHER EXPENSES DEPRECIATION 522 243,804 1.279 52.937 1,553 1 98.498 66,405 SO 2,118 138,045 1.256 56,230 2.699 1 80.460 70.971 0 1.131 116,465 1,279 77,665 2,772 2.095.829 746,444 0 13.210 1,744,261 15,348 678.247 24,166 2.426.530 794.953 600 25,028 1,656,584 15,072 674,745 32,379 32 379 2.258.621 767,566 694 25.464 1,542,689 15,161 639,488 32,683 TOTAL OP EXPENSES 558,687 465,301 450,742 5.317,504 5,625,891 5.282.367 NET INCOME FROM OPERATIONS (404,540) (463,386) (442.859) (4,444,285) (5,602.908) (5.246,934) NET INCOME (5404.540) (S463.386) (S442.859) (S4.444.285) (55.602.908) (55.246,934) IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept #8630 - MARKETING For the Twelve Months Ending June 30, 2013 June Actual Year To Date Actual Budest Prior Year Budget Pror Year OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS SUPPLIES PURCHASED SERVICES UTILITIES OTHER EXPENSES DEPRECIATION $37.863 14,861 (361) 19.307 $38,519 11,423 1,856 32,078 $37,243 14,310 887 11.755 $458,442 157.882 4,493 78,081 3,972 1.256,521 124,873 S468,548 135,158 22.843 384,936 3,972 1,633,396 11,220 $449,064 131,076 16,743 272,670 3,857 1.999,409 12.290 331 331 331 104,333 10,465 136,116 935 97,116 1,702 TOTAL OP EXPENSES 186,798 221.258 163,344 2,084,264 2,660,074 2,885,110 NET INCOME FROM OPERATIONS (186,798) (221.258) (163,344) (2,084.264) (2,660,074) (2,885,110) NET INCOME ($186,798) ($221,258) (S163,344) (52,084,264) (S2,660,074) (52,885,110)
