Modul Operasional Penjualan
Penjualan Harian & Kalkulator Beban
Data penjualan mengikuti format sheet PENJUALAN HARIAN lengkap dengan kalkulasi otomatis.
Total Omset Marketing
Rp 105.485.832
1.220 Pesanan ValidTotal Omset Finance
Rp 88.710.186
Net yang masuk ke FinanceTotal Beban & Biaya
Rp 79.757.257,5
Ads, Admin, Ongkir, Affiliasi, HPPTotal Margin Kotor
Rp 8.952.928,51
ROAS Rata-rata: 2.68xTabel Rekap Penjualan Harian
13 Baris Data| Tgl | Omset Mkg | Omset Fin | Orders | Admin (16%) | Proses | Ads Spend | Ongkir (8.9%) | Aff (9%) | HPP (16.8%) | Total Beban | Margin Kotor | Margin % | ROI | Aksi |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Tgl 1 | Rp 5.180.985 | Rp 4.572.841 | 67 | Rp 731.655 | Rp 83.750 | Rp 1.981.343 | Rp 411.098 | Rp 411.556 | Rp 769.152 | Rp 4.388.554 | Rp 184.287 | 4.2% | 2.58x | |
| Tgl 2 | Rp 9.595.393 | Rp 7.687.731 | 106 | Rp 1.230.037 | Rp 132.500 | Rp 3.193.374 | Rp 691.127 | Rp 691.896 | Rp 1.293.076 | Rp 7.232.010 | Rp 455.721 | 6.3% | 3.07x | |
| Tgl 3 | Rp 7.609.031 | Rp 6.405.684 | 90 | Rp 1.024.909 | Rp 112.500 | Rp 2.576.595 | Rp 575.871 | Rp 576.512 | Rp 1.077.436 | Rp 5.943.823 | Rp 461.861 | 7.8% | 2.98x | |
| Tgl 4 | Rp 8.890.778 | Rp 6.918.698 | 90 | Rp 1.106.992 | Rp 112.500 | Rp 3.431.902 | Rp 621.991 | Rp 622.683 | Rp 1.163.725 | Rp 7.059.792 | Rp -141.094 | -2.0% | 2.63x | |
| Tgl 5 | Rp 10.917.802 | Rp 9.176.851 | 129 | Rp 1.468.296 | Rp 161.250 | Rp 3.598.777 | Rp 824.999 | Rp 825.917 | Rp 1.543.546 | Rp 8.422.785 | Rp 754.066 | 9.0% | 3.14x | |
| Tgl 6 | Rp 10.315.345 | Rp 8.976.139 | 122 | Rp 1.436.182 | Rp 152.500 | Rp 3.133.519 | Rp 806.955 | Rp 807.853 | Rp 1.509.787 | Rp 7.846.795 | Rp 1.129.344 | 14.4% | 3.34x | |
| Tgl 7 | Rp 8.446.601 | Rp 7.446.611 | 106 | Rp 1.191.458 | Rp 132.500 | Rp 2.970.175 | Rp 669.450 | Rp 670.195 | Rp 1.252.520 | Rp 6.886.298 | Rp 560.313 | 8.1% | 3.08x | |
| Tgl 8 | Rp 5.538.870 | Rp 4.660.841 | 70 | Rp 745.735 | Rp 87.500 | Rp 1.889.601 | Rp 419.010 | Rp 419.476 | Rp 783.953 | Rp 4.345.274 | Rp 315.567 | 7.3% | 2.89x | |
| Tgl 9 | Rp 7.540.847 | Rp 5.923.916 | 79 | Rp 947.827 | Rp 98.750 | Rp 2.219.539 | Rp 532.560 | Rp 533.152 | Rp 996.403 | Rp 5.328.231 | Rp 595.685 | 11.2% | 3.38x | |
| Tgl 10 | Rp 10.522.683 | Rp 9.358.192 | 121 | Rp 1.497.311 | Rp 151.250 | Rp 2.857.851 | Rp 841.301 | Rp 842.237 | Rp 1.574.048 | Rp 7.763.998 | Rp 1.594.194 | 20.5% | 3.68x | |
| Tgl 11 | Rp 9.297.652 | Rp 7.600.189 | 98 | Rp 1.216.030 | Rp 122.500 | Rp 2.649.669 | Rp 683.257 | Rp 684.017 | Rp 1.278.352 | Rp 6.633.825 | Rp 966.364 | 14.6% | 3.54x | |
| Tgl 12 | Rp 4.946.694 | Rp 4.214.579 | 60 | Rp 674.333 | Rp 75.000 | Rp 1.146.572 | Rp 378.891 | Rp 379.312 | Rp 708.892 | Rp 3.363.000 | Rp 851.579 | 25.3% | 4.36x | |
| Tgl 13 | Rp 6.683.151 | Rp 5.767.914 | 82 | Rp 922.866 | Rp 102.500 | Rp 1.509.695 | Rp 518.535 | Rp 519.112 | Rp 970.163 | Rp 4.542.872 | Rp 1.225.042 | 27.0% | 4.53x | |
| TOTAL | Rp 105.485.832 | Rp 88.710.186 | 1220 | (Kalkulasi Akumulasi Beban) | Rp 79.757.258 | Rp 8.952.929 | 10.1% | 2.68x | ||||||