Question
Problem 5-46 Ontario, Inc. manufactures two products, Standard and Enhanced, and applies overhead on the basis of direct-labor hours. Anticipated overhead and direct-labor time for
Problem 5-46
Ontario, Inc. manufactures two products, Standard and Enhanced, and applies overhead on the basis of direct-labor hours. Anticipated overhead and direct-labor time for the upcoming accounting period are $800,000 and 25,000 hours, respectively. Information about the companys products follows.
Standard:
Estimated production volume, 3,000 units
Direct-material cost, $25 per unit
Direct labor per unit, 3 hours at $12 per hour
Enhanced:
Estimated production volume, 4,000 units
Direct-material cost, $40 per unit
Direct labor per unit, 4 hours at $12 per hour
Ontarios overhead of $800,000 can be identified with three major activities: order processing ($150,000), machine processing ($560,000), and product inspection ($90,000). These activities are driven by number of orders processed, machine hours worked, and inspection hours, respectively. Data relevant to these activities follow.
Orders Processed Machine Hours Worked Inspection Hours
Standard. 300 18,000 2,000
Enhanced 200 22,000 8,000
Total.. 500 40,000 10,000
Top management is very concerned about declining profitability despite a healthy increase in sales volume. The decrease in income is especially puzzling because the company recently undertook a mas sive plant renovation during which new, highly automated machinery was installedmachinery that was expected to produce significant operating efficiencies.
Required:
Assuming use of direct-labor hours to apply overhead to production, compute the unit manufacturing costs of the Standard and Enhanced products if the expected manufacturing volume is attained.
Assuming use of activity-based costing, compute the unit manufacturing costs of the Standard and Enhanced products if the expected manufacturing volume is attained.
Ontarios selling prices are based heavily on cost. a. By using direct-labor hours as an application base, which product is over costed and which product is undercoated? Calculate the amount of the cost distortion for each product. b. Is it possible that over costing and undercoating (i.e., cost distortion) and the subsequent determination of selling prices are contributing to the companys profit woes? Explain.
Build a spreadsheet: Construct an Excel spreadsheet to solve requirements 1, 2, and 3(a) above. Show how the solution will change if the following data change: the overhead associated with order processing is $300,000 and the overhead associated with product inspection is $270,000.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started