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,300 8,700 9,000 Total Sales price per unit $46 $49 $49 $54 Total sales revenue $349,600 $406,700 $426,300 $ Production Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 7,600 8,300 8,700 1,660 1,740 1,800 Q1, Year 2 9,000 8,000 Expected sales Desired ending inventory 900 Total required units 9,260 10,040 10,600 8,900 10,500 1,740 Less: Beginning inventory 1,520 1,660 1,800 1,600 Required production 7,740 8,380 8,760 7,300 Total Direct Materials Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 7,740 8,380 8,760 2 2 2 Quarter 4 Total Units to be produced 8,800 33,680 Direct material per unit 2 2 67,360 15,480 4,190 16,760 4,380 17,520 4,400 Total pounds needed for production Add: Desired ending inventory Total material required Less: Beginning inventory Pounds of direct material purchase requirements 17,600 3,650 21,250 3,650 19,670 21,920 71,010 21,140 4,190 0 4,380 4,400 19,670 16,950 17,540 16,850 71,010 Cost per pound $1.50 $1.50 $1.50 $1.50 $1.50 Total cost of direct material purchase $29,505 $25,425 $26,310 $25,275 $106,515 Total $106,515 Direct Labor Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,740 8,380 8,760 Direct labor hours per unit 0.75 0.75 0.75 0.75 0.75 Total required direct labor hours 5,805 6,285 6,570 6,600 Labor cost per hour $25 $25 $25 $25 $25 Total direct labor cost $145,125 $157,125 $164,250 $ $631,500

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

Recommended Textbook for

Financial Reporting And Analysis

Authors: Lawrence Revsine, Daniel Collins, Bruce Johnson, Fred Mittelstaedt, Leonard Soffer

8th Edition

1260247848, 978-1260247848

Students also viewed these Accounting questions