Locked Where:Pictures The management of Nabar Manufacturing pre ollowing estimat

Question

Locked Where:Pictures The management of Nabar Manufacturing pre ollowing estimated balance sheet for June 2017: Problem 20-48 NABAR MANUFACTURING Estimated Balance Sheet June 30, 2017 acturing Prepartc of master budge P1 P2 P3 Assets Liabilities and Equity 40,000 249,900 35,000 241,080 565,980 720,000 Accounts payable Income taxes payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity$1.045,980 $ 51,400 0,000 24,000 5,400 300,000 385,400 600,000 60,580 660,580 Cash Raw materials inventory Finished goods inventory .. Equipment 240,000) 480,000 Total assets. $1,045,980 o prepare a master budget for July, August, and September of 2017, management gathers the following a sales were 20.000 units in June. ntormation: units in June. Forecasted sales in units are as follows: July, 21,000; August, 19,000 product tember mpany policy calls for a given month's ending finished goods inventory to equal 70% of the next s expected unit sales. The June 30 finished goods inventory is 16.800 units, which does not er.20,000, and October, 24,000. The product's selling price is $17 per unit and its total prod- uct cost is $14.35 per unit. Co comply with the policy

Explanation / Answer

Solution:

Part 1 --- Sales Budget

Sales Budget

For the Third Quarter

July

August

September

Total Quarter Third

Expected Sales Unit

21000

19000

20000

60000

Unit Selling Price

$17

$17

$17

$17

Budgeted Sales in dollars

$357,000

$323,000

$340,000

$1,020,000

Part 2 --- Production Budget

Production Budget

For the Third Quarter

Working

July

August

September

Total Quarter Third

October

Expected Sales Unit

21000

19000

20000

24000

Plus: Desired Ending Finished Goods Inventory (70% of Next Month's Expected Unit Sales)

13300

14000

16800

(24,000*70%)

Total Needs

34300

33000

36800

Less: Estimated Beginning Finished Goods Inventory (Ending Inventory of last month)

16800

13300

14000

Required Production in Units

17500

19700

22800

60000

Part 3 – Raw Materials Budget

Raw Materials Budget

For the Third Quarter

July

August

September

Total Quarter Third

Budgeted Units to be produced

17,500

19,700

22,800

Required Direct materials per unit of finished product in units

0.5

0.5

0.5

Direct materials needed for production

8750

9850

11400

Plus: Desired Raw Material Ending Inventory (20% of next month's production needs)

1970

2280

1980

(Given)

Total direct materials needed

10720

12130

13380

Less: Estimated Beginning Raw materials Inventory

4375

(given)

1970

2280

Budgeted Raw Materials purchases in units

6345

10160

11100

Direct materials cost per unit

$8

$8

$8

Budgeted cost of direct materials

$50,760

$81,280

$88,800

$220,840

Part 4 – Direct labor Budget

Direct Labor Budget

July

August

September

Total Quarter Third

Budgeted Bats to be produced

17500

19700

22800

Direct Labor hour needed per unit

0.5

0.5

0.5

Direct labor hours needed for production

8750

9850

11400

Hourly Rate

$16

$16

$16

Budgeted Direct Labor Costs

$140,000

$157,600

$182,400

$480,000

Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you

Pls ask separate question for remaining parts

Sales Budget

For the Third Quarter

July

August

September

Total Quarter Third

Expected Sales Unit

21000

19000

20000

60000

Unit Selling Price

$17

$17

$17

$17

Budgeted Sales in dollars

$357,000

$323,000

$340,000

$1,020,000

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.