Sales of quilt covers at Bud Banis's discount department store in Carbondale over the past year are shown below. Management prepared a forecast using a combination of exponential smoothing and its collective judgment for the 4 months (March, April, May, and June): Month Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Unit Sales 102 97 96 112 120 120 92 84 100 96 88 112 Management's Forecast 125 116 108 108 a) MAD for the forecast developed by the management's technique = sales (round your response to two decimal places).

Sales of quilt covers at Bud Banis's discount department store in Carbondale over the past year are shown below. Management prepared a forecast using a combination of exponential smoothing and its collective judgment for the 4 months (March, April, May, and June): Month Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Unit Sales 102 97 96 112 120 120 92 84 100 96 88 112 Management's Forecast 125 116 108 108 a) MAD for the forecast developed by the management's technique = sales (round your response to two decimal places).

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter8: Time Series Analysis And_forecasting

Section: Chapter Questions

Problem 11P: For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12...

See similar textbooks

Similar questions

Monthly sales of storage sheds at Wallace Garden supply are shown in the following table. Using the 3-month moving average forecasting method (simple average), what is your forecast of December sales? Actual Month Sales January February March April May June July August September October November December? O 15.2 16.7 20.67 O None of the above 10 12 16 13 17 19 15 20 22 19 21
The Toro Cutlery Company has collected monthly sales information below: MONTH MONTH May January February June March April SALES 15,000 18,000 33,000 115,000 SALES 77,000 30,000 80,000 44,000 MONTH September October November December SALES 34,000 101,000 68,000 84,000 July August The company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales. a. What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast (January, 3-month MA): Forecast (January, 4-month MA): Forecast (January, 5-month MA): b. What will the forecast be for January the following year using exponential smoothing with a = 0.4? Assume the forecast for February this year is 15,000. Do not round intermediate calculations. Round your answer to the nearest whole number.
The 100-room Delavan Inn's past three years of room sales for April are as follows: Rooms Room Year Sold ADR Revenues 20X1 2,100 $45 $94,500 20X2 2,130 47 100,110 20X3 2,160 49 105,840 Analyze the past performance and project sales for April 20X4. Assume that the trends of rooms sold and ADR continue for April of 20X4.
The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 20 21 17 12 15 15 15 19 22 22 23 24 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method = sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = sales (round your response to two decimal places). The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20, 0.20, and 0.30, where the heaviest weights are applied the most recent month = sales (round your response to one decimal place). Using exponential smoothing with a = 0.35 and a September forecast of 18.00, the forecast for the next period (Jan) = sales (round your response to two decimal places). Using a method of trend projection, the forecast for the next month (Jan) = sales (round your response to two decimal places). c) The method…
The monthly sales for Yazici Batteries, Inc., were asfollows: a) Plot the monthly sales data.b) Forecast January sales using each of the following:i) Naive method.ii) A 3-month moving average.iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3,with the heaviest weights applied to the most recent months.iv) Exponential smoothing using an a = .3 and a Septemberforecast of 18.v) A trend projection. c) With the data given, which method would allow you to fore-cast next March’s sales?
The quarterly sales data (number of copies sold) for a college textbook over the past three years are as follows: a. Construct a time series plot. What type of pattern exists in the data? b. Use a regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = l if quarter l, 0 otherwise; Qtr2 = l if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. c. Based on the model you developed in part (b), compute the quarterly forecasts for next year. d. Let t = 1 to refer to the observation in quarter 1 of year 1; t = 2 to refer to the observation in quarter 2 of year 1; ; and t = 12 to refer to the observation in quarter 4 of year 3. Using the dummy variables defined in part (b) and t, develop an equation to account for seasonal effects and any linear trend in the time series. e. Based upon the seasonal effects in the data and linear trend, compute the quarterly forecasts for next year. f. Is the model you developed in part (b) or the model you developed in part (d) more effective? Justify your answer.
Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
Cash collections for Wax On Candles found that 60% of sales were collected in the month of the sale, 30% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in January and February?
Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?
The following data were obtained from the financial records of Sonicbrush, Inc., for March: Sales are expected to increase each month by 15%. Prepare a budgeted income statement.
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account):1st Quarter 2nd Quarter 3rd Quarter 4th QuarterBudgeted unit sales ............................ 11,000 12,000 14,000 13,000The selling price of the company’s product is $18.00 per unit. Management expects to collect 65% of salesin the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to beuncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in thefi rst quarter, is $70,200.The company expects to start the first quarter with 1,650 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 15% of the next quarter’s budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,850 units.Required:1. Prepare the company’s sales budget and schedule of expected cash…
The home buyer is planning their basic towel assortment for the fall season. The sales plan is $304,800 with a planned turnover for the fall season of 0.96. The planned sales by month are: August $44,450 September $57,150 October $47,625 November $63,500 December $76,200 January $28,575 Calculate the basic stock needed for each month.