Concept explainers
1.
Budgeting is a process to prepare the financial statement by the manager to estimate the organization’s future actions. It is also helpful to satisfy the everyday activities.
To Prepare: The
1.
Explanation of Solution
Prepare the budgeted income statement of Company M.
Company M | ||
Budgeted Income Statement | ||
For the Month Ending December 31, 2017 | ||
Particulars | Amount ($) | Amount ($) |
Revenue from sales (3,800 × $120) | 456,000 | |
Less: Cost of goods sold | ||
Direct materials (3,800 × $30) | 114,000 | |
Direct labor (3,800 × $8,40) | 31,920 | |
Factory overhead [(3,800 × $4.80) +$4,000+$1,400] |
23,640 | |
Cost of goods sold | (169,560) | |
Gross profit | 286,440 | |
Operating expenses: | ||
Selling expenses: | ||
Sales salaries and commissions [(3,800 × $13.50) + 12,800] |
64,100 | |
Advertising | 13,200 | |
Miscellaneous selling expense [(3,800 × $2.50) + 1,000] |
10,500 | |
Total selling expenses | 87,800 | |
Administrative expenses: | ||
Office and officers’ salaries [(3,800 × $7.00) + 7,800] |
34,400 | |
Supplies [(3,800 × $1.20) + 500] | 5,060 | |
Miscellaneous administrative expense [(3,800 × $2.40) + $400] |
9,520 | |
Total administrative expenses | 48,980 | |
Total operating expenses | (136,780) | |
Income before income tax | 149,660 | |
Income tax expense (30%) | (35,000) | |
Net Income | 114,660 |
Table (1)
2.
To Prepare: The budgeted balance sheet of Company M.
2.
Explanation of Solution
Prepare the budgeted balance sheet of Company M.
M Company Budgeted Balance Sheet December 31, 2017 |
|||
Particulars | Amount ($) | Amount ($) | Amount ($) |
Assets | |||
Current assets: | |||
Cash (Refer Table 3) | 106,660 | ||
23,800 | |||
Inventories: | |||
Finished goods | 16,900 | ||
Work in process | 4,200 | ||
Materials | 6,400 | 27,500 | |
Prepaid expenses | 600 | ||
Total current assets | 158,560 | ||
Property, plant, and equipment: | |||
Plant and equipment | 104,000 (1) | ||
Less: |
36,000 (2) |
68,000 | |
Total Assets | 226,560 | ||
Liabilities | |||
Current liabilities: | |||
Accounts payable | 14,800 | ||
Total Liabilities | 14,800 | ||
Common stock | 30,000 | ||
181,760 | |||
Total Stockholders’ Equity | 211,760 | ||
Total liabilities and stockholders’ equity | 226,560 |
Table (2)
Working Note:
Calculate the cash balance.
Particulars | Amount ($) | Amount ($) |
Balance, January 1, 2017 | 26,000 | |
Add: Cash from operations | ||
Net income | 114,660 | |
Depreciation of plant and equipment | 4,000 | 118,660 |
Less: Dividends to be paid in 2017 [$20,000 × $0.20 × 4 qtrs.] |
16,000 | |
Plant and equipment to be acquired in 2017 | 22,000 | (38,000) |
Cash balance, December 31, 2017 | 106,660 |
Table (3)
Calculate the amount of plant and equipment.
Calculate the amount of accumulated depreciation.
Calculate the retained earnings balance.
Particulars | Amount ($) |
Balance, January 1, 2017 | 83,100 |
Add: Net income | 114,660 |
Less: Dividends to be paid in 2017 [$20,000 × $0.20 × 4 qtrs.] |
(16,000) |
Balance, December 31, 2017 | 181,760 |
Table (4)
Want to see more full solutions like this?
Chapter 21 Solutions
FINANCIAL+MAN.ACCT.-WKPPRS.,V.1-W/CODE
- Selling and administrative expense budget and budgeted income statement Budgeted selling and administrative expenses for Scottsdale Styles Inc. in P7-4 for the year ended December 31, 2016, were as follows: Required: 1. Prepare a selling and administrative expenses budget, in good form, for the year 2016. 2. Using the information above and the budgets prepared in P7-4, prepare a budgeted income statement for the year 2016, assuming an income tax rate of 30%.arrow_forwardPrepare a budgeted income statement for the month ending March 31, 2016.arrow_forwardPrepare a budgeted income statement for the month ending September 30, 2016.arrow_forward
- Prepare a revenue budget for the year ending December 31, 2016.arrow_forwardRoman Inc. has the following totals from its operating budgets: Prepare a budgeted income statement for the year ended December 31, 2016, assuming that income from operations is taxed at a rate of 30%.arrow_forwardBudgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Mesa Publishing Co.: Factory output and sales for 20Y9 are expected to total 3,800 units of product, which are to be sold at 120 per unit. The quantities and costs of the inventories at December 31, 20Y9, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Balances of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 35,000 on 20Y9 taxable income will be paid during 20Y9. Regular quarterly cash dividends of 0.20 per share are expected to be declared and paid in March, June, September, and December on 20,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 22,000 cash in May. Instructions Prepare a budgeted income statement for 20Y9. Prepare a budgeted balance sheet as of December 31, 20Y9, with supporting calculations.arrow_forward
- A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent inflation rate. Listed below are selected items from next years budget before the adjustment. After adjusting for the 3 percent inflation rate, what is the companys total budget for the selected items before taxes for next year? a. 858,150 b. 860,412 c. 810,971 d. 858,971arrow_forwardRelevant data from the operating budget of The Framers are: Other data: Capital assets were sold in quarter 1 and $8,000 was collected in quarter 1 and $500 collected in quarter 2. Dividends of $500 will be paid in May The beginning cash balance was $50,000 and a required minimum cash balance is $10,000. Prepare a cash budget for the first two quarters of the year.arrow_forwardA company has prepared the operating budget and the cash budget. It is now preparing the budgeted balance sheet. Identify the document that contains each of these balances. A. cash B. accounts receivable C. finished goods inventory D. accounts payable E. equipment purchasesarrow_forward
- REQUIRED Use the information given below to answer the following questions: Prepare the Cash Budget for January, February and March Comment on the cash position of the company for the budgeted INFORMATION Some of the items in the Statement of Financial Position as at 31 December 2021 of Lomax Ltd are as follows: Current assets R Accounts receivable 1 300 000 Bank 235 000 Current liabilities Accounts payable (for material purchases) 95 000 Other current liabilities 700 000 The following forecasts have been made by Lomax Ltd for the first three months of 2022 for the bricks that it produces which are sold in pallets (with each pallet comprising 500 bricks): The sales manager anticipates the following credit sales: January February March 2 160 pallets 2 340 pallets 2 250 pallets The bricks are sold at a constant price of R500 per pallet. Ten percent (10%) of the sales are for cash and the rest is on credit. Debtors…arrow_forwardnot graded... please help Prepare Cash Budget from Budgeted Transactions Prepare a cash budget for the month ended May 31, 2019. Campton Company anticipates a cash balance of $74,000 on May 1, 2019. The following budgeted transactions for May 2019 present data related to anticipated cash receipts and cash disbursements: 1. For May, budgeted cash sales are $50,000 and budgeted credit sales are $490,000. (Credit sales for April were $450,000.) In the month of sale, 40% of credit sales are collected, with the balance collected in the month following sale. 2. Budgeted merchandise purchases for May are $270,000. (Merchandise purchases in April were $240,000.) In the month of purchase, 70% of merchandise purchases are paid for, and the balance is paid for in the following month. 3. Budgeted cash disbursements for salaries and operating expenses for May total $155,000. 4. During May, $25,000 of principal repayment and $4,000 of interest payment are due to the bank. 5. A $20,000 income…arrow_forwardPreparing a financial budget—budgeted income statement and balance sheet Bradley Company has the following post-closing trial balance on December 31, 2018 The company’s accounting department has gathered the following budgeting information for the quarter of 2019: Additional information: Direct materials purchases are paid 70°/o in the quarter purchased and 30% in the next quarter. Direct labor, manufacturing overhead, selling and administrative costs, and income tax expense are paid in the quarter incurred. Accounts payable at December 31, 2018 are paid in the first quarter of 2019. Requirements Prepare Bradley Company’s budgeted income statement for the first quarter of 2019. Prepare Bradley Company’s budgeted balance sheet as of March 31, 2019.arrow_forward
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning