Put in Excel format

4.5 Refer to problem 4-4. Assume that the three patient services departments are Adult Services, Pediatric Services, and Other Services. The patient services revenue and hours of housekeeping services for each department are as follows: Department Adult Services Pediatric Services Other Services Total Revenue $3,000,000 1,500,000 500,000 $5,000,000 Housekeeping Hours 1,500 3,000 500 5,000 What is the dollar allocation to each patient services department if patient services revenue is used as the cost driver? b. What is the dollar allocation to each patient services department if hours of housekeeping support are used as the cost driver? c. What is the dollar difference in the amount allocated to each department be- tween the two drivers? d. Which of the two drivers is better? Why? 4.4 The Housekeeping Services Department of Ruger Clinic, a multispecialty practice in Toledo, Ohio, had $100,000 in direct costs during the year. These costs must be allocated to Ruger's three revenue-producing patient services departments using the direct method. Two cost drivers are under consideration: patient services rev- enue and hours of housekeeping services used. The patient services departments generated a total of $5 million in revenues during the year. To support these clinical activities, the departments used 5,000 total hours of housekeeping services. a. What is the value of the cost pool? b. What is the allocation rate if (1) patient services revenue is used as the cost driver and if (2) hours of housekeeping services are used as the cost driver? 4.5 Refer to problem 4.4. Assume that the three patient services departments are Adult Services, Pediatric Services, and Other Services. The patient services revenue and 11:24 AM M. 41% Answer 1 of 1 + Part 1 Value of the cost pool (In dollars) = $100000 (direct costs) Part 2 Allocation Rate - Indirect Cost / Patient service revenue: $100000 / 85000000 = 0.02 per patient service revenue Allocation Rate - Indirect Cost / Housekeeping service hour = $ 100000/5000= $ 2Oper house keeping hours