1. Direct labor hrs./unit | ||||||
Product | Debbie | Trish | Sarah | Mike | Sewing Kit | |
1.Direct labor $/unit | 2.7 | 1.2 | 4.5 | 3.3 | 0.9 | |
2.Direct labor rate /hr. | 6 | 6 | 6 | 6 | 6 | |
3.Direct labor hrs./unit(1/2) | 0.45 | 0.2 | 0.75 | 0.55 | 0.15 | |
2. VOH cost /unit | ||||||
Product | Debbie | Trish | Sarah | Mike | Sewing Kit | |
1.Direct labor hrs./unit(1/2) | 0.45 | 0.2 | 0.75 | 0.55 | 0.15 | |
2. VOH cost /unit(Row 1*$3) | 1.35 | 0.6 | 2.25 | 1.65 | 0.45 | |
3. Contribution Margin/DL hr. | ||||||
Product | Debbie | Trish | Sarah | Mike | Sewing Kit | |
1.Selling price/unit | 15.5 | 6 | 25 | 11 | 8.1 | |
Less: Variable costs: | ||||||
a. Direct materials/unit | 4.4 | 1.2 | 6.59 | 2.3 | 3.3 | |
b.Direct labor $/unit | 2.7 | 1.2 | 4.5 | 3.3 | 0.9 | |
c. VOH cost /unit(Row 1*$3) | 1.35 | 0.6 | 2.25 | 1.65 | 0.45 | |
2.Total V/C(a+b+c) | 8.45 | 3 | 13.34 | 7.25 | 4.65 | |
3.Contribution margin/unit(1-2) | 7.05 | 3 | 11.66 | 3.75 | 3.45 | |
4.Direct labor hrs./unit | 0.45 | 0.2 | 0.75 | 0.55 | 0.15 | |
5. Contribution margin/DL hr.(3/4) | 15.67 | 15.00 | 15.55 | 6.82 | 23.00 | |
6. Ranking as per 5 | 2 | 4 | 3 | 5 | 1 | |
7.Demands met as per Ranking in 6 | 51000 | 43000 | 36000 | 20000 | 326000 | |
8. Total D/L hrs. to produce as in 7(7*4) | 22950 | 8600 | 27000 | 11000 | 48900 | 118450(capacity d/l hrs.) |
(Bal. fig.) | ||||||
9.Contibution (8*5) | 359550 | 129000 | 419760 | 75000 | 1124700 | |
OR | ||||||
10.Contibution (7*3) | 359550 | 129000 | 419760 | 75000 | 1124700 | |
11. Highest total contribution | 2108010 | |||||
(sum of row.9 or 10) | ||||||
2. Highest D/L rate Walton Toy Co. would be willing to pay for additional labor time is | ||||||
Current labor rate/hr.+Contribution /DLH for Mike foregone | ||||||
ie. 6+6.82=12.82 | ||||||
so that demand for MIKE can be FULLY MET |
2 Problem 12-25 Volume Trade-Off Decisions [LO12-5, LO12-6 The Walton Toy Company manufactures a line of doll...
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company's products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Product Debbie Trish Sarah Mike Sewing kit Demand Selling Next year Price (units) per Unit 64,000 $22.00 56,000 $ 8.00 49,000 $38.50 45,600 $ 13.00 339,000 $ 9.40 Direct Materials $4.10 $2.50 $8.54 $3.40 $4.60...
7 Problem 6-25 (Algo) Volume Trade-Off Decisions (L06-5, L06-6) The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company's products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: 8.33 points Skipped eBook Product Debbie Trish Sarah Mike Sewing kit Demand Next Selling year Price Direct (units) per Unit Materials 58,000 $26.00 $5.10 50,000 $...
Required:1. How many direct labor hours are used to manufacture one unit of each of the company’s five products?2. How much variable overhead cost is incurred to manufacture one unit of each of the company’s five products?3. What is the contribution margin per direct labor-hour for each of the company’s five products?4. Assuming that direct labor-hours is the company’s constraining resource, what is the highest total contribution margin that the company can earn if it makes optimal use of its...
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company's products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company nas provided the following data: Product Debbie Trish Sarah Mike Sewing kit Demand Selling Next year Price (units) per Unit 72,000 $18.00 64,000 $ 6.50 57,000 $30.00 40,000 $15.00 347,000 $10.20 Direct Materials $4.90 $1.80 $9.74 $4.20 $5.40 Direct Labor...
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company's products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Product Debbie Trish Sarah Mike Sewing kit Demand Next Selling year Price Direct (units) per Unit Materials 61,000 $20.00 $5.40 53,000 $ 6.50 $2.20 46,000 $33.50 $8.09 44,400 $14.00 $3.10 336,000 $ 9.10 $4.30 Direct...
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company's products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Product Debbie Trish Sarah Mike Sewing kit Demand Next Selling year Price Direct (units) per Unit Materials 69,000 $41.00 $4.60 61,000 $ 4.50 $1.50 54,000 $30.50 $9.29 46,800 $15.00 $3.90 344,000 $ 9.90 $5.10 Direct...
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company's products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Product Debbie Trish Sarah Mike Sewing kit Demand Next Selling year Price (units) per Unit 71,000 $17.50 63,000 $ 6.00 56,000 $31.50 47,600 $13.00 346,000 $10.10 Direct Materials $4.80 $1.70 $9.59 $4.10 $5.30 Direct Labor...
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company’s products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Demand Selling Next Direct Direct Labor 3.85 1.12 5.95 $4.55 0.77 Price year (units) per Unit 74,000 Product Materials Debbie Trish $25.50 66,000 5.20 59,000 $33.00 40,000 $17.00 5.10 2.00 $10.04 $4.40 $5.60 Sarah Mike...
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company's products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Product Debbie Trish Sarah Mike Sewing kit Demand Next Selling year Price Direct (units) per Unit Materials 70,000 $38.00 $4.70 62,000 $ 4.60 $1.60 55,000 $31.00 $9.44 48,000 $14.00 $4.00 345,000 $10.00 $5.20 Direct Labor...
Walton Toy Company manufactures a line of dolls and a sewing kit Demand for the company's products is increasing, and nagement requests assistance from you in determining an economical sales and production mix for the coming year. The compa provided the following data: Demand Selling Next year Price Product Debbie Trish Sarah Mike Sewing kit Direct Direct (units) per Unit Materials Labor 64,000 22.00 $4.10 3.20 1.04 $ 5.60 45,600 $13.00 $3.40 $ 4.00 339,000 $ 9.40 $4.60 s .64...