Ocean Sense - OTV Executive
Ocean Sense Executive Suite · v2.1
Live
Scenario
Year
v2.1 · -
A · Current Snapshot
This month, live
MTD actuals from Google Sheet · Monthly run-rate scaled
Revenue (MTD)
RM 0
Run-rate: RM 0
Oysters Sold
0
Run-rate: 0
Avg Price/Piece
RM 0
Blended across channels
Operating Margin
0%
M1 / M2 / M3
Cash Runway
-
Based on burn rate
B · Channel Performance
Monitor each sales channel - live
Stall · Pack · Pre-Order · On Land · B2B · Events · B2E · Margins across 3 costing methods

Revenue by channel

Current month · all sales channels

Pieces by channel

Volume distribution

Channel margin table

Pieces · Revenue · Avg price · M1/M2/M3 margins per channel
ChannelPiecesRevenue Avg PriceM1 Margin M2 MarginM3 Margin
C · Live P&L Breakdown
Net Profit walk-down · this month
Revenue minus actual costs, including labor (auto-computed from staff names × RM 70 per shift)

Net Profit calculation

MTD figures from live shift data
Line item Amount (RM) % of Revenue Notes
Revenue (MTD) RM 0 100.0% Stall + non-stall channels
(−) Cost of goods sold RM 0 0% Sold-only, farm-aware (Tawau/Setiu/Melaka)
(−) Logistics RM 0 0% Operator-entered per shift
(−) Consumables RM 0 0% Operator-entered per shift
(−) Labor cost RM 0 0% Auto-counted from Staff column × RM 70/shift
= Net Profit (true) RM 0 0% Revenue − all 4 cost lines
D · Batch Performance
Per-batch profitability
Initial → sold → mortality → remaining → revenue → cost → profit per batch
Active batches
0
Currently being sold
Total batches lifetime
0
Across all farms
Avg profit/batch
RM 0
Distributed batches only
Best batch
-
Highest gross profit

All batches

Live data from Batch Traceability
Batch IDSourceDate InitialSold MortalityRemaining RevenueCost ProfitStatus
E · Operational Health
Daily operations status
Stock levels, mortality tracking, order pipeline

Stock by location

Across farms + stalls
Loading...

Orders pipeline

By stage
Loading...

Mortality MTD

Live vs hibernated
Loading...
F · Cash Position
Monthly cash flow
Based on run-rate revenue and configured overhead

Cash flow breakdown

Change overhead via Settings
Pre-Funding Stage
All projections shown are planned targets pending RM 1,275,000 RCPS funding. Y0 = Setup Year (post-funding infrastructure build-out). Y1 operations begin after setup completes.
Awaiting Funding
A · 8-Year P&L Trajectory
Base case · Y0 setup + Y1-Y8 operations
Revenue, COGS, OPEX, EBITDA trajectory from THE_REAL_TRUTH v2 model
Funding Status
Pre-Funding
Target raise: RM 1.275M RCPS
Capital Raised
RM 0
0% of target
Y0 Setup Burn
RM 1,016K
Planned setup spend
Y1 Operations Begin
After Setup
Projections locked
Y1 Revenue
RM 0
YoY: -
Gross Profit
RM 0
Margin: 0%
EBITDA
RM 0
Margin: 0%
Tax Paid
RM 0
Rate: 0%
Net Income (after tax)
RM 0
Margin: 0%
Growth Capex
RM 0
Cumulative: RM 0
Cash Position (EOY)
RM 0
After all deductions

8-year P&L stack

Revenue (line) · COGS, OPEX, EBITDA (stacked)
B · P&L Detail
Year 1 breakdown
Full income statement for selected year
Line ItemAmount (RM)% of Revenue
C · Compliance Costs
21 compliance line items
Y1 RM 127K scaling to Y8 RM 4.09M · 8-year total RM 14.2M

Compliance cost growth

6 categories over 8 years

Category split (Y1)

Current year view

Compliance line items (Y1)

21 items grouped by category
CategoryItemAmount (RM)% of total
D · Fund Allocation (RCPS Deployment)
How the RM 1.275M RCPS raise is deployed
Per Term Sheet v3 · 5 active setup categories + RM 258,590 held in Working Capital reserve

Allocation breakdown

Active setup spend: RM 1,016,410

RCPS fund summary

Term sheet v3 (Apr 2026)
Total RCPS RaiseRM 1,275,000
Active Setup SpendRM 1,016,410
Working Capital Reserve (FD)RM 258,590
Pre-Money ValuationRM 12.75M
Post-Money ValuationRM 14.03M
Equity on Conversion10%
Annual DividendRM 102,000 (8%)

Fund allocation detail

5 categories per term sheet (excluding Working Capital reserve)
CategoryAmount (RM)% of Active Setup% of Total Raise
E · Capital & Cash Deployment
Where the money goes
Growth capex, working capital reserve, cumulative investment over 8 years

Annual cash deployment

Reserve + capex + dividends per year

Cumulative capex invested

Total capital deployed over 8 years

Year-by-year capital deployment

Working capital, growth capex, tax, dividends
Year Net Income Working Capital Reserve Growth Capex Tax Paid RCPS Dividend Net Cash Flow
F · Infrastructure Growth
Scale trajectory 8 years
Stalls, B2E, B2B, consignment, team, farm workers, states, entities

Growth metrics

Operational infrastructure expansion
G · Investor Returns (RCPS)
RM 1.275M raise · 10% equity
Valuation at 5× EBITDA · Annual RM 102K dividend · Redemption schedule

Company valuation

5× EBITDA multiple

Return multiples

Conversion, dividend, redemption

Investor return table

8-year cumulative returns
YearEBITDAValuation 10% EquityCum Dividends RedemptionConv 5× Multiple
A · Variant Cost Matrix
What one oyster actually costs
6 variants · 10 cost components · From OTV Exact Cost Breakdown

Full cost breakdown per variant

Variable costs only · Fixed overhead added separately in Section C
Cost Component Iredelei StallIredelei Bulk Bel L StallBel L Bulk Bel XL StallBel XL Bulk
B · The Real Margin
Three views of profitability
Variable vs Fully Loaded (blanket) vs Channel-Specific (ABC)
How to read this: Method 1 = marginal cost (should I sell one more?). Method 2 = absorption costing with overhead spread evenly. Method 3 = ABC costing with channel-specific overhead (most realistic). If all 3 are positive, the product is healthy. If only M1 is positive, you have a volume problem.
C · Overhead Breakdown
Where per-piece overhead comes from
Monthly fixed costs broken into 6 buckets
Overhead ComponentMonthly (RM)% of TotalAllocation
D · Break-Even Price Check
Minimum price to avoid loss
Current price vs break-even across 3 methods
VariantCurrent Price M1 Break-evenM2 Break-even M3 Break-evenSafety Margin (M3)
Plan vs Actual - Not Yet Active
Plan vs Actual comparison activates after funding is received and Y1 operations begin. Currently in pre-funding stage; use the Operational tab to track current pre-funding activity.
A · Current Month vs Base Y1 Plan
Are we tracking to plan?
Monthly run-rate compared to Y1 target divided by 12
Revenue Variance
RM 0
Plan: RM 0 · 0%
Volume Variance
0
Plan: 0 · 0%
Avg Price Variance
RM 0
Plan: RM 0 · 0%
Stalls Active
0/6
On track
B · Variance Analysis
Line-by-line deviation from plan
Actual (run-rate) vs Plan (Y1 / 12) for each metric
Metric Actual (run-rate) Plan (monthly) Variance (RM) Variance % Status
C · Trajectory Check
Path to Y1 target
Run-rate extrapolated to end of Y1

Revenue trajectory

Cumulative actual (if maintained) vs plan
Status: Loading...