Explore BrainMass

Forecasting Demand Each Season

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

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.

© BrainMass Inc. brainmass.com September 20, 2018, 5:37 am ad1c9bdddf - https://brainmass.com/statistics/multivariate-time-series-and-survival-analysis/forecasting-demand-each-season-98707

Solution Summary

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