Purchase Solution

Forecasting Demand Each Season

Not what you're looking for?

Ask Custom Question

1000 tires sold on average each of the past few years.

the past 2 years 200 and 250 respectively in the fall season, 300 and 350 in the winter season, 150 and 165 in the spring season, and 300 and 285 in the summer season.

Projected sales next year are 1200.

What will the demand be each season?

I would like this in an excel file.

Purchase this Solution
Solution Summary

Excel spreadsheet showing calculations to find demand in the future of a tire company.

Purchase this Solution
Free BrainMass Quizzes
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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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

  • Forecast inventory for next year.

    Step 2: For each year, divide the actual demand for each season by the average demand per season, resulting in a seasonal index for each season of the year, indicating the level of demand relative to the average demand.

  • Forecasting Monthly Sales on a Month by Month Basis

    Here we have calculated the average monthly sales for each of the month in years 1-6 (total sales in each month divided by 6 years) and the expected average monthly demand (total annual sales divided by 6 years and further divided by 12 months).

  • forecasting models

    Let's say that an organization manufactures a product whose demand fluctuates in every season. The winter season are the peak demand times for the product whereas summers account for moderate to low sales.

  • Recommending a Forecasting Method Type for a New Company

    It is an effective method of demand forecasting, while the sales are fluctuated according to the market, season or occasion. - Linear programming Leaner programming model is also used by organizations for forecasting.

  • Role of Forecasting

    The demand or customer service can be determined by several factors such as price, availability of close substitutes, market trends, season and advertising strategy.

  • Forecasting & Inventory Model

    o For example: Consumers prefer to have ice-cream in summer season than winter season although it is available all throughout the year. o For example: Consumers purchase Umbrellas in rainy season or summer season than any other season ?

  • Forecasting in Business

    In my company, forecasts for educational toys are made using time series forecasting. 4. The example of a product that my company produces in which time series analysis is not appropriate is the demand for toys during the holiday season.

  • Compare and contrast forecasting methods

    For example, seasonal analysis can be done for previous periods in order to determine which seasons of the year have highest demand for golf clubs, for example, summer season, season when major tournaments take place, etc.

  • Seasonally adjusted forecast model

    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? Please see attached file.

View More Related Solutions