Explore BrainMass
Share

Ontario, Inc. calculate the unit manufacturing costs

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Calculating Cost
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 is $800,000 and 25,000 hours, respectively. Information about the company's products follows.
Standard: Enhanced:
Estimated production volume 3,000 units 4,000 units
Direct-material cost $25 per unit $40 per unit
Direct labor per unit 3 hours at $12 per hour 4 hours at $12 per hour

Ontario's 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 massive plant renovation during which new, highly automated machinery was installedâ?"machinery that was expected to produce significant operating efficiencies.
Using a Microsoft Excel format for calculations, complete the following:
â?¢ Assuming use of direct-labor hours to apply overhead to production, calculate the unit manufacturing costs of the standard and enhanced products if the expected manufacturing volume is attained.
â?¢ Assuming the use of activity-based costing, calculate the unit manufacturing cost of the standard and enhanced products if the expected manufacturing volume is attained.
â?¢ Ontario's selling price is based heavily on cost:
o Calculate which product is over cost and which is under cost by using direct-labor hours as an application base.
o Explain if it is possible that this over costing and under costing is responsible for the profit issues the company is facing.
â?¢ Illustrate how the solution will change if the following data changes:
o The overhead associated with order processing is $300,000 and the overhead associated with product inspection is $270,000.

© BrainMass Inc. brainmass.com October 25, 2018, 7:03 am ad1c9bdddf
https://brainmass.com/business/management-accounting/ontario-inc-calculate-the-unit-manufacturing-costs-488431

Attachments

Solution Preview

Your tutorial is attached in excel. You can see how to approach this problem.

Using labor hours, enhanced gets much more of the overhead (they use much more of the labor). However, this over-costs enhanced. Why? They don't use overhead ...

Solution Summary

Your tutorial shows the overhead under traditional and activity based costing as well as giving you some ideas on why the differences occur. This is a head start in trying to think through how costing choices impact sales and profits.

$2.19
See Also This Related BrainMass Solution

Activity based costing; cost analysis for Ontario, Inc.

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 company's products follows.

Standard:
Estimated production volume, 3000 units
Direct-material cost, $25 per unit
Direct-labor per unit, 3 hours at $12 per hour
Enhanced:
Estimated production volume, 4000 units
Direct-material cost, $40 per unit
Direct-labor per unit, 4 hours at $12 per hour

Ontario's 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. Date relevant to these activities follows.

orders processed machine hours worked inspection hours

Standard.... 300 18,000 2000

Enhanced.... 200 22,000 8000

total..... 500 40,000 10,000

1. 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.

2. Assuming use of activity-based costing, compute the unit manufacturing costs of the standard and enhanced products if the expected manufacturing volume is attained.

3. Ontario's selling prices are based heavily on cost.

a. By using direct-labor hours as an application base, which product is overcosted and which product is undercosted? Calculate the amount of the cost distortion for each product

b. Is it possible that overcosting and undercosting, and the susequent determination of selling prices are contributing to the company's profit woes? Explain

4. Build the spreadsheet: construct an excel spreadsheet to solve requirements 1, 2 and 3 (a) above. how will the solution change if the following data change: the overhead associate with order processing is $300,000 and the overhead associated with product inspection is $270,000.

View Full Posting Details