Cost Management
8th Edition
ISBN: 9781259917028
Author: BLOCHER, Edward
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Question
Chapter 7, Problem 40P
To determine
Ascertain the cost allocated using each method of allocation.
Expert Solution & Answer
Explanation of Solution
a) Direct method:
Compute the base for allocation:
| Departmental Cost Allocation Bases | ||||
| Particulars | Information Technology | Administration | Education | Program Management |
| Direct labor hour | 2000 | 6000 | 4000 | 4000 |
| Direct labor percent | 12.5000% | 37.5000% | 25.0000% | 25.0000% |
| Headcount | 2 | 3 | 3 | 4 |
| Headcount percent | 16.6667% | 25.0000% | 25.0000% | 33.3333% |
| Direct costs | $6,000 | $122,000 | $100,000 | $190,000 |
Table (1)
Compute the base for allocation of indirect costs:
| Indirect labor costs | ||||
| Particulars | Information Technology | Administration | Education | Program Management |
| Direct labor hour | 2000 | 6000 | 4000 | 4000 |
| Allocation percentage | 12.5000% | 37.5000% | 25.0000% | 25.0000% |
| Allocation amount ($50,000) | $6,250 | $18,750 | $12,500 | $12,500 |
| Indirect supplies costs | ||||
| Particulars | Information Technology | Administration | Education | Program Management |
| Headcount | 2 | 3 | 3 | 4 |
| Allocation percentage | 16.6667% | 25.0000% | 25.0000% | 33.3333% |
| Allocation amount ($15,000) | $2,500 | $3,750 | $3,750 | $5,000 |
| Particulars | Information Technology | Administration | ||
| First phase allocation | $6,000 | $122,000 | ||
| Information Technology | $6,250 | $18,750 | ||
| Administration | $2,500 | $3,750 | ||
| Total Amount Allocated | $14,750 | $144,500 | ||
Table (2)
Compute the total costs allocated:
| Information Technology | ||
| Particulars | Education | Program Management |
| Service percentage | 20% | 60% |
| Allocation percentage | 25.00% | 75.00% |
| Allocation amount ($14,750) | $3,688 | $11,063 |
| Administration | ||
| Particulars | Education | Program Management |
| Service percentage | 30% | 60% |
| Allocation percentage | 33.3333% | 66.6667% |
| Allocation amount ($144,500) | $48,167 | $96,333 |
| Particulars | Education | Program Management |
| Information Technology | $3,688 | $11,063 |
| Administration | $48,167 | $96,333 |
| Total Amount Allocated | $51,854 | $107,396 |
| Particulars | Education | Program Management |
| First phase allocation | $100,000 | $190,000 |
| Indirect labor costs | $12,500 | $12,500 |
| Indirect supplies costs | $3,750 | $5,000 |
| Information Technology | $3,688 | $11,063 |
| Administration | $48,167 | $96,333 |
| Total Amount Allocated | $168,104 | $314,896 |
Table (3)
Compute the further allocation of the costs:
| Departmental Cost Allocation Bases | ||
| Particulars | Mental health | Housing |
| Direct labor hour | 2,000 | 2,000 |
| Direct labor percent | 50% | 50% |
| Headcount | 1 | 3 |
| Headcount percent | 25% | 75% |
| Education | ||
| Particulars | Mental health | Housing |
| Service percentage | 50% | 50% |
| Allocation percentage | 50% | 50% |
| Allocation amount ($168,104) | $84,052 | $84,052 |
| Program Management | ||
| Particulars | Mental health | Housing |
| Service percentage | 25% | 75% |
| Allocation percentage | 25% | 75% |
| Allocation amount ($314,896) | $78,724 | $236,172 |
| Particulars | Mental health | Housing |
| Education | $84,052 | $84,052 |
| Program Management | $78,724 | $236,172 |
| Total Amount Allocated | $162,776 | $320,224 |
Table (4)
b.1) Split-off method if info systems are split first:
Compute the base for allocation:
| Departmental Cost Allocation Bases | ||||
| Particulars | Information Technology | Administration | Education | Program Management |
| Direct labor hour | 2000 | 6000 | 4000 | 4000 |
| Direct labor percent | 12.5000% | 37.5000% | 25.0000% | 25.0000% |
| Headcount | 2 | 3 | 3 | 4 |
| Headcount percent | 16.6667% | 25.0000% | 25.0000% | 33.3333% |
| Direct costs | $6,000 | $122,000 | $100,000 | $190,000 |
| Indirect labor costs | ||||
| Particulars | Information Technology | Administration | Education | Program Management |
| Direct labor hour | 2000 | 6000 | 4000 | 4000 |
| Allocation percentage | 12.5000% | 37.5000% | 25.0000% | 25.0000% |
| Allocation amount ($50,000) | $6,250 | $18,750 | $12,500 | $12,500 |
| Indirect supplies costs | ||||
| Particulars | Information Technology | Administration | Education | Program Management |
| Headcount | 2 | 3 | 3 | 4 |
| Allocation percentage | 16.6667% | 25.0000% | 25.0000% | 33.3333% |
| Allocation amount ($15,000) | $2,500 | $3,750 | $3,750 | $5,000 |
| Particulars | Information Technology | Administration | Education | Program Management |
| First phase allocation | $6,000 | $122,000 | $100,000 | $190,000 |
| Information Technology | $6,250 | $18,750 | $12,500 | $12,500 |
| Administration | $2,500 | $3,750 | $3,750 | $5,000 |
| Total Amount Allocated | $14,750 | $144,500 | $116,250 | $207,500 |
Table (5)
Compute the costs allocated:
| Particulars | Administration | Education | Program Management |
| Service percentage | 20% | 20% | 60% |
| Allocation amount ($14,750) | $2,950 | $2,950 | $8,850 |
| Administration | |||
| Particulars | Education | Program Management | |
| Service percentage | 30% | 60% | |
| Allocation percentage | 33.3333% | 66.6667% | |
| Allocation amount ($147,450) | $49,150 | $98,300 | |
| Particulars | Education | Program Management | |
| Computer | $2,950 | $8,850 | |
| CFL Group | $49,150 | $98,300 | |
| Total Amount Allocated | $52,100 | $107,150 | |
| Particulars | Education | Program Management | |
| First phase allocation | $116,250 | $207,500 | |
| Information Technology | $2,950 | $8,850 | |
| Administration | $49,150 | $98,300 | |
| Total Amount Allocated | $168,350 | $314,650 | |
Table (6)
Compute the total costs allocated:
| Departmental Cost Allocation Bases | ||
| Particulars | Mental health | Housing |
| Direct labor hour | 2,000 | 2,000 |
| Direct labor percent | 50% | 50% |
| Headcount | 1 | 3 |
| Headcount percent | 25% | 75% |
| Education | ||
| Particulars | Mental health | Housing |
| Service percentage | 50% | 50% |
| Allocation percentage | 50% | 50% |
| Allocation amount ($168,350) | $84,175 | $84,175 |
| Program Management | ||
| Particulars | Mental health | Housing |
| Service percentage | 25% | 75% |
| Allocation percentage | 25% | 75% |
| Allocation amount ($314,650) | $78,663 | $235,988 |
| Particulars | Mental health | Housing |
| Education | $84,175 | $84,175 |
| Program Management | $78,663 | $235,988 |
| Total Amount Allocated | $162,838 | $320,163 |
Table (7)
c) Reciprocal method
Compute the base for allocation:
| Departmental Cost Allocation Bases | ||||
| Particulars | Information Technology | Administration | Education | Program Management |
| Direct labor hour | 2000 | 6000 | 4000 | 4000 |
| Direct labor percent | 12.5000% | 37.5000% | 25.0000% | 25.0000% |
| Headcount | 2 | 3 | 3 | 4 |
| Headcount percent | 16.6667% | 25.0000% | 25.0000% | 33.3333% |
| Direct costs | $6,000 | $122,000 | $100,000 | $190,000 |
| Indirect labor costs | ||||
| Particulars | Information Technology | Administration | Education | Program Management |
| Direct labor hour | 2000 | 6000 | 4000 | 4000 |
| Allocation percentage | 12.5000% | 37.5000% | 25.0000% | 25.0000% |
| Allocation amount ($50,000) | $6,250 | $18,750 | $12,500 | $12,500 |
| Indirect supplies costs | ||||
| Particulars | Information Technology | Administration | Education | Program Management |
| Headcount | 2 | 3 | 3 | 4 |
| Allocation percentage | 16.6667% | 25.0000% | 25.0000% | 33.3333% |
| Allocation amount ($15,000) | $2,500 | $3,750 | $3,750 | $5,000 |
| Particulars | Information Technology | Administration | Education | Program Management |
| First phase allocation | $6,000 | $122,000 | $100,000 | $190,000 |
| Information Technology | $6,250 | $18,750 | $12,500 | $12,500 |
| Administration | $2,500 | $3,750 | $3,750 | $5,000 |
| Total Amount Allocated | $14,750 | $144,500 | $116,250 | $207,500 |
Table (8)
Compute the costs allocated:
| Information Technology | ||
| Particulars | Education | Program Management |
| Allocation percentage | 20% | 60% |
| Allocation amount ($29,795.92) | $5,959 | $17,878 |
| Administration | ||
| Particulars | Education | Program Management |
| Allocation percentage | 30% | 60% |
| Allocation amount ($150,459.18) | $45,138 | $90,276 |
| Particulars | Education | Program Management |
| Information Technology | $5,959 | $17,878 |
| Administration | $45,138 | $90,276 |
| Total Amount Allocated | $51,097 | $108,153 |
| Particulars | Education | Program Management |
| First phase allocation | $116,250 | $207,500 |
| Information Technology | $5,959 | $17,878 |
| Administration | $45,138 | $90,276 |
| Total Amount Allocated | $167,347 | $315,653 |
Table (9)
Compute the total costs allocated:
| Departmental Cost Allocation Bases | ||
| Particulars | Mental health | Housing |
| Direct labor hour | 2,000 | 2,000 |
| Direct labor percent | 50% | 50% |
| Headcount | 1 | 3 |
| Headcount percent | 25% | 75% |
| Education | ||
| Particulars | Mental health | Housing |
| Allocation percentage | 50% | 50% |
| Allocation amount ($167,347) | $83,674 | $83,674 |
| Program Management | ||
| Particulars | Mental health | Housing |
| Allocation percentage | 25% | 75% |
| Allocation amount ($315,653) | $78,913 | $236,740 |
| Particulars | Mental health | Housing |
| Education | $83,674 | $83,674 |
| Program Management | $78,913 | $236,740 |
| Total Amount Allocated | $162,587 | $320,413 |
Table (10)
Compute the base for allocation:
| Reciprocal Cost allocation Using Solver | |||||
| Particulars | Allocated costs | Service rates to | Allocation to | ||
| CFL Group | Computer | CFL Group | Computer | ||
| Information Technology | $29,795.92 | 1.00 | (0.20) | $29,796 | ($5,959) |
| Administration | $150,459.18 | (0.10) | 1.00 | ($15,046) | $150,459 |
| Total | $14,750 | $144,500 | |||
Table (11)
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
What is the applied overhead?
What is the earnings per share ?
Accounting
Chapter 7 Solutions
Cost Management
Ch. 7 - Prob. 1QCh. 7 - Explain the difference between joint products and...Ch. 7 - Prob. 3QCh. 7 - What are the three methods of departmental cost...Ch. 7 - Prob. 5QCh. 7 - Prob. 6QCh. 7 - Prob. 7QCh. 7 - What are the limitations of joint product and...Ch. 7 - Prob. 9QCh. 7 - Prob. 10Q
Ch. 7 -
What is the amount of service department cost...Ch. 7 - Prob. 12BECh. 7 - Prob. 13BECh. 7 - Prob. 14BECh. 7 - Prob. 15BECh. 7 - Prob. 16BECh. 7 - Prob. 17BECh. 7 - Prob. 18BECh. 7 - Prob. 19BECh. 7 - Brief Exercises 7-17 through 7-20 require the...Ch. 7 - Prob. 21ECh. 7 - Prob. 22ECh. 7 - Prob. 23ECh. 7 - Prob. 24ECh. 7 - Great Ape Glassworks manufactures glass used for...Ch. 7 - Cost allocation is often the centerpiece of...Ch. 7 - Prob. 27ECh. 7 - Prob. 28ECh. 7 - Robinson Products Company has two service...Ch. 7 - Donation of blood through the American Red Cross...Ch. 7 - Tango Company produces joint products M, N, and T...Ch. 7 - Arkansas Corporation manufactures liquid chemicals...Ch. 7 - Webster Company produces 25,000 units of product...Ch. 7 - Marin Company produces two software products...Ch. 7 - Logan Products has two production...Ch. 7 - McKeoun Enterprises is a large machine tool...Ch. 7 - Barfield Corporation prepares business plans and...Ch. 7 - Solexx Corporation allocates its service...Ch. 7 - Prob. 39PCh. 7 - Prob. 40PCh. 7 - Prob. 41PCh. 7 - Prob. 42PCh. 7 - Prob. 43PCh. 7 - Prob. 44PCh. 7 - Prob. 45PCh. 7 - Prob. 46PCh. 7 - Prob. 47PCh. 7 - Prob. 48PCh. 7 - Prob. 49PCh. 7 - Prob. 50P
Knowledge Booster
Similar questions
- Express Delivery Company (EDC) is considering outsourcing its Payroll Department to a payroll processing company for an annual fee of $220,800. An internally prepared report summarizes the Payroll Department’s annual operating costs as follows: Supplies $ 30,800 Payroll clerks’ salaries 120,800 Payroll supervisor’s salary 58,800 Payroll employee training expenses 10,800 Depreciation of equipment 20,800 Allocated share of common building operating costs 15,800 Allocated share of common administrative overhead 28,800 Total annual operating cost $ 286,600 EDC currently rents overflow office space for $36,800 per year. If the company closes its Payroll Department, the employees occupying the rented office space could be brought in-house and the lease agreement on the rented space could be terminated with no penalty. If the Payroll Department is outsourced the payroll clerks will not be retained; however, the supervisor would be transferred to the company’s Human…arrow_forwardThalassines Kataskeves, S.A., of Greece makes marine equipment. The company has been experiencing losses on its bilge pump product line for several years. The most recent quarterly contribution format income statement for the bilge pump follows: Thalassines Kataskeves, S.A. Income Statement—Bilge Pump For the Quarter Ended March 31 Sales $ 410,000 Variable expenses: Variable manufacturing expenses $ 123,000 Sales commissions 50,000 Shipping 21,000 Total variable expenses 194,000 Contribution margin 216,000 Fixed expenses: Advertising (for the bilge pump product line) 27,000 Depreciation of equipment (no resale value) 120,000 General factory overhead 38,000* Salary of product-line manager 113,000 Insurance on inventories 5,000 Purchasing department 49,000† Total fixed expenses 352,000 Net operating loss $ (136,000) *Common costs allocated on the basis of machine-hours. †Common costs allocated on the basis of…arrow_forwardDo companies maintain two sets of depreciation schedules, one for financial reporting and the other one for tax purposes?arrow_forward
- none ??arrow_forwardNeed help with this accounting questionsarrow_forwardCarichem Company produces sanitation products after processing specialized chemicals. The following relates to its activities: 1 Kilogram of chemicals purchased for $4000 and with an additional $2000 is processed into 400 grams of Crystals and 80 litres of a Cleaning agent. At split-off, a gram of Crystal can be sold for $2 and the Cleaning agent can be sold for $8 per litre. At an additional cost of $800, Carichem can process the 400 grams of Crystal into 500 grams of Detergent that can be sold for $4 per gram. The 80 litres of Cleaning agent is packaged at an additional cost of $600 and made into 200 packs of Softener that can be sold for $4 per pack. Required: 1. Allocate the joint cost to the Detergent and the Softener using the following: a. Sales value at split-off method b. NRV method 2. Should Carichem have processed each of the products further? What effect does the allocation method have on this decision?arrow_forward
- Please provide correct solution this financial accounting questionarrow_forwardAllocate the two support departments’ costs to the two operating departments using the following methods: a. Direct method b. Step-down method (allocate HR first) c. Step-down method (allocate IS first) d. The Algebraic method.arrow_forwardCan you help me with accounting questionsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education