Bill of materials — one 750ml bottle
| Component | Source | Per bottle | Unit cost |
|---|---|---|---|
| Bulk wine (Cabernet Sauvignon) | Vintrace | 0.75 L | $6.0000 |
| 750ml Antique Green Bottle | Orora · DG-GLS-AG | 1 | $1.1000 |
| Stelvin Screwcap 30×60 | Vinpac · DG-CAP-SCR | 1 | $0.3400 |
| 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) | $7.2200 | ||
| Distributor price / bottle (ex-GST) | $11.67 | ||
| Margin / bottle | $4.45 | ||
Attributesreported in Power BI
VarietyCabernet Sauvignon
ColourRed
RangeEstate
Vintage2023
Container750ml glass
ClosureScrewcap
RRP (inc GST)$26.00
Distributor carton (ex-GST)$140.00
Available10,367In stock
RowsRow 20, Row 21, Row 22
Show on the warehouse map →Compositeseach a multiple of the one bottle · 10,367 bottles on hand
| Code | Composite | × bottle | Available | Note |
|---|---|---|---|---|
| PKDOG23-6PK | Six-pack | 6 | 1,727 | 6 × bottle |
| PKDOG23-CS12 | Carton of 12 (distributor shortcase) | 12 | 863 | 12 × bottle · distributor unit |
| PKDOG23-GLS | By the glass | 0.2 | 51,835 | 0.2 × bottle |
| PKDOG23-TST | Tasting / sample | 1 | 10,367 | written off · not sold |
| PKDOG23-IC | Intercompany | 1 | 10,367 | transfer to a sister entity |