Purchase Solution

Forecasting

Not what you're looking for?

Ask Custom Question

Developing a Spreadsheet to Calculate a Forecast for Floral Shop

Details: 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?

Attachments
Purchase this Solution
Solution Summary

The solution contains spreadsheet showing forecast of the demand using a 3- and 5-period moving average and graph.

Purchase this Solution
Free BrainMass Quizzes
Basics of corporate finance

These questions will test you on your knowledge of finance.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

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.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

View More Free Quizzes
Related BrainMass Solutions

  • Planning tools for forecasting

    Forecasting Planning Tools 1. Quantitative Forecasting - This type of forecasting is a common method used in organizations. Quantitative predictions are generated by using past or historical data to forecast the future.

  • Appropriate Forecasting Technique for Aldi Foods

    (forecasting, n.d).

  • Developing a Financial Forecast for the Division

    Forecasting is an essential part of budgeting. Forecasting can be made by a firm for purpose other than budgeting whereas Budgeting makes by firm for purpose of forecasting (Kinney & Raiborn, 2008).

  • discussion on methodology of forecasting

    389756 Discussion on Methodology of Forecasting Provide an introduction and background discussion on methodology of forecasting. Give an example on forecasting. Forecasting is the practice of estimating future events.

  • Forecasting tools

    223236 Forecasting tools What criteria should an organization use in deciding what type of forecasting tools they should use? Criteria Used to Select Forecasting Tools Forecasting Tool is used to estimate the unknown events and situations.

  • Understanding Forecasting models as they apply to products

    houses can be forecasted by using linear regression model of forecasting-a quantitative method of demand forecasting.

  • Types of demand forecasting

    This discusses the types of demand forecasting

  • Forecasting Methods used by Modern Corporations

    One of the newer forecasting techniques is called "scenario forecasting" (Dictionary of American History, 2003).

  • RevPAR and Forecasting

    409845 RevPAR and Forecasting Why is forecasting so important? How are RevPAR used for forecasting? Why is forecasting so important? How are RevPAR used for forecasting? Forecasting is important because it is less time consuming.

  • The Challenges of Forecasting

    Consequences of under/over forecasting: • Under forecasting can result to opportunity cost of not being able to sell the product because no inventory exists • Under forecasting will result to lost commission for potential sales • Over forecasting

View More Related Solutions