static budget Parameters - budgetQuarters4YearQuarters334YearSales ( hours):Actual total salesActual sales - commercialActual sales - residentialSelling price ( $/hr):Actual selling price - commercialActual selling price - residential4,0202,8104,1202,8801,2405,3203,7201,60018,68013,0605,6205,220Sales (hours):Budgeted total sales in hoursBudgeted commercial sales in hoursBudgeted residential sales in hoursSelling price ( $thr):Selling price per hour (commercial)- Selling price per hour (residential)4,1602,9001,2605,0603,5304,4603,1101,3505,3603,7401,62019,04013,2805,7603,6501,5701,2101,530$40$40$40$40$40$437 $37 $37 $37 $37$50$50$50$50$50482448 $48 $48$4482222222222 $Direct labour expense ( $lhr):22 $22 $222 Direct labour expense ( $thr):1314 Cleaning Supply usage ( litre / labour hour):Commercial16 ResidentialActual Cleaning Supply usage ( litre / labour hour):CommerçialResidential0.220.220.220.220.250.15150.250.250.250.10.110.10.110.150.150.1517$ 5.50 $ 5.50Actual Cleaning Supply expense ( 1518Cleaning Supply expense ( $litre)}: $ 5.50 $ 5.5019Actual Fixed overhead:20 Fixed overhead:21 Receptiornist22 DepreciationGas24 Office Supplies6,325 24,02036,9007,275 29,9651,2155,7705,915ReceptionistDepreciationGas6,0109,2257,3006,36325,45036,9006,3639,2257,6501,0756,3639,2257,65010756,3639,2257,9409,2259,2259,2257,6501,0759,2257,6501,0757,45097530,600234,300Office Supplies9909504,1302520,361Total no. of hours actually paid to eBreakdown:26274,0551,74414,2356,1263,1391.3524.49198.7983,0631,3193,9791,7115,690Commercial28Residential29Actual hours workedDirect labour cost4,3825,79920,3613096,4001,25,1761,27,574#####3132Unproductive ( unbilled ) factor9%9%9%9%9%333435NE 5 D.ASUPER CLEAN1Operating Budget for the period Jan - Dec '1834Quarters4Year- Sales budgetB Sales CommercialeSales residentialO Total salesB Direct material budgetVariable costs commercialVariable costs residentialTotal variable costsLabour budgetCommercialResidentialTotal labourFixed Overhead:ReceptionistDepreciationGasOffice SuppliesTotal

Budgeting: It is a process of planning the work to be performed. Under this process a formal plan is…

F. A SUPER CLEAN 1 Operating Budget for the period Jan - Dec '18 Quarters 1 2 4 Year Sales budget Sales Commercial Sales residential O Total sales Direct material budget Variable costs commercial Variable costs residential Total variable costs Labour budget Commercial Residential Total labour Fixed Overhead: Receptionist Depreciation Gas Office Supplies Total

F. A SUPER CLEAN 1 Operating Budget for the period Jan - Dec '18 Quarters 1 2 4 Year Sales budget Sales Commercial Sales residential O Total sales Direct material budget Variable costs commercial Variable costs residential Total variable costs Labour budget Commercial Residential Total labour Fixed Overhead: Receptionist Depreciation Gas Office Supplies Total

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 1PA

See similar textbooks

Similar questions

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:
Refer to Cornerstone Exercise 8.6. Required: 1. Calculate the total budgeted cost of units produced for Play-Disc for the coming year. Show the cost of direct materials, direct labor, and overhead. 2. Prepare a cost of goods sold budget for Play-Disc for the year. 3. What if the beginning inventory of finished goods was 75,200 (for 16,000 units)? How would that affect the cost of goods sold budget? (Assume Play-Disc uses the FIFO method.) Play-Disc makes Frisbee-type plastic discs. Each 12-inch diameter plastic disc has the following manufacturing costs: For the coming year, Play-Disc expects to make 300,000 plastic discs, and to sell 285,000 of them. Budgeted beginning inventory in units is 16,000 with unit cost of 4.75. (There are no beginning or ending inventories of work in process.) Required: 1. Prepare an ending finished goods inventory budget for Play-Disc for the coming year. 2. What if sales increased to 290,000 discs? How would that affect the ending finished goods inventory budget? Calculate the value of budgeted ending finished goods inventory.
Preparing a performance report Use the flexible budget prepared in P7-6 for the 31,000-unit level and the actual operating results listed below for the 31,000-unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 31,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:
Use the following information for Exercises 9-50 and 9-51: Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for 475, and the S12L5 sells for 300. Projected sales (number of speakers) for the coming 5 quarters are as follows: The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Exercise 9-50 Sales Budget Refer to the information regarding Stillwater Designs above. Required: 1. Prepare a sales budget for each quarter of 20X1 and for the year in total. Show sales by product and in total for each time period. 2. CONCEPTUAL CONNECTION How will Stillwater Designs use this sales budget?
Sales and production budgets Ultimate Audio Company manufactures two models of speakers. U500 and S1000. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget.
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%.
Preparing a flexible budget Use the information in Figure 7-12 of the chapter. Required: Prepare flexible budgets for the production and sale of 29,000 units and 31,000 units, respectively.
Sales, production, direct materials, direct labor, and factory overhead budgets King Tire Co.s budgeted unit sales for the year 2016 were: The budgeted selling price for truck tires was 200 per tire, and for passenger car tires it was 65 per tire. The beginning finished goods inventories were expected to be 2,000 truck tires and 5,000 passenger tires, for a total cost of 326,478, with desired ending inventories at 2,500 and 6,000, respectively, with a total cost of 400,510. There was no anticipated beginning or ending work-in- process inventory for either type of tire. The standard materials quantities for each type of tire were as follows: The purchase prices of rubber and steel were 2 and 3 per pound, respectively. The desired ending inventories for rubber and steel were 60,000 and 6,000 lb, respectively. The estimated beginning inventories for rubber and steel were 75,000 and 7,000 lb, respectively. The direct labor hours required for each type of tire were as follows: The direct labor rate for each department is as follows: Budgeted factory overhead costs for 2016 were as follows: Required: Prepare each of the following budgets for King for the year ended December 31, 2016: 1. Sales budget. 2. Production budget. 3. Direct material budget. 4. Direct labor budget. 5. Factory overhead budget. 6. Cost of goods sold budget.
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.
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.
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.
Q7 Duo, Incorporated, carries two products and has the following year-end income statement (000s omitted): Product AR-10 Product ZR-7 Budget Actual Budget Actual Units 2,600 3,600 7,200 6,700 Sales $ $ 13,000 $ 9,720 $ 14,400 $ 14,070 Variable costs 2,860 3,600 7,200 7,040 Fixed Costs 1,800 1,900 2,400 2,400 Total Costs $ 4,660 $ 5,500 $ 9,600 $ 9,440 Operating income $ 8,340 $ 4,220 $ 4,800 $ 4,630 The net effect of AR-10's sales volume variance on profit is: Multiple Choice $2,880 favorable. $1,950 favorable. $3,900 favorable. $3,150 favorable. $2,220 favorable.