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.
Excel spreadsheet showing calculations to find demand in the future of a tire company.