Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fill in the missing information from the following schedules: Sales Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter

Fill in the missing information from the following schedules:

Sales Budget
For the Year Ending Dec. 31, 2018
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total
Expected sales (units) 7,500 8,400 8,800 9,100 fill in the blank 1
Sales price per unit $44 $50 $50 $54
Total sales revenue $330,000 $420,000 $440,000 $fill in the blank 2 $fill in the blank 3

Production Budget
For the Year Ending Dec. 31, 2018
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Q1, Year 2
Expected sales 7,500 8,400 8,800 9,100 7,900
Desired ending inventory 1,680 1,760 1,820 fill in the blank 4 880
Total required units 9,180 10,160 10,620 10,680 8,780
Less: Beginning inventory 1,500 1,680 1,760 1,820 1,580
Required production 7,680 8,480 8,860 fill in the blank 5 7,200
Total fill in the blank 6

Direct Materials Budget
For the Year Ending Dec. 31, 2018
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total
Units to be produced 7,680 8,480 8,860 8,860 33,880
Direct material per unit 2 2 2 2 2
Total pounds needed for production 15,360 16,960 17,720 17,720 67,760
Add: Desired ending inventory 4,240 4,430 4,430 3,600 3,600
Total material required 19,600 21,390 22,150 21,320 71,360
Less: Beginning inventory 0 4,240 4,430 4,430 -
Pounds of direct material purchase requirements 19,600 17,150 17,720 16,890 71,360
Cost per pound $1.50 $1.50 $1.50 $1.50 $1.50
Total cost of direct material purchase $29,400 $25,725 $26,580 $25,335 $107,040
Total $fill in the blank 7 $107,040

Direct Labor Budget
For the Year Ending Dec. 31, 2018
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total
Units to be produced 7,680 8,480 8,860 fill in the blank 8 fill in the blank 9
Direct labor hours per unit 0.75 0.75 0.75 0.75 0.75
Total required direct labor hours 5,760 6,360 6,645 6,645 fill in the blank 10
Labor cost per hour $25 $25 $25 $25 $25
Total direct labor cost $144,000 $159,000 $166,125 $fill in the blank 11 $635,250

Feedback Area

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions