90.2K

Verified Solution

Link Copied!

instant like

Current Designs 9 (Part Level Submission) Diane luswell is preparing the 2020 budget for one of Current Designs Fotomoded kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2020. Quarter: 2,300 kayaks Quarter 2 3.100 kayaks Quarter 3 1.900 kayaks Quarter 4 1.900 kayaks Current Designs' polky is to have finished goods ending inventory in a quarter equal to 25% of the next quarter's anticipated sales. Preliminary sales projections for 2021 are 1,100 units for their quarter and 300 nits for the second quarter Ending inventory of finished goods at December 31, 2019, will be 575 rotomelded kayaks. Production of each waynkroovires 42 pounds of polyethylene powder and a finishing ke trope, stat, hardware, etc.). Company policy is that the ending inventory of polyethylene powder should be 20w of the amaunt meded for production in the next quarter Amund that the ending wventory of polyethylene powder on December 31, 2019, s 19,00 pound. The fishing kes ombe assembled as they are needed. As a result, Current Designs does not maintain a significant inventory of the finishing The polyethylene powdered in these kayaks costs $1.50 per pound, and the finishing its cost $180 each. Production of a single kayak requires 4 hours of time by more experience, type employees and 5 hours of fishing time by type It employees. The type employees are paid $12 per hour, and the type 11 employees are paid 19 per hour Selling and administrative expenses for this line are expected to be 150 per ut soit plus $7.500 per quarter Manufacturing overhead signed at 140% of labor costs (a) Your answer is correct. Prepare the production budget for this product line by quarter and in total for 2020 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 Q1 Q2 Q3 Q4 Total Expected Unit Sales 2300 3100 1900 1900 Add Desired Ending Finished Goods Unit 775 475 475 275 Total Required Units 3075 3575 2375 2175 Less Beginning Finished Goods Unit 575 775 475 475 2500 2800 1900) 1200 Required Production Units 8900 Prepare the direct materials budget for this product line by quarter and in total for 2020. (Round cost per pound to 2 decimal places, e.g. 1.25 and o 125.) CURRENT DESIGNS Direct Materials Budget-Polyethylene Powder For the Year Ending December 31, 2020 Quarter ody Q1 Q2 Q3 Q4 Total Units to be produced 2500 2800 1900 1700 E Pounds of polyethylene Powder Per Unit 42 42 42 42 Total Pounds Nended for production 105000 117600 79000 21400 Add Desired Ending Inventory of Powder 23520 15960 14250 13440 Total Pounds of Powder Required 128520 133560 94080 84840 Beginning Inventory of Powder 100100 23520 15900 14200 Pounds of Polyethylene Powder to be purchased 108720 110040 78120 70560 Cost Per Pound 1.5 1.5 117100 105840 Collane whether 1630 165060 vent Pay Policy.2000-2021 thn Wiley & Sons, Inc. All Rights Reserved. A Division of John Wiley Sons, Inc Your answer is correct. Prepare the direct labor budget for this product line by quarter and in total for 2020. CURRENT DESIGNS Direct labor Budget For the Year Ending December 31, 2020 Q1 Q2 More skilled labor Q3 04 TOTAL Units to be produced 2500 2800 1900 1700 9900 E Direct Labor Time (Hours) Per Unit Total Required Direct Labor Hours 10000 11200 75001 6800 35600 Direct Labor Cost Per Hour 12 12 12 12 120000 134400 91200 81600) 4272001 Total Direct Labor Cost for More Skilled Labor Less skilled labor Q1 Q2 Q) Q4 TOTAL Units to be produced 2500 2000 1900 1700 8900 Direct Labor Time (Hours) Per Unit 9500 1500 44500 Total Required Direct Labor Hours 12500l 16000 vacy Policy 2000-2021 John Wiley Sons, Inc. All Rights Reserved. A Division of an Willy Sons, Inc (d) Prepare the manufacturing overhead budget for this product line by quarter and in total for 2020. CURRENT DESIGNS Manufacturing Overhead Budget Q1 Q2 Q3 04 TOTAL M Attempts: 0 of 2 used SAVE FOR LATER SUS Current Designs 9 (Part Level Submission) Diane luswell is preparing the 2020 budget for one of Current Designs Fotomoded kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2020. Quarter: 2,300 kayaks Quarter 2 3.100 kayaks Quarter 3 1.900 kayaks Quarter 4 1.900 kayaks Current Designs' polky is to have finished goods ending inventory in a quarter equal to 25% of the next quarter's anticipated sales. Preliminary sales projections for 2021 are 1,100 units for their quarter and 300 nits for the second quarter Ending inventory of finished goods at December 31, 2019, will be 575 rotomelded kayaks. Production of each waynkroovires 42 pounds of polyethylene powder and a finishing ke trope, stat, hardware, etc.). Company policy is that the ending inventory of polyethylene powder should be 20w of the amaunt meded for production in the next quarter Amund that the ending wventory of polyethylene powder on December 31, 2019, s 19,00 pound. The fishing kes ombe assembled as they are needed. As a result, Current Designs does not maintain a significant inventory of the finishing The polyethylene powdered in these kayaks costs $1.50 per pound, and the finishing its cost $180 each. Production of a single kayak requires 4 hours of time by more experience, type employees and 5 hours of fishing time by type It employees. The type employees are paid $12 per hour, and the type 11 employees are paid 19 per hour Selling and administrative expenses for this line are expected to be 150 per ut soit plus $7.500 per quarter Manufacturing overhead signed at 140% of labor costs (a) Your answer is correct. Prepare the production budget for this product line by quarter and in total for 2020 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 Q1 Q2 Q3 Q4 Total Expected Unit Sales 2300 3100 1900 1900 Add Desired Ending Finished Goods Unit 775 475 475 275 Total Required Units 3075 3575 2375 2175 Less Beginning Finished Goods Unit 575 775 475 475 2500 2800 1900) 1200 Required Production Units 8900 Prepare the direct materials budget for this product line by quarter and in total for 2020. (Round cost per pound to 2 decimal places, e.g. 1.25 and o 125.) CURRENT DESIGNS Direct Materials Budget-Polyethylene Powder For the Year Ending December 31, 2020 Quarter ody Q1 Q2 Q3 Q4 Total Units to be produced 2500 2800 1900 1700 E Pounds of polyethylene Powder Per Unit 42 42 42 42 Total Pounds Nended for production 105000 117600 79000 21400 Add Desired Ending Inventory of Powder 23520 15960 14250 13440 Total Pounds of Powder Required 128520 133560 94080 84840 Beginning Inventory of Powder 100100 23520 15900 14200 Pounds of Polyethylene Powder to be purchased 108720 110040 78120 70560 Cost Per Pound 1.5 1.5 117100 105840 Collane whether 1630 165060 vent Pay Policy.2000-2021 thn Wiley & Sons, Inc. All Rights Reserved. A Division of John Wiley Sons, Inc Your answer is correct. Prepare the direct labor budget for this product line by quarter and in total for 2020. CURRENT DESIGNS Direct labor Budget For the Year Ending December 31, 2020 Q1 Q2 More skilled labor Q3 04 TOTAL Units to be produced 2500 2800 1900 1700 9900 E Direct Labor Time (Hours) Per Unit Total Required Direct Labor Hours 10000 11200 75001 6800 35600 Direct Labor Cost Per Hour 12 12 12 12 120000 134400 91200 81600) 4272001 Total Direct Labor Cost for More Skilled Labor Less skilled labor Q1 Q2 Q) Q4 TOTAL Units to be produced 2500 2000 1900 1700 8900 Direct Labor Time (Hours) Per Unit 9500 1500 44500 Total Required Direct Labor Hours 12500l 16000 vacy Policy 2000-2021 John Wiley Sons, Inc. All Rights Reserved. A Division of an Willy Sons, Inc (d) Prepare the manufacturing overhead budget for this product line by quarter and in total for 2020. CURRENT DESIGNS Manufacturing Overhead Budget Q1 Q2 Q3 04 TOTAL M Attempts: 0 of 2 used SAVE FOR LATER SUS

Answer & Explanation Solved by verified expert

See Answer