Financial and Managerial Accounting 7th Edition Chapter 20 P

Financial and Managerial Accounting (7th Edition) Chapter 20, Problem 4PB. Need the solutions for number 5 through 10 (only) I just need 5 to 7 checked.

Sales Budget

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

Next months unit sale

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

Sales Budget
	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

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

Solution

Part 5 NABAR MANUFACTURING Factory Overhead Budget July, August, and September 2017 July August Sept. Total Budgeted production (units) 17500 19700 22800 Variable factory overhead rate( $2.70 per direct labor hour x 0.50 direct labor hours per unit) x $1.35 x $1.35 x $1.35 Budgeted variable overhead $23,625.00 $26,595.00 $30,780.00 $81,000.00 Fixed overhead $20,000.00 $20,000.00 $20,000.00 $60,000.00 Budgeted total overhead $43,625.00 $46,595.00 $50,780.00 $141,000.00 Part 6 NABAR MANUFACTURING Selling Expense Budgets July, August, and September 2017 July August Sept. Total Budgeted sales $357,000.00 $323,000.00 $340,000.00 Sales commission percent x 10% x 10% x 10% Sales commissions expense $35,700.00 $32,300.00 $34,000.00 $102,000.00 Sales Salaries $3,500.00 $3,500.00 $3,500.00 $10,500.00 Total selling expenses $39,200.00 $35,800.00 $37,500.00 $112,500.00 Part 7 NABAR MANUFACTURING General and Administrative Expense Budgets July, August, and September 2017 July August Sept. Total Salaries $9,000.00 $9,000.00 $9,000.00 $27,000.00 Interest on long-term note $2,700.00 $2,700.00 $2,700.00 $8,100.00 Total expenses $11,700.00 $11,700.00 $11,700.00 $35,100.00 Part 8 NABAR MANUFACTURING Cash Budgets July, August, and September 2018 July August Sept. Beginning cash balance $40,000.00 $96,835.00 $141,180.00 Cash receipts from customers (note A) $357,000.00 346800 328100 Total cash available $397,000.00 $443,635.00 $469,280.00 Cash disbursements Payments for raw materials (note B) $51,400.00 $50,760.00 $81,280.00 Payments for direct labor $140,000.00 $157,600.00 $182,400.00 Payments for variable overhead $23,625.00 $26,595.00 $30,780.00 Sales commissions $35,700.00 $32,300.00 $34,000.00 Sales salaries $3,500.00 $3,500.00 $3,500.00 General & administrative salaries $9,000.00 $9,000.00 $9,000.00 Income taxes $10,000.00 Dividends $20,000.00 Loan interest ($24,000 x 1%) $240.00 Long-term note interest ($300,000 x .0.9%) $2,700.00 $2,700.00 $2,700.00 Purchase of equipment $100,000.00 Total cash disbursements $276,165.00 $302,455.00 $443,660.00 Preliminary cash balance $120,835.00 $141,180.00 $25,620.00 Additional loan $14,380.00 Repayment of loan to bank -$24,000.00 Ending cash balance $96,835.00 $141,180.00 $40,000.00 Loan balance, end of month $0.00 $0.00 $14,380.00 Working Notes: July August Sept. Total Note A: Cash receipts from customers Total sales $357,000.00 $323,000.00 $340,000.00 $1,020,000.00 Cash sales (30%) $107,100.00 $96,900.00 $102,000.00 $306,000.00 Credit sales (70%) $249,900.00 $226,100.00 $238,000.00 $714,000.00 Cash collections Month after sale (100%) $249,900.00 $249,900.00 $226,100.00 $725,900.00 Cash Sales (30%) $107,100.00 $96,900.00 $102,000.00 $306,000.00 Total cash received $357,000.00 $346,800.00 $328,100.00 $1,031,900.00 Note B: Cash payments for raw materials Month after purchase (100%) $51,400.00 $50,760.00 $81,280.00 $183,440.00 Part 9 NABAR MANUFACTURING Budgeted Income Statement For Three Months Ended September 30, 2017 Sales $1,020,000.00 Cost of goods sold (60,000 units @ $14.35) 861000 Gross profit $159,000.00 Operating expenses Sales commissions $102,000.00 Sales salaries 10500 General administrative salaries 27000 Long-term note interest 8100 Interest expense 240 $147,840.00 Income before taxes $11,160.00 Income taxes (35%) $3,906.00 Net income $7,254.00