This is an exercise that requires you to allocate costs across a Rehabilitation Department.

Please complete BOTH of the spreadsheets in this Excel workbook.

Worksheet 1 requires you to use the information given to allocate indirect costs across three areas: Physical Therapy,

Occupational Therapy and Speech Therapy.

Worksheet 2 requires you to calculate the direct costs to these areas.

I'm lost please help

Proportion of Direct Costs # Computers in Service Allocation Basis Indirect Cost to be Allocated Visit Volume Allocated to 9,600 60.0% 10Physical Therapy (PT) Occupational Therapy 4,000 2,400 25.0% 15.0% 3 (OT) Proof Total Clerical Cost per Visit 3.50 Cost per Computer 5,000.00