Financial & Managerial Accounting
Financial & Managerial Accounting
18th Edition
ISBN: 9781260006520
Author: williams
Publisher: MCG
bartleby

Videos

Question
Book Icon
Chapter 23, Problem 5BP

a.

To determine

Prepare the budgeted income statement of Company S for the month May.

a.

Expert Solution
Check Mark

Explanation of Solution

Budget:

Budget is an effective tool to achieve the financial and operational goals of the business. Budget is the key element of the financial planning and it assists managers to control the business costs. Management should set the budgeted amount at reasonable and achievable levels.

Prepare the budgeted income statement of Company S for the month May as follows:

Budgeted income statement of Company S for the month of May
Particulars $
Budgeted sales100,000
Less: Cost of goods sold (2)60,000
Gross profit (1)40,000
Less: Operating , administrative and selling expense: 
     Variable selling & administrative costs (3)5,000
     Fixed selling & administrative costs10,000
       Budgeted pretax operating income25,000
     Interest expense3,000
Pretax income22,000
Less: Income taxes (4)5,500
Budgeted net income16,500

Table (1)

Therefore, the budgeted net income of Company S for the month of May is $16,500.

Working note:

Calculate the amount of gross profit

Gross profit = Budgeted sales × Gross profit margin=$100,000×40100=$40,000 (1)

Calculate the cost of goods sold

Cost of goods sold = Budgeted sales Gross profit (1)=$100,000$40,000=$60,000 (2)

Calculate the variable selling, and administrative costs

Variable selling and administrative costs} = Budgeted sales ×Percentage on sakes=$100,000×5100=$5,000 (3)

Calculate the income tax expense

Income tax expense = Pretax income ×Income tax rate=$22,000×25100=$5,500 (4)

b.

To determine

Prepare the cash budget of Company S for the month May.

b.

Expert Solution
Check Mark

Explanation of Solution

Prepare the cash budget of Company S for the month May as follows:

Cash budget of Company S for the month of May
Particulars $ $
Beginning cash, May 130,000
Add:
Collections on March sales (5)9,000
Collections on April sales (6)20,000
Collections on May sales (7)40,00069,000
Total cash available99,000
Less:
       Payments on April payables (8)6,250
       Payments on May payables (9)45,000
       Variable selling & administrative costs (3)5,000
       Fixed selling & administrative costs (10)7,000
       Debt service payments4,00067,250
Ending cash, May 3131,750

Table (2)

Therefore, the ending cash balance at the end of the May is $31,750.

Working note:

Calculate the cash received from the March sales

Cash received from the March sales} = [Sales made on March × 10 percent in the second month following the sales]=$90,000 ×10100=$9,000 (5)

Calculate the cash received from the April sales

Cash received from the April sales} = [Sales made on April × 50 percent in the month of following the sales]=$40,000 ×50100=$20,000 (6)

Calculate the cash received from the May sales

Cash received from the May sales} = [Sales made on May × 40 percent in the month of sales]=$100,000 ×40100=$40,000 (7)

Calculate the cash paid for the merchandise purchase for the month April

Cash paid for the merchandise purchase for the month April}=[Purchase in the month of April ×(25 percent of th purcahse in the given month are paid in the following month)]=$25,000×25100=$6,250

Note: The purchase in the given month that are paid in the following month is 25% (100%75%) (8)

Calculate the cash paid for the merchandise purchase for the month May

Cash paid for the merchandise purchase for the month May}=[Purchase in the month of May ×(75 percent of th purcahse in the given month )]=$60,000×75100=$45,000

(9)

Calculate the fixed selling and administrative costs

Fixed selling and administrative costs }[Fixed selling and administrative costs (Deprciation expense included in the fixed cost of selling and administrative expense)]=$10,000$3,000=$7,000 (10)

c.

To determine

Explain the primary benefits of preparing and using a budget.

c.

Expert Solution
Check Mark

Explanation of Solution

Explain the primary benefits of preparing and using a budget as follows:

  • Budget indicates the possible problems in the upcoming period, such as insufficient amount of the raw materials or labor needed for the production.
  • It ensures the cooperation of different departments within a company to meet the expected production levels.
  • Budget can be used at the time when the company sets the financial and operating goals. Company should evaluate the actual performance, and set the budgeted amount at reasonable and achievable levels.

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 23 Solutions

Financial & Managerial Accounting

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
IAS 29 Financial Reporting in Hyperinflationary Economies: Summary 2021; Author: Silvia of CPDbox;https://www.youtube.com/watch?v=55luVuTYLY8;License: Standard Youtube License