Concept explainers
As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 2017, the following tentative
Cash............................................................. | $ 85,000 | |
125,600 | ||
Finished Goods................................................... | 69,300 | |
Work in Process................................................... | 32,500 | |
Materials......................................................... | 48,900 | |
Prepaid Expenses................................................. | 2,600 | |
Plant and Equipment.............................................. | 325,000 | |
$156,200 | ||
Accounts Payable................................................. | 62,000 | |
Common Stock, $10 par........................................... | 180,000 | |
290,700 | ||
$688,900 | $688,900 |
Factory output and sales for 2017 are expected to total 200,000 units of product, which are to be sold at $5.00 per unit. The quantities and costs of the inventories at December 31, 2017, are expected to remain unchanged from the balances at The beginning of the year.
Budget estimates of
Estimated Costs and Expenses | ||
Cost of goods manufactured and sold: | Fixed (Total for Year) | |
Direct materials................................................ | — | $1.10 |
Direct labor.................................................... | — | 0.65 |
Factory |
||
Depreciation of plant and equipment.......................... | $40,000 | — |
Other factory overhead....................................... | 12,000 | 0.40 |
Selling expenses: | ||
Sales salaries and commissions.................................. | 46,000 | 0.45 |
Advertising.................................................... | 64,000 | — |
Miscellaneous selling expense.................................. | 6,000 | 0.25 |
Administrative expenses: | ||
Office and officers salaries...................................... | 72,400 | 0.12 |
Supplies....................................................... | 5,000 | 0.10 |
Miscellaneous administrative expense........................... | 4,000 | 0.05 |
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 $30,000 on 2017 taxable income will be paid during 2017. Regular quarterly cash dividends of $0.15 per share are expected to be declared and paid in March, June, September, and December on 18,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for $75,000 cash in May.
Instructions
- 1. Prepare a budgeted income statement for 2017.
- 2. Prepare a budgeted balance sheet as of December 31, 2017, with supporting calculations.
Want to see the full answer?
Check out a sample textbook solutionChapter 21 Solutions
EBK FINANCIAL & MANAGERIAL ACCOUNTING
- 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_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_forwardQuestion 6. Please answer in same format as question so it's easy to transfer overarrow_forward
- 1. Prepare a Sales Budget 2. Determine a production volume. 3. Estimate manufacturing cost and operating expense. a. Purchase (material budget) b. Personnel budget c. Overhead budget d. Selling and Administrative budget 4. Determine cash flow and other financial effects. a. Cash collection schedule b. Cash disbursement for purchases, factory overhead, and selling and administrative expense. c. Cash budget 5. Formulate Projected Financial Statement (As of December 31, 3021) a. Budgeted cost of goods manufactured b. Budgeted income statement c. Budgeted Balance Sheetarrow_forwardArjuna Sdn Bhd is preparing its annual budgets for the year to 31 December 2016. It manufactures and sells one product, which has a selling price of RM130. The marketing Director believes that the prices can be increased to RM140 with effect from 1 July 2016 and that at this price the sales volume for each quarter of 2016 will be as follows: Sales Volume Quarter 1 Quarter 2 Quarter 3 Quarter 4 30,000 40,000 20,000 35,000 Sales for each quarter 2017 are expected to be 30,000 units. Each unit of the finished product requires four units of components A and three units of component B, together with a body shell C (Component C). These items are purchased from an outside supplier and their current prices are: RM Component A Component B Component C 7.00 each 4.00 each 20.00 each The component are expected to increase price by 10% with effect from 1 April 2016, no change is expected for the price of the shell. Assembly of the shell and components into the finished product requires 6 labour…arrow_forwardQUESTION 3: Based on the following assumptions and policies ; a) Prepare the budget for Collectables from Sales! b) Prepare the budget for Purchases! c) Prepare the budget of Cash Payment for Purchases! d) Set the company’s Cash Budget for 2021 BOARD Policies & Assumptions - Company’s projected sales for the three months as followings: Sales Forecast for 2021 January 2021 200.000 USD February 2021 220.000 USD March 2021 240.000 USD - All Sales are credited: %40 of sales are collected as in form of cash. %30 of sales are credited for 1 month and %30 of it for the next month. Rule: 40;30;30 - Accounts Receivables by quarter ending 31/12/2020 amounted to 120.000 USD a) 30.000 USD of Account Receivables belong to November Sales ( 11/2020) b) 90.000 USD of Account Receivables belong to December Sales ( 12/2020) - All purchases are credited: %50 of purchases are paid in advance and %50 of purchases are debited - Projected Inventories by the…arrow_forward
- Please answer in 1 hourarrow_forwardYou are provided with the following information taken from Wildhorse Inc.'s March 31, 2025, balance sheet. Cash Accounts receivable Inventory Property, plant, and equipment, net of depreciation Accounts payable Common stock Retained earnings 1. 2. 3. 4. 5. Additional information concerning Wildhorse Inc. is as follows. 6. 7. Gross profit is 25% of sales. Actual and budgeted sales data: March (actual) April (budgeted) March April Purchases March $48,200 $19,280 42,420 $61,700 Purchases April $11,600 70,700 20,180 36,010 Sales are both cash and credit. Cash collections expected in April are: (40% of $48,200) (60% of $70,700) 120,800 22,560 154,500 11.680 Half of a month's purchases are paid for in the month of purchase and half in the following month. Cash disbursements expecte $22,560 28,320 $50,880 Cash operating costs are anticipated to be $12,630 for the month of April. Equipment costing $2,560 will be purchased for cash in April. The company wishes to maintain a minimum cash balance…arrow_forwardPreparing a financial budget—budgeted income statement and balance sheet Ball 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 first quarter of 2019: Additional information: Rent and income tax expenses are paid as incurred. Insurance expense is an expense is an expiration of the prepaid amount. Requirements Prepare a budgeted income statement for the quarter ended March 31, 2019. Prepare a budgeted balance sheet as of March 31, 2019.arrow_forward
- Prepare fountain sales budget for April and May 2024. Round all calculations to the nearest dollar. Prepare fountains, inventory, purchases, and cost of good sold budget for April and May.  Prepare fountain, selling and administrative expense budget for April and May.arrow_forwardPreparing a financial budget—budgeted income statement and balance sheet Buncomb 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 first quarter of 2019: Additional information; Rent and income tax expenses are paid as incurred. Insurance expense is an expiration of the prepaid amount. Requirements Prepare a budgeted income statement for the quarter ended March 31, 2019. Prepare budgeted balance sheet as of March 31, 2019.arrow_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_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegePrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning