EXERCISE 9–4 Direct Labor Budget [LO5]The production manager of Rordan Corporation has submitted the following forecast of units to beproduced by quarter for the upcoming fiscal year:1st Quarter2nd Quarter3rd Quarter4th QuarterUnits to be produced ....8,0006,5007,0007,500Each unit requires 0.35 direct labor-hours, and direct laborers are paid $12.00 per hour.Required:Construct the company's direct labor budget for the upcoming fiscal year, assuming that thedirect labor workforce is adjusted each quarter to match the number of hours required to pro-duce the forecasted number of units produced.1.

Introduction Direct labor budget: Direct labor budget is the budget which shows how many hours of…

1. Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to pro- duce the forecasted number of units produced.

1. Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to pro- duce the forecasted number of units produced.

Accounting (Text Only)

26th Edition

ISBN:9781285743615

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter22: Budgeting

Section: Chapter Questions

Problem 22.2APE

See similar textbooks

Similar questions

Forecast sates volume and sales budget For 20Y8, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y8, the following unit sales data were reported for the year: Unit Sales 8" 10" Frame 12" 16" Frame East 8,755 3,686 Central 6,510 3,090 West 12,348 5,616 For the year ending December 31, 20Y9, unit sales are expected to Follow the patterns established during the year ending December 31, 20Y8. The unit selling price for the 8" 10" the frame is expected to Increase to 17 and the unit selling price for the 12" 16" frame is expected to increase to 32, effective January 1, 20Y9. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31,. 20Y8, Over budget. Place your answers in a columnar table with the following format: 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to lie used for preparing the sales budget for the year ending December 31, 20Y9. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest. 20Y8 Percentage 20Y9 Actual Increase Budgeted Units (Decrease) Units (rounded) 3. Prepare a sales budget for the year ending December 51. 20Y9.
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.: Cash. 26,000 Finished Goods.............................................. 16,900 Work in Process.............................................. 4,200 Materials.................................................... 6,400 Prepaid Expenses............................................ 600 Plant and Equipment......................................... 82,000 Accumulated DepreciationPlant and Equipment............. 32,000 Accounts Payable............................................ 14,800 Common Stock. 1.50 par..................................... 30,000 Retained Earnings............................................ 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 manufacturing costs and operating expenses for the year are summarized as follows: 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 overhead: 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 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 1. Prepare a budgeted income statement for 20Y9. 2. Prepare a budgeted balance sheet as of December 31, 20Y9, with supporting calculations.
Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January I, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Regina Soap Co.: Cash 85,000 Accounts Receivable........................................ 125,600 Finished Goods............................................ 69,300 Work in Process............................................ 32,500 Materials.................................................. 48,900 Prepaid Expenses.......................................... 2,600 Plant and Equipment....................................... 325,000 Accumulated DepreciationPlant and Equipment........... 156,200 Accounts Payable.......................................... 62,000 Common Stock. 10 par.................................... 180,000 Retained Earnings.......................................... 290,700 688,900 688,900 Factory output and sales for 20Y9 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, 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: Estimated Costs and Expenses Fixed Variable (Total for Year) (Per Unit Sold) Cost of goods manufactured and sold: Direct materials.................................. 1.10 Direct labor...................................... 0.65 Factory overhead: 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, anti 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 20Y9 taxable income will be paid during 20Y9. 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 20Y9. 2. Prepare a budgeted balance sheet as of December 31, 20Y9, with supporting calculations.
Forecast sales volume and sales budget Sentinel systems Inc. prepared the following sales budget for 20Y8: At the end of December 20Y8, the following unit sales data were reported for the year: Unit Sales Home Alert System Business Alert System United States 1,734 1,078 Europe 609 329 Asia 432 252 For the year ending December 31, 20Y9, unit sales are expected to follow the patterns established during the year ending October 31, 20Y8. The unit selling price for the Home: Alert System is expected to increase to 250, and the unit selling price for the Business Alert System is expected to be increased 820, effective January 1, 20Y9. Instructions 1. Compute the increase or decrease.ase of actual unit sales for the year ended October 31, 20Y8, over budget. Place your answers in a columnar table with the following format: 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y9. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit. 20Y8 Percentage 20Y9 Actual Increase Budgeted Units (Decrease) Units (rounded) 3. Prepare a sales budget for the year ending December 31, 201Y9
Budgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., 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 March: A. Estimated sales for March: Batting helmet.................. 1,200 units at 40 per unit Football helmet................. 6,500 units at 160 per unit B. Estimated inventories at March 1: Direct materials: Finished products: Plastic............ 90 lbs. Batting helmet....... 40 units at 25 per unit Foam lining....... 80 lbs. Football helmet...... 240 units at 77 per unit C. Desired inventories at March 31: Direct materials: Finished products: Plastic............ 50 lbs. Batting helmet....... 50 units at 25 per unit Foam lining....... 65 lbs. Football helmet...... 220 units at 78 per unit D. Direct materials used in production: In manufacture of batting helmet: Plastic............................... 1.2lbs. per unit of product Foam lining......................... 0.5 lb. per unit of product In manufacture of football helmet: Plastic............................... 3.5lbs. per unit of product Foam lining.......................... 1.5 lbs. per unit of product E. Anticipated cost of purchases and beginning and ending inventory of direct materials: Plastic........................ 6 per lb. Foam lining................... 4 per lb. F. Direct labor requirements Batting helmet: Molding Department............. 0.2 hr. at 20 per unit Assembly Department............ 0.5 hr. at 14 per hr. Football helmet: Molding Department............. 0.5 hr. at 20 per hr. Assembly Department............ 1.8 hrs. at 14 per hr. G. Estimated factory overhead costs for March: Indirect factory wages 86,000 Depreciation of plant and equipment 12,000 Power and light 4,000 Insurance and property tax 2,300 H. Estimated operating expenses for March: Sales salaries expense 184,300 Advertising expense 87,300 Office salaries expense 32,400 Depreciation expenseoffice equipment 3,800 Telephone expenseselling 5,800 Telephone expenseadministrative 1,200 Travel expenseselling 9,000 Office supplies expense 1,100 Miscellaneous administrative expense 1,000 I. Estimated other income and expense for March: Interest revenue 940 Interest expense 872 J. Estimated tax rate:30% Instructions 1. Prepare a sales budget for March. 2. Prepare a production budget for March. 3. Prepare a direct materials purchases budget for March. 4. Prepare a direct labor cost budget for March. 5. Prepare a factory overhead cost budget for March. 6. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be 15,300, and work in process at the end of March is desired to be 14,800. 7. Prepare a selling and administrative expenses budget for March. 8. Prepare a budgeted income statement for March.
Capital expenditures budget On January 1, 20Y2, the controller of Omicron Inc. is planning capital expenditures for the years 20Y2-20Y5. The following interviews helped the controller collect the necessary information for the capital expenditures budget: Director of Facilities A construction contract was signed in late 20Y1 for the construction of a new factory building at a contract cost of 10,000,000. The construction is scheduled to begin in 20Y2 and be completed in 20Y3. Vice President of Manufacturing: Once the new factory building is finished, we plan to purchase 15 million m equipment in late 20Y3. I expect that an additional 200,000 will be needed early in the following year (20Y4) to test and install the equipment before we can begin production. If sales continue to grow, I expect we'll need to invest another 1,000,000 in equipment in 20Y5. Chief Operating Officer: We have really been growing lately. I wouldn't be surprised if we need to expand the size of our new factory building in 20YS by at least 35%. Fortunately, we expect inflation to have minimal impact on construction costs over the next four years In addition. I would expect the cost of the expansion to be proportional to the size of the expansion. Director of Information Systems: We need to upgrade our information systems to wireless network technology. It doesn't make sense to do this until after the new factory building is completed and producing product. During 20Y4, once the factory is up and running, we should equip the whole facility with wireless technology. I think it would cost us 800,000 today to install the technology. However, prices have been dropping by 25% per year, so it should be less expensive at a later date. Chief Financial Officer: I am excited about our long-term prospects. My only short-term concern is managing our cash flow while we expend the 4,000,000 of construction costs on the portion of the new factory building scheduled to be completed m 20Y2. Use this interview information to prepare a capital expenditures budget for Omicron Inc. for the years 20Y2-20Y5.
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, 20Y8, the following tentative trial balance as of December 31, 20Y7, is prepared by the Accounting Department of Mesa Publishing Co.: Cash 26,000 Accounts Receivable 23,800 Finished Goods 16,900 Work in Process 4,200 Materials 6,400 Prepaid Expenses 600 Plant and Equipment 82.000 Accumulated DepreciationPlant and Equipment 32,000 Accounts Payable 14.800 Common Stock. 1.50 par 30,000 Retained Earnings 83,100 159,900 159,900 Factory output and sales for 20Y8 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, 20Y8, 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: Estimated Costs and Expenses Fixed Variable (Total for Year) (Per Unit Sold) Cost of goods manufactured and sold: Direct materials 30.00 Direct labor B.40 Factory overhead: Depreciation of plant and equipment 4,000 Other factory overhead 1,400 4.30 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 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 20Y8 taxable income will be paid during 20Y8. 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 1. Prepare a budgeted income statement for 20Y8. 2. Prepare a budgeted balance sheet as of December 31,20Y8, with supporting calculations.
Forecast sales volume and sales budget Sentinel Systems Inc. prepared the following sales budget for 20Y8: Sentinel Systems Inc. Sales Budget For the Year Ending December 31, 20 Y8 Unit Sales Unit Selling Total Product and Area Volume Price Sales Home Alert System: United States 1,700 200 340,000 Europe 580 200 116,000 Asia 450 200 90,000 Total 2,730 546,000 Business Alert System: United States 980 750 735,000 Europe 350 750 262,500 Asia 240 750 180,000 Total 1,570 1,177,500 Total revenue from sales 1,723,500 At the end of December 20Y8, the following unit sales data were reported for the year: Unit Sales Home Alert System Business Alert System United States 1,734 1,078 Europe 609 329 Asia 432 252 For the year ending December 31, 20Y9, unit sales are expected to follow the patterns established during the year ending December 31, 20Y8. The unit selling price for the Home Alert System is expected to increase to 250, and the unit selling price for the Business Alert System is expected to be decreased to 820, effective January 1, 20Y9. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y8, over budget. Place your answers in a columnar table with the following format: Unit Sales, Year Ended 20Y8 Increase (Decrease) Actual Over Budget Budget Actual Sales Amount Percent Home Alert System: United States Europe Asia Business Alert System: United States Europe Asia 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to lie used for preparing the sales budget for the year ending December 31, 20Y9- Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit. 20Y8 Actual Units Percentage Increase (Decrease) 20Y9 Budgeted Units (rounded) 3. Prepare a sales budget for the year ending December 31, 20Y9.
EXERCISE 8–7 Cash Budget [LO8–8] Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Managementhas prepared the following summary of its budgeted cash flows: [picture] The company’s beginning cash balance for the upcoming fiscal year will be $20,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Required: Prepare the company’s cash budget for the upcoming fiscal year Particulars 1Q 2Q 3Q 4Q Year Cash balance. Beginning Add:Collection from customer Total cash available Less:Disbursement Purchase of inventory Selling and…
EXERCISE 8–7 Cash Budget [LO8–8] Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Managementhas prepared the following summary of its budgeted cash flows: [picture] The company’s beginning cash balance for the upcoming fiscal year will be $20,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Required: Prepare the company’s cash budget for the upcoming fiscal year
Direct Materials and Direct Labor Budgets [LO4, LO5]The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th QuarterUnits to be produced . . . . . . 5,000 8,000 7,000 6,000In addition, the beginning raw materials inventory for the 1st Quarter is budgeted to be 6,000 grams and the beginning accounts payable for the 1st Quarter is budgeted to be $2,880. Each unit requires 8 grams of raw material that costs $1.20 per gram. Management desires to end each quarter with an inventory of raw materials equal to 25% of the following quarter’s production needs. The desired ending inventory for the 4th Quarter is 8,000 grams. Management plans to pay for 60% of raw material purchases in the quarter acquired and 40% in the following quarter.Each unit requires 0.20 direct labor-hours and direct…