Check how menu prices affect your bottom line
Who did it: Craig and Kristen Jordan, Gilford Village Store (NH)
The co-owners use Gemini in Sheets to manage and analyse things like menu prices to understand the impact on their bottom line.
Time saved: not stated in the source.
Steps
- Put menu items, prices and ingredient costs in a sheet.
- Ask Gemini about margins and what-if price changes.
- Decide changes yourself.
The prompt
Example prompt written by FirstAIWin to match the documented task, not the original user's words. Replace the [brackets].
In this sheet, calculate the margin for each menu item and show what happens to total profit if I raise the 5 lowest-margin items by 10%.
Source:Google blog (Vendor blog)