Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sales Budget July August September Total Units to be sold 20,000 35,000 25,000 80,000 Sales price $180 $180 $180 $180 Total sales dollars $3,600,000 $6,300,000

Sales Budget

July

August

September

Total

Units to be sold

20,000

35,000

25,000

80,000

Sales price

$180

$180

$180

$180

Total sales dollars

$3,600,000

$6,300,000

$4,500,000

$14,400,000

Production Budget

July

August

September

Total

Sales

20,000

35,000

25,000

80,000

Add: Desired ending inventory

7,000

5,000

6,000

6,000

Total needs

27,000

40,000

31,000

86,000

Less: Beginning inventory

(4,000)

(7,000)

(5,000)

(4,000)

Units to be produced

23,000

33,000

26,000

82,000

Direct Materials Budget

July

August

September

Total

Units to be produced

23,000

33,000

26,000

82,000

lbs per unit

3

3

3

3

Pounds needed

69,000

99,000

78,000

246,000

Desired ending inventory

29,700

23,400

25,200

25,200

Total needs

98,700

122,400

103,200

271,200

Less beginning inventory

(20,700)

(29,700)

(23,400)

(20,700)

Purchases needed

78,000

92,700

79,800

250,500

$20.00/lb

$20

$20

$20

$20

Total purchase cost

$1,560,000

$1,854,000

$1,596,000

$5,010,000

Direct Labor Budget

July

August

September

Total

Units to be produced

23,000

33,000

26,000

82,000

0.60 of direct labor hours per unit

0.60

0.60

0.60

0.60

Direct labor hours needed

13,800

19,800

15,600

49,200

$16.00 per hour

$16.00

$16.00

$16.00

$16.00

Total direct labor cost

$220,800

$316,800

$249,600

$787,200

Overhead Budget

July

August

September

Total

Labor hours

13,800

19,800

15,600

49,200

variable rate per hour

$3.50

$3.50

$3.50

$3.50

Total variable OH

$48,300

$69,300

$54,600

$172,200

Fixed overhead

$22,000

$22,000

$22,000

$ 66,000

Total overhead

$70,300

$91,300

$76,600

$238,200

Selling and Administrative Budget

July

August

September

Total

Variable selling expense

$108,000

$189,000

$135,000

$432,000

Fixed expenses:

Rent

6,000

6,000

6,000

18,000

Utilities

1,200

1,200

1,200

3,600

Advertising

400

400

400

1,200

Office salaries

35,000

35,000

35,000

105,000

Total

$150,600

$231,600

$177,600

$559,800

Calculate the Cost of Goods that would appear on the Income Statement for the month of July?

Please round all your calculations to two decimals.

Do not include "$" or commas in your answer

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

Students also viewed these Accounting questions