80.2K

Verified Solution

Link Copied!

Sales Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Expected sales (units) 7,600 8,200 8,600 8,900 $44 $51 $51 Sales price per unit Total sales revenue $334,400 $418,200 $438,600 $ Production Budget For the Year Ending Dec. 31, 2018 $56 | Quarter 1 Quarter 2 Quarter 3 Quarter 4 Q1, Year 2 Expected sales 7,600 8,200 8,600 8,900 8,000 Desired ending inventory 1,640 1,720 1,780 900 Total required units 9,240 9,920 10,380 10,500 8,900 Less: Beginning inventory 1,520 1,640 1,720 1,780 1,600 Required production 7,720 8,280 8,660 7,300 Total Direct Materials Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced Direct material per unit 7,720 8,280 8,660 8,720 33,380 2 2 2 2 2 Total pounds needed for production 15,440 16,560 17,320 17,440 66,760 Add: Desired ending inventory 4,140 4,330 4,360 3,650 3,650 Total material required 19,580 20,890 21,680 21,090 70,410 Less: Beginning inventory 0 4,140 4,330 4,360 Pounds of direct material purchase requirements 19,580 16,750 17,350 16,730 70,410 Cost per pound $1.50 $1.50 Total cost of direct material purchase $29,370 $25,125 $1.50 $26,025 $1.50 $1.50 $25,095 $105,615 Total $105,615 Direct Labor Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,720 8,280 8,660 Direct labor hours per unit 0.75 0.75 0.75 0.75 0.75 Total required direct labor hours 5,790 6,210 6,495 6,540 Labor cost per hour $25 $25 $25 $25 $25 Total direct labor cost $144,750 $155,250 $162,375 $ $625,875

Answer & Explanation Solved by verified expert

See Answer