Here is a comprehensive walkthrough guide for the Excel on Rocky Top case “It’s Harvest Time” provided by one of our faculty fellows, Diarmuid Early. The case is available in your ExPrep account in folder Excel on Rocky Top. Try it yourself, and if you get stuck, look for the solution in the videos.

TASK
AgroWizards Inc. is a fictional company in a fictional universe. They operate a magic field that is able to produce fruits and vegetables – tomatoes, grapes, apples, etc. (we will call them “units” throughout the case). The field size is 100×100 cells in Excel. The map of the field is provided in the financial model. Your goal is to make calculations based on the location of the units on the field and to answer the questions for the case.
WALKTHROUGH VIDEO PROVIDED BY DIARMUID EARLY
This video was recorded when Diarmuid completed this case as part of the Financial Modeling World Cup stage.
So take into account his comment: This has the usual caveats of my live attempts:
(i) I’m rushing, so not always explaining myself very clearly (it will be easier to understand if you try the questions first), and
(ii) I sometimes (OK, often) make mistakes or don’t follow the optimal path. That said, this is the fastest I’ve ever finished a FMWC round by a wide margin, so I obviously didn’t waste too much time!
© 2022-2026 Microsoft Excel Collegiate Challenge. All rights reserved.