Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer in Excel and show formulas. A. The annual demand for lime bags at McCall's Garden Supply for the past 11 months is provided

Please answer in Excel and show formulas.

A. The annual demand for lime bags at McCall's Garden Supply for the past 11 months is provided in the image below.

  1. Use 2-month, 3-month, and 4-month moving averages to forecast demand in month 12.
  2. Forecast demand with a 3-month weighted moving average in which demand in the most recent month is given a weight of 3 and demands in the other two months are each given a weight of 1.
  3. Forecast demand for month 12 by using exponential smoothing with a smoothing constant of 0.7. Assume that the forecast for month 1 is 6,000 bags to begin the procedure.
  4. Which of the methods analyzed here would you use for month 12 and beyond? Answer by making forecasts for months 5-11 using each of the above methods and then calculating the mean absolute deviation (MAD).

B. Daily sales volume for Nilgiris Convenience Store is provided in the image below.

  1. Starting Day 11, the store wants to use exponential smoothing to forecast the next day's sales volume. But what value of should it use? It is considering three values: 0.2, 0.5, and 0.9. Select the appropriate value of by calculating forecasts for days 2 through 10 with each of these values and calculating the Mean Absolute Percent Error (MAPE). Assume in each case that the forecast for Day 1 was $300.
  2. The store sees an increasing trend in the data and decides to use a linear trend for forecasting. What is the trend equation for this data?
  3. Using the trend equation calculate forecasts for days 2 through 10.Calculate the MAPE of this set of forecasts.
  4. Compare the MAPE of the best in (a) with the MAPE in (c).Which method would you prefer?

C. A retail store sells space heaters. Sales data for four years is provided in the image below.

  1. Plot the time series.Describe the time series in a few sentences.
  2. Calculate the seasonal index for each quarter. What are the implications of these indexes?
  3. Calculate the trend equation for this data. Explain what the slope and intercept mean in this context.
  4. Using the multiplicative decomposition method calculate forecasts for each quarter of Year 5.

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

Step: 3

blur-text-image

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

Principles of Responsible Management Global Sustainability Responsibility and Ethics

Authors: Oliver Laasch

1st Edition

9781285981321, 1285080262, 1285981324, 978-1285080260

More Books

Students also viewed these General Management questions