Phoenix Company reports the following fixed budget. It is based on an expected production and sales volume of 15,200 units Sales Costs PHOENIX COMPANY Fixed Budget For Year Ended December 31 Direct materials Direct labor Sales staff commissions Depreciation-Machinery Supervisory salaries Shipping Sales staff salaries (fixed annual amount] Administrative salaries Depreciation-office equipment Incone 33,040, 098 1,003,200 212,800 45,608 295,008 282,098 228,099 246, 098 457,498 198,098 $152,000 Problem 8-1A (Algo) Preparing and analyzing a flexible budget LO P1 Required: 1&2. Prepare flexible budgets at sales volumes of 14,200 and 16,200 units. 3. The company's business conditions are improving. One possible result is a sales volume of 18,200 units. Prepare a simple budgeted income statement if 18,200 units are sold. Answer is not complete. Complete this question by entering your answers in the tabs below. Req 1 and 2 Req 3 The company's business conditions are improving. One possible result is a sales volume of 18,200 units. Prepare a simple budgeted income statement if 18,200 units are sold. PHOENIX COMPANY Budgeted Income Statement For Year Ended December 31 Sales (in units) 18,200

Phoenix Company reports the following fixed budget. It is based on an expected production and sales volume of 15,200 units Sales Costs PHOENIX COMPANY Fixed Budget For Year Ended December 31 Direct materials Direct labor Sales staff commissions Depreciation-Machinery Supervisory salaries Shipping Sales staff salaries (fixed annual amount] Administrative salaries Depreciation-office equipment Incone 33,040, 098 1,003,200 212,800 45,608 295,008 282,098 228,099 246, 098 457,498 198,098 $152,000 Problem 8-1A (Algo) Preparing and analyzing a flexible budget LO P1 Required: 1&2. Prepare flexible budgets at sales volumes of 14,200 and 16,200 units. 3. The company's business conditions are improving. One possible result is a sales volume of 18,200 units. Prepare a simple budgeted income statement if 18,200 units are sold. Answer is not complete. Complete this question by entering your answers in the tabs below. Req 1 and 2 Req 3 The company's business conditions are improving. One possible result is a sales volume of 18,200 units. Prepare a simple budgeted income statement if 18,200 units are sold. PHOENIX COMPANY Budgeted Income Statement For Year Ended December 31 Sales (in units) 18,200

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter9: Profit Planning And Flexible Budgets

Section: Chapter Questions

Problem 48BEB: Performance Report Based on Budgeted and Actual Levels of Production Balboa Company budgeted...

See similar textbooks

Similar questions

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.
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.
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.
Preparing a performance report Use the flexible budget prepared in P7-6 for the 29,000-unit level of activity and the actual operating results listed below for the 29,000- unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 29,000 units differs from the master budget operating income at 30,000 units in Figure 7-12. 3. Given the level at which the company operated, how was its cost control? Item Direct materials: Direct labor:
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.
Professional labor cost budget Based on the data in Exercise 13-5 and assuming that the average compensation per hour for staff is $36 and for partners is $300. prepare a professional labor cost budget for Day & Spieth, CPAs, for the year ending March 31. 20Y6. Use the following column headings:
Using the information for Crable and Tesch, the systems consultants in P9-3 and P9-4, prepare a budgeted income statement for the year ended December 31, 2016.
Required information [The following information applies to the questions displayed below.] Phoenix Company reports the following fixed budget. It is based on an expected production and sales volume of 15,400 units. Sales Costs PHOENIX COMPANY Fixed Budget For Year Ended December 31 Direct materials Direct labor Sales staff commissions Depreciation-Machinery Supervisory salaries Shipping Sales staff salaries (fixed annual amount) Administrative salaries Depreciation Office equipment Income $ 3,234,000 1,001,000 231,000 61,600 305,000 201,000 Return to question 231,000 247,000 604,700 190,000 $ 161,700 Required: 1&2. Prepare flexible budgets at sales volumes of 14,400 and 16,400 units. 3. The company's business conditions are improving. One possible result is a sales volume of 18,400 units. Prepare a simple budgeted income statement if 18,400 units are sold.
Relevant data from Picta Company’s operating budgets are presented below. The company’s financial year ends on 30 June. Quarter 1Quarter 2Sales$248,470$251,539Direct material purchases120,295128,832Direct labor76,55374,289Manufacturing overhead26,00024,400Selling and administration expenses33,50033,500Depreciation included in selling and administration expenses 2,000 2,500 Collection from customers230,524220,116Cash payments for purchases114,345118,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. bi) Briefly comment on Picta Company’s expected cashflow position in the first two quarters of the year.
Phoenix Company reports the following fixed budget. It is based on an expected production and sales volume of 15,100 units. Sales Costs PHOENIX COMPANY Fixed Budget For Year Ended December 31 Direct materials Direct labor Sales staff commissions Depreciation-Machinery Supervisory salaries) Shipping Sales staff salaries (fixed annual amount) Administrative salaries Depreciation-Office equipment Income $3,020,000 996,600 211,400 60,400 295,000 198,000 226,500 253,000 432,100 196,000 $ 151,000 Problem 8-1A (Algo) Preparing and analyzing a flexible budget LO P1 Required: 1&2. Prepare flexible budgets at sales volumes of 14,100 and 16,100 units. 3. The company's business conditions are improving. One possible result is a sales volume of 18.100 units. Prepare a simple budgeted income statement if 18.100 units are sold
Phoenix Company reports the following fixed budget. It is based on an expected production and sales volume of 15,200 units. Sales Costs Direct materials Direct labor PHOENIX COMPANY Fixed Budget For Year Ended December 31 Sales staff commissions Depreciation-Machinery. Supervisory salaries Shipping Sales staff salaries (fixed annual amount) Administrative salaries Depreciation-office equipment Income $ 3,040,000 1,003, 200 212,800 45,600 295,000 202,000 228,000 246,000 457,400 198,000 $ 152,000 Problem 8-1A (Algo) Preparing and analyzing a flexible budget LO P1 Required: 1&2. Prepare flexible budgets at sales volumes of 14,200 and 16,200 units. 3. The company's business conditions are improving. One possible result is a sales volume of 18,200 units. Prepare a simple budgeted income statement if 18,200 units are sold. Complete this question by entering your answers in the tabs below.
Phoenix Company reports the following fixed budget. It is based on an expected production and sales volume of 15,400 units. Sales Costa PHOENIX COMPANY Fixed Budget For Year Ended December 31 Direct materials Direct labor Sales staff commissions Depreciation-Machinery Supervisory salaries Shipping Sales staff salaries (fixed annual amount) Administrative salaries Depreciation-office equipment Income $ 3,234,000 1,001,000 246,400 46,200 295,000 198,000 231,000 251,000 610,700 193,000 $ 161,700