Edgar Ltd. is looking at implementing a new costing system to refine its support department allocations. The company currently has four support divisions: Accounting (Acctg), Research & Development (R&D), Human Resources (HR) and Information Technology (IT). It has two operating divisions: Central and Western. In an effort to improve its costing, Edgar wishes to implement reciprocal cost allocation. The following table summarizes information on the cost pools and usage:
Operating costs of the Central and Western Divisions are $1,200,000 and $750,000 respectively.
Required:
a. Use the matrix algebra function in Excel to calculate the inverse of the coefficient matrix for support divisions.
b. Multiply the inverse of the coefficient matrix by the vector of constants to obtain the artificial costs.
c. Calculate the allocation of costs to the support and operating departments.
Definitions:
Activity Variance
The difference between planned activity levels or costs and actual activity levels or costs.
Other Expenses
Expenses not directly tied to the production of goods or services, such as administrative and selling expenses.
Budgeting
The practice of formulating a budget to dictate how you’ll use your money, identifying prospective financial aims and the approaches to attain them.
Activity Variance
The gap between planned activity levels and actual outcomes in any sphere of operations, reflecting operational efficiency and planning accuracy.
Q31: What is the operating income in Year
Q39: Life-cycle budgeting is necessary before a company
Q43: Activity-based costing has more applicability in a
Q47: What are the four key perspectives in
Q55: Wharf Fisheries processes many of its seafood
Q58: What is the direct manufacturing labour partial
Q65: Value engineering is a time-and-motion system that
Q112: Which of the following does NOT apply
Q119: The user department is responsible for any
Q144: Brandy has been manager of the downtown