Purchase Solution

Calculate a forecast

Not what you're looking for?

Ask Custom Question

The ABC Floral Shop sold the following number of geraniums 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

Calculate a forecast of the above demand using a 3- and 5-period moving average (ABC Floral Shop)

Solution Preview

The MA and graphs are in the **attached excel file**. We will discuss the 3rd question here.

Which of the above forecast is better? Well, it depends on what kind of information we are trying to get out of them.

Notice that the second one (5 day) is much more smooth than the first one, and this is ...

Purchase this Solution
Free BrainMass Quizzes
Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Lean your Process

This quiz will help you understand the basic concepts of Lean.

View More Free Quizzes
Related BrainMass Solutions

  • MAD, slope, intercept, regression equation, forecast

    Using data in chart 6-11 calculate a 3-month moving average forecast for month 12.

  • Compariosn of forecasting methods

    Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. (see chart in attached file) a. Calculate the simple three-month moving average for periods 10-12. b.

  • Forecast

    81490 Forecast (See attached file for full problem description) --- Consider the following forecasts: a.

  • Chapter 13 -Problem 17 Operations Management for Competitive

    Using a simple four-month moving average, calculate a forecast for October. b. Using single exponential smoothing with α = 0.2 and a September forecast = 65, calculate a forecast for October. c.

  • Operational management: Calculate Sales Forecasts

    197613 Operational management: Calculate Sales Forecasts 3 The following tabulations are actual sales of units for six months and a starting forecast in January. a.

  • Forecasting the demand by moving average method

    500000 Calculate a forecast of the demand using a 3 and 5 period moving average. You sold the following number of flowers during the last two weeks. Calculate a forecast of the demand using a 3 and 5 period moving average.

  • Forecasting: weighted moving average

    Using simple linear regression analysis, calculate the regression equation for the preceding demand data. e. Using the regression equation in d, calculate the forecast for July. Thanks Hello Please see the excel file attached.

  • Three-Year Moving Average

    The smaller the MAD, the more reliable the forecast. We conclude that the 3-yr weighted moving average is a better forecast. This solution shows how to calculate a 3-year moving average and a 3-year weighted moving average.

  • The equation for MAD

    What must alpha equal (rounded to 4 decimals) if a simple exponential smoothing forecast method is being used? A. 0.0042 B. 0.9667 C. 0.0400 D. 0.0967 E.

  • Calculate a Shop's Forecast of Demand Using a 3- and 5-Period Moving Average

    370962 Calculate a Shop's Forecast of Demand Using a 3- and 5-Period Moving Average Please help with the following problems.

View More Related Solutions