Ivey Publishing
Food Truck Forecaster
Product Number:
Publication Date:
Revised Date:
4 pages (3 pages of text)
Product Type:
Case (Gen Exp)
In 2014, the owner of a food truck based in Hamilton, Ontario, was looking over the first year of her operations. In addition to working in Hamilton, she had tried to maximize her revenues by driving to several other cities and charging various prices for each burger, depending partly on the fresh ingredients available in each city. Besides location, the owner had collected data on a few other factors—the weather, the day of the week, the city’s population, and whether a festival was going on—that had had an impact on the demand for her product. She wondered whether analytics could help her decide where to sell and how much to charge on a daily basis. The owner also wondered whether this decision-making and data-collection process could be automated since she would be using it every day.
Learning Objective:
  • To use a mix of analytics techniques such as regression and simulation to build a spreadsheet model that can help the decision-maker
  • To use Visual Basic for Applications (VBA) concepts to make the spreadsheet user-friendly and automate some of the tasks in the model
    Management Science
    Accommodation & Food Services
    Canada, Small, 2014
    Intended Audience:
    $4.25 CAD / $4.25 USD Printed Copy
    $3.75 CAD / $3.75 USD Permissions
    $3.75 CAD / $3.75 USD Digital Download
    Associated Materials
    Supplements: 7B16E033 (76 KB)
    Translations: Simplified Chinese (4 pages)
    You Might Also Like...

    Save In: