Bill of materials — one 750ml bottle
| Component | Source | Per bottle | Unit cost |
|---|---|---|---|
| Bulk wine (Cabernet Sauvignon) | Vintrace | 0.75 L | $13.0000 |
| 750ml Antique Green Bottle | Orora · DG-GLS-AG | 1 | $1.1000 |
| Natural Cork 44×24 (reserve) | Vinpac · DG-CAP-CORK | 1 | $0.6200 |
| Front Label | MCC · DG-LBL-FR | 1 | $0.1500 |
| Back Label | MCC · DG-LBL-BK | 1 | $0.1200 |
| Carton Divider (1/12) | Visy · DG-DIV | 1/12 | $0.9000 |
| 12-bottle Carton (1/12) | Visy · DG-CTN-12 | 1/12 | $1.8500 |
| Bottling (per bottle) | Bottling line | 1 | $0.7800 |
| Assembled cost / bottle (COGS) | $12.7500 | ||
| Distributor price / bottle (ex-GST) | $35.00 | ||
| Margin / bottle | $22.25 | ||
Attributesreported in Power BI
VarietyCabernet Sauvignon
ColourRed
RangeReserve
Vintage2023
Container750ml glass
ClosureNatural cork
RRP (inc GST)$65.00
Distributor carton (ex-GST)$420.00
Available2,133In stock
RowsRow 3
Show on the warehouse map →Compositeseach a multiple of the one bottle · 2,133 bottles on hand
| Code | Composite | × bottle | Available | Note |
|---|---|---|---|---|
| PKHIL23-6PK | Six-pack | 6 | 355 | 6 × bottle |
| PKHIL23-CS12 | Carton of 12 (distributor shortcase) | 12 | 177 | 12 × bottle · distributor unit |
| PKHIL23-GLS | By the glass | 0.2 | 10,665 | 0.2 × bottle |
| PKHIL23-TST | Tasting / sample | 1 | 2,133 | written off · not sold |
| PKHIL23-IC | Intercompany | 1 | 2,133 | transfer to a sister entity |