Price & Quantity Benchmark
Dokumentasi spesifikasi teknis dan fungsional Sheet 1: Price & Quantity Benchmark pada Story SAP Analytics Cloud (SAC) Marketing PT Jhonlin Group.
Penting (Important)> **Tautan Story SAC Production:**
> 🔗 [Buka Story Marketing di SAC Production (Tenant 6c653)](https://sacprod-jhonlin.ap11.analytics.cloud.sap/sap/fpa/ui/tenants/6c653/app.html#;mode=view%3Bpreview%3Dtrue;view_id=story2;resource_id=C304905A7FA9DA455ECF4CDAABFED6F;url_api=true)
> *Resource ID:* `C304905A7FA9DA455ECF4CDAABFED6F` | *Tenant:* `6c653` | *Sheet Name:* **Price & Quantity Benchmark**1. Ringkasan & Ruang Lingkup Sheet
Sheet Price & Quantity Benchmark menyajikan analisis komprehensif kinerja penjualan komersial komoditas batubara PT Jhonlin Group. Fokus halaman ini adalah perbandingan volume pengapalan (Sales Quantity in Metric Ton / MT), nilai realisasi faktur penjualan (Invoice Value in USD), harga kontrak rata-rata (Average Contract Price USD/MT), serta perbandingan tren harga bulanan terhadap indeks pasar batubara resmi:
- Harga Patokan Batubara (HPB): Indeks regulasi patokan harga batubara pemerintah RI (ESDM).
- Indonesia Coal Index (ICI): Indeks pasar acuan perdagangan batubara Indonesia (Argus / Coalindo).
Asumsi & Kebijakan Data Marketing:
- Sistem Sumber: Data transaksi penjualan bersumber langsung dari SAP S/4HANA Sales and Distribution (SD) melalui Live Connection.
- Tanggal Dokumen: Menggunakan tanggal Sales Order (
Sales Document Date). - Harga Satuan Perbandingan: Harga satuan penjualan (Sales Price) disaring hanya untuk Goods / FOB Price harga kontrak sebelum penyesuaian (before adjustment).
- Total Invoice Value: Menampilkan nilai pendapatan bersih setelah penyesuaian (after adjustment).
2. Filter Global & Parameter Halaman
| Parameter / Dimensi | Sumber Referensi Data | Tipe Tampilan | Sifat Seleksi | Keterangan |
|---|---|---|---|---|
| Sales Document Date | JG_M_S4HLV_ZCSDXX001 - Document Date |
Page Filter | Range Date (Opsional) | Rentang tanggal dokumen pesanan penjualan (Sales Order) |
| Material Description | JG_M_S4HLV_ZCSDXX001 - Material |
Page Filter | Multi Selection (Opsional) | Spesifikasi produk / komoditas batubara |
| Sales Group | JG_M_S4HLV_ZCSDXX001 - Sales Group |
Page Filter | Multi Selection (Opsional) | Klasifikasi grup penjualan (Ekspor vs Domestik) |
| Port of Loading | JG_M_S4HLV_ZCSDXX001 - Port of Loading |
Page Filter | Multi Selection (Opsional) | Pelabuhan muat pengapalan tongkang/vessel |
| ICI Grade | JG_M_FFIIM_ICI - Grade |
Page Filter | Multi Selection (Opsional) | Filter grade kalori indeks ICI (ICI 1 s/d ICI 5) |
3. Spesifikasi Rinci Widget (13 Komponen)
Berdasarkan Story Builder Specification, Sheet Price & Quantity Benchmark mencakup 13 widget analitik:
3.1 Ringkasan Kartu Metrik (Numeric Point Widgets)
| No | Nama Widget | Tipe Widget | Logika Kalkulasi & Formula Measure | Sumber Data Teknis |
|---|---|---|---|---|
| 1 | Total Sales Quantity (MT) | Numeric Point | Current Year Sales Quantity (menampilkan angka penuh Metric Ton tanpa singkatan) |
Live CDS S/4HANA SD |
| 2 | Total Sales Quantity (MT) Previous Year | Numeric Point | Previous Year Sales Quantity untuk komparasi pertumbuhan volume YoY |
I_Salesdocumentitem - OrderQuantity |
| 3 | Total Invoice Value (USD) | Numeric Point | Current Year Net Value (Nilai realisasi penjualan dalam USD setelah adjustment) |
Live CDS S/4HANA SD |
| 4 | Total Invoice Value (USD) Previous Year | Numeric Point | Previous Year Net Value untuk komparasi pendapatan devisa YoY |
Live CDS S/4HANA SD |
| 5 | Average Contract Price (USD/MT) | Numeric Point | $\text{Contract Price ($)} = \frac{\text{Current Year Net Value}}{\text{Sales Quantity (MT)}}$ | Measures (Calculated) |
| 6 | Average Contract Price (USD/MT) Previous Year | Numeric Point | $\text{Avg Price Prev Year} = \frac{\text{Sum Prev Year Net Value}}{\text{Sum Prev Year Qty}}$ (di-agregasi berdasarkan Billing Document & Calendar Date) | Measures (Calculated) |
3.2 Monthly Sales Quantity & Price vs Benchmark (HPB & ICI)
- Nomor Widget: 7
- Tipe Visualisasi: Combination Stacked Column & Line Chart
- Sumbu Batang (Stacked Column):
Sales Quantity (MT)bulanan. - Sumbu Garis (Lines):
Contract Price ($)bulanan.HPB ($)bulanan: Rata-rata HPB (Operation - AVERAGE incl. 0, NULL) di-agregasi berdasarkanDatedanMaterial.ICI ($)bulanan: Indeks rata-rata ICI sesuai grade batubara yang dipilih.
- Model Sumber Data:
Marketing_HPB_ICI(Import Model) & Live S/4HANA SD.
3.3 Visualisasi Distribusi Penjualan (Bar / Column Charts)
| No | Nama Widget | Tipe Visualisasi | Dimensi Analisis | Opsi Pengukuran (Measure) |
|---|---|---|---|---|
| 8 | Quantity of Sales by Sales Group | Bar/Column Chart | Sales Group |
Opsi tampilan Quantity (MT) atau Persentase (%) |
| 9 | Quantity of Sales by Country | Bar/Column Chart | Port of discharge country (Negara tujuan ekspor) |
Opsi tampilan Quantity (MT) atau Persentase (%) |
| 12 | Quantity of Sales by Port of Loading | Bar/Column Chart | Port of loading (Pelabuhan muat asal) |
Opsi tampilan Quantity (MT) atau Persentase (%) |
| 13 | Quantity of Sales by Domestic Port of Discharge | Bar/Column Chart | Port of discharge (Khusus grup penjualan domestik) |
Opsi tampilan Quantity (MT) atau Persentase (%) |
3.4 Grafik Time Series Indeks Pasar (HPB & ICI)
Widget 10: Harga Patokan Batubara (HPB) in USD
- Tipe: Time Series Chart (Monthly)
- Measure: $\text{HPB ($)} = \text{Average}(\text{HPB}) \quad [\text{Agregasi: Date & Material}]$
- Dimensi:
Date - Model:
Marketing_HPB_ICI_2(Import Model)
Widget 11: Indonesia Coal Index (ICI) in USD
- Tipe: Time Series Chart (Monthly)
- Measure: $\text{ICI ($)} = \text{Average}(\text{Index Price}) \quad [\text{Agregasi: Date & Grade}]$
- Dimensi:
Grade(ICI 1: 6500 GAR, ICI 2: 5800 GAR, ICI 3: 5000 GAR, ICI 4: 4200 GAR, ICI 5: 3400 GAR) - Model:
JG_M_FFIIM_ICI(Import File Model)