|THE PANDEMIC PIVOT|
A 30-minute totally free tool for reimagining your business in corona-time.
To use this tool, go to File > Make a copy, and edit that copy.
|Give feedback on the tool by clicking here.|
|What this is||Right now, some kind of physical distancing is likely to be imposed on F&B businesses for at least another 8 months to 2 years. This will seriously affect all restaurants/bars that depend on customers dining in.|
This spreadsheet is designed to help you
1) See how your current business model might deal with reduction in business due to physical distancing required during and after intense lockdowns.
2) See how offering a mix of different new products that work with physical distancing might affect your business's profit/loss numbers
|Caution!||This spreadsheet cannot exactly describe your business nor does it include any of your tax liabilities—but it can help you think about what you can do next. |
Use your judgment before taking any actions.
|How to use||0) Before starting, you take a look at the example sheets.|
|1) Make a copy of this spreadsheet by clicking File > Make a copy. Edit that copy.|
|2) IMPORTANT: Don't change or delete anything in white cells. Doing this may affect formulas and calculations.|
|3) DO put in or update numbers in orange cells. These cells are used in formulas and calculations.|
|4) DO use green cells for new line items that make sense for your business. You can delete or change contents of green cells.|
|5) Start with Sheet 1—this shows how your current business will respond to reductions due to physical distancing/lower demand even after reopening|
|6) Continue to Sheet 2—this shows how new product offerings might affect your business economics.|
|How much it costs||Nothing. This tool is free to use. You don't need to pay anyone, let alone a consultant, to use it. If you find it useful, share it as widely as possible. |
Feel free to email me (see below) if you really want to pay someone to bounce ideas off and talk you through reimagining your business model.
|Please share it||If you share it on social media, it would be nice if you use the #PandemicPivot hashtag.|
|How to share it||Please share this spreadsheet (not modified copies) with others, preserving the license information below.|
|Feedback||Click here to give feedback on the tool.|
|License information||This resource by Vaughn Tan is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License or any later version.|
|Full license terms||Creative Commons BY-NC-ND License|
|Version information||Version number||Date||Change from previous version|
|1.1||1/5/2020||Adding variable cost lines for PPE and % of revenue costs (example sheets not updated)|
|Disclaimer||The information provided here (including all links and downloads) is for general informational purposes only and is provided to you in good faith. I can make no representation or warranty of any kind, express or implied, regarding its accuracy or completeness and do not accept any liability to you for any loss or damage of any kind incurred as a result of reliance on it.|