In: Accounting
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:
| 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 | |||||||||