This handy tool takes the wholesale price of a wine and works out the final sell price based on the customer’s gross profit (GP) expectations and potential discounts offered.
Variables you can control are:
- Wholesale Price
- Units per Carton
- 3 x Customer GP %
- 2 x Buy deals
Follow this link to the Google Spreadsheet:
Please note: this spreadsheet is completely editable and any changes you make will automatically be saved. So please only edit the white cells otherwise it won’t work for future users. You can save the spreadsheet as an Excel file to edit fully on your own computer (File > Download As > Excel). All formulas can be found on the second sheet.
Note: This guide is designed for the Australian domestic wine market