Problem 3-22 (Algo)Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows: Month12345678910Sales835845850820785840815840785800Forecast 1Forecast 2MAPE F1MAPE F2a. Compute the MSE and MAD for each forecast. (Roundyour answers to 2 decimal places.)Forecast 1835830840790815785770835805785MSEMADMSETracking signalControl limits782.501,125.60Forecast 2765830815830b. Compute MAPE for each forecast. (Round yourintermediate calculations to 5 decimal places and finalanswers to 4 decimal places.)3.0800 %6.0800 %800806775810815805MAD0 +c. Prepare a naive forecast for periods 2 through 11 usingthe given sales data. Compute each of the following; (1)MSE, (2) MAD, (3) tracking signal at month 10, and (4) 2scontrol limits. (Negative values should be indicated by aminus sign. Round your answers to 2 decimal places.)14.0013.72

Answered: Two independent methods of forecasting…

Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: The following table gives the number of pints of type A blood used at Damascus Hospital in the past…

A: Week ofPints usedAugust, 31360September, 7372September, 14412September, 21381September,…

Q: a) The forecasted demand for the week of October 12 using a 3-week moving average = 373.33 pints…

A: Week ofPrints usedAug-31360Sep-07372Sep-14412Sep-21378Sep-28368Oct-05374

Q: Below is a table containing data on product demand for the most recent three months along with the…

A: MAPE - is a statistical measure of how accurate a forecast system is. It measures this accuracy as a…

Q: The following table gives the number of pints of type A blood used at Damascus Hospital in the past…

A: to find:the forecast for October 12 month using a three-week moving averagethe forecast for October…

Q: The MAD for Method 1 = 0.153 thousand gallons (round your response to three decimal places). The…

A: WeekForecast method 1Actual10.950.7221.080.9830.95141.20.97

Q: Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10…

A: Exponential smoothing is a forecasting model which considering the actual and forecasting demand…

Q: Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown…

A: Exponential smoothing determine with following formula Exponential smoothing = Alpha*At+(1-Alpha)*Ft…

Q: The Holy Smokes Corporation sells altar candles world-wide. Quarterly sales data for the past 5…

A: Below are the used three standard error measures: mean squared error (MSE), mean absolute percent…

Q: determine the forecasts for the first four months of 2024 (January, February, March, and April)…

A: MonthSalesJan51Feb55Mar54Apr57May50Jun68Jul66Aug59Sep67Oct69Nov75Dec77

Q: a) The forecasted demand for the week of October 12 using a 3-week moving average = 373.33 pints…

A: Forecasts can be developed by various methods. Some of the methods are moving averages, weighted…

Q: The following table gives the number of pints of type A blood used at Damascus Hospital in the past…

A: Forecasting is a process that predict the future demand using available past actual information. The…

Q: The MAD for Method 1= _____ thousand gallons (round response to three decimal places)

A: Demand is the amount of quantity of goods and services for which the people are willing to pay at…

Q: A police station had to deploy a police officer for an emergency multiple times in the last four…

A: Naive forecasting is an forecast estimation technique in which the current period forecast is equal…

Q: Harlen Industries Limited has a simple forecasting model whose forecast demand has been plotted…

A: In this question, we have the table data for an 8 periods duration, for each period, we have actual…

Q: Below is a table containing data on product demand for the most recent three months along with the…

A: Calculate the MSE

Q: Develop a 3-weck weighted average forecast for Week 4 through 9 with weights WI - W2 = W3 = 0.2 0.3…

A: A moving average based on weighted average puts weight on the data gathered recently, by multiplying…

Q: Additional Algo 15-12 Forecasting with Seasonality Demand history for the past three years is shown…

Q: Following are two weekly forecasts made by two different methods for the number of gallons of…

A: Find the Given details below:

Q: Following are two weekly forecasts made by two different me demanded at a local gasoline station.…

A: WeekForecast method 1Actual demand10.90.7221.08130.971.0741.171

Q: The MAD for Method 1 = enter your response here thousand gallons (round your response to three…

A: Forecasting is a technique used to predict future outcomes on the basis of past data. In business…

Q: Starbucks has a large, global supply chain that must efficiently supply over 17,000 stores. Although…

A: WEEK−5−4−3−2−112345678910111213Atlanta463532543433463633552820584536255541Boston59264841333534434346…

Q: National Standard, Inc. sells radio frequency identification (RFID) tags. Monthly demand for a…

A: Note: - Since we only answer up to 3 sub-parts, we’ll answer the first3. Please resubmit the…

Q: Month 1 2 3 4 5 6 7 8 9 10 Sales 835 Forecast 1 Forecast 2 MAPE F1 MAPE F2 845 850 820 785 840 815…

A: Forecast for 10 months is provided using 2 methods:

Question

Problem 3-22 (Algo) Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:

Month
1
2
3
4
5
6
7
8
9
10
Sales
835
845
850
820
785
840
815
840
785
800
Forecast 1
Forecast 2
MAPE F1
MAPE F2
a. Compute the MSE and MAD for each forecast. (Round
your answers to 2 decimal places.)
Forecast 1
835
830
840
790
815
785
770
835
805
785
MSE
MAD
MSE
Tracking signal
Control limits
782.50
1,125.60
Forecast 2
765
830
815
830
b. Compute MAPE for each forecast. (Round your
intermediate calculations to 5 decimal places and final
answers to 4 decimal places.)
3.0800 %
6.0800 %
800
806
775
810
815
805
MAD
0 +
c. Prepare a naive forecast for periods 2 through 11 using
the given sales data. Compute each of the following; (1)
MSE, (2) MAD, (3) tracking signal at month 10, and (4) 2s
control limits. (Negative values should be indicated by a
minus sign. Round your answers to 2 decimal places.)
14.00
13.72

Leveraging special tenchniques in analyzing historical data to predict future trends. Forecasting covers the methods and types of forecasting and their application to case studies.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: State the given information

VIEW

Step 2: a) Compute MAD & MSE for each forecast

VIEW

Step 3: b) Compute MAPE for each forecast

VIEW

Step 4: c) Prepare Naive Forecast & compute MSE & MAD

VIEW

Step 5: c) Find the Tracking Signal & Control Limits

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 6 steps with 25 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

snip
K Following are two weekly forecasts made by two different methods for the number of gallons of gasoline, in thousands, demanded at a local gasoline station. Also shown are actual demand levels, in thousands of gallons: Week 1 2 3 4 Forecast Method 1 0.95 1.05 0.97 1.20 Actual Demand 0.68 1.05 0.96 1.00 Week 1 2 3 4 Forecast Method 2 0.82 1.21 0.88 1.17 The MAD for Method 1 = thousand gallons (round your response to three decimal places). Actual Demand 0.68 1.05 0.96 1.00 Save D
Explain different forecasting techniques like moving averages, exponential smoothing, regression etc.
The worksheet Hudson Demand Case Data in MindTap provides the number of visits over one year from January to December (52 weeks). Chart the data and explain the characteristics of the time series. How would you forecast future demand for customer visits? What criteria will you use to determine a “good” forecast? What methods would you use, and why? What is your final recommendation with respect to a forecasting method? Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
The following table shows the actual demand observed over the last 11 years: Year 1 2 3 4 5 6 7 8 9 10 11 Demand 6 8 4 7 11 7 13 12 10 13 8 This exercise contains only parts b, c, and d. Part 2 b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Part 3 c) Using the 3-year weighted moving average with weights 0.10, 0.30, and 0.60, using 0.60 for the most recent period, provide the forecast from periods 4 through 12 (round your responses to two decimal places). Part 4 d) Mean absolute deviation for the forecast developed…
The following table gives the number of pints of type A blood used at Woodlawn Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 - a) The forecasted demand for the week of October 12 using a 3-week moving average = pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.10, 0.30, and 0.60, using 0.60 for the most recent week, the forecasted demand for the week of October 12 = pints (round your response to two decimal places and remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.) Week Of c) If the forecasted demand for the week of August 31 is 360 and a = 0.20, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places). August 31 September 7 September 14…
Forecasting can be classified into which basic types?
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: August 31 September 7 September 14 Week Of September 21 September 28 October 5 Week Of a) The forecasted demand for the week of October 12 using a 3-week moving average = pints (round your response to two decimal places). pints (round your b) Using a 3-week weighted moving average, with weights of 0.10, 0.35, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week of October 12 = response to two decimal places and remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.) c) If the forecasted demand for the week of August 31 is 350 and x = 0.25, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places). August 31 September 7 September 14…
a. Use a 3-month moving average to estimate the month-in-advance forecast of demand for months 4–12 and generate a forecast for the first month of next year. Calculate the average forecast error and mean absolute error. b. Use a 3-month weighted moving average with weights of 0.6, 0.3, 0.1 (most recent to least recent, respectively) to calculate month-in-advance forecasts for months 4–12 and forecast for the first month of next year. Calculate the average forecast error and mean absolute error. c. Compare the average forecast error and MAD for the forecasting methods in parts a and b. Based on these error calculations, which of the two forecast methods would you recommend? Why?
Problem 3
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: S Week Of August 31 September 7 September 14 September 21 September 28 October 5 a) The forecasted demand for the week of October 12 using a 3-week moving average = pints (round your response to two decimal places) b) Using a 3-week weighted moving average, with weights of 0.15, 0.35, and 0.50, using 0.50 for the most recent week, the forecasted demand for the week of October 12 = order the largest weight applies to most recent period and smallest weight applies to oldest period.) c) If the forecasted demand for the week of August 31 is 350 and a = 0.30, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places) Week Of Pints Used Forecast for this Date 350 350.00 356.00 August 31 September 7 September 14 September 21 September 28 October 5 October 12 Pints…
Heres a zoom in photo of of the problem/ Please solve