QA_Ori:
MARATHON RUNNING SHOP
Departmental Expense Allocation Spreadsheet
For Year Ended December 31, 2013
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
Advertising expense: $23,120
Ads Placed % of Total Cost
Administrative expense: $31,400