Réquired: A. Prepare overhead analysis sheet to determine the total overhead allocated to production departments. NB: Round all figures up to the nearest whole number. B. Calculate the overhead absorption rates using an appropriate base C. Assuming PTS manufactures two products: Mang and Banny. Mang has a direct cost of $100. It's manufacturing process uses 10 hours in Mixing, 10 hours in Assembly and 2 hours in finishing department. Banny has a direct cost of $200 and each unit requires 10 hours in Mixing, 20 hours in Assembly and 20 hours in Finishing. Calculate the manufacturing costs assigned to each unit of product.

Financial & Managerial Accounting
14th Edition
ISBN:9781337119207
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Carl Warren, James M. Reeve, Jonathan Duchac
Chapter18: Activity-Based Costing
Section: Chapter Questions
Problem 18.15EX: Activity-based costing and product cost distortion The management of Four Finger Appliance Company...
icon
Related questions
Question
QUESTION 4
PTS Ltd is a manufacturing company which uses three production and three service departments to make its
products. It has the following overhead costs from primary distribution.
Production Departments:
Mixing $234,980
Assembly $345,900
Finishing $134,525
Service Departments:
Stores $120,354
Accounts $238,970
Canteen $ 89,700
Other overhead costs which are yet to be distributed are as follows:
Factory rent
2,685,500
Business rates
$ 3,450,900
Heat and lighting $ 985,350
Machinery power
Depreciation
Canteen subsidy
$ 2,890,600
$ 600,000
$ 256,000
The basis of apportioning the overheard cost is given as follows:
Mix
As
Fin
Stor
Acct
Can
Number of employees
Floor area occupied (m sq)
50
60
18
6
12
24
1,800
1,400
800
1000
400
600
Horse power of machine 13,000 500
Value of machine ($'000) 250
6,500
200
100
400
30
120
50
20
30
Overheads allocated to service departments are redistributed to the production departments as follows:
Mix
Ass
Fin
Stores
50%
30%
20%
Accounts
15%
25%
60%
Canteen
25%
55%
20%
Labour hours (000)
100
140
35
Machine hours (000)
200
36
90
Required:
A. Prepare overhead analysis sheet to determine the total overhead allocated to production departments.
NB: Round all figures up to the nearest whole number.
B. Calculate the overhead absorption rates using an appropriate base
C. Assuming PTS manufactures two products: Mang and Banny.
Mang has a direct cost of $100. It's manufacturing process uses 10 hours in Mixing, 10 hours in Assembly and 2 hours
in finishing department. Banny has a direct cost of $200 and each unit requires 10 hours in Mixing, 20 hours in
Assembly and 20 hours in Finishing. Calculate the manufacturing costs assigned to each unit of product.
Transcribed Image Text:QUESTION 4 PTS Ltd is a manufacturing company which uses three production and three service departments to make its products. It has the following overhead costs from primary distribution. Production Departments: Mixing $234,980 Assembly $345,900 Finishing $134,525 Service Departments: Stores $120,354 Accounts $238,970 Canteen $ 89,700 Other overhead costs which are yet to be distributed are as follows: Factory rent 2,685,500 Business rates $ 3,450,900 Heat and lighting $ 985,350 Machinery power Depreciation Canteen subsidy $ 2,890,600 $ 600,000 $ 256,000 The basis of apportioning the overheard cost is given as follows: Mix As Fin Stor Acct Can Number of employees Floor area occupied (m sq) 50 60 18 6 12 24 1,800 1,400 800 1000 400 600 Horse power of machine 13,000 500 Value of machine ($'000) 250 6,500 200 100 400 30 120 50 20 30 Overheads allocated to service departments are redistributed to the production departments as follows: Mix Ass Fin Stores 50% 30% 20% Accounts 15% 25% 60% Canteen 25% 55% 20% Labour hours (000) 100 140 35 Machine hours (000) 200 36 90 Required: A. Prepare overhead analysis sheet to determine the total overhead allocated to production departments. NB: Round all figures up to the nearest whole number. B. Calculate the overhead absorption rates using an appropriate base C. Assuming PTS manufactures two products: Mang and Banny. Mang has a direct cost of $100. It's manufacturing process uses 10 hours in Mixing, 10 hours in Assembly and 2 hours in finishing department. Banny has a direct cost of $200 and each unit requires 10 hours in Mixing, 20 hours in Assembly and 20 hours in Finishing. Calculate the manufacturing costs assigned to each unit of product.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Cost allocation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781337119207
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning