Question

In: Accounting

Rosie Learns, Inc. manufactures robots and uses an activity-based costing system. Rosie Learns’ activities and related...

Rosie Learns, Inc. manufactures robots and uses an activity-based costing system. Rosie Learns’ activities and related data are listed below:

Activity Budgeted Cost Allocation Base Predetermined Overhead Allocation Rate
Materials Handling $230,000 Number of Parts $1.50
Assembly 3,200,000 Number of assembling direct labor hours 16.00
Finishing 150,000 Number of finished units* 3.00

*The number of units receiving the finish activity, not the number of units transferred to Finished Goods Inventory.

Rosie Learns produces two models of robots, the Rosie V and the Rosie X. The Rosie X has fewer parts and requires no finishing work.

Product Total Units Produced Total Direct Materials Costs Total Direct Labor Costs Total Number of Parts Total Assembling Direct Labor Hours
Rosie V 3,000 54,000 67,500 8,000 4,500
Rosie X 3,500 56,000 52,500 6,000 3,500

Requirements:

  1. Compute the manufacturing product costs per unit of each model of robot.
  2. Suppose that pre-manufacturing activities, such as product design were assigned to Roxie V at $8 each and to Rosie X at $5 each. Similar analyses were done on post-manufacturing actives such as distribution, marketing, and customer service. The post-manufacturing costs were $18 for Rosie V and $14 for Rosie X. What is the full product costs per unit?
  3. Which product costs are reported in the external financial statements? Which costs are used for management decision making? What is the difference?
  4. What price should Rosie Learns set for Rosie X to earn a target net profit of $20 per robot?

Solutions

Expert Solution

A B C=A*B D E=A*D
ROSIE V ROSIE X
Activity Budgeted Cost Allocation Base Predetermined Overhead Allocation Rate Activity Volume Allocated Overhead Activity Volume Allocated Overhead
Materials Handling $230,000 Number of Parts $1.50 8000 $12,000 6000 $9,000
Assembly 3,200,000 Number of assembling direct labor hours 16 4500 $72,000 3500 $56,000
Finishing 150,000 Number of finished units* 3 3000 $9,000 0 $0
TOTAL $93,000 $65,000
ROSIE V ROSIE X
Total Cost Units produced Cost per unit Total Cost Units produced Cost per unit
Direct Materials $54,000 3000 $18 $56,000 3500 $16
Direct labor $67,500 3000 $23 $52,500 3500 $15
Allocated Overhead $93,000 3000 $31 $65,000 3500 $19
TOTAL $72 TOTAL $50
Manufacturing Product Cost per unit of ROSIE V $72
Manufacturing Product Cost per unit of ROSIE X $50
ROSIE V ROSIE X
Manufacturing Product Cost per unit $72 $50
Pre-manufacturing activities cost $8 $5
Post manufacturing costs $18 $14
Full product cost per unit $98 $69
Cost of sales reported in externalfinancial statement $80 $55 (Pre manufacturing costs are added as part of manufacturing overhead)
Costs used in management decision making $98 $69 (Totalvariable costs are used for decisions like product profitability, product portfolio, pricing etc)
Target Net Profit $20 $20
Price tobe set $118 $89

Related Solutions

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...
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...
5)X Company uses an activity-based costing overhead allocation system. It has identified three activities - Material...
5)X Company uses an activity-based costing overhead allocation system. It has identified three activities - Material handling, Product testing, Packaging - and their respective cost drivers - pounds of material, tests, packages. Budgeted activity costs in 2018 were as follows: Activity Budgeted Cost   Material handling $104,700       Product testing 58,700       Packaging 53,000       The following 2018 cost driver information is available for one of its products, Product A, and for all of its products (including Product A): Product A All Products pounds...
Mayeux Corporation uses an activity-based costing system with three activity cost pools.
 Mayeux Corporation uses an activity-based costing system with three activity cost pools. The company has provided the following data concerning its costs and its activity-based costing system: Costs: Wages and salaries   $ 320,000 Depreciation   160,000 Utilities   240,000 Total  $720,000 Distribution of resource consumption: Activity Cost Pools  How much cost, in total, would be allocated in the first-stage allocation to the Setting Up activity cost pool?A) $360,000 B) $336,000 C) $288,000 D) $348,000
ABC Company uses a traditional costing system. Management is considering switching to an activity-based costing system....
ABC Company uses a traditional costing system. Management is considering switching to an activity-based costing system. What steps must Star take in initiating an activity-based costing system? Need unique answer
Borg Corporation uses a traditional costing system. Management is considering switching to an activity-based costing system....
Borg Corporation uses a traditional costing system. Management is considering switching to an activity-based costing system. What steps must Borg take in initiating an activity-based costing system?  
Garner Industries manufactures precision tools. The firm uses an activity-based costing system. CEO Deb Garner is...
Garner Industries manufactures precision tools. The firm uses an activity-based costing system. CEO Deb Garner is very proud of the accuracy of the system in determining product costs. She noticed that since the installment of the ABC system 10 years earlier, the firm had become much more competitive in all aspects of the business and earned an increasing amount of profits every year. In the last two years, the firm sold 0.658 million units to 3,100 customers each year. The...
Garner Industries manufactures precision tools. The firm uses an activity-based costing system. CEO Deb Garner is...
Garner Industries manufactures precision tools. The firm uses an activity-based costing system. CEO Deb Garner is very proud of the accuracy of the system in determining product costs. She noticed that since the installment of the ABC system 10 years earlier, the firm had become much more competitive in all aspects of the business and earned an increasing amount of profits every year. In the last two years, the firm sold 0.658 million units to 2,500 customers each year. The...
Garner Industries manufactures precision tools. The firm uses an activity-based costing system. CEO Deb Garner is...
Garner Industries manufactures precision tools. The firm uses an activity-based costing system. CEO Deb Garner is very proud of the accuracy of the system in determining product costs. She noticed that since the installment of the ABC system 10 years earlier the firm had become much more competitive in all aspects of the business and earned an increasing amount of profits every year.       In the last two years the firm sold 0.635 million units to 3,700 customers each year. The...
Garner Industries manufactures precision tools. The firm uses an activity-based costing system. CEO Deb Garner is...
Garner Industries manufactures precision tools. The firm uses an activity-based costing system. CEO Deb Garner is very proud of the accuracy of the system in determining product costs. She noticed that since the installment of the ABC system 10 years earlier the firm had become much more competitive in all aspects of the business and earned an increasing amount of profits every year In the last two years the firm sold 0.628 million units to 4,100 customers each year. The...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT