![Financial & Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781285866307/9781285866307_largeCoverImage.gif)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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 | ||
Accounts receivable | 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 & Managerial Accounting
- Budgeted selling and administrative expenses for King Tire Co. In P7-2 for the year ended December 31, 2016, were as follows: Required: 1. Prepare a selling and administrative expense budget, in good form, for the year 2016. 2. Using the information above and the budgets prepared in P7-2, prepare a budgeted income statement for the year 2016, assuming an income tax rate of 40%.arrow_forwardPrepare a revenue budget for the year ending December 31, 2016.arrow_forwardSelling 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_forward
- An accounting statement that presents predicted amounts of the company's assets, liabilities, and stockholders' equity as of the end of the budget period is called a(n): Multiple Choice Budgeted income statement. Pro forma cash flow statement. Master balance sheet. Pro forma balance sheet. Operating balance sheet.arrow_forwardPlease answer in 1 hourarrow_forwardYou are provided with the following information taken from Sage Hill Inc's March 31, 2027, balance sheet. Cash Accounts receivable Inventory Property, plant, and equipment, net of depreciation Accounts payable Common stock Retained earnings 1 2 3. 5. 6. 7. Additional information concerning Sage Hill Inc. is as follows. Gross profit is 24% of sales. Actual and budgeted sales data: March (actual) April (budgeted) March April $18.840 $47.100 $62460 $12,280 72.700 23.120 37,100 123,400 22,910 Sales are both cash and credit, Cash collections expected in April are: 152.900 12.320 (40% of $47.100) (60% of $72,700) Half of a month's purchases are paid for in the month of purchase and half in the following month Cash disbursements expecte Purchases March Purchases April $22,910 28,910 $51820 Cash operating costs are anticipated to be $12,110 for the month of April. Equipment costing $2,530 will be purchased for cash in April. The company wishes to maintain a minimum cash balance of $12,240. An…arrow_forward
- The budgeted balance sheet is prepared based on the __________ and __________ budgets. a.sales; selling and administrative expenses. b.financial; investing c.operating; investing d.financial; operatingarrow_forwardHello. Help me to solve sub part (d) and (e) from this questionarrow_forward4G . 4G S 9:58 以令 Shrek & Fiona Company Statement of Financial Position As of December 31, 2020 Current Assets Current Liabilities Cash 18,000 Accounts Payable (N2) 240,000 Accounts Receivable (N1) Taxes Payable Dividends Payable 1,192,000 13,200 Less: Uncollectible accounts (22,400) 1,169,600 500,000 Inventories Total Current Liabilities 753,200 Raw Materials (12,000 pounds) 30,000 Finished Goods (4,000 units) 140,000 170,000 Total Current Assets 1,357,600 Stockholder's Equity Common Stock (100,000 shares) 500,000 Non-current Assets Retained Earnings 360,400 Property, plant, and equipment 320,000 Total Stockholder's Equity 860,400 Less: Accumulated depreciation (64,000) 256,000 Total Assets 1,613,600 Total Liabilities and SHE 1,613,600 N1 2020 3rd quarter sales P2,500,000 2020 4th quarter sales P3,100,000 200,000 992,000 1,192,000 75,000 165,000 N2 2020 3rd quarter purchases P300,000 2020 4th quarter purchases P330,000 240,000 1. Estimated unit sales for the first quarter of 2021 is…arrow_forward
- Question 6. Please answer in same format as question so it's easy to transfer overarrow_forward1: Create own budget for the month of April 2021. This must include Fixed and Variable expenditure plans; and the sub-heads within each of these two. Please remember to make margin for miscellaneous expenses and some savings as well. 2:At the end of the month, would compare the Budgeted vs Actual figures for the month- using the correct calcuations. 3: Reflections/experience on how their budgeting experience went Whether they maintained the budget as per plan- how did they achieve this; Whether they exceeded the planned expenses or managed to save some money- - how did they manage this; What they would like to do in the future to plan their budget effectively. STUDENT NAME DATE BUDGET MONTH 01-30 April 2021 MONTHLY INCOME BUDGETED (AED) ACTUAL (AED) Earned Income Any other Income TOTAL INCOME (1) MONTHLY EXPENDITURE BUDGETED (AED) ACTUAL (AED) FIXED EXPENSES…arrow_forwardBudgeted Income Statement and Balance SheetAs 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.: Cash$ 26,000Accounts Receivable23,800Finished Goods16,900Work in Process4,200Materials6,400Prepaid Expenses600Plant and Equipment82,000Accumulated Depreciation—Plant and Equipment$ 32,000Accounts Payable14,800Common Stock, $1.50 par30,000Retained Earnings83,100$159,900$159,900Factory 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:Estimated Costs and ExpensesFixed(Total for…arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegePrinciples 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
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305087408/9781305087408_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305961883/9781305961883_smallCoverImage.gif)