Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Could someone tell me why part 3 is wrong? Managerial Accounting ACCT 2013 Project Students are to complete the master budget project below using the

image text in transcribedimage text in transcribedimage text in transcribedCould someone tell me why part 3 is wrong?

Managerial Accounting ACCT 2013

Project

Students are to complete the master budget project below using the template worksheet provided.

Manufacturing: Preparation of the Master Budget

The management of Zigby Manufacturing prepared the following estimated Balance Sheet for March 2017.

To prepare a master budget for April, May and June 2017, management gathers the following information:

Part 1

ZIGBY MANUFACTURING

Sales Budgets

April, May, and June 2017

Budgeted Units

Budgeted Unit Price

Budgeted Total Dollars

April 2017 .......................................................

20,500

$23.85

$ 488,925

May 2017 ........................................................

19,500

23.85

465,075

June 2017 .......................................................

20,000

23.85

477,000

Total for the second quarter.........................

60,000

$1,431,000

Part 2

ZIGBY MANUFACTURING

Production Budget

April, May, and June 2017

April

May

June

Total

Next months budgeted sales (in units)........

19,500

20,000

20,500

Ratio of inventory to future sales ......

x 80%

x 80%

x 80%

Budgeted ending inventory................

15,600

16,000

16,400

Add budgeted sales (units)......................

19,700

19,900

20,400

Required units to be produced ..........

35,300

35,900

36,800

Deduct beginning inventory...............

16400

15600

16000

Units to be produced ..........................

18,900

20,300

20,800

60,000

Part 3

ZIGBY MANUFACTURING

Raw Materials Budget

April, May, and June 2017

April

May

June

Total

Production budget (units) ..................

18900

20,300

20,800

Materials requirement per unit...........

x 0.50

x 0.50

x 0.50

Materials needed for production........

9450

10,150

10,400

Add budgeted ending inventory ........

15,600

16,000

16,400

Total materials requirements (units) .

25050

26,150

26,800

Deduct beginning inventory...............

16400

15600

16000

Materials to be purchased..................

9,900

121

10,400

29,075

Material price per unit.........................

$ 20

$ 20

$ 20

$ 20

Total cost of raw material purchases.....

$198,000

$191,750

$208,000

$581,500

Part 4

ZIGBY MANUFACTURING

Direct Labor Budget

April, May, and June 2017

April

May

June

Total

Budgeted production (units) ..............

19,700

19,900

20,400

Labor requirements per unit (hours) .

x 0.50

x 0.50

x 0.50

Total labor hours needed ...................

9,850

9,950

10,200

30,000

Labor rate (per hour)...........................

$ 15

$ 15

$ 15

$ 15

Labor dollars .......................................

$147,750

$149,250

$153,000

$450,000

Part 5

ZIGBY MANUFACTURING

Factory Overhead Budget

April, May, and June 2017

April

May

June

Total

Labor hours needed (See DL Budget).........

9,850

9,950

10,200

Variable factory overhead rate (POHR calc)....

2.7

2.7

2.7

Budgeted variable overhead........

26,595

26,865

27,540

$ 121,000

Fixed overhead .............................

20,000

20,000

20,000

20,000

Budgeted total overhead..............

$46,595

$46,865

$47,540

$141,000

Part 6

ZIGBY MANUFACTURING

Selling Expense Budgets

April, May, and June 2017

April

May

June

Total

Budgeted sales .............................

$20,500

$19,500

$20,000

Sales commission percent ..........

8%

8%

8%

Sales commissions expense .......

1,640

1,560

1,600

$4,800

Sales salaries ................................

3,000

3,000

3,000

9,000

Total selling expenses .................

$ 4,640

$ 4,560

$ 4,600

$123,480

Part 7

ZIGBY MANUFACTURING

General and Administrative Expense Budgets

April, May, and June 2017

April

May

June

Total

Salaries.............................................

$12,000

$12,000

$12,000

$36,000

Interest on long-term note (.009)..........

4,500

4,500

4,500

13,500

Total expenses ................................

$16,500

$16,500

$16,500

$49,500

ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Liabilities and Equity Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation (150,000) Retained earnings Equipment, net Total assets 200,500 342.248 Short-term notes payable 12.000 212.500 325,540 Long-term note payable 500.000 712.500 335.000 208.788 450,000 Total stockholders' equity543.788 S1.256.288 Total liabilities and equity S1.256.28S S 40.000 Accounts payable 98.500 Total current liabilities S06.288 Total liabilities 600.000 Common stock

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_2

Step: 3

blur-text-image_3

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

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

23rd Edition

978-0324662962

More Books

Students also viewed these Accounting questions

Question

=+ a. A change in consumer preferences increases the saving rate.

Answered: 1 week ago