Concept explainers
As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative
Cash……………. | $ 26,000 | |
Finished Goods.............................................. | 16,900 | |
Work in Process.............................................. | 4,200 | |
Materials.................................................... | 6,400 | |
Prepaid Expenses............................................ | 600 | |
Plant and Equipment......................................... | 82,000 | |
$ 32,000 | ||
Accounts Payable............................................ | 14,800 | |
Common Stock. $1.50 par..................................... | 30,000 | |
83,100 | ||
$159,900 | $159,900 |
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
Estimated Costs and Expenses | ||
Fixed | Variable | |
(Total for Year) | (Per Unit Sold) | |
Cost of goods manufactured and sold: | ||
Direct materials................................... | — | $30.00 |
Direct labor....................................... | — | 840 |
Factory |
||
Depreciation of plant and equipment............ | $ 4,000 | — |
Other factory overhead......................... | 1,400 | 4.80 |
Selling expenses: | ||
Sales salaries and commissions..................... | 12,800 | 13.50 |
Advertising....................................... | 13,200 | — |
Miscellaneous selling expense..................... | 1,000 | 2.50 |
Administrative expenses: | ||
Office and officers salaries......................... | 7,800 | 7.00 |
Supplies.......................................... | 500 | 1.20 |
Miscellaneous administrative expense.............. | 400 | 2.40 |
Balances of
Instructions
- 1. Prepare a budgeted income statement for 20Y9.
- 2. Prepare a budgeted balance sheet as of December 31, 20Y9, with supporting calculations.
Trending nowThis is a popular solution!
Chapter 21 Solutions
Financial & Managerial Accounting
- Budgeted 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_forwardHow do I solve the chart?arrow_forwardGarden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows:1st Quarter 2nd Quarter 3rd Quarter 4th QuarterTotal cash receipts .............................. $180,000 $330,000 $210,000 $230,000Total cash disbursements .................... $260,000 $230,000 $220,000 $240,000The company’s beginning cash balance for the upcoming fiscal year will be $20,000. The company requiresa minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterlyinterest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repayits loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at thetime it is repaid. For simplicity, assume that interest is not compounded.Required:Prepare the company’s cash budget for the upcoming fiscal yeararrow_forward
- The following information is available from various budgets for the current period: Amount Budget Cash budget Account Cash Accounts Receivable Prepaid Insurance Equipment Accumulated Depreciation - Equipment Schedule of cash receipts from customers Inventory, purchases, and cost of goods sold budget Selling and administrative expense budget Capital expenditures budget OA. $173,000 OB. $164,000 OC. $159,000 O D. $162,000 $28,000 Merchandise Inventory Insurance Expense (expense incurred during the period) Equipment Depreciation Expense Equipment (expense incurred during the period) Selling and administrative expense budget 2,000 The following balances are available from the balance sheet at the end of the previous year: $5,000 28,000 7,000 What would be the amount of total assets on the budgeted balance sheet? 35,000 41,000 2,000 36,000arrow_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 Regina Soap Co.: Cash $109,300 Accounts Receivable 201,100 Finished Goods 42,200 Work in Process 28,200 Materials 46,300 Prepaid Expenses 3,400 Plant and Equipment 524,600 Accumulated Depreciation—Plant and Equipment $225,600 Accounts Payable 167,500 Common Stock, $10 par 300,000 Retained Earnings 262,000 $955,100 $955,100 Factory output and sales for 20Y9 are expected to total 26,000 units of product, which are to be sold at $110 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…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, 20Y4, the following tentative trial balance as of December 31, 20Y3, is prepared by the Accounting Department of Regina Soap Co.: Cash $119,200 Accounts Receivable 227,700 Finished Goods 47,800 Work in Process 31,900 Materials 52,400 Prepaid Expenses 3,900 Plant and Equipment 609,100 Accumulated Depreciation—Plant and Equipment $261,900 Accounts Payable 206,700 Common Stock, $10 par 300,000 Retained Earnings 323,400 $1,092,000 $1,092,000 Factory output and sales for 20Y4 are expected to total 29,000 units of product, which are to be sold at $90 per unit. The quantities and costs of the inventories at December 31, 20Y4, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating…arrow_forward
- The management of Mecca Copy, a photocopying centre located on University Avenue, has compiled the following data to use in preparing its budgeted balance sheet for next year: Cash......................................................................? Accounts Receivable.........................$8100 Supplies Inventory..............................$3200 Equipment...........................................$34000 Accumulated Depreciation...........$16000 Accounts Payable................................$1800 Common Shares.................................$5000 Retained Earnings.........................................? The beginning balance of retained earnings was $28,000, net income is budgeted to be $11,500, and dividends are budgeted to be $4,800. Required: Prepare the company's budgeted balance sheet.arrow_forward1. 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_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 Regina Soap Co.: Cash $117,800 Accounts Receivable 208,500 Finished Goods 43,800 Work in Process 29,200 Materials 48,000 Prepaid Expenses 3,500 Plant and Equipment 548,900 Accumulated Depreciation—Plant and Equipment $236,000 Accounts Payable 200,300 Common Stock, $10 par 250,000 Retained Earnings 313,400 $999,700 $999,700 Factory output and sales for 20Y9 are expected to total 27,000 units of product, which are to be sold at $100 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…arrow_forward
- 3. The Uthred Company, a merchandising firm, has planned the following sales for the next four months: March $50,000 Аpril $70,000 Мay $90,000 June July $90,000 Total budgeted Sales $60,000 Sales are made 60% on account and 40% cash. From experience, the company has learned that a month's sales on account are collected according to the following pattern: Month of sale 60% • First month following month of sale . • Second month following month of sale • Uncollectible 28% 10% 2% Uthred has a building that is not used in the business operation; they rented it out and receive $10,080 rent every month. The company requires a minimum cash balance of $14,000 to start a month.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, 20Y4, the following tentative trial balance as of December 31, 20Y3, is prepared by the Accounting Department of Regina Soap Co.: Cash $105,400 Accounts Receivable 206,600 Finished Goods 43,400 Work in Process 28,900 Materials 47,500 Prepaid Expenses 3,500 Plant and Equipment 474,300 Accumulated Depreciation—Plant and Equipment $203,900 Accounts Payable 138,700 Common Stock, $10 par 350,000 Retained Earnings 217,000 $909,600 $909,600 Factory output and sales for 20Y4 are expected to total 25,000 units of product, which are to be sold at $110 per unit. The quantities and costs of the inventories at December 31, 20Y4, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating…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
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningFinancial & Managerial AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning