Required: 1. Prepare a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive. (Hint: There will be only one forecasted number for January-this is the forecast done in December. For February, there will be two forecasts: one done in December and a second done in January. For June, there will be six forecasts, one done in each of the preceding six months.) 2. For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier.

Required: 1. Prepare a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive. (Hint: There will be only one forecasted number for January-this is the forecast done in December. For February, there will be two forecasts: one done in December and a second done in January. For June, there will be six forecasts, one done in each of the preceding six months.) 2. For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier.

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 3PA: Budgeted income statement and supporting budgets The budget director of Birding Homes Feeders Inc.,...

See similar textbooks

Similar questions

Digital Solutions Inc. uses flexible budgets that are based on the following data: Prepare a flexible selling and administrative expenses budget for October for sales volumes of 500,000, 750,000, and 1,000,000.
The data shown were obtained from the financial records of Italian Exports, Inc., for March: Sales are expected to increase each month by 10%. Prepare a budgeted income statement.
Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Company policy requires that ending inventories for each month be 25 percent of next months sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.
Budgeted income statement and supporting budgets for three months Bellaire Inc. gathered the following data for use in developing the budgets for the first quarter (January, February, March) of its fiscal year: Estimated sales at 125 per unit: Estimated finished goods inventories: Work in process inventories are estimated to be insignificant (zero). Estimated direct materials inventories: Manufacturing costs: Selling expenses: Instructions Prepare the following budgets using one column for each month and a total column for the first quarter, as shown for the sales budget: Prepare a sales budget for March. Prepare a production budget for March. Prepare a direct materials purchases budget for March. Prepare a direct labor cost budget for March. Prepare a factory overhead cost budget for March. Prepare a cost of goods sold budget for March. Prepare a selling and administrative expenses budget for March. Prepare a budgeted income statement with budgeted operating income for March.
Before the year began, the following static budget was developed for the estimated sales of 100,000. Sales are sluggish and management needs to revise its budget. Use this information to prepare a flexible budget for 80,000 and 90,000 units of sales.
Sales, production, direct materials purchases, and direct labor cost budgets The budget director of Gourmet Grill Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for July is summarized as follows: Estimated sales for July by sales territory: Estimated inventories at July 1: Desired inventories at July 31: Direct materials used in production: Anticipated purchase price for direct materials: Direct labor requirements: Instructions Prepare a sales budget for July. Prepare a production budget for July. Prepare a direct materials purchases budget for July. Prepare a direct labor cost budget for July.
Before the year began, the following static budget was developed for the estimated sales of 50,000. Sales are higher than expected and management needs to revise its budget. Prepare a flexible budget for 100,000 and 110,000 units of sales.
Roman Inc. has the following totals from its operating budgets: Prepare a budgeted income statement for the year ended December 31, 2016, assuming that income from operations is taxed at a rate of 30%.
Echo Amplifiers prepared the following sales budget for the first quarter of 2018: It also has this additional information related to its expenses: Prepare a sales and administrative expense budget for each month in the quarter ending March 31, 2018.
Budgeted income statement and supporting budgets The budget director of Birding Homes Feeders Inc., 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 January: Estimated sales for January: Estimated inventories at January 1: Desired inventories at January 31: Direct materials used in production: Anticipated cost of purchases and beginning and ending inventory of direct materials: Direct labor requirements: Estimated factory overhead costs for January: Estimated operating expenses for January: Estimated other revenue and expense for January: Estimated tax rate: 25% Instructions Prepare a sales budget for January. Prepare a production budget for January. Prepare a direct materials purchases budget for January. Prepare a direct labor cost budget for January. Prepare a factory overhead cost budget for January. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be 9,000, and work in process at the end of January is estimated to be 10,500. Prepare a selling and administrative expenses budget for January. Prepare a budgeted income statement for January.
The fixed overhead budgeted for Ranier Industries at an expected capacity of 500,000 units is 1,500,000. Variable costing is used internally, and the net income is adjusted to an absorption costing net income at year-end. Data collected over the last three years show the following: Determine the adjustment each year to convert the variable costing income to absorption costing net income. Compute the absorption costing net income for each year.
Sales, production, direct materials purchases, and direct labor cost budgets The budget director of Royal Furniture Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for February is summarized as follows: Estimated sales of King and Prince chairs for February by sales territory: Estimated inventories at February 1: Desired inventories at February 28: Direct materials used in production: Anticipated purchase price for direct materials: Direct labor requirements: Instructions Prepare a sales budget for February. Prepare a production budget for February. Prepare a direct materials purchases budget for February. Prepare a direct labor cost budget for February.