Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fill in the missing information from the following schedules: Solution Sales Budget For the Year Ended Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3

  1. Fill in the missing information from the following schedules:

Solution

Sales Budget

For the Year Ended Dec. 31, 2018

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Total

Expected Sales (units)

7,500

8,250

8,750

9,000

?????

Sales Price per Unit

$45

$50

$50

$55

Total Sales Revenue

$337,500

$412,500

$437,500

?????

$???????

Production Budget

For the Year Ended Dec. 31, 2018

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Q1, Year 2

Expected Sales

7,500

8,250

8,750

9,000

8,000

Desired Ending Inventory

1,650

1,750

1,800

?????

900

Total Required Units

9,150

10,000

10,550

10,600

8,900

Beginning Inventory

(1,500)

(1,650)

(1,750)

(1,800)

(1,600)

Required Production

7,650

8,350

8,800

?????

7,300

Total

?????

Direct Materials Budget

For the Year Ended Dec. 31, 2018

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Total

Units to Be Produced

?????

?????

????

????

????

Direct Material per Unit

2

2

2

2

2

Total Pounds Needed for Production

15,300

16,700

17,600

17,600

67,200

Desired Ending Inventory

4,175

4,400

4,400

3,650

3,650

Total Material Required

19,475

21,100

22,000

21,250

70,850

Beginning Inventory

0

(?????)

(?????)

(?????)

Pounds of Direct Material Purchase Requirements

19,475

16,925

17,600

16,850

70,850

Cost per Pound

$1.5

$1.5

$1.5

$1.5

$1.5

Total Cost of Direct Material Purchase

?????

?????

?????

?????

$106,275

Direct Labor Budget

For the Year Ended Dec. 31, 2018

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Total

Units to Be Produced

?????

?????

?????

?????

?????

Direct Labor Hours per Unit

0.75

0.75

0.75

0.75

0.75

Total Required Direct Labor Hours

?????

?????

?????

?????

?????

Labor Cost per Hour

$25

$25

$25

$25

$25

Total Direct Labor Cost

?????

?????

?????

?????

?????

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

Financial Accounting A Business Perspective

Authors: Roger H. Hermanson, James Don Edwards

7th Edition

0072289988, 978-0072289985

More Books

Students also viewed these Accounting questions