Calculation of direct labor hours per unit = Direct labor cost per unit/Rate per hour | |||||
Direct labor Cost | Rate per hour | Direct Labor hours per unit | |||
Debbie | 3.2 | 8 | 0.4 | ||
Trish | 1.04 | 8 | 0.13 | ||
Sarah | 5.6 | 8 | 0.7 | ||
Mike | 4 | 8 | 0.5 | ||
Sewing Machine | 0.64 | 8 | 0.08 | ||
Calculation of variable overhead cost per unit | |||||
Variable overhead cost per unit = Labor hours per unit*Variable overhead cost per unit | |||||
Direct Labor hours per unit | Rate per hour | Variable overhead cost per unit | |||
Debbie | 0.4 | 5 | 2 | ||
Trish | 0.13 | 5 | 0.65 | ||
Sarah | 0.7 | 5 | 3.5 | ||
Mike | 0.5 | 5 | 2.5 | ||
Sewing Machine | 0.08 | 5 | 0.4 | ||
Debbie | Trish | Sarah | Mike | Sewing kit | |
Selling price per unit | 22 | 8 | 38.5 | 13 | 9.4 |
Direct Material | 4.1 | 2.5 | 8.54 | 3.4 | 4.6 |
Direct Labor | 3.2 | 1.04 | 5.6 | 4 | 0.64 |
Variable overhead | 2 | 0.65 | 3.5 | 2.5 | 0.4 |
Contribution Margin per Unit (A) | 12.7 | 3.81 | 20.86 | 3.1 | 3.76 |
Direct Labor hours per unit (B) | 0.4 | 0.13 | 0.7 | 0.5 | 0.08 |
Contribution margin per direct labor hour(A/B) | 31.75 | 29.3076923 | 29.8 | 6.2 | 47 |
4.Labor hours will be allocated on the basis of maximum contribution margin per hour | |||||
Product | Units | Labor hours per unit | Total Labor hours | Contribution Margin | |
Debbie | 64,000 | 0.4 | 25,600 | 812,800 | |
Trish | 56,000 | 0.13 | 7,280 | 213,360 | |
Sarah | 49,000 | 0.7 | 34,300 | 1,022,140 | |
Mike | 22,800 | 0.5 | 11,400 | 70,680 | |
Sewing Kit | 339,000 | 0.08 | 27,120 | 1,274,640 | |
Total | 105,700 | 3,393,620 | |||
5.highest direct labor rate per hour = Cost + Contribution margin per hour | |||||
=$8+6.2 | |||||
14.2 | per hour |
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company's products is increasing,...
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 58,000 $26.00 $5.10 50,000 $ 7.50 $1.90 43.000 $41.50 $7.64 48,000 $11.00 $2.80 333,000 $8.80 $4.00 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...
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...
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 Demand selling Next year Price (units) per Unit 53,000 $19.69 45,000 $7.99 38,000 $29.00 32.000 $13.00 328,000 $ 8.30 Direct Materials $4.60 $1.40 $6.89 52.30 $3.50 Direct Labor $ 4.40 S...
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 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: 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...