Purchase Solution

Seasonally adjusted forecast model

Not what you're looking for?

Ask Custom Question

Metro Food Vending operates vending machines in office buildings, the airport, bus stations, colleges, and other businesses and agencies around town and operates vending trucks for building and construction sites. The company believes its sandwich sales follow a seasonal pattern. It has accumulated the following data for sandwich sales per season during the past four years.

Season 2000 2001 2002 2003

Fall 42.7 44.3 45.7 40.6

Winter 36.9 42.7 34.8 41.5

Spring 51.3 55.6 49.3 47.3

Summer 62.9 64.8 71.2 74.5

Develop a seasonally adjusted forecast model for these sandwich sales data. Forecast demand for each season for 2004 using a linear trend line estimate for sales in 2004. Do the data appear to have a seasonal pattern?

Purchase this Solution
Solution Summary

The solution develops a seasonally adjusted forecast model for the scenario explained in the question.

Solution Preview

Please see attached file.

For your understanding, I have also ...

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

View More Free Quizzes
Related BrainMass Solutions

  • Seasonally Adjusted Forecast

    313623 Seasonally Adjusted Forecast From the given data develop a seasonally adjusted forecast for 2006. (Use a linear trend line model to develop a forecast estimate for 2006.)

  • Quantitative modeling

    Which forecast model do you perceive to be accurate: the exponential smoothing model from Problem 11or the seasonally adjusted forecast?

  • INTRODUCTION TO mANAGEMENT

    b) Develop a seasonally adjusted forecast for the demand data for fertilizer.

  • Moving Averages for the Time Series

    The regression equation to predict the long term trend in the seasonally adjusted revenues. Seasonally adjusted revenues = 705.97 + 11.67*Q. f. Compute the seasonally adjusted forecast for the fourth quarter of 2001. g.

  • Time series analysis of ice cream production

    Develop: a) an exponential smoothing model (= 0.50) b) moving average model (k = 4) c) a trend model; and d) a seasonally adjusted model to forecast demand.

  • Forecast

    This solution is comprised of detailed analysis and step-by-step calculations of various Forecast Techniques like Seasonally Adjusted Foecast in EXCEL.

  • Seasonally Adjusted Forecast

    375386 Seasonally Adjusted Forecast Small Wonder, an amusement park, experiences seasoned attendance. It has collected two years of quarterly attendance data and made a forecast of annual attendance for the upcoming year.

  • Step-by-step answer to Time Series Analysis

    Assuming that a multiplicative model can be used to describe the building permit data, generate a forecast for the number of building permits that you expect will be granted in July of 2004 .

  • Regression and Linear Trend Equations

    Use a trend equation to forecast future time periods and to develop seasonally adjusted forecasts. 5.

View More Related Solutions