| A | B | |
|---|---|---|
1 |  | |
2 | Delivery Economics Calculator | |
3 | ||
4 | Version 1.0.1 | April 17, 2020 |
5 | Published by Figure 8 Logistics | https://figure8.delivery/ |
6 |  | |
7 | To Use: | |
8 | To best use this spreadsheet, download or make a copy of the file. If you are having issues, please let us know and we will send you copy any time! hello@oystersunday.com | |
9 | ||
10 | Instructions | |
11 | Delivery | Input for all delivery costs and fees. E.g. a 20% Commission Charge by third-party delivery, a $4.99 Customer Delivery Fee. |
12 | Packaging | Input for all packaging costs - a list of each Packging Item and its Unit Cost. E.g. a Wrapped Cutlery Kit for $0.56. |
13 | Menu | Input for all food costs - a list of each Menu Item, its Retail Price, and its Food Cost. E.g. a Side Salad with an $8 Retail Price and $1.50 Food Cost. |
14 | Calculates COGS and Item Margin based on the selected Item Pakaging for each Menu Item. | |
15 | Orders | Input for building three orders including up to 10 unique Menu Items and 5 unique Packaging Items. |
16 | Calculates the Unit Margin for each order based on Retail Price, COGS, and delivery costs. | |
17 | ||
18 | ||
19 | ||
20 |