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,600 8,200 8,800 9,100 ___
Sales price per unit $45 $49 $49 $55
Total sales revenue $342,000 $401,800 $431,200 $___ $___

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,200 8,800 9,100 8,100
Desired ending inventory 1,640 1,760 1,820 ___ 880
Total required units 9,240 9,960 10,620 10,720 8,980
Less: Beginning inventory 1,520 1,640 1,760 1,820 1,620
Required production 7,720 8,320 8,860 ___ 7,360
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,720 8,320 8,860 8,900 33,800
Direct material per unit 2 2 2 2 2
Total pounds needed for production 15,440 16,640 17,720 17,800 67,600
Add: Desired ending inventory 4,160 4,430 4,450 3,680 3,680
Total material required 19,600 21,070 22,170 21,480 71,280
Less: Beginning inventory 0 4,160 4,430 4,450 -
Pounds of direct material purchase requirements 19,600 16,910 17,740 17,030 71,280
Cost per pound $1.50 $1.50 $1.50 $1.50 $1.50
Total cost of direct material purchase $29,400 $25,365 $26,610 $25,545 $106,920
Total $___ $106,920

Direct Labor Budget
For the Year Ending Dec. 31, 2018
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total
Units to be produced 7,720 8,320 8,860 ___ ___
Direct labor hours per unit 0.75 0.75 0.75 0.75 0.75
Total required direct labor hours 5,790 6,240 6,645 6,675 ___
Labor cost per hour $25 $25 $25 $25 $25
Total direct labor cost $144,750 $156,000 $166,125 $___ $633,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 And Finance For Lawyers In A Nutshell

Authors: Charles Meyer

7th Edition

1647083001, 9781647083007

More Books

Students also viewed these Accounting questions

Question

Describe the concept of corporate social responsibility.

Answered: 1 week ago

Question

Explore the concept of business ethics.

Answered: 1 week ago

Question

Discuss human resource management issues for small businesses.

Answered: 1 week ago