Principles of Financial Accounting.
Principles of Financial Accounting.
22nd Edition
ISBN: 9780077632892
Author: John J. Wild
Publisher: McGraw Hill
bartleby

Concept explainers

bartleby

Videos

Question
Book Icon
Chapter 22, Problem 4BP

1.

To determine

Prepare the sales budget of N Manufacturing for the first quarter.

1.

Expert Solution
Check Mark

Explanation of Solution

Sales Budget: The sales budget is the budget prepared to estimate the revenue, the expected number of units to be sold and the expected selling price for each product. The sales budget is the first step for an operating budget and the basis for the production and cost of goods sold budget.

Prepare the sales budget of N Manufacturing for the first quarter:

N Manufacturing
Sales Budgets
July, August, and September 2015
 Budgeted UnitsBudgeted Unit PriceBudgeted Total Dollars
July 201521,000$17.00$  357,000
August 201519,000  17.00323,000
September 201520,000  17.00     340,000
Total for the first quarter60,000 $1,020,000

Table (1)

Conclusion

Therefore, budgeted sales for N Manufacturing for the first quarter are 60,000 units for $1,020,000.

2.

To determine

Prepare the production budget of N Manufacturing for the first quarter.

2.

Expert Solution
Check Mark

Explanation of Solution

Production Budget: The production budget refers to that budget which forecasts the production for the future accounting period. The budgeted production for any financial period is planned by combining the forecasted unit of sales and the finished goods inventory and deducting the beginning goods inventory.

Prepare the production budget of N Manufacturing for the first quarter:

N Manufacturing
Production Budget
July, August, and September 2015
  JulyAugustSeptember Total
Next month’s budgeted sales (A)19,00020,00024,000 
Ratio of inventory to future sales (B)70%70%70% 
Budgeted ending inventory [(A)×(B)] 13,30014,00016,800 
Add: Budgeted sales21,000 19,000 20,000 
Required units to be produced34,30033,00036,800 
Less: Beginning inventory (16,800)(13,300)(14,000) 
Units to be produced17,500 19,700 22,80060,000

Table (2)

Conclusion

Therefore, Z manufacturing’s budgeted production for the first quarter is 60,000 units.

3.

To determine

Prepare the raw materials budget of N Manufacturing for the first quarter.

3.

Expert Solution
Check Mark

Explanation of Solution

Raw Materials Budget: The raw materials budget is prepared to estimate the number of units of raw materials used in the production to produce a product.

Prepare the raw materials budget of N Manufacturing for the first quarter:

N Manufacturing
Raw Materials Budget
July, August, and September 2015
  JulyAugustSeptember Total
Production budget (units) (A)17,50019,70022,800 
Materials requirement per unit (B)0.500.500.50 
Materials needed for production [(A)×(B)]8,7509,85011,400 
Add: budgeted ending inventory1,9702,2801,980 
Total materials requirements (units)10,72012,13013,380 
Less: beginning inventory(4,375)(1,970)(2,280) 
Materials to be purchased (units)6,34510,16011,10027,605
$8$8Material price per unit$8$8$8$8
Total cost of raw material purchases$50,760$81,280$88,800$220,840

Table (3)

Conclusion

Therefore, N manufacturing’s budgeted raw material for production for the first quarter is 27,605 units.

4.

To determine

Prepare the direct labour budget of N Manufacturing for the first quarter.

4.

Expert Solution
Check Mark

Explanation of Solution

Direct Labour Budget: The direct labour budget provides information about the total direct manufacturing labour hours and the cost of the total direct manufacturing labour hour.

Prepare the direct labour budget of N Manufacturing for the first quarter:

N Manufacturing
Direct Labour Budget
July, August, and September 2015
  JulyAugustSeptember Total
Budgeted production (units)17,50019,70022,800 
Labour requirements per unit (hours)0.500.500.50 
Total labour hours needed (A)8,7509,85011,40030,000
Labour rate (per hour) (B)$16$16$16$16
Labour dollars [(A)×(B)]$140,000$157,600$182,400$480,000

Table (4)

Note:

Total labour hours needed =Budgeted production (units)×Labour requirements per unit (hours)

Conclusion

Therefore, total labour hours needed by N Manufacturing for the first quarter is 30,000 hours.

5.

To determine

Prepare the factory overhead budget of N Manufacturing for the first quarter.

5.

Expert Solution
Check Mark

Explanation of Solution

Factory overhead: It includes all the budgeted manufacturing costs except direct material cost and direct labour cost.

Prepare the factory overhead budget of N Manufacturing for the first quarter:

N Manufacturing
Factory Overhead Budget
July, August, and September 2015
 JulyAugustSeptemberTotal
Labour hours needed (A)17,50019,70022,800 
Variable factory overhead rate (B)$1.35$1.35$1.35 
Budgeted variable overhead [(A)×(B)]23,62526,59530,780$ 81,000
Fixed overhead20,00020,00020,00060,000
Budgeted factory overhead (total)$43,625$46,595$50,780$141,000

Table (5)

Note (B): Variable factory overhead is $1.35 per hour ($2.70per labour hour×0.50 direct labour hours per unit)

Conclusion

Therefore, total budgeted factory overheads for the first quarter are $141,000.

6.

To determine

Prepare the selling expense budget of N Manufacturing for the first quarter.

6.

Expert Solution
Check Mark

Explanation of Solution

Selling expense budget: This budget shows the estimated selling expenses for the budgeted period.

Prepare the selling expense budget of N Manufacturing for the first quarter:

N Manufacturing
Selling Expense Budgets
July, August, and September 2015
 JulyAugustSeptemberTotal
Budgeted sales (A)$357,000$323,000$340,000 
Sales commission percent (B)10%10%10% 
Sales commissions expense [(A)×(B)]35,70032,30034,000$102,000
Sales salaries3,5003,5003,50010,500             
Total selling expenses$ 39,200$35,800$37,500$112,500

Table (6)

Conclusion

Therefore, total budgeted selling expense for the first quarter is $112,500.

7.

To determine

Prepare the General and administrative expenses budget of N Manufacturing for the first quarter.

7.

Expert Solution
Check Mark

Explanation of Solution

General and administrative expense budget: This budget shows the estimated General and administrative expenses for the budgeted period.

Prepare the selling expense budget of N Manufacturing for the first quarter:

N Manufacturing
General and administrative Expense Budgets
July, August, and September 2015
 JulyAugustSeptemberTotal
Salaries(A)$9,000$9,000$9,000$27,000
Interest rate on long-term note (B)0.90%0.90%0.90% 
Long term note (C)$300,000$300,000$300,000 
Sales commissions expense D=[(B)×(C)]2,7002,7002,7008,100
Total budgeted general and administrative expenses (A)+(D) $11,700$11,700$11,700$35,100

Table (7)

Conclusion

Therefore, total budgeted general and administrative expense for the first quarter is $35,100.

8.

To determine

Prepare the cash budget of N Manufacturing for the first quarter.

8.

Expert Solution
Check Mark

Explanation of Solution

Cash budget: This budget shows the total cash receipts and cash disbursements for the budgeted period.

Prepare the cash budget of N Manufacturing for the first quarter:

N Manufacturing
Cash Budgets
July, August, and September 2015
 JulyAugustSeptember
Beginning cash balance$40,000$96,835$141,180
Cash receipts from customers (Working note A)357,000346,800328,100
Total cash available397,000443,635469,280
Cash disbursements:   
Payments for raw materials (Working note B)51,40050,76081,280
Payments for direct labour140,000157,600182,400
Payments for variable overhead23,62526,59530,780
Sales commissions35,70032,30034,000
Sales salaries3,5003,5003,500
General & administrative salaries9,0009,0009,000
Income tax10,000  
Dividends 20,000 
Loan interest ($24,000×1%) 240  
Long-term note interest ($300,000×0.90%) 2,7002,7002,700
Purchase of equipment$0$0100,000
Total cash disbursements276,165302,455443,660
Preliminary cash balance120,835141,18025,620
Additional loan  14,380
Repayment of loan to bank(24,000)$0$0
Ending cash balance$96,835$141,180$40,000
Loan balance, end of month$0$0$14,380 

Table (8)

Working note A: Compute the cash receipts from customers:

 JulyAugustSeptemberTotal
Cash sales (30%)  107,100    96,900  102,000     306,000
Credit sales (70%)  249,900  226,100  238,000     714,000
Total sales$357,000$323,000$340,000$1,020,000
Cash collections from customers:    
Month after sale (100%)  249,900  226,100  238,000     714,000
Cash sales107,10096,900102,000306,000
Total cash received$357,000$346,800$328,100$1,031,900

Table (9)

Working note B: Compute the cash payment for raw materials

 JulyAugustSeptemberTotal
Cash paid in the following month of purchases (100%)$ 51,400$ 50,760$ 81,280$ 183,440
Total cash paid for raw material$ 51,400$ 50,760$ 81,280$ 183,440

Table (10)

9.

To determine

Prepare the budgeted income statement for the entire first quarter.

9.

Expert Solution
Check Mark

Explanation of Solution

Budgeted income statement: The budgeted financial statement which reports the budgeted revenues and expenses from business operations and the result of those operations as net income or net loss for a budgeted period is referred to as budgeted income statement.

Prepare the budgeted income statement for the entire first quarter:

N Manufacturing
Budgeted Income Statement
For Three Months Ended September 30, 2015
ParticularsAmount ($)Amount ($)
Sales $1,020,000
Cost of goods sold (60,000 units @ $14.35) 861,000
Gross profit 159,000
Operating expenses:  
Sales commissions$102,000 
Sales salaries10,500 
General administrative salaries27,000 
Long-term note interest8,100 
Interest expense240147,840
Income before taxes 11,160
Income taxes (35%) 3,906
Net income $7,254

Table (11)

Conclusion

Therefore, budgeted net income of N Manufacturers for the first quarter is $7,254.

10.

To determine

Prepare the budgeted balance sheet for the entire first quarter.

10.

Expert Solution
Check Mark

Explanation of Solution

Budgeted Balance Sheet: Budgeted Balance Sheet is one of the budgeted financial statements which summarize the budgeted assets, the liabilities, and the Shareholder’s equity of a company at a given date.

Prepare the budgeted balance sheet for the entire first quarter:

N Manufacturing
Budgeted Balance sheet
As on September 30, 2015
ParticularsAmount ($)Amount ($)
Assets   
Cash (Cash budget) $40,000
Accounts receivable (Note C) 238,000
Raw materials inventory (Note D) 15,840
Finished goods inventory (Note E) 241,080
Total current assets 534,920
Equipment (Note F)$820,000 
Less: Accumulated depreciation (Note G)300,000520,000
Total assets $1,054,920
  
Liabilities and Equity  
Accounts payable (Note H) $88,800
Bank loan payable (Cash budget) 14,380
Taxes payable (Income statement) 3,906
Total current liabilities 107,086
Long-term note payable 300,000
Common stock (Unchanged)$600,000 
Retained earnings (Note I)47,834
Total stockholders’ equity 647,834
Total liabilities and equity $1,054,920

Table (12)

Working notes:

Note C: Compute the ending receivables: 
Beginning receivables$249,900
Credit sales714,000
Less: Collections(725,900)
Ending receivables$238,000
  
Note D: Compute the ending raw material: 
Beginning raw materials inventory$249,900
Purchases of raw materials714,000
Less: materials used in production (balance amount)(725,900)
Ending raw materials inventory (1,980units×$8) $238,000
 
Note E: Compute the ending finished goods inventory 
Beginning finished goods inventory$ 241,080
Cost of goods completed during the period861,000
Less: cost of goods sold during the period(861,000)
Ending finished goods inventory (16,800 units @ $14.35)$ 241,080
 
Note F: Compute the equipment balance: 
Beginning equipment$720,000
Purchased in September100,000
Total equipment balance$820,000
 
Note G: Compute the ending accumulated depreciation
Beginning accumulated depreciation$240,000
Depreciation expense      60,000
Total$300,000
 
Note H: Compute the ending balance of accounts payable
Beginning accounts payable$51,400
Purchases of raw materials220,840
Payments for raw materials(183,440)
Ending accounts payable$88,800
 
Note I: Compute the ending balance of retained earnings
Retained earnings at beginning$60,580
Add: Net Income$7,254
Less: Dividend($20,000)
Ending balance of retained earnings$47,834

Table (13)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Chapter 22 Solutions

Principles of Financial Accounting.

Ch. 22 - Prob. 6DQCh. 22 - Prob. 7DQCh. 22 - Prob. 8DQCh. 22 - Prob. 9DQCh. 22 - Prob. 10DQCh. 22 - Prob. 11DQCh. 22 - Prob. 12DQCh. 22 - Prob. 13DQCh. 22 - Prob. 14DQCh. 22 - Prob. 1QSCh. 22 - Prob. 2QSCh. 22 - QS 22-3 Identify which of the following sets of...Ch. 22 - Prob. 4QSCh. 22 - Prob. 5QSCh. 22 - Prob. 6QSCh. 22 - Prob. 7QSCh. 22 - Prob. 8QSCh. 22 - Prob. 9QSCh. 22 - Prob. 10QSCh. 22 - Prob. 11QSCh. 22 - Prob. 12QSCh. 22 - Prob. 13QSCh. 22 - Prob. 14QSCh. 22 - Prob. 15QSCh. 22 - Prob. 16QSCh. 22 - Prob. 17QSCh. 22 - Prob. 18QSCh. 22 - Prob. 19QSCh. 22 - Prob. 20QSCh. 22 - Prob. 21QSCh. 22 - Prob. 22QSCh. 22 - Prob. 23QSCh. 22 - Prob. 24QSCh. 22 - Prob. 25QSCh. 22 - Prob. 26QSCh. 22 - Prob. 27QSCh. 22 - Prob. 28QSCh. 22 - Prob. 29QSCh. 22 - Prob. 30QSCh. 22 - Prob. 31QSCh. 22 - Prob. 32QSCh. 22 - Prob. 1ECh. 22 - Prob. 2ECh. 22 - Prob. 3ECh. 22 - Prob. 4ECh. 22 - Prob. 5ECh. 22 - Prob. 6ECh. 22 - Prob. 7ECh. 22 - Prob. 8ECh. 22 - Prob. 9ECh. 22 - Prob. 10ECh. 22 - Prob. 11ECh. 22 - Prob. 12ECh. 22 - Exercise 22-13 Electro Company budgets production...Ch. 22 - Prob. 14ECh. 22 - Prob. 15ECh. 22 - Prob. 16ECh. 22 - Prob. 17ECh. 22 - Prob. 18ECh. 22 - Prob. 19ECh. 22 - Prob. 20ECh. 22 - Prob. 21ECh. 22 - Prob. 22ECh. 22 - Prob. 23ECh. 22 - Prob. 24ECh. 22 - Prob. 25ECh. 22 - Prob. 26ECh. 22 - Prob. 27ECh. 22 - Prob. 28ECh. 22 - Prob. 29ECh. 22 - Prob. 30ECh. 22 - Prob. 31ECh. 22 - Prob. 32ECh. 22 - Prob. 33ECh. 22 - Prob. 34ECh. 22 - Prob. 1APCh. 22 - Prob. 2APCh. 22 - Prob. 3APCh. 22 - Prob. 4APCh. 22 - Prob. 5APCh. 22 - Prob. 6APCh. 22 - Prob. 7APCh. 22 - Prob. 8APCh. 22 - Prob. 1BPCh. 22 - Prob. 2BPCh. 22 - Prob. 3BPCh. 22 - Prob. 4BPCh. 22 - Prob. 5BPCh. 22 - Prob. 6BPCh. 22 - Prob. 7BPCh. 22 - Prob. 8BPCh. 22 - Prob. 22SPCh. 22 - Prob. 1BTNCh. 22 - Prob. 2BTNCh. 22 - BTN 22-3 Both the budget process and budgets...Ch. 22 - Prob. 7BTNCh. 22 - Prob. 9BTN
Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY