In: Accounting
Product-Costing Accuracy, Plantwide and Departmental Rates, ABC
Escuha Company produces two type of calculators: scientific and business. Both products pass through two producing departments. The business calculator is by far the most popular. The following data have been gathered for these two products:
| Product-Related Data | ||
| Scientific | Business | |
| Units produced per year | 75,000 | 750,000 |
| Prime costs | $235,000 | $2,350,000 |
| Direct labor hours | 97,800 | 978,000 |
| Machine hours | 50,600 | 506,000 |
| Production runs | 100 | 150 |
| Inspection hours | 2,000 | 3,000 |
| Maintenance hours | 2,250 | 9,000 |
| Department Data | ||
| Department 1 | Department 2 | |
| Direct labor hours: | ||
| Scientific calculator | 72,900 | 24,900 |
| Business calculator | 97,800 | 880,200 |
| Total | 170,700 | 905,100 |
| Machine hours: | ||
| Scientific calculator | 25,200 | 25,400 |
| Business calculator | 393,120 | 112,880 |
| Total | 418,320 | 138,280 |
| Overhead costs: | ||
| Setup costs | $236,000 | $236,000 |
| Inspection costs | 170,000 | 170,000 |
| Power | 244,000 | 134,000 |
| Maintenance | 210,000 | 228,750 |
| Total | $860,000 | $768,750 |
Required:
1. Compute the overhead cost per unit for each product using a plantwide, unit-based rate using direct labor hours. Round your calculations and answers to the nearest cent.
| Plantwide rate | $ per direct labor hour |
| Overhead cost per unit: | |
| Scientific | $ per unit |
| Business | $ per unit |
2. Compute the overhead cost per unit for each product using departmental rates. In calculating departmental rates, use machine hours for Department 1 and direct labor hours for Department 2. Round departmental rates and the overhead cost per unit to the nearest cent if rounding is required.
| Departmental rates: | |
| Department 1 | $ per machine hour |
| Department 2 | $ per direct labor hour |
| Overhead cost per unit: | |
| Scientific | $ per unit |
| Business | $ per unit |
Repeat using direct labor hours for Department 1 and machine hours for Department 2. Round departmental rates and the overhead cost per unit to the nearest cent if rounding is required.
| Departmental rates: | |
| Department 1 | $ per direct labor hour |
| Department 2 | $ per machine hour |
| Overhead cost per unit: | |
| Scientific | $ per unit |
| Business | $ per unit |
3. Compute the overhead cost per unit for each product using activity-based costing. Round your calculations and answers to the nearest cent.
| Overhead Cost | |
| Scientific | $ per unit |
| Business | $ per unit |
1) Budgeted Overhead per labour hour = ($860000+$768750)/(170700+905100)
= $1628750/1075800
= $1.514
Overhead Cost Per Unit for each Product :-
Scientific = ($1.514 * 97800) / 75000 = $1.97 per unit
Business = ($1.514 * 978000) / 750000 = $1.97 per unit
2) a. Machine hours for department 1 and Direct labor hours for Department 2.
Dept. 1 = Overhead Cost / Machine Hours
= $860000/ 418320 H
= $2.06 Par Machine Hour
Dept. 2 = Overhead Cost / Direct Labor Hours
= $768750 / $905100
= $0.85 Per Labor Hour
Scientific = ($2.06*25200 + $0.85*24900) / 75000
= ($51912 + $21165) / 75000
= $0.974 per unit
Business = ($2.06*393120 + $0.85*880200) / 750000
= ($809827 + $748170) / 750000
= $2.08 Per unit
b)
Dept. 1 = Overhead Cost / Direct Labor Hour
= $860000/ 170700 H
= $5.04 Par Direct Labor Hour
Dept. 2 = Overhead Cost / Machine Hours
= $768750 / $138280
= $5.56 Per Machine Hour
Scientific = ($5.04*72900 + $5.56*25400) / 75000
= ($367416 + $141224) / 75000
= $6.78 per unit
Business = ($5.04*97800 + $5.56*112880) / 750000
= ($492912 + $627613) / 750000
= $1.49 Per unit
3)
| Activty | cost driver | Total Cost | Scientific | Business |
| Set up cost | No of Production run (0.4 : 0.6) | 472000 | 188800 | 283200 |
| Inspection cost | Inspection Hours (0.4 : 0.6) | 340000 | 136000 | 204000 |
| Power | Machine Hours(1 : 11) | 378000 | 34364 | 343636 |
| Maintenance | Maintenance Hour(0.2 : 0.8) | 438750 | 87750 | 351000 |
| Total (A) | 1628750 | 446914 | 1181836 | |
| No. of Units (B) | 825000 | 75000 | 750000 | |
| Cost Per Unit (A/B) | $5.96 | $1.58 |