Internal Tools · Case Study

RAI Operations Console

Rovic Agriventures Inc. — commercial egg-layer farm

A single back-office application that replaced a stack of disconnected spreadsheets. It ties daily production, sales & collection, cash flow, receivables, expenses and customers into one source of truth — built around how the family actually runs the farm, not around accounting theory. Every screen below is the real interface, populated with representative figures.

RoleProduct design & build
SurfaceWeb app · 7 modules
UsersOwner + 2 encoders
StackGoogle Sheets backend
🔒

Sample data — nothing real. Every figure, customer name, invoice and balance on these screens is invented purely to demonstrate the interface. No actual Rovic Agriventures Inc. records, client information or financial data appears here, and none has been exposed or shared.

script.google.com/rai-console · Dashboard
Sample data
ROVIC AGRIVENTURES INC./Dashboard
PRODTue, 30 Jun 2026
Sample data — illustrative figures onlyYear to date · 2026
Revenue
₱39,120,000
Period-based
Cash Holdings
₱19,720,000
Current · GXI + RCBC + Cash
Accounts Receivable
₱284,300
Current · Unpaid from sales
Inventory Value
₱549,100
Current · Live × avg price
Avg Good / Day
1,501 tr
Period · production days
Avg Good Price
₱208
Period · ₱ per tray

Year-End Forecast

Projected 468,000 good trays · ₱97.3M revenue at current pace
Actuals Jan–May · dashed projection Jun–Dec at 5% assumed growth

Production · Good

2026 vs 2025 · trays/mo

Production · Crack

2026 vs 2025 · trays/mo

Expenses · By Category

YTD · ₱61.9M total
script.google.com/rai-console · Production
Sample data
ROVIC AGRIVENTURES INC./Production
PRODTue, 30 Jun 2026
Building 1 · 50,000 hens · lay rate 90.4%
⛅
31°C · Cabuyao
Partly cloudy · humidity 78%

Production Building 1 Unlocked

Building 1 — Layer House A
Accounts
1
☀
2
☀
3
⛅
4
🌧
5
🌧
6
⛅
7
☀
8
☀
9
⛅
10
☀
11
☀
12
⛅
13
🌧
14
⛅
Head Counthd50,00050,00049,99649,99249,98849,98449,98049,97749,97349,96949,96649,96249,95849,955
Good1,501 tr/d1,5221,5351,5031,4581,4391,4841,5271,5401,5081,5221,5331,4921,4471,506
Crack65.9 tr/d5462708391675448625954708662
Mortality5.1 ck/d5051680351103583
Adjustmentsck————−4—————————
Crack %%3.23%3.64%4.15%5.19%5.71%4.21%3.21%2.74%3.69%3.67%3.20%4.19%5.24%3.72%
Production Rate%92.9%93.8%92.1%89.1%87.8%91.0%93.6%94.5%92.7%93.2%94.1%91.5%88.4%92.0%
Production TrendΔ—+0.90%−1.70%−3.00%−1.30%+3.20%+2.60%+0.90%−1.80%+0.50%+0.90%−2.60%−3.10%+3.60%

Notes June 2026

auto-saves
script.google.com/rai-console · Sales
Sample data
ROVIC AGRIVENTURES INC./Sales & Collection
PRODTue, 30 Jun 2026

System Inventory · 2026-06

GOOD
Beginning Inventory2,560
+ Prod MTD39,600
− Sold MTD39,520
= Ending Inventory2,640
CRACK (info only — sold on farm)
Crack Prod MTD1,670

Live Inventory · last update 09 Jun

Good Live
Good→Crack Adj.
Good Variance+50
auto-saves

Financials · 2026-06

Total Revenue₱8,150,000
− Expenses₱6,874,000
= Net₱1,276,000
Total Receivables (AR)₱284,300
Total Collected₱7,800,000
Crack Adjustments₱136,000

Sales & Collection · 7

DateTxn #InvoiceCustomerCatQtyPriceTotal (₱)PaidBalancePaid ToNotes⋯
08 Jun1042INV-2291Other CustomersGood36₱240₱8,640₱8,640₱0FarmWalk-in retail, mixed✎
09 Jun1043INV-2292Aling Nena Sari-SariGood60₱242₱14,520₱14,520₱0JCLPaid GCash✎
10 Jun1044INV-2293Golden Yolk BakeryGood150₱238₱35,700₱20,000₱15,700JCLBalance due 21 Jun✎
11 Jun1045INV-2294Mang Tonio EateryGood45₱245₱11,025₱11,025₱0JCL✎
12 Jun1046INV-2295RML Poultry SupplyCrack90₱150₱13,500₱13,500₱0FarmCrack sold on farm✎
13 Jun1047INV-2296Sps. Villanueva StoreGood120₱240₱28,800₱10,000₱18,800JCLRegular · weekly terms✎
14 Jun1048INV-2297Reyes CarinderiaGood30₱245₱7,350₱7,350₱0JCL✎
＋ Add sale — type here…✓
Period totals:₱119,535₱85,035₱34,500
script.google.com/rai-console · Cash Flow
Sample data
ROVIC AGRIVENTURES INC./Cash Flow
PRODTue, 30 Jun 2026

Cash Flow Records · 8

DateTxn #NameAmount (₱)Cash
Position		Pyt #Notes⋯
09 Jun1043Aling Nena Sari-Sari₱14,520GXIP-311Collection · GCash✎
09 Jun–Purina Feeds — Lot 2291−₱1,450,000RCBC–~820 bags layer mash✎
10 Jun1044Golden Yolk Bakery₱20,000RCBCP-312Partial vs INV-2293✎
11 Jun–Payroll — 14 farmhands−₱215,000Cash–Jun 5–11 cycle✎
11 Jun1045Mang Tonio Eatery₱11,025CashP-313Cash on delivery✎
12 Jun–Meralco — Jun bill−₱96,000GXI–Auto-debit✎
13 Jun1047Sps. Villanueva Store₱10,000GXIP-314Partial vs INV-2296✎
14 Jun–Diesel — delivery truck−₱58,000Cash–Full tank✎
＋ Add entry — type here…✓
Period Net:−₱1,763,455

Cash Positions · as of 2026-06-11

RCBC
₱11,850,000
GXI
₱3,420,000
Cash
₱4,450,000
AR
₱284,300

Weekly Forecast · 2026-06

Assumptions
Week 415–21 Jun7 days
+ Egg sales₱2,184,000
+ AR collections₱260,000
− Feeds₱1,360,000
− Payroll & ops₱360,000
Net movement+₱724,000
Projected close₱4,180,000
script.google.com/rai-console · Accounts Receivable
Sample data
ROVIC AGRIVENTURES INC./Accounts Receivable
PRODTue, 30 Jun 2026
TOTAL OUTSTANDING
₱284,300
6 customers with AR
Sample data — names & amounts invented

Accounts Receivable · 6

▾
Golden Yolk BakeryOverdue · 7d
4 sales · 2 payments 6+: ₱15,700
₱15,700
outstanding
⚠ Aged sales (6+ days) — 1 unpaid
08 Jun#1044Good · 150tr₱15,7007d
DateRefDescriptionChargePaid / PaymentBalanceAge
10 JunPMTPayment received (RCBC)–₱20,000––
08 Jun1044Sale · Good · 150tr₱35,700₱20,000₱15,7007d
▸
Sps. Villanueva StoreOutstanding
7 sales · 5 payments 0-2: ₱18,800
₱18,800
outstanding
▸
Dizon Poultry TradingAging
3 sales · 1 payment 3-5: ₱62,400
₱62,400
outstanding
▸
Sunrise Groceries — Sta. RosaOverdue · 9d
5 sales · 3 payments 3-5: ₱35,3006+: ₱50,100
₱85,400
outstanding
▸
Aling Rosa CarinderiaOutstanding
2 sales · 1 payment 0-2: ₱9,600
₱9,600
outstanding
▸
JCL TradingOutstanding
9 sales · 8 payments 0-2: ₱92,400
₱92,400
outstanding
script.google.com/rai-console · Expenses
Sample data
ROVIC AGRIVENTURES INC./Expenses
PRODTue, 30 Jun 2026

Expenses · 8

DateExpense TitleCategoryAmount (₱)Cash
Position		Notes⋯
01 JunLayer mash — 3,300 bagsFeeds₱5,850,000RCBCPurina, monthly stock✎
02 JunVitamins & electrolytesVet & Meds₱42,000CashHeat-stress prep✎
03 JunPayroll — farmhands (cycle 1)Labor₱215,000Cash14 staff × 6 days✎
05 JunMeralco — electricityUtilities₱96,000GXIJun billing✎
07 JunEgg trays — 60,000 pcsPackaging₱210,000CashPulp trays✎
09 JunDiesel — delivery truckLogistics₱58,000Cash2 fill-ups✎
11 JunPayroll — farmhands (cycle 2)Labor₱215,000Cash14 staff × 6 days✎
13 JunCoop roof repair — GI sheetsRepairs₱188,000RCBCStorm damage B2✎
Total shown:₱6,874,000

Analytics · 2026-06

Spend by Category
Spend by Week
Unusual (titles not seen in prior months)
Coop roof repair — GI sheetsRepairs · 13 Jun₱188,000
Egg trays — 60,000 pcsPackaging · 07 Jun₱210,000
script.google.com/rai-console · Customers
Sample data
ROVIC AGRIVENTURES INC./Customers
PRODTue, 30 Jun 2026

Customers · 24

CustomerLast
Purchase		LTV (₱)⋯
JCL Trading
142 txns
25 June 2026₱1,684,200✎
Golden Yolk Bakery
88 txns
21 June 2026₱812,600✎
Sunrise Groceries — Sta. Rosa
64 txns
17 June 2026₱598,300✎
Sps. Villanueva Store
51 txns
24 June 2026₱472,900✎
Aling Nena Sari-Sari
39 txns
20 June 2026₱214,500✎
Dizon Poultry Trading
28 txns
16 June 2026₱188,700✎
Mang Tonio Eatery
22 txns
22 June 2026₱96,400✎
Reyes Carinderia
14 txns
25 June 2026₱58,200✎

JCL Trading

LTV
₱1,684,200
AR Balance
₱92,400
Transactions
142
avg ₱241.4/tray
Trays
6,970
6,540 good · 430 crack
Credit Balance
₱4,800
Adjust ↻
Payment Cycle
~6 days
weekly, reliable
₱4,800 credit available to apply against this customer's outstanding ₱92,400.
Use Cash Flow → Apply Payment → Apply Existing Credit to consume the credit.
First purchase: 04 Jan 2023 · Last purchase: 25 June 2026

Monthly revenue

2026-06
2026-04
2026-03
2026-02