In: Accounting
The following data are for the two products produced by Tadros
Company.
| Product A | Product B | ||||
| Direct materials | $ | 14 per unit | $ | 24 per unit | |
| Direct labor hours | 0.6 DLH per unit | 1.5 DLH per unit | |||
| Machine hours | 0.5 MH per unit | 1.1 MH per unit | |||
| Batches | 125 batches | 250 batches | |||
| Volume | 10,000 units | 2,000 units | |||
| Engineering modifications | 10 modifications | 50 modifications | |||
| Number of customers | 500 customers | 400 customers | |||
| Market price | $ | 34 per unit | $ | 95 per unit per unit | |
The company's direct labor rate is $20 per direct labor hour (DLH).
Additional information follows.
| Costs | Driver | |||
| Indirect manufacturing | ||||
| Engineering support | $ | 22,500 | Engineering modifications | |
| Electricity | 28,800 | Machine hours | ||
| Setup costs | 41,000 | Batches | ||
| Nonmanufacturing | ||||
| Customer service | 74,000 | Number of customers | ||
Required:
(Round your per unit cost answers to 2 decimal places and other
answers to nearest whole number. Loss amounts should be indicated
with minus sign.)
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5. Which method of product costing gives better
information to managers of this company?
Departmental overhead rate method
Activity-based costing method
Plantwide overhead rate method
Solution 1.1:
| Computation of overhead rate and Overhead assignment to product - (Plantwide overhead rate) | |||
| Particulars | Product A | Product B | Total |
| Direct labor hours per unit | 0.6 | 1.5 | |
| Volume (In Units) | 10000 | 2000 | |
| Direct Labor hours | 6000 | 3000 | $9,000.00 |
| Manufacturing overhead | $92,300.00 | ||
| Overehead rate - Per direct labor dollar (Manufacturing overhead/Direct labor) | $10.26 | ||
| Overhead allocation | $61,533 | $30,767 | $92,300 |
| Overhead cost per unit | $6.15 | $15.38 | |
| Computation of per unit cost (Plantwide overhead rate) | ||
| Particulars | Product A | Product B |
| Direct material | $14.00 | $24.00 |
| Direct Labor | $12.00 | $30.00 |
| Manufacturing overhead | $6.15 | $15.38 |
| Unit product cost | $32.15 | $69.38 |
Solution 1.2 and 2.1:
| Computation of Gross Profit Per unit & Gross Profit generated by each customer (Planwide overhead rate) | ||
| Particulars | Product A | Product B |
| Selling Price | $34.00 | $95.00 |
| Product cost | $32.15 | $69.38 |
| Gross Profit Per unit | $1.85 | $25.62 |
| Volume | 10000 | 2000 |
| Number of customer | 500 | 400 |
| Units purchased per customer | 20 | 5 |
| Gross Profit per customer | $36.93 | $128.08 |
Solution 2.2:
| Computation of cost of providing customer service to each customer & Adequacy of Gross Profit | |||
| Particulars | Product A | Product B | Total |
| Customer service cost | $74,000.00 | ||
| Number of customer | 500 | 400 | 900 |
| Cost of customer service to each customer | $82.22 | ||
| Gross Profit per customer | $36.93 | $128.08 | |
| Cost of customer service to each customer | $82.22 | $82.22 | |
| Profit (Loss) per customer | -$45.29 | $45.86 | |
| Is the profit adequate | No | Yes | |
Solution 3.1:
| Computation of overhead assigned to product & Overehead cost per unit- Activity Based Costing | ||||||||
| Activity | Cost | Cost Driver | Qty of cost driver | Allocation rate | Product A | Product B | ||
| Allocation Qty | Allocated Overhead | Allocation Qty | Allocated Overhead | |||||
| Engineering Support | $22,500.00 | Engineering Modification | 60 | $375.00 | 10 | $3,750.00 | 50 | $18,750.00 |
| Electricity | $28,800.00 | Machine hours | 7200 | $4.00 | 5000 | $20,000.00 | 2200 | $8,800.00 |
| Setup Cost | $41,000.00 | Batches | 375 | $109.33 | 125 | $13,666.67 | 250 | $27,333.33 |
| Total | $92,300.00 | $37,416.67 | $54,883.33 | |||||
| Volume (In units) | 10000 | 2000 | ||||||
| Overhead cost per unit | $3.74 | $27.44 | ||||||
| Computation of per unit cost (ABC) | ||
| Particulars | Product A | Product B |
| Direct material | $14.00 | $24.00 |
| Direct Labor | $12.00 | $30.00 |
| Manufacturing overhead | $3.74 | $27.44 |
| Product cost | $29.74 | $81.44 |
Solution 3.2 and 4.1:
| Computation of Gross Profit Per unit & Gross Profit generated by each customer (ABC) | ||
| Particulars | Product A | Product B |
| Selling Price | $34.00 | $95.00 |
| Product cost | $29.74 | $81.44 |
| Gross Profit Per unit | $4.26 | $13.56 |
| Volume | 10000 | 2000 |
| Number of customer | 500 | 400 |
| Units purchased per customer | 20 | 5 |
| Gross Profit per customer | $85.17 | $67.79 |
Solution 4.2:
| Computation of adequacy of Gross Profit | ||
| Particulars | Product A | Product B |
| Gross Profit per customer | $85.17 | $67.79 |
| Cost of customer service to each customer | $82.22 | $82.22 |
| Profit (Loss) per customer | $2.95 | -$14.43 |
| Is the profit adequate | Yes | No |
Solution 5:
Activity based costing method gives better information ot manager of this company