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,200 8,700 9,000 fill in the blank 1
Sales price per unit $46 $51 $51 $56
Total sales revenue $345,000 $418,200 $443,700 $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,200 8,700 9,000 7,900
Desired ending inventory 1,640 1,740 1,800 fill in the blank 4 920
Total required units 9,140 9,940 10,500 10,580 8,820
Less: Beginning inventory 1,500 1,640 1,740 1,800 1,580
Required production 7,640 8,300 8,760 fill in the blank 5 7,240
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,640 8,300 8,760 8,780 33,480
Direct material per unit 2 2 2 2 2
Total pounds needed for production 15,280 16,600 17,520 17,560 66,960
Add: Desired ending inventory 4,150 4,380 4,390 3,620 3,620
Total material required 19,430 20,980 21,910 21,180 70,580
Less: Beginning inventory 0 4,150 4,380 4,390 -
Pounds of direct material purchase requirements 19,430 16,830 17,530 16,790 70,580
Cost per pound $1.50 $1.50 $1.50 $1.50 $1.50
Total cost of direct material purchase $29,145 $25,245 $26,295 $25,185 $105,870
Total $fill in the blank 7 $105,870

Direct Labor Budget
For the Year Ending Dec. 31, 2018
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total
Units to be produced 7,640 8,300 8,760 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,730 6,225 6,570 6,585 fill in the blank 10
Labor cost per hour $25 $25 $25 $25 $25
Total direct labor cost $143,250 $155,625 $164,250 $fill in the blank 11 $627,750

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

Accounting, Chapters 1-13

Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac

25th Edition

1285069625, 9781285069623

More Books

Students also viewed these Accounting questions