Product | Debbie | Trish | Sarah | Mike | Sewing Kit |
Direct labor cost | $ 2.10 | $ 0.70 | $ 4.20 | $ 2.80 | $ 0.35 |
(÷) Direct labor rate per hour | $ 7.00 | $ 7.00 | $ 7.00 | $ 7.00 | $ 7.00 |
No. of Direct labor hours required per Unit (1) | 0.30 | 0.10 | 0.60 | 0.40 | 0.05 |
(x) Variable Overhead costs per direct-labour hour | $ 4 | $ 4 | $ 4 | $ 4 | $ 4 |
Variable OH cost per unit (2) | $ 1.20 | $ 0.40 | $ 2.40 | $ 1.60 | $ 0.20 |
Product | Debbie | Trish | Sarah | Mike | Sewing Kit | Total |
Selling Price p.u. | $ 30.00 | $ 7.00 | $ 42.00 | $ 12.00 | $ 8.90 | |
Less: Variable Cost p.u. | ||||||
Direct Material | $ (5.20) | $ (2.00) | $ (7.79) | $ (2.90) | $ (4.10) | |
Direct Labor | $ (2.10) | $ (0.70) | $ (4.20) | $ (2.80) | $ (0.35) | |
Variable OH | $ (1.20) | $ (0.40) | $ (2.40) | $ (1.60) | $ (0.20) | |
Total variable Costs p.u. | $ (8.50) | $ (3.10) | $ (14.39) | $ (7.30) | $ (4.65) | |
Contribution Margin p.u, | $ 21.50 | $ 3.90 | $ 27.61 | $ 4.70 | $ 4.25 | |
(÷) Direct labor hours required p.u. | 0.30 | 0.10 | 0.60 | 0.40 | 0.05 | |
Contribution Margin per labor hour (3) | $ 72 | $ 39 | $ 46 | $ 12 | $ 85 | |
Ranking of Allocation of labour hours | II | IV | III | V | I | |
Estimated Demand | 59,000 | 51,000 | 44,000 | 54,500 | 334,000 | |
(x) No. of labor hours required per unit | 0.30 | 0.10 | 0.60 | 0.40 | 0.05 | |
Total labor hours required | 17,700 | 5,100 | 26,400 | 21,800 | 16,700 | 87,700 |
Allocation of labor hours | 17,700 | 5,100 | 26,400 | 10,900 | 16,700 | 76,800 |
(÷) No. of hours per unit | 0.30 | 0.10 | 0.60 | 0.40 | 0.05 | |
Estimated Production | 59,000 | 51,000 | 44,000 | 27,250 | 334,000 | |
(x) Contribution p.u. | $ 21.50 | $ 3.90 | $ 27.61 | $ 4.70 | $ 4.25 | |
Estimated Total Contribution (4) | $ 1,268,500 | $ 198,900 | $ 1,214,840 | $ 128,075 | $ 1,419,500 | $ 4,229,815 |
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the...
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company's products is increasing. ement 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 69, eee $ 41.00 61,00 $ 4.50 54, eee $38.50 46,800 $15.00 344,200 $ 9.90 Direct Materials $4.60 $1.50 59.29 $9.29...
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 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...
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 Demand Next year (units) Selling Price per Unit Direct Materials Direct Labor Debbie 66,000 $ 37.00 $ 4.30 $ 3.50 Trish 58,000 $ 5.00 $ 1.20 $ 0.84 Sarah 51,000 $ 35.50 $ 8.84...
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: Product Demand Next year (units) Selling Price per Unit Direct Materials Direct Labor Debbie 66,000 $ 37.00 $ 4.30 $ 3.50 Trish 58,000 $ 5.00 $ 1.20 $ 0.84 Sarah 51,000 $ 35.50 $ 8.84...
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 doll
dress sewing kit. Demand for the dolls 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
Demand
Next year
(units)
Selling
Price
per Unit
Direct
Materials
Direct
Labor
Debbie
61,000
$20.00
$5.40
$3.60
Trish
53,000
$
6.50
$2.20
$1.44
Sarah
46,000
$33.50
$8.09
$6.30
Mike
44,400
$14.00
$3.10...
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 64,000 $22.00 $4.10 56,000 $ 8.00 $2.50 49,000 $38.50 $8.54 45,600 $13.00 $3.40 339,000 $ 9.40 $4.60 Direct...