Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part I. Verify/confirm with Excel OM your hand-calculation solutions to the homework problems. Part II. Exponential Smoothing Use the actual and forecast data presented to

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Part I. Verify/confirm with Excel OM your hand-calculation solutions to the homework problems. Part II. Exponential Smoothing 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 =0.1 and, increasing by 0.1 units, ending with =0.9. Tabulate your results and then present them as a graph with as the x-axis and the Forecasts as the y-axis. If the Actual for February turns out to be 18 , which value or values would be best to use? Type a short explanation of your decision on your spreadsheet. Part III. Moving Average 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. Part. IV. Weighted Moving Average 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. Forecasting Exponential smoothing \begin{tabular}{|l|l|} \hline Next period & 0 \\ \hline \end{tabular} Forecasts and Error Analysis Forecasting DemandForecast Not enough data to compute the standard error Not enough data to compute the standard error Part I. Verify/confirm with Excel OM your hand-calculation solutions to the homework problems. Part II. Exponential Smoothing 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 =0.1 and, increasing by 0.1 units, ending with =0.9. Tabulate your results and then present them as a graph with as the x-axis and the Forecasts as the y-axis. If the Actual for February turns out to be 18 , which value or values would be best to use? Type a short explanation of your decision on your spreadsheet. Part III. Moving Average 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. Part. IV. Weighted Moving Average 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. Forecasting Exponential smoothing \begin{tabular}{|l|l|} \hline Next period & 0 \\ \hline \end{tabular} Forecasts and Error Analysis Forecasting DemandForecast Not enough data to compute the standard error Not enough data to compute the standard error

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial and managerial accounting

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

1st edition

111800423X, 9781118233443, 1118016114, 9781118004234, 1118233441, 978-1118016114

More Books

Students also viewed these Accounting questions