Exercise 8-4 Direct Labor Budget [LO8-5]The production manager of Rordan Corporation has submitted the following quarterly production forecast for theupcoming fiscal year:Units to be producedEach unit requires 0.35 direct labor-hours, and direct laborers are paid $12.00 per hour.Required:1. Prepare the company's direct labor budget for the upcoming fiscal year. Assume that the direct labor workforce isadjusted each quarter to match the number of hours required to produce the forecasted number of units produced.2. Prepare the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is notadjusted each quarter. Instead, assume that the company's direct labor workforce consists of permanent employees whoare guaranteed to be paid for at least 2,600 hours of work each quarter. If the number of required direct labor-hours isless than this number, the workers are paid for 2,600 hours anyway. Any hours worked in excess of 2,600 hours in aquarter are paid at the rate of 1.5 times the normal hourly rate for direct labor.Show Transcribed TextRequired 1 Required 21st Quarter 2nd Quarter 3rd Quarter 4th Quarter8,0006,5007,5007,000Prepare the company's direct labor budget for the upcoming fiscal year. Assume that the direct labor workforce is adjusted eachquarter to match the number of hours required to produce the forecasted number of units produced. (Round "Direct labor timeper unit (hours)" answers to 2 decimal places.)Required production in unitsDirect labor time per unit (hours)Total direct labor-hours neededDirect labor cost per hourTotal direct labor costShow Transcribed TextRordan CorporationDirect Labor Budget2nd Quarter1st Quarter$$8,0000.352,80012 $33,600 $6,5000.352,2751227,3003rd Quarter 4th Quarter7,0007,5000.350.352,4502,625$1231,500 $$$12 $29,400 $Year29,0000.3510,15012121,800 Required 1Required 2Prepare the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is not adjustedeach quarter. Instead, assume that the company's direct labor workforce consists of permanent employees who are guaranteed tpaid for at least 2,600 hours of work each quarter. If the number of required direct labor-hours is less than this number, the worlare paid for 2,600 hours anyway. Any hours worked in excess of 2,600 hours in a quarter are paid at the rate of 1.5 times thenormal hourly rate for direct labor. (Round "Direct labor time per unit (hours)" answers to 2 decimal places.)Required production in unitsDirect labor time per unit (hours)Total direct labor-hours neededRegular hoursOvertime hoursWages for regular hoursOvertime wagesTotal direct labor costRordan CorporationDirect Labor Budget1st Quarter 2nd Quarter 3rd Quarter 4th Quarter8,0006,5007,0007,500$0 $00 $Year00Show less

Name: Exercise 8-4 Direct Labor Budget [LO8-5]The production manager of Ror
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: Exercise 8-4 Direct Labor Budget [LO8-5]The production manager of Rordan Corporation has submitted the following quarterly production forecast for theupcoming fiscal year:Units to be producedEach unit requires 0.35 direct labor-hours, and direct lab

The direct labor budget is prepared to know the expected number of labor hours required to produce…

Business

Accounting

The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming fiscal year: Units to be produced 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 8,000 6,500 7,000 7,500 Each unit requires 0.35 direct labor-hours, and direct laborers are paid $12.00 per hour. Required: 1. Prepare the company's direct labor budget for the upcoming fiscal year. Assume that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced. 2. Prepare the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is not adjusted each quarter. Instead, assume that the company's direct labor workforce consists of permanent employees who are guaranteed to be paid for at least 2,600 hours of work each quarter. If the number of required direct labor-hours is less than this number, the workers are paid for 2,600 hours anyway. Any hours worked in excess of 2,600 hours in a quarter are paid at the rate of 1.5 times the normal hourly rate for direct labor.

The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming fiscal year: Units to be produced 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 8,000 6,500 7,000 7,500 Each unit requires 0.35 direct labor-hours, and direct laborers are paid $12.00 per hour. Required: 1. Prepare the company's direct labor budget for the upcoming fiscal year. Assume that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced. 2. Prepare the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is not adjusted each quarter. Instead, assume that the company's direct labor workforce consists of permanent employees who are guaranteed to be paid for at least 2,600 hours of work each quarter. If the number of required direct labor-hours is less than this number, the workers are paid for 2,600 hours anyway. Any hours worked in excess of 2,600 hours in a quarter are paid at the rate of 1.5 times the normal hourly rate for direct labor.

Financial & Managerial Accounting

14th Edition

ISBN:9781337119207

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

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

Chapter21: Budgeting

Section: Chapter Questions

Problem 21.1BPR: Forecast sales volume and sales budget Sentinel systems Inc. prepared the following sales budget for...

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.
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
Forecast sales volume and sales budget For 20Y6, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y6, 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 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y6 Unit Sales Unit Selling Total Product and Area Volume Price Sales 8"10" Frame: East 8,500 16 136,000 Central 6,200 16 99,200 West 12,600 16 201,600 Total 27,300 436,800 12" x 16" Frame: East 3,800 30 5114,000 Central 3,000 30 90,000 West 5,400 30 162,000 Total 12,200 366,000 Total revenue from sales 802,800 For the year ending December 31, 20Y7, unit sales are expected to follow the patterns established during the year ending December 31, 20Y6. The unit selling price for the 8" 10"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, 20Y7. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y6, over budget. Place your answers in a columnar table with the following format: Unit Sales, Year Ended 20Y6 Increase (Decrease) Actual Over Budget Budget Actual Sales Amount Percent 8" 10" Frame: East Central West 12"16" Frame: East Central West 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y7, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y7. 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. 20Y6 Percentage 20Y7 Actual Increase Budgeted Units (Decrease! Units (rounded) 3. Prepare a sales budget for the year ending December 31, 20Y7.
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.
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.
Communication The city of Milton has an annual budget cycle that begins on July 1 and ends on June 30. At the beginning of each budget year, an annual budget is established for each department. The annual budget is divided by 12 months to provide a constant monthly static budget. On June 30, all unspent budgeted monies for the budget year from the various city departments must be returned to the General Fund. Thus, if department heads fail to use their budget by year-end, they will lose it. A budget analyst prepared a chart of the difference between the monthly actual and budgeted amounts for the recent fiscal year. The chart was as follows: Write a memo to Stacy Collins, the city manager, interpreting the chart and suggesting improvements to the budgeting system.
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.
Forecast sales volume and sales budget Sentinel Systems Inc. prepared the following sales budget for 2016: At the end of December 2016, the following unit sales data were reported for the year: For the year ending December 31 , 2017, unit sales are expected to follow the patterns established during the year ending December 31, 2016. 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, 2017. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 2016, 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 2017, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 2017. 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. 3. Prepare a sales budget for the year ending December 31, 2017.