Question

In: Accounting

Activity-Based Supplier Costing Levy Inc. manufactures tractors for agricultural usage. Levy purchases the engines needed for...

Activity-Based Supplier Costing

Levy Inc. manufactures tractors for agricultural usage. Levy purchases the engines needed for its tractors from two sources: Johnson Engines and Watson Company. The Johnson engine has a price of $1,000. The Watson engine is $900 per unit. Levy produces and sells 22,000 tractors. Of the 22,000 engines needed for the tractors, 4,000 are purchased from Johnson Engines, and 18,000 are purchased from Watson Company. The production manager, Jamie Murray, prefers the Johnson engine. However, Jan Booth, purchasing manager, maintains that the price difference is too great to buy more than the 4,000 units currently purchased. Booth also wants to maintain a significant connection with the Johnson source just in case the less expensive source cannot supply the needed quantities. Jamie, however, is convinced that the quality of the Johnson engine is worth the price difference.

Frank Wallace, the controller, has decided to use activity costing to resolve the issue. The following activity cost and supplier data have been collected:

Activity Cost
Replacing engines $800,000
Expediting orders 1,000,000
Repairing engines 1,800,000

a All units are tested after assembly, and some are rejected because of engine failure. The failed engines are removed and replaced, with the supplier replacing any failed engine. The replaced engine is retested before being sold. Engine failure often causes collateral damage, and other parts often need to be replaced.

b Due to late or failed delivery of engines.

c Repair work is for units under warranty and almost invariably is due to engine failure. Repair usually means replacing the engine. This cost plus labor, transportation, and other costs make warranty work very expensive.

Watson Johnson
Engines replaced by source 1,980 20
Late or failed shipments 198 2
Warranty repairs (by source) 2,440 60

Required:

1. Calculate the activity-based supplier cost per engine (acquisition cost plus supplier-related activity costs). (Round to the nearest cent.)

Watson
Johnson

Which of the two suppliers is the low-cost supplier?

Explain why this is a better measure of engine cost than the usual purchase costs assigned to the engines.

The engine costs less when the full supplier effects are considered. This is a better assessment of cost because it considers the costs that are caused by the supplier due to poor quality, poor reliability, and poor delivery performance.

2. Consider the supplier cost information obtained in Requirement 1. Suppose further that Johnson can only supply a total of 20,000 units. What actions would you advise Levy to undertake with its suppliers?

In the short run, buy 20,000 from and 2,000 from . In the long run, one possibility is to encourage to increase its quality and maintain purchases from both sources (lowers source risk by having two suppliers).

Solutions

Expert Solution

1. Calculate the activity-based supplier cost per engine (acquisition cost plus supplier-related activity costs). (Round to the nearest cent.)
Activity rates for assigning costs to suppliers:
Replacing engines: $800,000/2,000 engines = $400 per engine
Expediting orders : 1,000,000/200  late Shipments $          5,000.00 per late shipment
Repairing engines : 180,000/2500 engines $             720.00 Per engine
Watson Johnson
Purchase cost: $900 × 18,000 ; $1,000 × 4,000 $ 16,200,000.00 $ 4,000,000.00
Replacing engines: $400 × 1,980 ; $400 × 20 $      792,000.00 $        8,000.00
Expediting orders: $5,000 × 198 ;  $5,000 × 2 $      990,000.00 $      10,000.00
Repairing engines: $720 × 2,440 ; $720 × 60 $   1,756,800.00 $      43,200.00
Total supplier cost $ 19,738,800.00 $ 4,061,200.00
÷ Units supplied            18,000.00            4,000.00
Unit cost $          1,096.60 $        1,015.30
b)
The Johnson engine costs less when the full supplier effects are considered. This is a better assessment of cost because it considers the costs that are caused by the supplier due to poor quality, poor reliability, and poor delivery performance
2. In the short run, buy 20,000 from Johnson and 2,000 from Watson. In the long run, one possibility is to encourage Watson to increase its quality and maintain purchases from both sources (lowers source risk by having two suppliers).

Related Solutions

Activity-Based Supplier Costing Levy Inc. manufactures tractors for agricultural usage. Levy purchases the engines needed for...
Activity-Based Supplier Costing Levy Inc. manufactures tractors for agricultural usage. Levy purchases the engines needed for its tractors from two sources: Johnson Engines and Watson Company. The Johnson engine has a price of $1,000. The Watson engine is $900 per unit. Levy produces and sells 22,000 tractors. Of the 22,000 engines needed for the tractors, 4,000 are purchased from Johnson Engines, and 18,000 are purchased from Watson Company. The production manager, Jamie Murray, prefers the Johnson engine. However, Jan Booth,...
Activity-Based Supplier Costing Bowman Company manufactures cooling systems. Bowman produces all the parts necessary for its...
Activity-Based Supplier Costing Bowman Company manufactures cooling systems. Bowman produces all the parts necessary for its product except for one electronic component, which is purchased from two local suppliers: Manzer Inc. and Buckner Company. Both suppliers are reliable and seldom deliver late; however, Manzer sells the component for $89 per unit, while Buckner sells the same component for $86. Bowman purchases 80% of its components from Buckner because of its lower price. The total annual demand is 4,000,000 components. To...
Activity-Based Supplier Costing Bowman Company manufactures cooling systems. Bowman produces all the parts necessary for its...
Activity-Based Supplier Costing Bowman Company manufactures cooling systems. Bowman produces all the parts necessary for its product except for one electronic component, which is purchased from two local suppliers: Manzer Inc. and Buckner Company. Both suppliers are reliable and seldom deliver late; however, Manzer sells the component for $89 per unit, while Buckner sells the same component for $86. Bowman purchases 80% of its components from Buckner because of its lower price. The total annual demand is 4,000,000 components. To...
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing....
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 4,000 direct labor hours. The total indirect labor is budgeted to be $462,400. Time records from indirect labor employees revealed that they spent 40% of their time setting up production runs and 60% of their time supporting actual production. The following information...
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing....
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 4,000 direct labor hours. The total indirect labor is budgeted to be $462,400. Time records from indirect labor employees revealed that they spent 40% of their time setting up production runs and 60% of their time supporting actual production. The following information...
Dodo Inc., uses activity-based costing to determine product margins. In the first stage, the activity-based costing...
Dodo Inc., uses activity-based costing to determine product margins. In the first stage, the activity-based costing system allocates two overhead accounts--equipment depreciation and supervisory expense--to three activity cost pools--Machining, Order Filling, and Other--based on resource consumption. Data pertinnent to perform these allocations appears below: Overhead costs: Equipment depreciation $ 107,000 Supervisory expense $ 9,900 Distribution of Resource Consumption Across Activity Cost Pools: Activity Cost Pools Machining Order Filling Other Equipment depreciation 0.60 0.30 0.10 Supervisory expense 0.60 0.20 0.20 In...
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing....
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 4,000 direct labor hours. The total indirect labor is budgeted to be $462,400. Time records from indirect labor employees revealed that they spent 40% of their time setting up production runs and 60% of their time supporting actual production. The following information...
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing....
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 4,000 direct labor hours. The total indirect labor is budgeted to be $462,400. Time records from indirect labor employees revealed that they spent 40% of their time setting up production runs and 60% of their time supporting actual production. The following information...
Question #6: Birds and Such, Inc. manufactures birdhouses and uses an activity-based costing system. The following...
Question #6: Birds and Such, Inc. manufactures birdhouses and uses an activity-based costing system. The following information is provided for the month of May: Activity Estimated Indirect Activity Costs Allocation Base Estimated Quantity of Allocation Base Materials handling $ 3,500 Number of parts 5,000 parts Assembling $12,000 Number of parts 5,000 parts Packaging $5,750 Number of birdhouses 1,250 birdhouses                         Each breadbox consists of 4 parts, and the direct materials cost per birdhouse is $7.00.                         What is the cost...
Activity-Based Costing Cardio Care Inc. manufactures stationary bicycles and treadmills. The products are produced in the...
Activity-Based Costing Cardio Care Inc. manufactures stationary bicycles and treadmills. The products are produced in the Fabrication and Assembly production departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated activity rates are as follows: Activity Activity Rate Fabrication $20 per machine hour (mh) Assembly $12 per direct labor hour (dlh) Setup $40 per setup Inspecting $18 per inspection Production scheduling $14 per production order Purchasing $6 per purchase...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT