$14\mathrm{.}2$a$-$Using Excel to Allocate Support Department Costs Using the Direct Method

PROBLEM

$\text{'}$he Screamin' Eagles Company makes wheels and wings for ground transport vehicles and drones. In addition to the key manufacturing departments, Screamin' Eagles needs two key support services, orovided by its Maintenance and IT departments. The Maintenance costs are allocated to other departments based on the square footage of space each department occupies. The IT department allocates its costs to other departments based on the amount of time the IT employees spend assisting the other departments. The cost information of all four departments, along with their usage information for both allocation bases, is as follows:

$\backslash$table$[[,$Support Departments,Operating Departments,Totals$],[,,$tenance,IT$,$Wheels,Wings$],[$Initial$,$$$,125,000,$$$80,000,$$$415,000,$$$650,000,$$$1,270,000$