Teaching note for product #W33716

Student Spreadsheet to accompany product W33716.

In March 2023, two strawberry producers in Ontario, Canada had to decide how many acres to plant with each of four strawberry varieties at Xanadu Farms. They had committed to providing 275,000 pounds of berries to a local independent grocery chain and also required some of their berry crop to make strawberry preserves. Complicating this decision was the impact that weather had on the yield of each type of berry. If the weather reduced the yield, the .....more

Instructor Spreadsheet to accompany product W33717.

London Hydro, Inc. (London Hydro) must forecast the electricity demand of the firm’s clients. The Ontario Energy Board had just announced the results of a pilot program to introduce a new pricing scheme to residential energy consumers in Ontario. This was the origin of tiered pricing, which was based on overall monthly energy usage. In the past, consumers had all been on a time-of-use plan where energy was more expensive during peak hours and cheaper .....more

Teaching note for product W28526.

Student spreadsheet for Ivey product W28526.

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 .....more

Spreadsheet to accompany product 9B21E009.

Teaching note for product 9B21E009.