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

image text in transcribed

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 Expected sales (units) 7,600 8,200 8,800 8,900 Sales price per unit $50 $50 $54 Total sales revenue $349,600 $410,000 $440,000 Total $46 Production Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 7,600 8,200 8,800 8,900 Q1, Year 2 7,900 1,640 1,760 1,780 900 9,240 9,960 10,580 10,480 8,800 Expected sales Desired ending inventory Total required units Less: Beginning inventory Required production Total 1,520 1,640 1,760 1.780 1,580 7,720 8,320 8,820 7,220 Quarter 4 Total 8,700 33,560 2 2 17,400 67,120 Direct Materials Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Units to be produced 7,720 8,320 8,820 Direct material per unit 2 2 2 Total pounds needed for production 15,440 16,640 17,640 Add: Desired ending inventory 4,160 4,410 4,350 Total material required 19,600 21,050 21,990 Less: Beginning inventory 4,160 4,410 Pounds of direct material purchase requirements 19,600 16,890 17,580 Cost per pound $1.50 $1.50 $1.50 Total cost of direct material purchase $29,400 $25,335 $26,370 Total 3,610 3,610 21,010 70,730 0 4,350 16,660 70,730 $1.50 $1.50 $24,990 5106,095 $106,095 Direct Labor Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 7,720 8,320 8,820 Total 0.75 0.75 0.75 0.75 0.75 Units to be produced Direct labor hours per unit Total required direct labor hours Labor cost per hour Total direct labor cost 5,790 6,240 6,615 6,525 S25 S25 $25 $25 $25 $144,750 S156,000 $165,375 S $629,250

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Audit Security How To Plan Implement And Audit Netsuite Security

Authors: Zenobia Plautz

1st Edition

B0B5KQKXSY, 979-8840043851

More Books

Students also viewed these Accounting questions

Question

Does it exceed two pages in length?

Answered: 1 week ago

Question

Does it avoid typos and grammatical errors?

Answered: 1 week ago