Part II - Cost Allocation A computer/electronics company needs help figuring out how to allocate their rent bill to the operational departments of the business. The following information is known about the scenario: Department Sq.Ft Annual Rent Hardware 4500 Software 6000 Accessories Programming 3500 Total 22,000 $ 2420,000 A. Use the excel template to build an allocation of the rent bill to the departments using square feet as the allocation base. B. The manager of Accessories thinks number of employees is a better measure and should be used in place of square feet. Do you agree or disagree? Support your position. 8000 = = = -- - Merye 1 fx x B A C D E F G H I PARTA Total Rent cost: Sq. Ft % $$$ Department Hardware Software Accessories Programming Total PARTB