| Computation of unit cost for each product using ABC:- | ||||||
| Computation of Activity rate using activity based costing system:- | ||||||
| Activity Cost Pool | Activity measures | Estimated Overhead Cost | Activity Level | Activity Rate | ||
| Total | ||||||
| a | b | c | d | e = c/d | ||
| Supervision | Direct labor Cost ($) | $2,148 | $ 17,900 | $0.12 | per $ of direct labor cost | |
| Depreciation of Machinery | Machine hours | $28,680 | 800 | $35.85 | per machine hour | |
| Assembly Line Preparation | Setups (number) | $22,872 | 124 | $184.45 | per time | |
| Total Manufacturing Overhead Cost | $53,700 | |||||
| Computation of unit product cost using activity based costing system:- | ||||||
| Computation of Overhead Cost :- | ||||||
| Overhead Assigned | Activity Driver | Activity Rate | Total Overhead Cost | |||
| a | b | c | d = b×c | |||
| Rounded Edge | ||||||
| Supervision | $ 6,000 | Direct labor Cost ($) | $0.12 | $720 | ||
| Depreciation of Machinery | 200 | Machine hours | $35.85 | $7,170 | ||
| Assembly Line Preparation | 30 | Setups (number) | $184.45 | $5,534 | ||
| Total | $13,424 | |||||
| Squared Edge | ||||||
| Supervision | $ 11,900 | Direct labor Cost ($) | $0.12 | $1,428 | ||
| Depreciation of Machinery | 600 | Machine hours | $35.85 | $21,510 | ||
| Assembly Line Preparation | 94 | Setups (number) | $184.45 | $17,338 | ||
| Total | $40,276 | |||||
| Computation of Manufacturing Cost Per unit | ||||||
| Rounded Edge | Squared Edge | |||||
| Direct Material Cost | $9,400 | $21,600 | ||||
| Direct labor Cost | $6,000 | $11,900 | ||||
| Supervision | $720 | $1,428 | ||||
| Depreciation of Machinery | $7,170 | $21,510 | ||||
| Assembly Line Preparation | $5,534 | $17,338 | ||||
| Total Cost | $28,824 | $73,776 | ||||
| Quantity Produced (ft.) | 10400 | 14000 | ||||
| Per Unit Cost | $2.77 | $5.27 | ||||
Feel free to ask any clarification, if required. Kindly
provide feedback by thumbs up, if satisfied. It will be highly
appreciated.
Thank you.
4 Glassworks Inc. produces two types of glass shelving. rounded edge and squared edge, on the same production line....
Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. Rounded Edge Squared Edge $21,700 11,900 35,700 $69,300 Total Direct materials $9,400 31,100 17,900 53,700 Direct labor 6,000 Overhead (300% of direct labor cost) 18,000 $33,400 $102,700 Total cost 10,600 ft. $ 3.15 Quantity produced 14,100 ft 4.91 Average cost per ft. (rounded) Glassworks's controller wishes to apply activity-based costing (ABC) to...
Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. Rounded Edge Squared Edge Total Direct materials $ 9,600 $ 21,700 $ 31,300 Direct labor 6,000 11,900 17,900 Overhead (300% of direct labor cost) 18,000 35,700 53,700 Total cost $ 33,600 $ 69,300 $ 102,900 Quantity produced 10,300 ft. 14,100 ft. Average cost per ft. (rounded) $ 3.26 $ 4.91 Glassworks's...
Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. Direct materials $ 9,600 $ 21,600 $ 31,200 Direct labor 6,000 11,900 17,900 Overhead (300% of direct labor cost) 18,000 35,700 53,700 Total cost $ 33,600 $ 69,200 $ 102,800 Quantity produced 10,400 ft. 14,000 ft. Average cost per ft. (rounded) $ 3.23 $ 4.94 Glassworks's controller wishes to apply activity-based...
Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. Direct materials Direct labor Overhead (3008 of direct labor cost) Total cost Quantity produced Average cost per ft. (rounded) Rounded Edge $ 9, 700 6.100 18,300 $34,100 10,300 ft. $ 3.31 Squared Edge Total $21,700 $ 31,400 11.900 18.000 35,700 54,000 $69,300 $103,400 14,000 ft. S 4.95 Glassworks's controller wishes to apply...
Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. Direct materials Direct labor Overhead (300% of direct labor cost) Total cost Quantity produced Average cost per ft. (rounded) Rounded Edge $ 9,600 6,200 18.600 $34,400 10,500 ft. $ 3.28 Squared Edge Total $21,500 $ 31,100 11,900 18,100 35,700 54,300 $69,100 $103,500 14,200 ft. $ 4.87 Glassworks's controller wishes to apply activity-based...
Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data 630, 900 $21,400 11.900 Direct materials Direct Labor Overhead (3001 or direct labor coat) Total cost Quantity produced Average cost per ft. (rounded) 633.500 6102.500 669.000 24.100 Glassworks's controller wishes to apply activity based costing (ABC) to allocate the $53,700 of overhead costs incurred by the two product lines to see whether...
Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. Direct materials Direct labor Overhead (382% of direct labor cost) Total cost Quantity produced Average cost per ft. (rounded) Rounded Edge $ 9,500 6.100 18,388 $ 33,982 10,688 ft. $ 3.20 Squared Edge Total $ 21,500 $ 31,000 11,900 18,00 35.700 54,00 $ 69,182 $183,888 14,288 ft. $ 4.87 Glassworks's controller wishes...
Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data Direct materials Direct labor Overhead (300x of direct labor cost) Total cost Quantity produced Average cost per ft. (rounded) Rounded Edge $ 9,600 6,100 18,309 534,000 10,700 ft. $ 3.18 Squared Edge Total $21,800 $ 31,400 11,900 18.000 35,700 54,000 569,400 $103, 400 14,200 ft. Glassworks's controller wishes to apply activity-based costing...
Glassworks Inc. produces two types of glass shelving, rounded
edge and squared edge, on the same production line. For the current
period, the company reports the following data.
Glassworks's controller wishes to apply activity-based costing
(ABC) to allocate the $54,000 of overhead costs incurred by the two
product lines to see whether cost per foot would change markedly
from that reported above. She has collected the following
information. She has also collected the following information about
the cost drivers for...
Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data. Rounded Edge $ 9,300 6.200 Direct materials Direct labor Overhead (300 of direct labor cost) Total cost Quantity produced Average cost per ft. (rounded) 18,600 $34,100 10,600 ft. Squared Edge Total $21.500 11.00 18.000 35,400 $103,100 14,100 ft. Glassworks's controller wishes to apply activity based costing (ABC) to allocate the $54,000 of...