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 transcribedimage 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 Total Expected sales (units) 7,600 8,400 8,600 8,900 Sales price per unit $46 $51 $51 $56 Total sales revenue $349,600 $428,400 $438,600 $ Production Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Q1, Year 2 Expected sales 7,600 8,400 8,600 8,900 7,900 Desired ending inventory 1,680 1,720 1,780 880 Total required units 9,280 10,120 10,380 10,480 8,780 Less: Beginning inventory 1,520 1,680 1,720 1,780 1,580 Required production 7,760 8,440 8,660 7,200 Accounting numeric field Total Direct Materials Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,760 8,440 8,660 8,700 33,560 Direct material per unit 2 2 2 2 2 Total pounds needed for production 15,520 16,880 17,320 17,400 67,120 Add: Desired ending inventory 4,220 4,330 4,350 3,600 3,600 Total material required 19,740 21,210 21,670 21,000 70,720 Less: Beginning inventory 0 4,220 4,330 4,350 Pounds of direct material purchase requirements 19,740 16,990 17,340 16,650 70,720 Cost per pound $1.50 $1.50 $1.50 $1.50 $1.50 Total cost of direct material purchase $29,610 $25,485 $26,010 $24,975 $ 106,080 Total $106,080 Direct Labor Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,760 8,440 8,660 Direct labor hours per unit 0.75 0.75 0.75 0.75 0.75 Total required direct labor hours 5,820 6,330 6,495 6,525 Labor cost per hour $25 $25 $25 $25 $25 Total direct labor cost $145,500 $ 158,250 $162,375 $ $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

More Books

Students also viewed these Accounting questions

Question

What is gravity?

Answered: 1 week ago

Question

What is the Big Bang Theory?

Answered: 1 week ago

Question

Which form of proof do you find most persuasive? Why?

Answered: 1 week ago