manager of the auto service department.
Exercise 24-2 (20 minutes)
MARATHON RUNNING SHOP
Departmental Expense Allocation Spreadsheet
For Year Ended December 31, 2015
Allocation of Expenses to Departments .
Alloca-
tion
Base
Expense
Account
Balance
Adver-
tising
Dept.
Admini-
strative
Dept.
Shoes
Dept.
Clothing
Dept.
Direct expenses…………. $161,000 $18,000 $25,000 $103,000 $15,000
Indirect utilities
expenses………………….
Sq.
feet 64,000 5,120 6,400 32,640 19,840
Supporting expense allocation calculations
Utilities expense: $64,000
Square Feet % of Total Cost
Advertising………… 1,120 8% $ 5,120
Ads Placed % of Total Cost
Shoes………………… 90 75% $17,340
Sales % of Total Cost