Activity-Based Costing
Zeus Industries manufactures two types of electrical power units, custom and standard, which involve four factory overhead activities—production setup, procurement, quality control, and materials management. An activity analysis of the overhead revealed the following estimated activity costs and activity bases for these activities:
| Activity | Activity Cost | Activity Base | |
| Production setup | $ 100,000 | Number of setups | |
| Procurement | 104,500 | Number of purchase orders (PO) | |
| Quality control | 165,000 | Number of inspections | |
| Materials management | 164,000 | Number of components | |
| Total | $533,500 | ||
The activity-base usage quantities for each product are as follows:
| Setups | Purchase Orders |
Inspections | Components | Unit Volume | ||||||
| Custom | 500 | 1,000 | 2,000 | 450 | 1,000 | |||||
| Standard | 300 | 100 | 200 | 350 | 1,000 | |||||
| Total | 800 | 1,100 | 2,200 | 800 | 2,000 | |||||
a. Determine an activity rate for each activity.
| Activity Rates | Production Setup | Procurement | Quality Control | Materials Management | ||||
| Activity cost | $ | $ | $ | $ | ||||
| ÷ Activity base | ||||||||
| Activity rate | $ | /setup | $ | /PO | $ | /inspection | $ | /component |
b. Assign activity costs to each product and determine the unit activity cost, using the activity rates from part (a). Round unit costs to the nearest cent.
| Custom | Standard | |||
| Setups Total | $ | $ | ||
| Purchase Orders Total | ||||
| Inspections Total | ||||
| Components Total | ||||
| Total product cost | $ | $ | ||
| Unit volume | ||||
| Unit cost | $ | $ | ||
c. Assume that each product required one direct
labor hour per unit. Determine the per-unit cost if factory
overhead is allocated on the basis of direct labor hours. Round
your answer to the nearest cent.
$per unit
d. The custom product will consume materials management activities than will the standard product.
In: Accounting
|
Q |
TC |
|
0 |
$ 100 |
|
1 |
110 |
|
2 |
130 |
|
3 |
160 |
|
4 |
200 |
|
5 |
250 |
|
6 |
310 |
|
7 |
380 |
|
8 |
460 |
|
9 |
550 |
|
10 |
650 |
|
11 |
760 |
Agriculture Manufact. Energy Services
Agriculture 1.40 0.30 0.40 0.40
Manufacturing 0.40 1.50 0.50 0.60
Energy 0.30 0.60 1.20 0.40
Services 0.40 0.50 0.40 1.30
Q = 400K0.5L0.7
Does this firm operate under increasing, decreasing or constant returns to scale, and why?
In: Economics
Activity-Based Costing
Hercules Industries manufactures two types of electrical power units, custom and standard, which involve four overhead activities—production setup, procurement, quality control, and materials management. An activity analysis of the overhead revealed the following estimated costs and activity bases for these activities:
| Activity | Cost | Activity Base | |
| Production setup | $ 82,500 | Number of setups | |
| Procurement | 137,500 | Number of purchase orders (PO) | |
| Quality control | 150,000 | Number of inspections | |
| Materials management | 205,000 | Number of components | |
| Total | $575,000 | ||
The activity-base usage quantities for each product are as follows:
| Setups |
Purchase Orders |
Inspections | Components | Unit Volume | ||||||
| Custom | 450 | 1,100 | 2,200 | 550 | 1,000 | |||||
| Standard | 100 | 150 | 300 | 450 | 1,000 | |||||
| Total | 550 | 1,250 | 2,500 | 1,000 | 2,000 | |||||
a. Determine an activity rate for each activity.
| Activity Rates | Production Setup | Procurement | Quality Control | Materials Management | ||||
| Activity cost | $ | $ | $ | $ | ||||
| Activity base | ||||||||
| Activity rate | $ | /setup | $ | /PO | $ | /inspection | $ | /component |
b. Assign activity costs to each product, and determine the unit activity cost using the activity rates from part (a). Round unit costs to the nearest cent.
| Custom | Standard | |||
| Setups Total | $ | $ | ||
| Purchase Orders Total | ||||
| Inspections Total | ||||
| Components Total | ||||
| Total product cost | $ | $ | ||
| Unit volume | ||||
| Unit cost | $ | $ | ||
c. Assume that each product required one direct
labor hour per unit. Determine the per unit cost if factory
overhead is allocated on the basis of direct labor hours. Round
your answer to the nearest cent.
$ per unit
d. The custom product will consume SelectmorelessItem 28 materials management activities than will the standard product.
In: Accounting
Exercise 6-8
Kingbird, Inc. uses the periodic inventory system and had 145 units in beginning inventory at a total cost of $18,125. The company purchased 290 units at a total cost of $58,000. At the end of the year, Kingbird had 70 units in ending inventory.
a.Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost. (Round average-cost per unit and final answers to 0 decimal places, e.g. 1,250.)
b. Which cost flow method would result in the highest net income?
c. Which cost flow method would result in inventories approximating current cost in the balance sheet?
d. Which cost flow method would result in Kingbird paying the least taxes in the first year?
In: Accounting
Monty Corp. uses the periodic inventory system and had 150 units in beginning inventory at a total cost of $15,000. The company purchased 300 units at a total cost of $39,000. At the end of the year, Monty had 80 units in ending inventory.
Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost. (Round average-cost per unit and final answers to 0 decimal places, e.g. 1,250.)
|
FIFO |
LIFO |
Average-cost |
||||
| The cost of the ending inventory |
$ |
$ |
$ |
|||
| The cost of goods sold |
$ |
$ |
$ |
Which cost flow method would result in the highest net income?
Which cost flow method would result in inventories approximating current cost in the balance sheet?
Which cost flow method would result in Monty paying the least taxes in the first year?
In: Accounting
Smoky Mountain Corporation makes two types of hiking boots—the Xtreme and the Pathfinder. Data concerning these two product lines appear below:
| Xtreme | Pathfinder | |||||
| Selling price per unit | $ | 120.00 | $ | 92.00 | ||
| Direct materials per unit | $ | 63.50 | $ | 54.00 | ||
| Direct labor per unit | $ | 13.50 | $ | 9.00 | ||
| Direct labor-hours per unit | 1.5 | DLHs | 1.0 | DLHs | ||
| Estimated annual production and sales | 24,000 | units | 71,000 | units | ||
The company has a traditional costing system in which manufacturing overhead is applied to units based on direct labor-hours. Data concerning manufacturing overhead and direct labor-hours for the upcoming year appear below:
| Estimated total manufacturing overhead | $ | 2,033,000 | ||
| Estimated total direct labor-hours | 107,000 | DLHs | ||
Required:
1. Compute the product margins for the Xtreme and the Pathfinder products under the company’s traditional costing system.
2. The company is considering replacing its traditional costing system with an activity-based costing system that would assign its manufacturing overhead to the following four activity cost pools (the Other cost pool includes organization-sustaining costs and idle capacity costs):
| Estimated Overhead Cost |
Expected Activity | |||||
| Activities and Activity Measures | Xtreme | Pathfinder | Total | |||
| Supporting direct labor (direct labor-hours) | $ | 663,400 | 36,000 | 71,000 | 107,000 | |
| Batch setups (setups) | 572,000 | 240 | 200 | 440 | ||
| Product sustaining (number of products) | 750,000 | 1 | 1 | 2 | ||
| Other | 47,600 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 2,033,000 | ||||
************BOLD ANSWERS ARE INCORRECT EVERYTHING ELSE IS CORRECT**************
Compute the product margins for the Xtreme and the Pathfinder products under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)
|
Compute the product margins for the Xtreme and the Pathfinder products under the activity-based costing system. (Round your intermediate calculations to 2 decimal places.)
|
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2 decimal places and "Percentage" answers to 1 decimal place.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Smoky Mountain Corporation makes two types of hiking boots—the Xtreme and the Pathfinder. Data concerning these two product lines appear below:
| Xtreme | Pathfinder | |||||
| Selling price per unit | $ | 120.00 | $ | 92.00 | ||
| Direct materials per unit | $ | 63.50 | $ | 54.00 | ||
| Direct labor per unit | $ | 13.50 | $ | 9.00 | ||
| Direct labor-hours per unit | 1.5 | DLHs | 1.0 | DLHs | ||
| Estimated annual production and sales | 24,000 | units | 71,000 | units | ||
The company has a traditional costing system in which manufacturing overhead is applied to units based on direct labor-hours. Data concerning manufacturing overhead and direct labor-hours for the upcoming year appear below:
| Estimated total manufacturing overhead | $ | 2,033,000 | ||
| Estimated total direct labor-hours | 107,000 | DLHs | ||
Required:
1. Compute the product margins for the Xtreme and the Pathfinder products under the company’s traditional costing system.
2. The company is considering replacing its traditional costing system with an activity-based costing system that would assign its manufacturing overhead to the following four activity cost pools (the Other cost pool includes organization-sustaining costs and idle capacity costs):
| Estimated Overhead Cost |
Expected Activity | |||||
| Activities and Activity Measures | Xtreme | Pathfinder | Total | |||
| Supporting direct labor (direct labor-hours) | $ | 663,400 | 36,000 | 71,000 | 107,000 | |
| Batch setups (setups) | 572,000 | 240 | 200 | 440 | ||
| Product sustaining (number of products) | 750,000 | 1 | 1 | 2 | ||
| Other | 47,600 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 2,033,000 | ||||
************BOLD ANSWERS ARE INCORRECT EVERYTHING ELSE IS CORRECT**************
Compute the product margins for the Xtreme and the Pathfinder products under the company’s traditional costing system. (Round your intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount.)
|
Compute the product margins for the Xtreme and the Pathfinder products under the activity-based costing system. (Round your intermediate calculations to 2 decimal places.)
|
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
Prepare a quantitative comparison of the traditional and activity-based cost assignments. (Round your intermediate calculations to 2 decimal places and "Percentage" answers to 1 decimal place.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Background information for all problems:
Chekley Manufacturing has two production departments (Machining and Assembly). They have two service departments that provide services to each other and to production (Plant Maintenance and IT) Chekley believes Plant Maintenance (PM) should be allocated based on square footage and IT should be allocated based on computer hours. Chekley allocates Plant Maintenance first when allocating using the step method. You have the following additional information:
Total manufacturing costs
COSTS Plant maintenance $500,000
Information systems $450,000
Machining $2,000,000
Assembly $3,150,000 $6,100,000
Square Feet Computer hours
Plant maintenance 4,000.00 8,000.00
Information systems 2,000.00 4,000.00
Machining 12,000.00 24,000.00
Assembly 6,000.00 8,000.00
24,000.00 44,000.00
Problem A
1. Under the direct method, what percentage of PM should be allocated to Machining? 2. Under the direct method, what percentage of PM should be allocated to Assembly? 3. Under the direct method, how much of the total allocable cost attributable to PM should be allocated to Machining? 4. Under the direct method, how much of the total allocable cost attributable to PM should be allocated to Assembly? 5. Under the direct method, what percentage of IT should be allocated to Machining? 6. Under the direct method, what percentage of IT should be allocated to Assembly? 7. Under the direct method, how much of the total allocable cost attributable to IT should be allocated to Machining? 8. Under the direct method, how much of the total allocable cost attributable to IT should be allocated to Assembly? Problem B 1. Under the step method, what percentage of PM should be allocated to IT? 2. Under the step method, what percentage of PM should be allocated to Machining? 3. Under the step method, what percentage of PM should be allocated to Assembly? 4. Under the step method, how much of the total allocable cost attributable to PM should be allocated to IT? 5. Under the step method, how much of the total allocable cost attributable to PM should be allocated to Machining? 6. Under the step method, how much of the total allocable cost attributable to PM should be allocated to Assembly? 7. Under the step method, what percentage of IT should be allocated to PM? 8. Under the step method, what percentage of IT should be allocated to Machining? 9. Under the step method, what percentage of IT should be allocated to Assembly? 10. Under the step method, how much of the total allocable cost attributable to IT should be allocated to PM? 11. Under the step method, how much of the total allocable cost attributable to IT should be allocated to Machining? 12. Under the step method, how much of the total MOH cost attributable to IT should be allocated to Assembly?
Problem C
1. Using the reciprocal method, what is the formula for determining the total PM costs that should be allocated? PM = 500,000 + .2IT PM = 500,000 + .2(450,000) PM = 450,000 + .1IT PM = 500,000 + .1(450,000) 2. Using the reciprocal method, what is the formula for determining the total IT costs that should be allocated? IT =500,000 + .1PM IT = 450,000 + .1PM IT = 450,000 + .2(500,000) IT = 500,000 + .1(450,000) 3. Using the reciprocal method, how much in total will be allocated from PM to the other departments? 4. Using the reciprocal method, how much in total will be allocated from IT to the other departments?
In: Accounting
Problem 2-20B Context-sensitive nature of cost behavior classifications
Sean Franklin sells a newly developed camera, Panorama Vision. He purchases the cameras from the manufacturer for $150 each and rents a store in a shopping mall for $6,000 per month.
Required
a. Determine the average cost of sales per unit if Mr. Franklin sells 100, 200, 300, 400, or 500 units of Panorama Vision per month. Use the following chart to organize your answer: Sales Volume in Units (a) 100 200 300 400 500 Total cost of cameras (a × $150) $15,000 Total cost of store rental 6,000 Total cost of sales (b) $21,000 Average cost per unit (b ÷ a) $210.00
b. If Mr. Franklin wants to make a gross profit of $30 on each camera he sells, what price should he charge at sales volumes of 100, 200, 300, 400, or 500 units?
c. Record the total cost of store rental if Mr. Franklin opens a camera store at one, two, three, four, or five shopping malls. Record your answers in the following chart. Is the cost of store rental fixed or variable relative to the number of stores opened? Shopping Malls 1 2 3 4 5 Total cost of store rental $6,000
d. Mr. Franklin provides decorative ornaments to customers who purchase cameras. Some customers take the ornaments, others do not, and some take more than one. The number of ornaments varies in relation to the number of cameras sold, but the relationship is not proportional. Assume that, on average, Mr. Franklin gives away $150 worth of ornaments for every 100 cameras sold. What is the additional cost per camera sold? Is the cost fixed or variable?
In: Accounting
In: Accounting