514 Home Insert Draw Page Layout Formulas Data New Week 1 Excel Assignment.xls [Compatibility Mode] E 72% [4] Sun 4:1 Review View Cut Times New... 12 A A Copy ab Wrap Text General Paste B I U A Format EE Merge & Center $ % Home Insert Draw Page Layout Formulas Data Review View Cut Arial 10 Copy Paste B I U A A A Wrap Text General Merge & Center $ % > .00 Paste Copy Wrap Text General Merge & Center $ % Cut Copy Arial Paste B I U Format A 10 10 A A A ab E A1 xfx fx m A B C D F G H 1 m 2 Use the Direct Method Approach 3 4 Projected Revenues by patient services department Routine care Amount EA 7 9 68 Laboratory Radiology 10 Total Revenues $ 5959 24,000,000 15,000,000 $ 14,000,000 R " 3,000,000 11 12 Projected Costs for all departments: 13 Patient Services Departments (Direct Cost) " 14 15 Routine care $ 18,000,000 16 Laboratory 8,000,000 17 Radiology 7,000,000 18 19 20 868 Total Costs $ 33,000,000 F 21 Support Services Department (Overhead Costs) 22 23 Financial Services $ 699 " 3,000,000 24 Facilities 25 Housekeeping 26 Administration $ 27 Human Resources $ 5,600,000 3,000,000 4,000,000 2,400,000 28 29 Totals Costs $ 18,000,000 30 " 31 Total Costs of both patient and support services 32 $ 51,000,000 " 33 Projected Profit $ 2,000,000 34 35 36 37 38 39 40 41 42 er ex 43 MAR 15 1 W P X EV