1 · PARAMETERS (edit any field — everything recalculates live)
RM 300k = Rp 1.29 bn
computed from cost breakdown below ↓
⚑ key driver — flow chart implies weekly (≈4)
drawn upfront, held as reserve (not deployed)
repacker build per FM_bulk.pdf — lower to lift ROI
added to investor return: +1% @M6, +2% @M12
Net margin per cycle = of capital deployed. Monthly net = working capital × cycle margin × turns. Edits auto-save in this browser.
1b · Per-Litre Cost Breakdown (auto-calculated from fm_units.xlsx cost ratios; net margin flows from the buy/sell prices in §1)
| Line | % of gross | Rp / litre | Running |
|---|
Percentages are of the gross margin (Rp /L), matching the xlsx. Transport+Insurance+Tax give the FOB; rental+manpower+machine+material take FOB down to NET.
Sell priceRp /L
− Buy / cost priceRp /L
= Gross marginRp /L
− Transport / Insurance / TaxRp /L
= FOBRp /L
− Rental / Manpower / Machine / MaterialRp /L
= NET MARGINRp /L
Net on cost basis
At full MOQ 500,000 L → gross Rp , net Rp per batch.
1c · Reconciliation to FM_bulk.pdf (higher-view tie-out — repacker budget vs capital tiers)
| OPEX — material / batch | Rp |
|---|---|
| Palm oil (20,000 kg × 19,250) | 385,000,000 |
| Botol (50,000 × 1,500) | 75,000,000 |
| Kardus (4,167 × 2,000) | 8,333,333 |
| Label sticker (50,000 × 150) | 7,500,000 |
| Employee (24 org) | 6,250,000 |
| Electricity | 2,500,000 |
| OPEX total | 484,583,333 |
| CAPEX — repacker build | Rp |
|---|---|
| Tanks (stainless + 24 IBC) | 113,000,000 |
| Filter / pipe / installation | 75,000,000 |
| Filling / pump / heater / sealer / mixing | 217,500,000 |
| Perizinan (permits, permanent) | 250,000,000 |
| CAPEX total | 655,500,000 |
| Tie-out | Rp | Note |
|---|---|---|
| PDF grand total (OPEX + CAPEX) | 1,140,083,333 | one full repacker + first batch |
| RM 300k × Rp 4,300 | 1,290,000,000 | smallest capital tier (gross) |
| Less 10% mobilization (xlsx basis) | −129,000,000 | held as reserve |
| Deployable capital | 1,161,000,000 | = xlsx USAGE cell exactly |
| Contingency over budget | +20,916,667 | RM 300k covers the full build |
✓ RM 300k, net of the 10% mobilization (xlsx basis), funds one complete repacker line (CAPEX) plus the first material batch (OPEX), with ~Rp 21M to spare. CAPEX is treated as sunk in the model; larger tiers (RM 600k / 900k / 1.8m) add revolving working capital on top of the same single build.
2 · Scenario Summary (net after investor = trading profit − investor return [interest + COF]; CAPEX held as asset)
3 · Month-by-Month Detail
4 · Notes & Open Parameters
- Inventory turns/month is the single biggest lever. Default is set to a conservative 1×. The flow chart describes a weekly buy→sell→collect cycle (≈4×) and up to 2–3×/week. Tell me the realistic collection cycle and I'll lock it.
- CAPEX defaults to the repacker build-out (tanks, filling/sealing machines, permits) ≈ Rp 655.5 mn per FM_bulk.pdf. It is treated as a sunk asset — it reduces deployable working capital but is not charged again against profit. Set it to 0 for a pure bulk-trade / toll-repack scenario.
- Upfront 10% extraction is modelled as a cash reserve held by the operator (nets out of the deal). If it's instead a fee paid away, the operator profit drops by that amount — confirm where it goes.
- Investor receives principal + base interest + cost-of-funds: 10% at M6 (9% + 1%) or 20% at M12 (18% + 2%). Return is fixed regardless of scenario; all upside/downside accrues to the operator.
- Target net profitability per tier is 10 / 20 / 30 / 40% (RM 300k → 1.8m) — shown as a reference pill on each card. These are directional guides; the curve is naturally concave (fixed CAPEX drags the smallest tier most). Lower CAPEX or raise turns to lift the lower tiers toward target.
- Operating costs (rental, manpower, machine) are modelled per-litre exactly as in fm_units.xlsx. If rental/manpower are actually fixed monthly costs, the small-capital scenarios look worse — flag it and I'll switch to a fixed-cost block.