A company wants to produce a weighted moving average forecast for April with theweights 0.40, 0.35, and 0.25 assigned to March, February, and January respectively.If the company had demands of 5,000 in January, 4,750 in February, and 5,200 inMarch, then April's forecast is5000.004992.504962.504983.33Page 4 of 20Previous PageNext Page36°C

Forecasting is a method of predicting future trends, based on historical data.

Answered: A company wants to produce a weighted…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 40P: The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels....

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
Simple exponential smoothing (with a 0.2) is beingused to forecast monthly beer sales at Gordon’s LiquorStore. After observing April’s demand, the predicted demandfor May is 4,000 cans of beer.a At the beginning of May, what is the prediction forJuly’s beer sales?b Actual demand during May and June is as follows:May, 4,500 cans of beer; June, 3,500 cans of beer. Afterobserving June’s demand, what is the forecast for July’sdemand?c The demand during May and June averages out to 4,5002 3,500 4,000 cans per month. This is the same asthe forecast for monthly sales before we observed theMay and June data. Yet after observing the May andJune demands for beer, our forecast for July demand hasdecreased from what it was at the end of April. Why?
Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 1 2 3 4 5 6 7 8 9 10 Demand 20 23 29 38 25 29 36 24 26 29 a) The forecast for weeks 2 through 10 using exponential smoothing with α = 0.50 and a week 1 initial forecast of 20.0 are (round your responses to two decimal places): Week 1 2 3 4 5 6 7 8 9 10 Demand 20 23 29 38 25 29 36 24 26 29 Forecast 20.0 b) For the forecast developed using exponential smoothing (α = 0.50 and initial forecast 20.0), the MAD = sales (round your response to two decimal places). c) For the forecast developed using exponential smoothing (α = 0.50 and initial forecast 20.0), the tracking…
The following table contains the demand from the last 10 months: a. Calculate the single exponential smoothing forecast for these data using an of .30 and an initial forecast (F1) of 31.b. Calculate the exponential smoothing with trend forecast for these data using an of.30, a of .30, an initial trend forecast (T1) of 1, and an initial exponentially smoothedforecast (F1) of 30.c. Calculate the mean absolute deviation (MAD) for each forecast. Which is best?
Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 a) Forecast demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1?
a) The demand forecast for Month 6 would be: A. 565 haircuts B. 574 haircuts C. 578 haircuts D. 584 haircuts b) With Mean Absolute Deviation (MAD) as the criterion, the best forecasting model for this time series data is: A. Naïve approach B. 2-week Simple Moving Average (SMA) C. Weighted Moving Average (WMA) with weights: 0.5, 0.3, 0.2 D. Exponential Smoothing (ES) with alpha = 0.8
MONTH DEMAND 1 45 2 3 4 5 48 43 48 49 6 54 7 8 9 10 47 50 46 47 Using the table above, calculate two forecasts using the following method:-i. First, for periods 4 through 10, develop the exponentially smoothed forecastsusing a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. ii. Calculate the weighted moving average for periods 4 through 10, using weights of.70, .20, and .10, with 0.70 applied to the most recent data iii. Calculate the mean absolute deviation (MAD) for each forecasting procedure.Which forecasting procedure would you select? Why?
What should be our forecast accuracy target if there is a high degree of volatility in customer orders and long lead times? We have a new chief sales officer who is proposing that we should forecast in dollars, not in units/cases. I have never heard of anyone forecasting in dollars. It is true that dollarized forecasts can help Sales in knowing precisely what sales target they should be hitting. But, is it the best practice?
Management of Davis’s Department Store has used time-series extrapolation to forecast retail sales for the next four quarters. The sales estimates are $100,000, $120,000, $140,000, and $160,000 for the respective quarters before adjusting for seasonality. Seasonal indices for the four quarters have been found to be 1.30, 0.90, 0.70, and 1.10, respectively. Compute a seasonalized or adjusted sales forecast? Develop an adjusted exponential forecast for a firm with the demand for bread as shown in the table below. week 1 2 3 4 5 6 7 8 Demands 700 685 648 717 713 728 754 762 Let α = 0.1 and β = 0.2. Previous average of Ft–1= 650, and let the initial trend adjustment, Tt–1 = 0? note please answer all the questions

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Contemporary Marketing

Marketing

ISBN:

9780357033777

Author:

Louis E. Boone, David L. Kurtz

Publisher:

Cengage Learning

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Contemporary Marketing

Marketing

ISBN:

9780357033777

Author:

Louis E. Boone, David L. Kurtz

Publisher:

Cengage Learning

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

A company wants to produce a weighted moving average forecast for April with the weights 0.40, 0.35, and 0.25 assigned to March, February, and January respectively. If the company had demands of 5,000 in January, 4,750 in February, and 5,200 in March, then April's forecast is