Purchase Solution

Moving Average Forecasting and Graphing Using Spreadsheet

Not what you're looking for?

Ask Custom Question

The ABC Floral Shop sold the following number of geraniums during the last 2 weeks:

See the following chart The number of geraniums the ABC Floral Shop sold during the last 2 weeks:
Day Demand Day Demand
1 200 8 150
2 134 9 182
3 157 10 197
4 165 11 136
5 177 12 163
6 125 13 157
7 146 14 169

Develop a spreadsheet to answer the following questions.

- Calculate a forecast of the above demand using a 3- and 5-period moving average.
- Graph these forecasts and the original data using Excel. What does the graph show?
- Which of the above forecasts is best? Why?

Purchase this Solution
Solution Summary

The solution shows how to graph and forecast data using the moving average method. The solution is found in the attached spreadsheet file.

Solution Preview

The attached files show the step-by-step forecast solution using a three (3) and five (5) - period moving average. The ...

Purchase this Solution
Free BrainMass Quizzes
Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Motivation

This tests some key elements of major motivation theories.

View More Free Quizzes
Related BrainMass Solutions

  • Forecasting sales with a moving average process

    259038 Sales Forecasting AC556 Week 2 Problem Sales Forecasting NOTE: It is expected that this problem will be completed using an Excel spreadsheet using formulas. Please see the Excel Tutorial that is available under the course home tab.

  • Forecast Analysis

    Develop spreadsheet models for forecasting prices using single moving average and single exponential smoothing. b.

  • Five-period and Ten-period Moving Average Forecasts

    The solution computes for a five-period and ten-year moving average and a ten-year forecasts. The mean absolute deviation was computed to identify the best forecasting method. The detailed computation was done in the attached spreadsheet file.

  • Demand Forecasting and Forecasting Error

    The graphs are being created with fictitious data to show forecasting trends, moving average, weighted moving average, exponential moving average, and trend line with regression equation.

  • Analysis on 4 forecasting models using Excel

    • 34.83 - 35.17 • 33.70 - 36.30 • 33.65 - 36.35 • 32.18 - 37.82 Please see answers in the attached spreadsheet The solution gives detailed steps on comparing 4 forecasting models: MA, weighted MA, exponential and regression.

  • Forecasting problem: comparing methods

    211800 Compute a moving average and a weighted moving average and compare results. The manager of carpet city outlet needs to make an accurate forecast of demand for soft shag carpet (its biggest seller).

  • Recommending a Forecasting Method Type for a New Company

    On the basis of time series, company forecasts the demand of product through using simple moving average or weighted moving average methods on arithmetical average of a given number of past data.

  • Stocks

    Develop a spreadsheet module for forecasting each of the stock prices using simple moving average and simple exponential smoothing. B.

  • Forecasting Demands for March and January

    168575 Forecasting Demands for March and January 7. See attached spreadsheet...From this information presented, do the forecasters think that the March demand is more indicative of future demand that the January demand? A.yes B.no 8.

View More Related Solutions