Managerial Accounting (Looseleaf)
Managerial Accounting (Looseleaf)
7th Edition
ISBN: 9781260482935
Author: Wild
Publisher: MCG
bartleby

Concept explainers

Question
Book Icon
Chapter 7, Problem 26E
To determine

Budgeted Income Statement:

It is the statement which presents the budgeted sales and expenses of an entity of a particular period. It is an estimated income statement of future period.

To Prepare: Budgeted Income Statement and Budgeted balance sheet.

Expert Solution & Answer
Check Mark

Explanation of Solution

    Company A
    Budgeted Income Statement
    Particulars July Amount ($)
    Sales (Given) 1,400,000
    Less: Cost of goods sold (working note 1) 770,000
    Gross profit [ A ] 630,000
    Less: Expenses:
    Salaries (working note 2) 285,000
    Depreciation (Given) 36,000
    Other expenses (Given) 200,000
    Interest on loan (Given) 6,600
    Total expenses [ B ] 527,600
    Income before taxes 102,400
    Less: Income tax@30% (Working Note 3) 30,720
    Net income after taxes 71,680
    Table (1)

Working Note 1:

Formula to calculate cost of goods sold,

    Cost of goods sold=Sales×55%

Sale is $1,400,000(given).

Substitute $1,400,000 for sales,

    Cost of goods sold=$1,400,000×55% =$770,000

Working Note 2:

Calculation of salaries,

Given,
Cash paid for salaries is $275,000.
Salary of June is $50,000.
Salary of July is $60,000.

    Salaries for July=( Salaries paid+closing balance of salary opening balance of salary ) =$275,000+$60,000$50,000 =$285,000

Working Note 3:

Calculation of income tax,

Given,
Income before tax is $102,400.
Rate of income tax is 30%.

    Income tax=Net income before taxes×rate of tax =$102,400×30%. =$30,720
    Company A
    Balance sheet for the month ended 31st July
    Particulars Amount ($) Amount ($)
    Assets:
    Cash (working note 4) 122,400
    Account receivable (working note 5) 1,220,000
    Merchandise inventory (given) 60,000
    Total current assets 1,402,000
    Equipment (given) 1,600,000
    Less: Accumulated depreciation 316,000 1,284,000
    Total Assets 2,686,400
    Liabilities and Equities:
    Account payable (working note 8) 300,000
    Salaries payable (given) 60,000
    Income tax payable (Working Note 3) 30,720
    Total Current liabilities 390,720
    Bank loan (given) 660,000
    Total liabilities 1,050,720
    Common stock (given) 600,000
    Retained earnings (working note 9) 1,035,680
    Total stakeholder’s equity 1,635,680
    Total Liabilities and Equities 2,686,400
    Table (2)

Working Note 4:

    Company A
    Cash
    Particulars July Amount ($)
    Beginning cash balance 50,000
    Add: Cash receipts (working note 7) 1,364,000
    Total cash available [ A ] 1,414,000
    Less: Cash disbursement
    Payments for purchases (working note 6) 730,000
    Salaries 275,000
    Other expense 200,000
    Accrued taxes 80,000
    Interest on loan 6,600
    Total Cash disbursement [ B ] 1,291,600
    Ending cash balance [ AB ] 122,400
    Table (3)

Working Note 5:

Calculation of account receivables,

    Account receivable=( Previous month sale×20% )+( Current month sale ×70% ) =( $1,200,000×20% )+( $1,400,000×70% ) =$240,000+$980,000 =$1,220,000

Working Note 6:

    Payments for purchases
    Particulars July Amount ($)
    June purchases ( 700,000×40% ) 280,000
    July purchases ( 750,000×60% ) 450,000
    Total 730,000
    Table (4)

Working Note 7:

    Cash receipts from sales
    Particulars July Amount ($)
    May sales ( 1,720,000×20% ) 344,000
    June sales ( 1,200,000×50% ) 600,000
    July sales ( 1,400,000×30% ) 420,000
    Total 1,364,000
    Table (5)

Working Note 8:

Calculation of account payables,

    Account payable=Current month purchase×40% =$750,000×40% =$300,000

Working Note 9:

    Company A
    Retained earnings
    Particulars July Amount ($)
    Beginning retained earnings (Given) 964,000
    Add: Net income 71,680
    Ending retained earnings 1,035,680
    Table (6)

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!
Students have asked these similar questions
Determine the following requirements of this financial accounting question
Provide correct answer this financial accounting question
Chapter 15 Homework 13 Saved Help Save & Exit Submit Part 1 of 2 0.83 points eBook Ask Required information Use the following information to answer questions. (Algo) [The following information applies to the questions displayed below.] Information on Kwon Manufacturing's activities for its first month of operations follows: a. Purchased $100,800 of raw materials on credit. b. Materials requisitions show the following materials used for the month. Job 201 Job 202 Total direct materials Indirect materials Total materials used $ 49,000 24,400 73,400 9,420 $ 82,820 c. Time tickets show the following labor used for the month. Print References Job 201 $ 40,000 Job 202 13,400 Total direct labor 53,400 25,000 $ 78,400 Indirect labor Total labor used d. Applied overhead to Job 201 and to Job 202 using a predetermined overhead rate of 80% of direct materials cost. e. Transferred Job 201 to Finished Goods Inventory. f. Sold Job 201 for $166,160 on credit. g. Incurred the following actual other…

Chapter 7 Solutions

Managerial Accounting (Looseleaf)

Ch. 7 - How does budgeting help management coordinate and...Ch. 7 - Why is the sales budget so important to the...Ch. 7 - What is the selling expense budget? What is the...Ch. 7 - Prob. 9DQCh. 7 - GOOGLE Google prepares a cash budget. What is a...Ch. 7 - Prob. 11DQCh. 7 - Prob. 12DQCh. 7 - Prob. 13DQCh. 7 - Prob. 14DQCh. 7 - Coca-cola recently redesigned its bottle to reduce...Ch. 7 - Activity-based budgeting is a budget system based...Ch. 7 - Budget motivation C1 For each of the following...Ch. 7 - Budgeting benefits C1 For each of the following...Ch. 7 - Prob. 3QSCh. 7 - Prob. 4QSCh. 7 - Prob. 5QSCh. 7 - Prob. 6QSCh. 7 - Prob. 7QSCh. 7 - Prob. 8QSCh. 7 - Prob. 9QSCh. 7 - Prob. 10QSCh. 7 - Prob. 11QSCh. 7 - Prob. 12QSCh. 7 - Prob. 13QSCh. 7 - Prob. 14QSCh. 7 - Prob. 15QSCh. 7 - Manufacturing: Production budget P1 Atlantic Surf...Ch. 7 - Prob. 17QSCh. 7 - Prob. 18QSCh. 7 - Prob. 19QSCh. 7 - Cash receipts, with uncollectible accounts P2 The...Ch. 7 - Cash receipts, with uncollectible accounts P2 Well...Ch. 7 - Prob. 22QSCh. 7 - Budgeted loan activity P2 Santos Co. is preparing...Ch. 7 - Prob. 24QSCh. 7 - Prob. 25QSCh. 7 - Prob. 26QSCh. 7 - Prob. 27QSCh. 7 - Prob. 28QSCh. 7 - Prob. 29QSCh. 7 - Prob. 30QSCh. 7 - Prob. 31QSCh. 7 - Prob. 1ECh. 7 - Prob. 2ECh. 7 - Prob. 3ECh. 7 - Prob. 4ECh. 7 - Exercise 20-5 Manufacturing: Direct labor budget...Ch. 7 - Prob. 6ECh. 7 - Prob. 7ECh. 7 - Prob. 8ECh. 7 - Prob. 9ECh. 7 - Prob. 10ECh. 7 - Prob. 11ECh. 7 - Prob. 12ECh. 7 - Prob. 13ECh. 7 - Prob. 14ECh. 7 - Prob. 15ECh. 7 - Prob. 16ECh. 7 - Prob. 17ECh. 7 - Prob. 18ECh. 7 - Prob. 19ECh. 7 - Prob. 20ECh. 7 - Prob. 21ECh. 7 - Prob. 22ECh. 7 - Prob. 23ECh. 7 - Prob. 24ECh. 7 - Prob. 25ECh. 7 - Prob. 26ECh. 7 - Prob. 27ECh. 7 - Prob. 28ECh. 7 - Prob. 29ECh. 7 - Prob. 30ECh. 7 - Prob. 31ECh. 7 - Prob. 32ECh. 7 - Prob. 33ECh. 7 - Prob. 34ECh. 7 - Prob. 35ECh. 7 - Prob. 1PSACh. 7 - Prob. 2PSACh. 7 - Prob. 3PSACh. 7 - Prob. 4PSACh. 7 - Prob. 5PSACh. 7 - Prob. 6PSACh. 7 - Prob. 7PSACh. 7 - Prob. 8PSACh. 7 - Prob. 1PSBCh. 7 - Prob. 2PSBCh. 7 - Prob. 3PSBCh. 7 - Prob. 4PSBCh. 7 - Prob. 5PSBCh. 7 - Prob. 6PSBCh. 7 - Prob. 7PSBCh. 7 - Prob. 8PSBCh. 7 - Prob. 7SPCh. 7 - Prob. 1AACh. 7 - Prob. 2AACh. 7 - Prob. 3AACh. 7 - ETHICS CHALLENGE C1 BTN 20-3 Both the budget...Ch. 7 - Prob. 2BTNCh. 7 - Prob. 3BTNCh. 7 - Prob. 4BTNCh. 7 - Prob. 5BTNCh. 7 - Prob. 6BTN
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.
Similar questions
SEE MORE QUESTIONS
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