個案總覽

Spreadsheet to accompany product 9B21E009.

As a result of recent success and rapid growth, the Skyrose Marketing Agency team was becoming overwhelmed with significant variation in workload levels. The vice-president, who was responsible for managing the company’s clients from the beverage industry, wanted to smooth the team’s workload level to improve morale. She also wanted to remain attentive to her clients’ needs, which could increase as peak holiday seasons approached. The vice-president was considering using Google Trends to predict how popular certain beverage products would be in the future so that her beverage company clients could predict future sales volumes. She hoped that by forecasting proxy sales for three specific clients she could gain key insight to help her smooth the volume levels of her team’s workload, without having a negative impact on her client relationships.

As a result of recent success and rapid growth, the Skyrose Marketing Agency team was becoming overwhelmed with significant variation in workload levels. The vice-president, who was responsible for managing the company's clients from the beverage industry, wanted to smooth the team's workload level to improve morale. She also wanted to remain attentive to her clients' needs, which could increase as peak holiday seasons approached. The vice-president was considering using Google Trends to predict how popular certain beverage products would be in the future so that her beverage company clients could predict future sales volumes. She hoped that by forecasting proxy sales for three specific clients she could gain key insight to help her smooth the volume levels of her team's workload, without having a negative impact on her client relationships.

Student spreadsheet to exercise W21220