i just need help with the direct materials budget

Question 2 View Policies Current Attempt in Progress Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2.900 kayaks 3.300 kayaks 2,700 kayaks 2.700 kayaks Current Designs policy is to have finished goods ending inventory in a quarter equal to 30% of the next quarter's antkated sales. Preliminary sales projections for 2021 are 1.100 units for the first quarter and 3.300 units for the second quarter. Ending Inventory of finished goods at December 31, 2019 will be 870 rotomolded kayaks. Production of each kayak requires 56 pounds of polyethylene powder and a nishing Kit trope, seat, hardware, etc.). Company policy is that the ending Inventory of polyethylene powder should be 25% of the amount needed for production in the next quarter Assume that the ending inventory of polyethylene powder on December 31, 2019, is 21.000 pounds. The finishing Kits can be assembled as they are needed. As a result, Current Designs does not maintain a significant inventory of the finishing kits. The polyethylene powder used in these kayak costs $1.40 per pound, and the fishing its cost $180 each. Production of a single Kayak requires 4 hours of time by more experienced, typer employees and 5 hours of finishing time by type ll employees. The type employees are paid $18 per hour, and the type il employees are paid $15 per hour Selling and administrative expenses for this line are expected to be $43 per unit sold plus $8,300 per quarter Manufacturing overhead is assigned at 150% of labor costs. Prepare the production budget for this product line by quarter and in total for 2020 CURRENT DESIGNS Production Budget For the Year Ending December 31, 2020 Expected Unit Sales Add : : Desired Ending Finished Goods Unit: Prepare the production budget for this product line by quarter and in total for 2020 CURRENT DESIGNS Production Budget December 31, 2020 For the Expected Unit Sales Add : : Desired Ending Goods Total Recured Units Les : Beginning shed Goods Unit Recured eTextbook and Media e Textbook 1 eTextbook 2 to decimal poses 125) Prepare the direct materials budget for this product line by quarter and in total for 2020. Round cost per pound to 2 decimales CURRENT DESIGNS Direct Materials Budget Polyethylene Powder For the Year Ending December 31, 2020 Quarter 91 92 93 Units to be produced Pounds of polyethylene Pow er Total Pounds Needed for production Add : : Desired Ending inventory of Powder Total Pounds of Powder Required : Lew : Being investory of Powder Pounds of Polyethylene Powder to be purchased SI Prepare the direct materials budget for this product line by quarter and in total for 2020. Round cost per pound to 2 decimal places. 1.25 and other answers to decimales. 125 CURRENT DESIGNS Direct Materials Budget-Polyethylene Powder For the Year Ending December 31, 2020 Quarter Pounds of polyethylene Powder Per Unit Total Pounds Needed for Production 169120 174720 151200 182280 Add : : Desired Ending storyal Powder Total Pounds of Powder Required Less! : Beginning inventory of Powder Pounds of the power to be chased Cost Per Pound Cost of Polyethylene Powder to be purchased Cost of Required i ng Total Costs for Direct Material : : : Assiste e Textbook and Media eTextbook 1 e Textbook 2 Prepare the direct labor budget for this product line by quarter and in total for 2020 CURRENT DESIGNS Direct labor Budget More skilled labor TOTAL Less skilled labor e Textbook and Media com/courses/29500/assignments/289830?module item id-722941 0.57/1 Question 2 View Policies Show Attempt History Current Attempt in Progress Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded kavaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2020. Quarter 1 Quarter 2 Quarter 3 Quarter 4 2.900 kayaks 3,300 kayaks 2.700 kayaks 2.700 kayaks Current Designs' policy is to have finished goods ending inventory in a quarter equal to 30% of the next quarter's anticipated sales. Preliminary sales projections for 2021 are 1,100 units for the first quarter and 3,300 units for the second quarter. Ending inventory of finished goods at December 31. 2019, will be 870 rotomolded kayaks. Production of each kayak requires 56 pounds of polyethylene powder and a finishing kit (rope,seat, hardware, etc.). Company policy is that the ending inventory of polyethylene powder should be 25% of the amount needed for production in the next quarter. Assume that the ending inventory of polyethylene powder on December 31, 2019, is 21,800 pounds. The finishing kits can be assembled as they are needed. As a result, Current Designs does not maintain a significant inventory of the finishing kits. The polyethylene powder used in these kayaks costs $1.40 per pound, and the finishing Kits cost $180 each. Production of a single kayak requires 4 hours of time by more experienced, type I employees and 5 hours of finishing time by type ll employees. The type I employees are paid $10 per hour, and the type ll employees are paid $15 per hour. Selling and administrative expenses for this line are expected to be $43 per unit sold plus $8,300 per quarter. Manufacturing overhead is assigned at 150% of labor costs. Your answer is correct. Prepare the production budget for this product line by quarter and in total for 2020 CURRENT DESIGNS Production Budget For the Year Ending December 31, 2020 Q2 3.300 810 Expected Unit Sales Add : Desired Ending Finished Goods Unite Total Required Units Lesst: Beginning Finished Goods Unit Required Production Units 4110 3510 810 3120 2700 11050 e Textbook and Media e Textbook 1 e Textbook 2 Prepare the direct materials budget for this product line by quarter and in total for 2020. Round cost per pound to 2 decimal places, s 125 and other answers to decimal places. 125) CURRENT DESIGNS Direct Materials Budget-Polyethylene Powder For the Year Ending December 31, 2020: Quarter Q2 56 151200 124320 Units to be produced Pounds of Polyethylene Powder Per Unit Total Pounds Needed for Production Add Desired Ending Inventory of Powder Total Pounds of Powder Required Less : Beginning invertory of Powder Pounds of Polyethylene Powder to be purchased 4360 37800 31000 212800 212520 182200 129770 1422801 [43650 1378001 0 31080) 170520 O Cost Per Pound 140 1.40 140 $ ! Cost of Polyethylene Powder to be purchased Cost of Required Finishing its 5377665 2200342 Total Costs for Direct Materials . Assista e Textbook and Media eTextbook 1 eTextbook 2 Question 2 View Policies Current Attempt in Progress Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2.900 kayaks 3.300 kayaks 2,700 kayaks 2.700 kayaks Current Designs policy is to have finished goods ending inventory in a quarter equal to 30% of the next quarter's antkated sales. Preliminary sales projections for 2021 are 1.100 units for the first quarter and 3.300 units for the second quarter. Ending Inventory of finished goods at December 31, 2019 will be 870 rotomolded kayaks. Production of each kayak requires 56 pounds of polyethylene powder and a nishing Kit trope, seat, hardware, etc.). Company policy is that the ending Inventory of polyethylene powder should be 25% of the amount needed for production in the next quarter Assume that the ending inventory of polyethylene powder on December 31, 2019, is 21.000 pounds. The finishing Kits can be assembled as they are needed. As a result, Current Designs does not maintain a significant inventory of the finishing kits. The polyethylene powder used in these kayak costs $1.40 per pound, and the fishing its cost $180 each. Production of a single Kayak requires 4 hours of time by more experienced, typer employees and 5 hours of finishing time by type ll employees. The type employees are paid $18 per hour, and the type il employees are paid $15 per hour Selling and administrative expenses for this line are expected to be $43 per unit sold plus $8,300 per quarter Manufacturing overhead is assigned at 150% of labor costs. Prepare the production budget for this product line by quarter and in total for 2020 CURRENT DESIGNS Production Budget For the Year Ending December 31, 2020 Expected Unit Sales Add : : Desired Ending Finished Goods Unit: Prepare the production budget for this product line by quarter and in total for 2020 CURRENT DESIGNS Production Budget December 31, 2020 For the Expected Unit Sales Add : : Desired Ending Goods Total Recured Units Les : Beginning shed Goods Unit Recured eTextbook and Media e Textbook 1 eTextbook 2 to decimal poses 125) Prepare the direct materials budget for this product line by quarter and in total for 2020. Round cost per pound to 2 decimales CURRENT DESIGNS Direct Materials Budget Polyethylene Powder For the Year Ending December 31, 2020 Quarter 91 92 93 Units to be produced Pounds of polyethylene Pow er Total Pounds Needed for production Add : : Desired Ending inventory of Powder Total Pounds of Powder Required : Lew : Being investory of Powder Pounds of Polyethylene Powder to be purchased SI Prepare the direct materials budget for this product line by quarter and in total for 2020. Round cost per pound to 2 decimal places. 1.25 and other answers to decimales. 125 CURRENT DESIGNS Direct Materials Budget-Polyethylene Powder For the Year Ending December 31, 2020 Quarter Pounds of polyethylene Powder Per Unit Total Pounds Needed for Production 169120 174720 151200 182280 Add : : Desired Ending storyal Powder Total Pounds of Powder Required Less! : Beginning inventory of Powder Pounds of the power to be chased Cost Per Pound Cost of Polyethylene Powder to be purchased Cost of Required i ng Total Costs for Direct Material : : : Assiste e Textbook and Media eTextbook 1 e Textbook 2 Prepare the direct labor budget for this product line by quarter and in total for 2020 CURRENT DESIGNS Direct labor Budget More skilled labor TOTAL Less skilled labor e Textbook and Media com/courses/29500/assignments/289830?module item id-722941 0.57/1 Question 2 View Policies Show Attempt History Current Attempt in Progress Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded kavaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2020. Quarter 1 Quarter 2 Quarter 3 Quarter 4 2.900 kayaks 3,300 kayaks 2.700 kayaks 2.700 kayaks Current Designs' policy is to have finished goods ending inventory in a quarter equal to 30% of the next quarter's anticipated sales. Preliminary sales projections for 2021 are 1,100 units for the first quarter and 3,300 units for the second quarter. Ending inventory of finished goods at December 31. 2019, will be 870 rotomolded kayaks. Production of each kayak requires 56 pounds of polyethylene powder and a finishing kit (rope,seat, hardware, etc.). Company policy is that the ending inventory of polyethylene powder should be 25% of the amount needed for production in the next quarter. Assume that the ending inventory of polyethylene powder on December 31, 2019, is 21,800 pounds. The finishing kits can be assembled as they are needed. As a result, Current Designs does not maintain a significant inventory of the finishing kits. The polyethylene powder used in these kayaks costs $1.40 per pound, and the finishing Kits cost $180 each. Production of a single kayak requires 4 hours of time by more experienced, type I employees and 5 hours of finishing time by type ll employees. The type I employees are paid $10 per hour, and the type ll employees are paid $15 per hour. Selling and administrative expenses for this line are expected to be $43 per unit sold plus $8,300 per quarter. Manufacturing overhead is assigned at 150% of labor costs. Your answer is correct. Prepare the production budget for this product line by quarter and in total for 2020 CURRENT DESIGNS Production Budget For the Year Ending December 31, 2020 Q2 3.300 810 Expected Unit Sales Add : Desired Ending Finished Goods Unite Total Required Units Lesst: Beginning Finished Goods Unit Required Production Units 4110 3510 810 3120 2700 11050 e Textbook and Media e Textbook 1 e Textbook 2 Prepare the direct materials budget for this product line by quarter and in total for 2020. Round cost per pound to 2 decimal places, s 125 and other answers to decimal places. 125) CURRENT DESIGNS Direct Materials Budget-Polyethylene Powder For the Year Ending December 31, 2020: Quarter Q2 56 151200 124320 Units to be produced Pounds of Polyethylene Powder Per Unit Total Pounds Needed for Production Add Desired Ending Inventory of Powder Total Pounds of Powder Required Less : Beginning invertory of Powder Pounds of Polyethylene Powder to be purchased 4360 37800 31000 212800 212520 182200 129770 1422801 [43650 1378001 0 31080) 170520 O Cost Per Pound 140 1.40 140 $ ! Cost of Polyethylene Powder to be purchased Cost of Required Finishing its 5377665 2200342 Total Costs for Direct Materials . Assista e Textbook and Media eTextbook 1 eTextbook 2