Homework Help is Here – Start Your Trial Now!
Math
Statistics
Homework for FORECASTING Problem Solving The Katonah Family Markets, operators of 5 supermarkets in Westchester County, approached Iona University's LaPenta School of Business to offer an Internship to an undergraduate business senior with the possibility of it becoming a full-time position. The purpose of the internship is to help the Chain forecast its demand for ALL (HE) Laundry Detergent. ALL (HE) is required for new high technology washing machines that cannot tolerate significant foaming so it is not a mainstream product and the Chain is having difficulty in carrying it on the shelves so it has lost some of its customers to other supermarket chains. ALL (HE) comes in two sizes namely 20 washes and 49 washes (used to be 26 and 56 before Pandemic Shrinkflation!). Below you will find the sales data for this product by size: Actual 20 Washes Forecast Period August 2021 September 2021 October 2021 November 2021 December 2021 January 2022 February 2022 March 2022 April 2022 May 2022 June 2022 July 2022 August 2022 September 2022 October 2022 12 Na 00 9 9 8 11 14 8 12 11 14 8 10 13 11 ?? 11 Actual 49 Washes Forecast FHON M&Ne 4 1 0 2 3 4 2 2 4 4 3 1 3 3 ?? 2 Exponential Smoothing- (Excel-OM) Use the actual and forecast data presented to you in the homework problem to calculate the February Forecast with Exponential Smoothing as a function of Alpha starting at a = 0.1 and, increasing a by 0.1 units, ending with a=0.9. Tabulate your results and then present them as a graph with a as the x-axis and the Forecasts as the y-axis. If the Actual for February turns out to be 18, which a value or values would be best to use? Type a short explanation of your decision on your spreadsheet.

Homework for FORECASTING Problem Solving The Katonah Family Markets, operators of 5 supermarkets in Westchester County, approached Iona University's LaPenta School of Business to offer an Internship to an undergraduate business senior with the possibility of it becoming a full-time position. The purpose of the internship is to help the Chain forecast its demand for ALL (HE) Laundry Detergent. ALL (HE) is required for new high technology washing machines that cannot tolerate significant foaming so it is not a mainstream product and the Chain is having difficulty in carrying it on the shelves so it has lost some of its customers to other supermarket chains. ALL (HE) comes in two sizes namely 20 washes and 49 washes (used to be 26 and 56 before Pandemic Shrinkflation!). Below you will find the sales data for this product by size: Actual 20 Washes Forecast Period August 2021 September 2021 October 2021 November 2021 December 2021 January 2022 February 2022 March 2022 April 2022 May 2022 June 2022 July 2022 August 2022 September 2022 October 2022 12 Na 00 9 9 8 11 14 8 12 11 14 8 10 13 11 ?? 11 Actual 49 Washes Forecast FHON M&Ne 4 1 0 2 3 4 2 2 4 4 3 1 3 3 ?? 2 Exponential Smoothing- (Excel-OM) Use the actual and forecast data presented to you in the homework problem to calculate the February Forecast with Exponential Smoothing as a function of Alpha starting at a = 0.1 and, increasing a by 0.1 units, ending with a=0.9. Tabulate your results and then present them as a graph with a as the x-axis and the Forecasts as the y-axis. If the Actual for February turns out to be 18, which a value or values would be best to use? Type a short explanation of your decision on your spreadsheet.

MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
Related questions
Question
Homework for FORECASTING Problem Solving The Katonah Family Markets, operators of 5 supermarkets in Westchester County, approached lona University's LaPenta School of Business to offer an Internship to an undergraduate business senior with the possibility of it becoming a full-time position. The purpose of the internship is to help the Chain forecast its demand for ALL (HE) Laundry Detergent. ALL (HE) is required for new high technology washing machines that cannot tolerate significant foaming so it is not a mainstream product and the Chain is having difficulty in carrying it on the shelves so it has lost some of its customers to other supermarket chains. ALL (HE) comes in two sizes namely 20 washes and 49 washes (used to be 26 and 56 before Pandemic Shrinkflation!). Below you will find the sales data for this product by size: Actual 20 Washes Forecast Actual 49 Washes Forecast Period August 2021 September 2021 October 2021 November 2021 December 2021 January 2022 February 2022 March 2022 April 2022 May 2022 June 2022 July 2022 August 2022 September 2022 October 2022 12 9 9 8 11 14 8 12 11 14 8 10 13 11 ?? 11 4 1 0 2 3 4 2 2 4 4 3 1 3 3 ?? Exponential Smoothing- (Excel-OM) Use the actual and forecast data presented to you in the homework problem to calculate the February Forecast with Exponential Smoothing as a function of Alpha starting at a = 0.1 and, increasing a by 0.1 units, ending with a= 0.9. Tabulate your results and then present them as a graph with a as the x-axis and the Forecasts as the y-axis. If the Actual for February turns out to be 18, which a value or values would be best to use? Type a short explanation of your decision on your spreadsheet.
Transcribed Image Text:Homework for FORECASTING Problem Solving The Katonah Family Markets, operators of 5 supermarkets in Westchester County, approached lona University's LaPenta School of Business to offer an Internship to an undergraduate business senior with the possibility of it becoming a full-time position. The purpose of the internship is to help the Chain forecast its demand for ALL (HE) Laundry Detergent. ALL (HE) is required for new high technology washing machines that cannot tolerate significant foaming so it is not a mainstream product and the Chain is having difficulty in carrying it on the shelves so it has lost some of its customers to other supermarket chains. ALL (HE) comes in two sizes namely 20 washes and 49 washes (used to be 26 and 56 before Pandemic Shrinkflation!). Below you will find the sales data for this product by size: Actual 20 Washes Forecast Actual 49 Washes Forecast Period August 2021 September 2021 October 2021 November 2021 December 2021 January 2022 February 2022 March 2022 April 2022 May 2022 June 2022 July 2022 August 2022 September 2022 October 2022 12 9 9 8 11 14 8 12 11 14 8 10 13 11 ?? 11 4 1 0 2 3 4 2 2 4 4 3 1 3 3 ?? Exponential Smoothing- (Excel-OM) Use the actual and forecast data presented to you in the homework problem to calculate the February Forecast with Exponential Smoothing as a function of Alpha starting at a = 0.1 and, increasing a by 0.1 units, ending with a= 0.9. Tabulate your results and then present them as a graph with a as the x-axis and the Forecasts as the y-axis. If the Actual for February turns out to be 18, which a value or values would be best to use? Type a short explanation of your decision on your spreadsheet.
Moving Average-- (Excel-OM) Calculate the Moving Averages for n = 3,4,5,6,7,8,9,10,11,12 periods. Tabulate your results and then present them as a graph with n (the number of periods being averaged) as the x-axis vs. the Forecasts as the y-axis. If the actual for February turns out to be 15, which n(s) would be the best to use? Type a short explanation of your decision on your spreadsheet. Weighted Moving Average-- (Excel-OM) Calculate the Weighted Moving Averages for n = 3 and 4 periods for the weights shown below: 1) 4,3,3 2) 4,3,1 3) 4,4,1 4) 4,2,1 5) 4,1,1 6) 4,4,2 7) 4,1,2 8) 4,2,2 9) 4,3,2 10) 3,2,1 Tabulate your results. If the actual for February turns out to be 14, which combination of n and weights would be the best to use? Type a short explanation of your decision on your spreadsheet.
Transcribed Image Text:Moving Average-- (Excel-OM) Calculate the Moving Averages for n = 3,4,5,6,7,8,9,10,11,12 periods. Tabulate your results and then present them as a graph with n (the number of periods being averaged) as the x-axis vs. the Forecasts as the y-axis. If the actual for February turns out to be 15, which n(s) would be the best to use? Type a short explanation of your decision on your spreadsheet. Weighted Moving Average-- (Excel-OM) Calculate the Weighted Moving Averages for n = 3 and 4 periods for the weights shown below: 1) 4,3,3 2) 4,3,1 3) 4,4,1 4) 4,2,1 5) 4,1,1 6) 4,4,2 7) 4,1,2 8) 4,2,2 9) 4,3,2 10) 3,2,1 Tabulate your results. If the actual for February turns out to be 14, which combination of n and weights would be the best to use? Type a short explanation of your decision on your spreadsheet.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman
SEE MORE TEXTBOOKS