Question

In: Accounting

   Qubix Systems produces two different products, Product A, which sells for $250 per unit, and...

  

Qubix Systems produces two different products, Product A, which sells for $250 per unit, and Product B, which sells for $400 per unit, using three different activities: Design, which uses Engineering Hours as an activity driver; Machining, which uses machine hours as an activity driver; and Inspection, which uses number of batches as an activity driver. The cost of each activity and usage of the activity drivers are as follows:

Cost

Usage by Product A

Usage by Product B

Design (Engineering hours)

150,000

100

150

Machining (Machine hours)

1,000,000

2,000

3,000

Inspection (Batches)

80,000

50

30

Qubix manufactures 10,000 units of Product A and 7,500 units of Product B per month. Each unit of Product A uses $100 of direct materials and $45 of direct labor, while each unit of Product B uses $140 of direct materials and $75 of direct labor.
Required:
a. Calculate the Design activity proportions for Products A and B.
b. Calculate the Machining activity proportions for Products A and B.
c. Calculate the Inspection activity proportions for Products A and B.
d. Determine the indirect costs assigned to Product A.
e. Determine the indirect costs assigned to Product B.

f. Determine the manufacturing cost per unit for Product A.
g. Determine the manufacturing cost per unit for Product B.
h. Determine the gross profit per unit for Product A.
i. Determine the gross profit per unit for Product B.

Solutions

Expert Solution

A B C D = B+ C E  = A/D F = B x E G = C x E
Cost Usage by Product A Usage by Product B Total Usage A + B Cost Per Usage Activity proportions for Products A Activity proportions for Products B
Design (Engineering hours) 150,000 100 150 250 $     600.00 $60,000.00 $90,000.00
Machining (Machine hours) 1,000,000 2,000 3,000 5000 $     200.00 $400,000.00 $600,000.00
Inspection (Batches) 80,000 50 30 80 $  1,000.00 $50,000.00 $30,000.00
Total manufacturing overhead costs $510,000.00 $720,000.00
Divide by number of units 10000 7500
Manufacturing overhead cost per unit $51.00 $96.00
Product A Product B
a. Calculate the Design activity proportions for Products A and B. $60,000.00 $90,000.00
b. Calculate the Machining activity proportions for Products A and B. $400,000.00 $600,000.00
c. Calculate the Inspection activity proportions for Products A and B. $50,000.00 $30,000.00
d. Determine the indirect costs assigned to Product A. $510,000.00
e. Determine the indirect costs assigned to Product B. $720,000.00
f. Determine the manufacturing cost per unit for Product A.
Direct Material $100
Direct Labour $45
Manufacturing overhead $51
Product A Total manufcturing cost per unit $196
g. Determine the manufacturing cost per unit for Product B.
Direct Material $140
Direct Labour $75
Manufacturing overhead $96
Product B Total manufcturing cost per unit $311
h. Determine the gross profit per unit for Product A.
Selling Price $          250
Less : manufacturing cost per unit $196
Gross profit per unit $            54
i. Determine the gross profit per unit for Product B.
Selling Price $          400
Less : manufacturing cost per unit $311
Gross profit per unit $            89

Related Solutions

Qubix Systems produces two different products, Product A, which sells for $250 per unit, and Product...
Qubix Systems produces two different products, Product A, which sells for $250 per unit, and Product B, which sells for $400 per unit, using three different activities: Design, which uses Engineering Hours as an activity driver; Machining, which uses machine hours as an activity driver; and Inspection, which uses number of batches as an activity driver. The cost of each activity and usage of the activity drivers are as follows: Cost Usage by Product A Usage by Product B Design...
Walnut Systems produces two different products, Product A, which sells for $123 per unit, and Product...
Walnut Systems produces two different products, Product A, which sells for $123 per unit, and Product B, which sells for $205 per unit, using three different activities: Design, which uses Engineering Hours as an activity driver; Machining, which uses machine hours as an activity driver; and Inspection, which uses number of batches as an activity driver. The cost of each activity and usage of the activity drivers are as follows:     Cost Usage by Product A Usage by Product B Design...
Fremont Systems produces two different products, Product A, which sells for $1,000 per unit, and Product...
Fremont Systems produces two different products, Product A, which sells for $1,000 per unit, and Product B, which sells for $2,000 per unit, using three different activities: Design, which uses Engineering Hours as an activity driver; Machining, which uses machine hours as an activity driver; and Inspection, which uses number of batches as an activity driver. The cost of each activity and usage of the activity drivers are as follows:    Cost Usage by Product A Usage by Product B Design...
Walnut Systems produces two different products, Product A, which sells for $135 per unit, and Product...
Walnut Systems produces two different products, Product A, which sells for $135 per unit, and Product B, which sells for $192 per unit, using three different activities: Design, which uses Engineering Hours as an activity driver; Machining, which uses machine hours as an activity driver; and Inspection, which uses number of batches as an activity driver. The cost of each activity and usage of the activity drivers are as follows:     Cost Usage by Product A Usage by Product B Design...
A manufacturer produces a product that sells for $10 per unit. Variable costs per unit are...
A manufacturer produces a product that sells for $10 per unit. Variable costs per unit are $6 and total fixed costs are $12,000. At this selling price, the company earns a profit equal to 10% of total dollar sales. By reducing its selling price to $9 per unit, the manufacturer can increase its unit sales volume by 25%. Assume that there are no taxes and that total fixed costs and variable costs per unit remain unchanged. If the selling price...
Valley Company sells two products. Product M sells for $12 and has variable costs per unit...
Valley Company sells two products. Product M sells for $12 and has variable costs per unit of $7. Product Q’s selling price and variable costs are $15 and $10, respectively. If fixed costs are $60,000 and Valley sells twice as many units of Product M as Product Q, what is the break-even point in units for Product M?
Cantor Products sells a product for $75. DM costs per unit and DL costs per unit...
Cantor Products sells a product for $75. DM costs per unit and DL costs per unit are $45. Depreciation Expenses costs and Production supervisor’s salary are $75,000. Answer the following questions: a. What is the break-even point in units? b. What unit sales would be required to earn a target profit of $200,000? c. Assume they achieve the level of sales required in part b, what is the degree of operating leverage? d. If sales decrease by 30% from that...
Your firm produces in a competitive market which sells its product, q, for $240 per unit....
Your firm produces in a competitive market which sells its product, q, for $240 per unit. Hourly variable costs are 20q2 while overhead costs consist of $50 per hour to rent its office space, $50 per hour for advertising, $390 per hour for equipment rental and $10 per hour in attorney fees. All overhead costs are fixed but avoidable. Question: Your firm wants to know its long term prospects. What will be the price and quantity charged in the market...
A company that produces and sells a single product for $22 per unit has provided the...
A company that produces and sells a single product for $22 per unit has provided the following volume and average cost data for two accounting period: Level of activity (unit) ---------------------------- ---------------- 1,000 2,000 Direct materials ------------------------- ------------------------ $4.00 $4.00 Direct Labor----------------------------------------------------- $3.00 $3.00 Manufacturing overhead-------------------------------------------- $3.50 $2.50 General, selling, and administrative expenses-------------- $1.00 $0.50 1. The best estimate of the total contribution margin when 4,300 units are sold is: $64,500 $45,150 $58,050 $51,600 2. The best estimate of the...
Madison Company produces a single product which sells for $30 per unit. Fixed expenses total $13,500...
Madison Company produces a single product which sells for $30 per unit. Fixed expenses total $13,500 per month, and variable expenses are $12 per unit. During the current month, sales, in units, totaled 900 units. Using the information above, match each of the items listed below with the appropriate amount.       - Contribution margin per unit.       -    Contribution margin ratio.       -    Break-even point in units.       - Break-even point in dollars.   ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT