Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows: April May June July Unit Sales 88,000 90,000 128,000 99,000 The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-c month inventory levels must equal 15% of the following month's unit sales. The inventory at the end of March was 13,200 units. Required: Prepare a production budget by month and in total, for the second quarter. Down Under Products, Ltd., Production Budget April May June Quarter 128,000 14,850 Budgeted unit sales 88,000 90,000 306,000 Add: Desired units of ending finished goods inventory 13,500 19,200 Total needs 101,500 109,200 142,850 306,000 Less: Units of beginning finished goods inventory (13,200) (13,500) (19,200) Required production in units 88,300 95,700 123,650 306,000

Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows: April May June July Unit Sales 88,000 90,000 128,000 99,000 The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-c month inventory levels must equal 15% of the following month's unit sales. The inventory at the end of March was 13,200 units. Required: Prepare a production budget by month and in total, for the second quarter. Down Under Products, Ltd., Production Budget April May June Quarter 128,000 14,850 Budgeted unit sales 88,000 90,000 306,000 Add: Desired units of ending finished goods inventory 13,500 19,200 Total needs 101,500 109,200 142,850 306,000 Less: Units of beginning finished goods inventory (13,200) (13,500) (19,200) Required production in units 88,300 95,700 123,650 306,000

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.1BPR: Forecast sales volume and sales budget Sentinel Systems Inc. prepared the following sales budget for...

See similar textbooks

Similar questions

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 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: 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.
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.
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.
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.
Exercise 8-2 Production Budget [LO8-3] Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows: Unit Sales April 72,000 May 85,000 June 112,000 July 91,000 The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of-month inventory levels must equal 20% of the following month’s unit sales. The inventory at the end of March was 14,400 units. Required: Prepare a production budget by month and in total, for the second quarter.
Exercise 9-2 Production Budget [LO9-3] Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next four months as follows: Sales in Units April 60,000 May 80,000 June 100,000 July 85,000 The company is now in the process of preparing a production budget for the second quarter. Past experience has shown that end-of-month inventory levels must equal 20% of the following month’s sales. The inventory at the end of March was 12,000 units. Required: Prepare a production budget for the second quarter; in your budget, show the number of units to be produced each month and for the quarter in total.
Exercise 9-4 Direct Labor Budget [LO9-5] The production manager of Rordan 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 Quarter Units to be produced 10,800 8,000 8,400 10,700 Each unit requires 0.65 direct labor-hours, and direct laborers are paid $16 per hour. Required: 1. Complete 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 produce the forecasted number of units produced. (Round "Direct labor time per unit (hours)" answers to 2 decimal places.) 2. Complete 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…