Assume that a merchandising company provided the following beginning and ending budgeted balance sheets for a forthcoming month: Beginning Balances Ending Balances Cash $30,000 $38,000 Accounts Receivable $13,000 $16,000 Inventory $20,000 $18,000 Buildings and equipment $100,000 $100,000 Accumulated depreciation (25,000) (30,000) Total Assets From above: 138,000 $142,000 Accounts payable $4,000 $5,000 Common stock $60,000 $60,000 Retained earnings $74,000 $ 77,000 Total liabilities and stockholders' equity $138,000 $142,000 Assume that all of the company's sales are on account and it has no uncollectible accounts. If the cash collected from customers during the period is $120,000, then how much sales must be shown on the company's budgeted income statement?

Assume that a merchandising company provided the following beginning and ending budgeted balance sheets for a forthcoming month: Beginning Balances Ending Balances Cash $30,000 $38,000 Accounts Receivable $13,000 $16,000 Inventory $20,000 $18,000 Buildings and equipment $100,000 $100,000 Accumulated depreciation (25,000) (30,000) Total Assets From above: 138,000 $142,000 Accounts payable $4,000 $5,000 Common stock $60,000 $60,000 Retained earnings $74,000 $ 77,000 Total liabilities and stockholders' equity $138,000 $142,000 Assume that all of the company's sales are on account and it has no uncollectible accounts. If the cash collected from customers during the period is $120,000, then how much sales must be shown on the company's budgeted income statement?

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter4: Financial Planning And Forecasting

Section: Chapter Questions

Problem 5P

See similar textbooks

Similar questions

Mesa Aquatics, Inc. estimated direct labor hours as 1,900 in quarter 1, 2,000 in quarter 2.2,200 in quarter 3, and 1,800 in quarter 4. a sales and administration budget using the information provided.
Performance Report Based on Budgeted and Actual Levels of Production Balboa Company budgeted production of 4,500 units with the following amounts: At the end of the year, Balboa had the following actual costs for production of 4,700 units: Required: 1. Calculate the budgeted amounts for each cost category listed above for the 4,500 budgeted units. 2. Prepare a performance report using a budget based on expected (budgeted) production of 4,500 units. 3. Prepare a performance report using a budget based on the actual level of production of 4,700 units.
The following data were obtained from the financial records of Sonicbrush, Inc., for March: Sales are expected to increase each month by 15%. Prepare a budgeted income statement.
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: a. Finished goods inventory on January 1 is 32,000 units, each costing 166.06. The desired ending inventory for each month is 80% of the next months sales. b. The data on materials used are as follows: Inventory policy dictates that sufficient materials be on hand at the end of the month to produce 50% of the next months production needs. This is exactly the amount of material on hand on December 31 of the prior year. c. The direct labor used per unit of output is 3 hours. The average direct labor cost per hour is 14.25. d. Overhead each month is estimated using a flexible budget formula. (Note: Activity is measured in direct labor hours.) e. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Note: Activity is measured in units sold.) f. The unit selling price of the subassembly is 205. g. All sales and purchases are for cash. The cash balance on January 1 equals 400,000. The firm requires a minimum ending balance of 50,000. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. Any cash borrowed is repaid at the end of the quarter, as is the interest due (cash borrowed at the end of the quarter is repaid at the end of the following quarter). The interest rate is 12% per annum. No money is owed at the beginning of January. Required: 1. Prepare a monthly operating budget for the first quarter with the following schedules. (Note: Assume that there is no change in work-in-process inventories.) a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Selling and administrative expenses budget g. Ending finished goods inventory budget h. Cost of goods sold budget i. Budgeted income statement j. Cash budget 2. CONCEPTUAL CONNECTION Form a group with two or three other students. Locate a manufacturing plant in your community that has headquarters elsewhere. Interview the controller for the plant regarding the master budgeting process. Ask when the process starts each year, what schedules and budgets are prepared at the plant level, how the controller forecasts the amounts, and how those schedules and budgets fit in with the overall corporate budget. Is the budgetary process participative? Also, find out how budgets are used for performance analysis. Write a summary of the interview.
Prepare a cost of goods sold budget for the Crest Hills Manufacturing Co. for the year ended December 31, 2016, from the following estimates. Inventories of production units: Direct materials purchased during the year, 854,000; beginning inventory of direct materials, 31,000; and ending inventory of direct materials, 26,000. Totals from other budgets included:
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.
Performance Report Based on Budgeted and Actual Levels of Production Bowling Company budgeted the following amounts: At the end of the year, Bowling had the following actual costs for production of 3,800 units: Required: 1. Calculate the budgeted amounts for each cost category listed above for the 4,000 budgeted units. 2. Prepare a performance report using a budget based on expected production of 4,000 units. 3. Prepare a performance report using a budget based on the actual level of production of 3,800 units.
Budgeted income statement and supporting budgets for three months Bellaire Inc. gathered the following data for use in developing the budgets for the first quarter (January, February, March) of its fiscal year: Estimated sales at 125 per unit: Estimated finished goods inventories: Work in process inventories are estimated to be insignificant (zero). Estimated direct materials inventories: Manufacturing costs: Selling expenses: Instructions Prepare the following budgets using one column for each month and a total column for the first quarter, as shown for the sales budget: Prepare a sales budget for March. Prepare a production budget for March. Prepare a direct materials purchases budget for March. Prepare a direct labor cost budget for March. Prepare a factory overhead cost budget for March. Prepare a cost of goods sold budget for March. Prepare a selling and administrative expenses budget for March. Prepare a budgeted income statement with budgeted operating income for March.
Budgeted income statement and supporting budgets The budget director of Birding Homes Feeders Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: Estimated sales for January: Estimated inventories at January 1: Desired inventories at January 31: Direct materials used in production: Anticipated cost of purchases and beginning and ending inventory of direct materials: Direct labor requirements: Estimated factory overhead costs for January: Estimated operating expenses for January: Estimated other revenue and expense for January: Estimated tax rate: 25% Instructions Prepare a sales budget for January. Prepare a production budget for January. Prepare a direct materials purchases budget for January. Prepare a direct labor cost budget for January. Prepare a factory overhead cost budget for January. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be 9,000, and work in process at the end of January is estimated to be 10,500. Prepare a selling and administrative expenses budget for January. Prepare a budgeted income statement for January.
he following information was collected in preparation of the company’s budgeted income statement: Wages Expense, $20,000; Sales, $100,000; Depreciation Expense, $10,000; Accounts Receivable, $25,000; Cost of Goods Sold, $40,000. Budgeted net income would be: A. $5,000 B. $30,000 C. $55,000 D. $100,000
Public Manufacturing Company (PMC) is preparing their budgeted financial statements for the coming year, and has accumulated the following data: Beginning-of-period balances: Cash $40,000 Accounts Receivable $50,000 Raw Materials Inventory $14,000 Work-in-Process Inventory $160,000 Finished Goods Inventory $6,000 Equipment (historical value) $200,000 Accumulated Depreciation $130,000 Accounts Payable $62,000 Estimates for end-of-period balances: Accounts Receivable $55,000 Raw Materials Inventory $10,000 Work-in-Process Inventory $120,000 Finished Goods Inventory $5,000 Accumulated Depreciation $124,000 Accounts Payable $50,000 Budgeted activity levels for the period: Sales 12,000 units @ a sales price of $300/unit Purchases of Direct Materials $500,000 Direct Labor Wages $340,000 Manufacturing Overhead $1,400,000 Selling and Administrative…
Relevant data from Picta Company’s operating budgets are presented below. The company’s financial year ends on 30 June. Quarter 1 Quarter 2 Sales $248,470 $251,539 Direct material purchases 120,295 128,832 Direct labor 76,553 74,289 Manufacturing overhead 26,000 24,400 Selling and administration expenses 33,500 33,500 Depreciation included in selling and administration expenses 2,000 2,500 Collection from customers 230,524 220,116 Cash payments for purchases 114,345 118,346 Additional data: Equipment was sold in July for $8,000 and $4,500 in November. Dividends of $5,500 were paid in August. The beginning cash balance was $80,395 and a required minimum cash balance per quarter is $60,000. The company has a 15% open line of credit for $70 000 with their bank. Required: a) Use this information to prepare a cash budget for the first two quarters of the year. i) Briefly comment on Picta Company’s expected cashflow position in the first two quarters of the year.