Finance Week 3 Problem

Question # 00020137 Posted By: expert-mustang Updated on: 07/18/2014 12:57 AM Due on: 07/18/2014
Subject Finance Topic Finance Tutorials:
Question
Dot Image
Key Information
Cost DriversUnit Measure
Financial ServicesPatient Services Revenue
FacilitiesSquare Footage
HousekeepingLabor Hours
AdministrationSalary Dollars
PersonnelSalary Dollars
Patient ServicesSquare FtHousekeepingSalary Dollars
RevenueLabor Hours
Routine care$ 14,000,000 165,000 68,000$ 4,000,000
Laboratory$ 5,000,000 30,000 3,800$ 750,000
Radiology$ 3,500,000 65,000 7,400$ 1,056,300
Total$ 22,500,000 260,000 79,200$ 5,806,300
COMPLETE THE TABLE (Need to calculate allocation rate)
Overhead Allocation Rates
Cost PoolCost DriverTotal utilizationAllocation Rate
Financial Services$1,000,000Patient Services Revenue$ 22,500,000
Facilities$2,600,000Square Footage 260,000
Housekeeping$1,200,000Labor Hours 79,200
Administration$3,000,000Salary Dollars$ 5,806,300

Personnel

Question 18
COMPLETE TABLE (All bolded areas) 3 points

$1,600,000


Salary Dollars$ 5,806,300
Dot Image
Tutorials for this Question
  1. Tutorial # 00019533 Posted By: expert-mustang Posted on: 07/18/2014 12:58 AM
    Puchased By: 2
    Tutorial Preview
    The solution of Finance Week 3 Problem Solution...
    Attachments
    Finance_Week_3_Problem_Solution.xlsx (16.01 KB)

Great! We have found the solution of this question!

Whatsapp Lisa