COST MANAGEMENT: A STRATEGIC EMPHASIS E
8th Edition
ISBN: 9781260912449
Author: BLOCHER
Publisher: MCG
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 labor rate variance for the month?
Kenwood would repya gross profit of
United Airlines reported the following (in
millions):
• Service cost = $520
• Interest on P. B. O.
=
$910
=
$700
• Return on plan assets
• Amortization of prior service cost
• Amortization of net loss
=
$140
=
$22
Compute United Airlines' pension expense.
Chapter 7 Solutions
COST MANAGEMENT: A STRATEGIC EMPHASIS E
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
- Answer?arrow_forwardA firm has $4 million in average inventories, $2 million in average accounts payable, a receivables period of 45 days, and an annual cost of goods sold of $22 million. What is the cash conversion cycle for the firm?arrow_forwardSamantha's Boutique has annual net sales of $6.5 million and maintains a markup of 20% based on cost. The boutique's expenses average 12% of net sales. What is Samantha's gross profit and net profit in dollars?arrow_forward
- Step by Step Answerarrow_forwardAt the start of the current year, Spotify Corp. purchased 25% of Skyline Technologies Inc. for $50 million. At the time of purchase, the carrying value of Skyline Technologies' net assets was $80 million. The fair value of Skyline Technologies' depreciable assets was $20 million in excess of their book value. For this year, Skyline Technologies reported a net income of $72 million and declared and paid $18 million in dividends. What is the amount of purchased goodwill?arrow_forwardCorrect Answerarrow_forward
- Need solution to this financial accounting prblmarrow_forwardA car dealership requires that salespeople generate a minimum selling cost of 6.5% to justify their salaries. If a salesperson earns $24,000 per year, how much must they sell to justify their earnings?arrow_forwardCharm Industries is a job lot manufacturer. The budget for the month of July calls for 7,500 direct labor hours to be worked. Budgeted overhead is $75,000 with a predetermined rate of $9 per hour. Overhead is applied based on actual direct hours worked. Actual direct hours were 7,800 and actual overhead spending was $85,500. What was the under-applied or over-applied overhead for the month of July? Over-applied is shown as a negative number. Nonearrow_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