Ivey Publishing
Food Truck Forecaster
Product Number:
9B16E033
Publication Date:
11/14/2016
Revised Date:
10/09/2018
Length:
4 pages (3 pages of text)
Product Type:
Case (Gen Exp)
Source:
Ivey
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
    Issues:
    Disciplines:
    Management Science
    Industries:
    Accommodation & Food Services
    Setting:
    Canada, Small, 2014
    Intended Audience:
    Undergraduate/MBA
    Price:
    $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: