Matrix Algebra & Excel - Homework Saved Help Seattle Western University has provided the following data to be used in its service department cost allocations: Service Departments Facility Administration Services $2,400,000 $1,600,000 Departmental costs before allocation Student credit-hours Space occupied-aquare feet Operating Departments Undergraduate Graduate Programs Program $26,800,000 $5,700,000 20,000 5,000 70,000 30,000 25,000 10,000 Required: Using matrix algebra, allocate the costs of the service departments to the two operating departments. Allocate the Administration cost on the basis of student credit-hours and the Facility Services cost on the basis of space occupled. (Based the allocation on a LA Matrix taken to the second power.) Service Departments Facility Administration Services $ 2,400,000 $1,600,000 Operating Departments Undergraduate Graduate Total Programs Programs $ 26,800,000 $5,700,000 $ 36,500,000 Departmental costs before allocations Allocations: Administration costs Facility services costs Total costs after allocations