Complete a four-part assessment in which you will prepare a production cost report, allocate overhead using estimated costs and cost drivers, use cost analysis in the decision-making process, and compare the results of cost allocation processes.
In the operation of a process cost accounting system, many manufacturing companies will uniformly apply materials, labor, and overhead, throughout the production process period. This is not necessarily true for other product and service companies whose production process requires adding materials at different points in the process. For these companies, cost calculation for each department in the production process is slightly more complex.
In some industries that use a manufacturing process operation, some units will always be lost due to shrinkage, spillage, or defects. These normal losses are expected as a necessary cost of producing high-quality products. They must be accounted for in the cost-of-production summary report. It is also possible—particularly when the process involves a liquid product— that units will be gained during production. This situation must also be accounted for and summarized in the production summary report.
Before beginning this assessment, take time to review the following topics:
Production cost report.
Predetermined overhead allocation rates.
Allocation of service department costs.
Complete a four-part assessment in which you prepare a production cost report, allocate overhead using estimated costs and cost drivers, use cost analysis in the decision-making process, and compare the results of cost allocation processes.
Use the Assessment 3 Template [XLSX] to complete the following four parts. Each part is a different tab in the template.
Part 1: In the template, prepare a production cost report using the FIFO method. Show all calculations and explain briefly.
Part 2: Compute overhead rate for each cost driver and production costs for each product, and compare to the consultant’s recommendations for cost drivers to explain the discrepancy between the two different approaches to product costing to management. Show all calculations.
Part 3: Compute and explain the rationale for using or not using the proposed new material based on the associated costs. Give other factors that should also be taken into consideration for this decision. Show all calculations.
Part 4: Allocate the cost to the service department using all three methods: direct, step, and reciprocal. Then comment on your findings in a paragraph. Show all calculations.
Assessment 3 Part 1: Prepare a Production Cost Report: FIFO Method
In the template, prepare a production cost report using the FIFO method. Show all calculations and explain briefly.
Part 1 Scenario
Lamar, Inc. provides the following information for one of its department’s operations for May (no new material is added in Department T):
Lamar, Inc.: WIP Inventory: Department T
Beginning Inventory (16,500 units, 60% complete with respect to Department T costs)
Transferred-in Costs (from Department S)
Department T Conversion Costs
Current Work (38,500 units started)
Prior Department Costs
Department T Costs
Complete the following:
Prepare a production cost report using the FIFO method. Include an introduction.
Assessment 3 Part 2: Activity-Based Costing and Predetermined Overhead Allocation Rates
Compute overhead rate for each cost driver, production costs for each product, and compare to the consultant’s recommendations for cost drivers to explain the discrepancy between the two product costing approaches to management. Show all calculations.
Part 2 Scenario
Bath Fixtures Supply, Inc. (BFSI), manufactures three types of fixtures: industrial, standard, and brass. It applies all indirect costs according to a predetermined rate based on direct labor-hours. A consultant recently suggested that the company switch to an activity-based costing system and prepared the following cost estimates for year two for the recommended cost drivers.
BFSI: Costing System
Recommended Cost Driver
Estimated Cost Driver Activity
Number of orders
Number of production runs
Pounds of materials used
Machine Depreciation and Maintenance
Number of inspections
Number of units
Total Estimated Cost
In addition, management estimated 7,500 direct labor-hours for year two.
Assume that the following cost driver volumes occurred in January, year two:
BFSI: Cost Driver Volumes
Number of Units Produced
Direct Materials Costs
Number of Orders
Number of Production Runs
Pounds of Material
Number of Inspections
Actual labor costs were $15 per hour.
Complete the following:
Compute a predetermined overhead rate for year two for each cost driver using the estimated costs and estimated cost driver units prepared by the consultant. Also, compute a predetermined rate for year two using direct labor-hours as the allocation base.
Compute the production costs for each product for January using direct labor-hours as the allocation base and the predetermined rate computed in Part 1.
Compute the production costs for each product for January using the cost drivers recommended by the consultant and the predetermined rates computed in Part 1. (Note: Do not assume that total overhead applied to products in January will be the same for activity-based costing as it was for the labor-hour-based allocation.)
Management has seen your numbers and wants an explanation for the discrepancy between the product costs using direct labor-hours as the allocation base and the product costs using activity-based costing. Write a brief response to management.
Assessment 3 Part 3: Quality Improvement
Compute and explain the rationale for using or not using the proposed new material based on the associated costs. Give other factors that should also be taken into consideration for this decision. Show all calculations.
Part 3 Scenario
Bonded Fencing, Inc., produces metal gates in two processes: shaping, in which metal is bent to the correct shape, and fastening, in which the bent metal pieces are welded into gates. The shaping process has a capacity of 11,000 units per year; welding has a capacity of 15,400 units per year. Demand is high. At a sales price of $550 per unit, the company can sell whatever output it can produce.
Bonded can start only 11,000 units into production in the shaping department because of capacity constraints. 1,650 units are found to be defective in the shaping department annually. Defective units are not detected until the end of production, at which time they are scrapped. Unit costs in the shaping department, including good and defective units, equal $275 per unit, with an allocation of the total fixed manufacturing costs of $825,000 per year to units.
Bonded Fencing: Unit Cost
Direct Materials (variable)
Direct Manufacturing, Setup, and Materials Handling Labor (variable)
Depreciation, Rent, and Other Overhead (fixed)
Total Unit Cost
The fixed cost of $75 per unit is the allocation of total fixed costs of the shaping department to each unit, whether the units are good or defective.
The good units from the shaping department are sent to the fastening department. Variable manufacturing costs in the fastening department are $75 per unit and fixed manufacturing costs are $550,000 per year. There is no scrap in the fastening department. Therefore, the company’s total sales quantity equals the shaping department’s good output. The company incurs no other variable costs.
The company’s designers have discovered that, by using a new type of direct material, the company could reduce scrap in the shaping department from 1,650 units to 550 units. Using the new material would increase the direct materials costs to $180 per unit in the shaping department for all 11,000 units. Recall that only 11,000 units can be started each year.
Complete the following:
Should Bonded use the new material and improve quality? Assume that inspection and testing costs of $132,000 per year will be reduced by $22,000 with the new materials. Fixed costs in the shaping department will remain the same whether 8,500 or 9,500 units are produced.
What other nonfinancial and qualitative factors should Bonded management consider in making the decision?
Assessment 3 Part 4: Allocation Methods Comparison
Allocate the cost to the service department using all three methods: direct, step, and reciprocal, then comment on your findings in a paragraph. Show all calculations.
Part 4 Scenario
Liberty Company has two service departments: administration and accounting, and two operating departments: domestic and international. Administration costs are allocated on the basis of employees and accounting costs are allocated on the basis of number of transactions. A summary of Liberty operations follows:
Liberty Company: Summary of Operations
Department Direct Costs
Complete the following:
Allocate the cost of the service departments to the operating departments using the direct method.
Allocate the cost of the service departments to the operating departments using the step method. Start with Administration.
Allocate the cost of the service departments to the operating departments using the reciprocal method.
Comment on the results.
By successfully completing this assessment, you will demonstrate your proficiency in the course competencies through the following assessment scoring guide criteria:
Competency 3: Use cost accounting concepts to operate job, process, and activity-based cost systems.
Prepare production cost report.
Determine predetermined overhead rate for each cost driver using the estimated costs and estimated cost driver units, and predetermined rate for using direct labor-hours as the allocation base.
Explain use of new material and quality improvement.
Allocate service department cost using direct, step, and reciprocal methods.
Competency 5: Communicate in a manner that is professional and consistent with expectations for professionals in the field of accounting.