Assigning Traceable Fixed Expenses Selected data for Colony Company, which operates three departments, follow: Department A Department B Department C Inventory $100,000 $360,000 $140,000 Equipment (average cost) $900,000 $540,000 $360,000 Payroll $607,500 $540,000 $202,500 Square feet of floor space 27,000 13,500 4,500 During the year, the company's fixed expenses included the following: Depreciation on equipment $150,000 Real estate taxes 45,000 Personal property taxes (on inventory and equipment) 72,000 Personnel department expenses 75,000 Assume that the property tax rate is the same for both inventory and equipment. Using the most causally related bases prepare a schedule assigning the fixed expenses to the three departments in No all fixed expenses are traceable to the three departments. One of these foed costs should be considered a common cost and not traceable to the department Do not round until your final answer. Round final answer to the nearest whole number Department Department Department Real estate taxes Personal property taxes