I have been working on this for an hour. I have a test tomorrow and I simply do not understand. I think I'm just making this harder than it is. Please see the attached file. I attached the wrong file before

Pepper Department store allocates its service department expenses to its various operating (sales) departments. The following data is available for its service departments: Expense Rent Advertising Administrative The following information is available for its three operating (sales) departments: Department A B C Totals What is the total expense allocated to Department B? $29,375.00 $30,462.00 $30,500.00 $30,775.00 $32,160.00 Basis for allocation Square feet of floor space Amount of dollar sales Number of employees Square Feet 3,000 3,400 3,600 10,000 Amount $24,000 $30,000 $45,000 Dollar sales $280,000 $300,000 $420,000 $1,000,000 Number of employees 6 8 10 24