She implemented the system. The following summer, she ordered 80 gallons of chocolate fudge instead of 40, and she didn't run out once. In winter, she launched a small hot cocoa and cookie menu (index 0.34 meant low volume, so she kept it simple). She stopped wasting money on full staff in January.
"Finally," Leo said, "multiply that 'average season' by each Seasonal Index."
| Year | Season | Sales (USD) | | :--- | :--- | :--- | | Year 1 | Summer | $60,000 | | Year 1 | Fall | $20,000 | | Year 1 | Winter | $10,000 | | Year 1 | Spring | $30,000 | | Year 2 | Summer | $70,000 | | Year 2 | Fall | $25,000 | | Year 2 | Winter | $12,000 | | Year 2 | Spring | $35,000 |
"Now," Leo said, "calculate the across all your years."
"I know," Elena sighed. "But the seasons aren't the same every year. Last June was cold, but the June before that was a heatwave. How can I predict anything?"
One rainy Tuesday in March, her cousin Leo, a data analyst visiting from the city, saw her frantically scribbling inventory notes on a napkin.
Leo grabbed a clean napkin and a pen. "You need to calculate seasonal variation. It’s how you separate the 'normal rhythm' of your business from the 'random noise' of life. It takes four steps. Let's use your sales data."
"Exactly. That's the 'flat line'—what you'd sell per season if there were no seasons at all." "Now for the magic," Leo said. "For each season, divide its average by the overall average. That gives you the Seasonal Index ."
How To Calculate Seasonal Variation -
She implemented the system. The following summer, she ordered 80 gallons of chocolate fudge instead of 40, and she didn't run out once. In winter, she launched a small hot cocoa and cookie menu (index 0.34 meant low volume, so she kept it simple). She stopped wasting money on full staff in January.
"Finally," Leo said, "multiply that 'average season' by each Seasonal Index."
| Year | Season | Sales (USD) | | :--- | :--- | :--- | | Year 1 | Summer | $60,000 | | Year 1 | Fall | $20,000 | | Year 1 | Winter | $10,000 | | Year 1 | Spring | $30,000 | | Year 2 | Summer | $70,000 | | Year 2 | Fall | $25,000 | | Year 2 | Winter | $12,000 | | Year 2 | Spring | $35,000 | how to calculate seasonal variation
"Now," Leo said, "calculate the across all your years."
"I know," Elena sighed. "But the seasons aren't the same every year. Last June was cold, but the June before that was a heatwave. How can I predict anything?" She implemented the system
One rainy Tuesday in March, her cousin Leo, a data analyst visiting from the city, saw her frantically scribbling inventory notes on a napkin.
Leo grabbed a clean napkin and a pen. "You need to calculate seasonal variation. It’s how you separate the 'normal rhythm' of your business from the 'random noise' of life. It takes four steps. Let's use your sales data." She stopped wasting money on full staff in January
"Exactly. That's the 'flat line'—what you'd sell per season if there were no seasons at all." "Now for the magic," Leo said. "For each season, divide its average by the overall average. That gives you the Seasonal Index ."