Wellington, Inc. manufactures three related products in its Colorado Springs facility. Relevant data are given below. The key material in these products is teflonium, a rare mineral of which there is currently a shortage. In the near future, only 23,000 pounds per month of teflonium will be available, at a price of $180/lb.
Product A Product B Product C
Selling price/unit $1,200 $1,450 $1,950
Cost/unit:
Teflonium 360 540 720
Other materials 100 120 100
Direct labor 90 120 110
Variable overhead 20 20 20
Fixed OH (300% of DL) 270 360 330
Expected monthly demand is: A, 8,000 units; B, 4,000 units; C, 1,000 units.
Required: How much of each product should Wellington produce each
month
while the shortage lasts? Explain.
Answer------------
Product | Units to be Produced |
A | 8,000 |
B | 1,000 |
C | 1,000 |
Working
Product | |||
A | B | C | |
Cost of Teflonium | $ 360.00 | $ 540.00 | $ 720.00 |
Cost per pound | $ 180.00 | $ 180.00 | $ 180.00 |
Pounds per unit | 2 | 3 | 4 |
.
Statement of ranking indicating which product to produced first, second and third | |||
Product | |||
A | B | C | |
Sales price per unit | $ 1,200.00 | $ 1,450.00 | $ 1,950.00 |
Variable cost per unit | $ 570.00 | $ 800.00 | $ 950.00 |
Contribution margin per unit | $ 630.00 | $ 650.00 | $ 1,000.00 |
Pounds per unit | 2.00 | 3.00 | 4.00 |
Contribution margin per Pound | $ 315.00 | $ 216.67 | $ 250.00 |
Ranking | I | III | II |
Produce | First | Third | Second |
.
Statement of Optimum mix | |||
Product | Units to be Produced | Pound hours per unit | Pounds consumed |
A | 8,000 | 2.00 | 16000.00 |
B | 1,000 | 3.00 | 3000.00 |
C | 1,000 | 4.00 | 4000.00 |
Maximum Quantity | 23000.00 |
Wellington, Inc. manufactures three related products in its Colorado Springs facility. Relevant data are given below....
Please show work
3. Wellington, Inc. manufactures three related products in its Colorado Springs facility. Relevant data are given below. The key material in these products is teflonium, a rare mineral of which there is currently a shortage. In the near future, only 23,000 pounds per month of teflonium will be available, at a price of $180/lb. Product A Product B Product C Selling price/unit $1,200 $1,450 $1,95 360 100 Cost/unit: Teflonium 720 Other materials 100 Direct labor 110 Variable...
Fixed Cost = $500,000
ABC, INC. manufactures three products: A, B, and C. Relevant data below: Unit Sales price Unit Var Cost Sales in units 100 150 200 50 90 7,000 2,000 1,000 90 a) What is the amount of profit at this sales volume? b) What is the breakeven point in sales dollars and units per product) at this sales mix? c) What sales volume in dollars must be achieved to earn a profit of $200,000? How many units...
ABC, Inc. manufactures three products: A, B, and C. Relevant data: Unit Unit Sales price Var Cost Sales in units A 100 50 7,000 B 150 90 2,000 C 200 90 1,000 Fixed costs are $500,000. Required: a) What is the amount of profit at this sales volume? b) What is the breakeven point (in sales dollars and units per product) at this sales mix? c) What sales volume in dollars must be achieved to earn a profit of $200,000?...
show/explain work and do each part
ABC, Inc. manufactures three products: A, B, and C. Relevant data: Unit Unit Var Cost Sales price Sales in units 100 150 200 50 90 90 7,000 2.000 1.000 Fixed costs are $500,000. Required: a) What is the amount of profit at this sales volume? b) What is the breakeven point in sales dollars and units per product) at this sales mix? c) What sales volume in dollars must be achieved to earn a...
Johnson Company manufactures and sells three products. Relevant per unit data concerning each product are given below: A B C _______________________________________________________________________________________ Selling Price $8 $15 $20 _________________________________________________________________________________________ Variable costs and expenses $6 $13 $17 __________________________________________________________________________________________ Machine hours to produce 2 1 2 ____________________________________________________________________________________________ -Compute the contribution margin per unit of limited resource (Machine hours) for each product. Product A Product B Product C ______________________________________________________________________________________________________________________ Contribution margin per unit of limited resources $ ? $ ? $ ? _______________________________________________________________________________________________________________________ -Assuming 3,000...
Bethard Corporation produces and sells a single product. Data concerning that product appear below: Percent of Per Unit Sales Selling price Variable expenses $120 100% 20% 24 Contribution margin 96 80% Fixed expenses are $354,000 per month. The company is currently selling 5,000 units per month Required: The marketing manager would like to cut the selling price by $8 and increase the advertising budget by $23,000 per month. The marketing manager predicts that these two changes would increase monthly sales...
Question 5 R Ltd. manufactures three products, A, B and C. The following information is given below. Sales Forecast Product Quantity Price Per Unit A 1000 Rs.100 B 2000 Rs.120 C 1500 Rs.140 Materials Used in Company’s Products Are: Material M1 Rs.4 per unit Quantities used in Product Product M1 M2 M3 A 4 2 – B 3 3 2 C 2 1 1 Finished Stocks: Product A B C Opening Inventory- units 1000 1500 500 Closing Inventory- units 1100...
76. A firm selling three products has the following data: Unit Unit Variable Product Sales Mix Price Cost 60,000 units $40 S20 40,000 units 60 30 20,000 units 30 5 If the firm can change the sales mix from 60,000 P, 40,000 Q, and 20,000 R to 60,000 P, 20,000 Q, and 40,000 R, pre-tax income will be a) Lower b) Higher c) Unchanged d) Cannot be determined Answer: a Difficulty: Medium Learning Objective: Apply CVP calculations for multiple products....
Barlow Company manufactures three products—A, B, and C. The
selling price, variable costs, and contribution margin for one unit
of each product follow:ProductABCSelling price$160$270$210Variable expenses:Direct materials168024Other variable expenses10890144Total variable expenses124170168Contribution margin$36$100$42Contribution margin ratio23%37%20%The same raw material is used in all three products. Barlow
Company has only 5,700 pounds of raw material on hand and will not
be able to obtain any more of it for several weeks due to a strike
in its supplier’s plant. Management is trying to decide...
Exercise 12-8 Volume Trade-Off Decisions [LO12-5, LO12-6] Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: Product A B C Selling price $ 160 $ 270 $ 210 Variable expenses: Direct materials 16 80 24 Other variable expenses 108 90 144 Total variable expenses 124 170 168 Contribution margin $ 36 $ 100 $ 42 Contribution margin ratio 23 % 37 % 20 % The same...