Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following are given the schedule of budget for a company: Sales Budget For the Year Ended December 31, 2018 Quarter 1 Quarter 2 Quarter

The following are given the schedule of budget for a company:

Sales Budget

For the Year Ended December 31, 2018

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Total

Expected sales (unis)

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 December 31, 2018

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Q1 Year 2

Expected sales (unis)

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

Less: beginning inventory

1,500

1,650

1,750

1,800

1,600

Required production

7,650

8,350

8,800

?

7,300

Direct Material Budget

For the Year Ended December 31, 2018

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Total

Unites to be produced

7,650

8,350

8,800

8,800

33,600

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

4,175

4,400

4,400

0

Pounds of D. material purchase requirement

19,475

16,925

17,600

16,850

70,850

Cost per pound

$1.59

$1.59

$1.59

$1.59

$1.59

Total cost of direct material purchase

$29,213

$25,388

$26,400

$25,275

$106,275

Total

?

$106,275

Direct Labor Budget

For the Year Ended December 31, 2018

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Total

Unites to be produced

7,650

8,350

8,800

?

?

Direct labor cost per unit

0.75

0.75

0.75

0.75

0.75

Total required direct labor hours

5,738

6,263

6,600

6,600

?

Labor cost per hour

$25

$25

$25

$25

$25

Total direct labor cost

$143,438

$156,563

$165,000

?

$630,000

Required

Fill in the missing information (marked with a "?" sign) from the above schedules

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

Microeconomics An Intuitive Approach with Calculus

Authors: Thomas Nechyba

1st edition

538453257, 978-0538453257

Students also viewed these Accounting questions