Please show how you got your calculations on excel.

Assignment Exercise 7-1: Allocating Indirect Costs Study Table 7-1, Table 7-2, and review the chapter text describing how the indirect cost is allocated. This assignment will change the allocation bases input for (A) Number of Visits (Volume), (B) Proportion of Direct Costs, and (C) Number of Computers in Service. Required 1. Compute the costs allocated to cost centers "Clerical Salaries," "Administrative Salaries," and "Computer Services" using the new allocation bases shown below. Use worksheet #1 that replicates the set up in Table 7-2. Total the new results. The new allocation bases are: A= # Visits (Volume): PT = 9,600; OT = 4,000; ST = 2,400; Total = 16,000S 16,000 3 $3.50 = $56,000) B = Proportion of Direct Costs: PT = 60%; OT = 25%, ST = 15%; Total = 100%s % 3 $55,000 total) C= # Computers in Service: PT = 10; OT 53; ST = 3; Total = 16 16 3 $5,000 each = $80,000) Responsibility Centers 57 Table 7-2 Example of Indirect Costs Allocated to Rehab Cost Center Clerical Administrative Salaries Salaries Computer Services Total Indirect Cost Allocation Basis: B $60,000 $50,000 $75,000 $185,000 Indirect Cost to Be Allocated Allocated to: Physical Therapy (PT) Occupational Therapy (OT) Speech Therapy (ST) Proof Total 34,000 16,000 10,000 $60,000 28,500 13,000 8,500 $50,000 45,000 15,000 15,000 $75,000 107,500 44,000 33,500 $185,000 Allocation Key: 1 $ A = # Visits (Volume): PT = 8500/OT = 4000/ST = 2500/Total = 15,000 (15,000 x $4.00 = $60,000) B = Proportion of Direct Costs: PT = 57%/OT = 26%/ST = 17%/Total = 100% % x $50,000) C = # Computers in Service: PT = 9/OT = 3/ST = 3/Total = 15 (15 x $5,000 each = $75,000)