In: Accounting
The following data are for the two products produced by Tadros
Company.
| Product A | Product B | ||||
| Direct materials | $ | 14 per unit | $ | 25 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 | 100 batches | 200 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 | $ | 120 per unit | |
The company's direct labor rate is $20 per direct labor hour (DLH).
Additional information follows.
| Costs | Driver | |||
| Indirect manufacturing | ||||
| Engineering support | $ | 23,500 | Engineering modifications | |
| Electricity | 36,000 | Machine hours | ||
| Setup costs | 40,000 | Batches | ||
| Nonmanufacturing | ||||
| Customer service | 73,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.)
| Thank you for your patience. Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
| Tadros Company | ||
| Total Manufacturing overhead | Amount $ | Note |
| Engineering Support | 23,500.00 | |
| Electricity cost | 36,000.00 | |
| Setup costs | 40,000.00 | |
| Total Manufacturing overhead | 99,500.00 | A |
| Answer 1 | ||||
| Calculation of Predetermined OH Rate | Product A | Product B | Total | |
| Volume | 10,000.00 | 2,000.00 | B | |
| Direct Labor Hour Per unit | 0.50 | 1.50 | C | |
| Total Direct Labor Hours | 5,000.00 | 3,000.00 | 8,000.00 | D=B*C |
| Total Manufacturing overhead | 99,500.00 | See A | ||
| Predetermined OH Rate | 12.44 | F=A/D | ||
| Allocated OH per unit | 6.22 | 18.66 | G=F*C |
| Direct Labor cost per hour | 20.00 | 20.00 | H |
| Direct Labor cost per unit | 10.00 | 30.00 | I=H*C |
| Total manufacturing cost | Product A | Product B | |
| Direct Materials | 14.00 | 25.00 | |
| Direct Labor | 10.00 | 30.00 | See I |
| Allocated OH per unit | 6.22 | 18.66 | See G |
| Total manufacturing cost | 30.22 | 73.66 | J |
| Answer 1.2 | Product A | Product B | |
| Marker price | 34.00 | 120.00 | K |
| Manufacturing cost per unit | 30.22 | 73.66 | See J |
| Gross profit per unit | 3.78 | 46.34 | L=K-J |
| Answer 2.1 | |||
| Units purchased per customer | Product A | Product B | |
| Volume | 10,000.00 | 2,000.00 | See B |
| Number of customer | 500.00 | 400.00 | M |
| Units purchased per customer | 20.00 | 5.00 | N=B/M |
| Gross profit generated by each customer | Product A | Product B | |
| Gross profit per unit | 3.78 | 46.34 | See L |
| Units purchased per customer | 20.00 | 5.00 | See N |
| Gross profit per customer | 76.00 | 232.00 | O=L*N |
| Answer 2.2 | ||||
| Customer service cost per customer | Product A | Product B | Total | |
| Number of customer | 500.00 | 400.00 | 900.00 | P |
| Customer costs | 73,000.00 | Q | ||
| Customer service cost per customer | 81.11 | R=Q/P | ||
| Product A | Product B | |||
| Gross profit per customer | 76.00 | 232.00 | See O | |
| Customer service cost per customer | 81.11 | 81.11 | See R | |
| Profit (loss) per customer | (5.11) | 150.89 | S=O-R | |
| Profit is positive so profit is adequate. | ||||
| Answer 3.1 | ||||
| Calculation of machine hours | Product A | Product B | Total | |
| Volume | 10,000.00 | 2,000.00 | See B | |
| Machine Hour Per unit | 0.50 | 1.10 | T | |
| Total machine hours | 5,000.00 | 2,200.00 | 7,200.00 | U=B*T |
| Calculation of ABC rates for overhead | V | W | X | Y=W+X | Z=V/Y | |
| Activity usage | ||||||
| Activity cost pool | Activity Measure | Cost | Product A | Product B | Total | ABC rates |
| Engineering Support | Engineering modifications | 23,500.00 | 10.00 | 50.00 | 60.00 | 391.67 |
| Electricity cost | Machine Hours | 36,000.00 | 5,000.00 | 2,200.00 | 7,200.00 | 5.00 |
| Setup costs | Batches | 40,000.00 | 100.00 | 200.00 | 300.00 | 133.33 |
| Total Cost assigned | 99,500.00 | |||||
| Allocation table | |||||
| Product A | See Z | See W | AA=Z*W | ||
| Activity cost pool | Activity Measure | ABC Rates | Activity used | Cost assigned | |
| Engineering Support | Engineering modifications | 391.67 | 10.00 | 3,916.70 | |
| Electricity cost | Machine Hours | 5.00 | 5,000.00 | 25,000.00 | |
| Setup costs | Batches | 133.33 | 100.00 | 13,333.00 | |
| Total Cost assigned | 42,249.70 | AB | |||
| Units produced | 10,000.00 | See B | |||
| Costs per unit | 4.22 | AC=AB/B | |||
| Product B | See Z | See W | AA=Z*W | ||
| Activity cost pool | Activity Measure | ABC Rates | Activity used | Cost assigned | |
| Engineering Support | Engineering modifications | 391.67 | 50.00 | 19,583.50 | |
| Electricity cost | Machine Hours | 5.00 | 2,200.00 | 11,000.00 | |
| Setup costs | Batches | 133.33 | 200.00 | 26,666.00 | |
| Total Cost assigned | 57,249.50 | AB | |||
| Units produced | 2,000.00 | See B | |||
| Costs per unit | 28.62 | AC=AB/B |
| Total manufacturing cost | Product A | Product B | |
| Direct Materials | 14.00 | 25.00 | |
| Direct Labor | 10.00 | 30.00 | See I |
| Allocated OH per unit | 4.22 | 28.62 | See AC |
| Total manufacturing cost | 28.22 | 83.62 | AD |
| Answer 3.2 | Product A | Product B | |
| Marker price | 34.00 | 120.00 | K |
| Manufacturing cost per unit | 28.22 | 83.62 | See AD |
| Gross profit per unit | 5.78 | 36.38 | AE=K-D |
| Answer 4.1 | |||
| Gross profit generated by each customer | Product A | Product B | |
| Gross profit per unit | 5.78 | 36.38 | See AE |
| Units purchased per customer | 20.00 | 5.00 | See N |
| Gross profit per customer | 116.00 | 182.00 | AF=AE*N |
| Answer 4.2 | Product A | Product B | |
| Gross profit per customer | 116.00 | 182.00 | See AF |
| Customer service cost per customer | 81.11 | 81.11 | See R |
| Profit (loss) per customer | 34.89 | 100.89 | AG=AF-R |
| Profit is positive so profit is adequate. |
| Answer 5 |
| ABC costing is better. |