Financial Forecasts

The following figures are taken from the Shopify analytics panel for Brewquets.

2016 Yearly Figures

Total Orders: 1,553

Average Order Value: $41.73

Net Sales: $62,862

Online Store Sessions: 22,444

Return Customers: 10.26%

Conversion Rate: 5.88%

2017 Yearly Figures

Total Orders: 1,946

Average Order Value: $63.30

Net Sales: $120,233

Online Store Sessions: 34,354

Return Customers: 17.80%

Conversion Rate: 4.85%

2018 Forecast Revenue

Total Orders: 5,000

Average Order Value: $60

Net Sales: $300,000

Return Customers: 10.0%

Conversion Rate: 5.0%

Where sales will come from for 2018:

Existing figures as at 17/07/18:

Total Orders: 1,471

Average Order Value: $63

Net Sales: $96,707

Revenue Gap to target: $203,293

Orders Required: 3226

Orders per day: 19

Sales Targets by Segment:

1. Every Day Gifting (55%) $111,800 / 1,775 orders (16 orders per day excluding August and December)

2. Fathers Day / September (15%) $30,500 / 485 orders (for all of August)

3. Christmas / December (20%): $40,650 / 644 orders (for all of December)

4. Corporates (10%): $20,000 / 40 orders with average spend of $500

2019 Forecast Revenue

Australia $600k

International $300k

2020 Forecast Revenue

Australia $1.2M

International $600k

2021 Forecast Revenue

Australia $2.4M

International $1.2M

JULY 2018 SALE FIGURES / PROFIT CALCULATIONS / SUPPLIER COSTS

Total Sales 10,000 inc GST

Costs:

Best Buds $413 (59 orders @ $7 each)

Australia Post $1,000 (approx 100 orders -- some orders were test orders in July--, total charged to customers was $1,375, i.e. $12.73 per order)

Sherpa $935 (so average $15.84 per order was paid, total charged to customers was $895 i.e. $15.17)

[actual freight charge to customers is $2,270 so about 10% more than actual costs]

So $10,000

less freight ($1,935) = $8,065

less GST = $7,331

x 65% GP = $4,765

Less Best Buds 3PL ($413) = $4,352 Gross Profit (then take out staff wages, website, marketing and other operating costs)