73.3%
176 / 240 RNs (8 suites)
RevPAR
$134
ADR: $182
73.3%
176 / 240 RNs (8 suites)
RevPAR
$134
ADR: $182
LKR 815K
Oct 26: LKR 2.18M Provisional — COGS Pending
Nov 26: LKR 4.64M Provisional — COGS Pending
LKR 1.10M
Fudo Sales: LKR 1,096,934
Capture / Occ. Suite: LKR 6,233
$140,081
Confirmed forward room bookings (90d)
Proj. F&B Capture: +LKR 5.54M Projection Formula Confirmed Forward Room Nights × Trailing 90-Day Historical F&B Revenue per Occupied Suite Night.
Intercompany management fees, cross-charges & F&B transfers between The Sun House (918795352) and SHG Leisure (919449166) are eliminated in Consolidated view.
| Period | Room Rev (LKR) | F&B Rev (LKR) | Net Revenue (LKR) | COGS (LKR) | Gross Margin | OpEx (LKR) | Net Op. Profit (LKR) | GOP % | IC Eliminated Intercompany transfers, management fees & shared expenses between The Sun House (918795352) and SHG Leisure (919449166) eliminated on consolidation. |
|---|---|---|---|---|---|---|---|---|---|
| Apr 26 (2026-04) | LKR 6,271,448 | LKR 2,114,354 | LKR 8,863,087 | LKR 3,280,186 | 63.0% | LKR 4,740,586 | LKR 842,314 | 9.5% | LKR 794,500 |
| May 26 (2026-05) | LKR 2,496,095 | LKR 1,254,691 | LKR 4,281,474 | LKR 2,500,414 | 41.6% | LKR 2,859,046 | -LKR 1,077,986 | -25.2% | LKR 794,500 |
| Jun 26 (2026-06) | LKR 1,314,063 | LKR 759,720 | LKR 2,249,903 | LKR 2,457,532 | -9.2% | LKR 3,206,673 | -LKR 3,414,302 | -151.8% | LKR 835,000 |
| Jul 26 (2026-07) | LKR 3,053,196 | LKR 1,472,840 | LKR 4,766,211 | LKR 2,907,975 | 39.0% | LKR 2,633,080 | -LKR 774,844 | -16.3% | LKR 842,600 |
| Aug 26 (2026-08) | LKR 6,766,585 | LKR 2,270,795 | LKR 10,966,095 | LKR 2,891,662 | 73.6% | LKR 3,728,387 | LKR 4,346,047 | 39.6% | LKR 840,625 |
| Sep 26 (2026-09) | LKR 3,448,229 | LKR 898,597 | LKR 5,785,828 | LKR 2,286,383 | 60.5% | LKR 2,684,685 | LKR 814,760 | 14.1% | LKR 821,500 |
| Oct 26 (2026-10)
PROVISIONAL · COGS PENDING
| LKR 2,869,427 | LKR 862,495 | LKR 5,108,094 | LKR 726,980 | 85.8% | LKR 2,198,128 | LKR 2,182,985 | 42.7% | LKR 0 |
| Nov 26 (2026-11)
PROVISIONAL · COGS PENDING
| LKR 4,352,144 | LKR 752,064 | LKR 5,708,303 | LKR 313,908 | 94.5% | LKR 753,698 | LKR 4,640,697 | 81.3% | LKR 0 |
| TTM Total / Avg | LKR 30,571,187 | LKR 10,385,557 | LKR 47,728,996 | LKR 17,365,041 | 63.6% | LKR 22,804,284 | LKR 7,559,672 | 15.8% | LKR 4,928,725 |
On-the-books (OTB) room nights across 8 suites (575 / 728 RNs, 1177 expected guests), confirmed room revenue, and projected Gallean F&B capture.
OTB Occupancy
64.2%
OTB Room Rev (USD)
$30,946
OTB Occupancy
73.8%
OTB Room Rev (USD)
$87,683
OTB Occupancy
79.0%
OTB Room Rev (USD)
$140,081
Full calendar month denominators (days in month × 8 suites) from pms_daily_room_nights.
| Stay Month | Booked / Avail RNs | OTB Occupancy % | Expected Guests | OTB Room Rev (USD) | OTB Room Rev (LKR) | Projected F&B (LKR) |
|---|---|---|---|---|---|---|
| Nov 26 (2026-11) | 176 / 240 | 73.3% | 345 | $32,116 | LKR 10,598,330 | LKR 1,712,077 |
| Dec 26 (2026-12) | 174 / 248 | 70.2% | 358 | $44,984 | LKR 14,844,773 | LKR 1,692,621 |
| Jan 27 (2027-01) | 211 / 248 | 85.1% | 436 | $54,823 | LKR 18,091,428 | LKR 2,052,546 |
| Feb 27 (2027-02) | 206 / 224 | 92.0% | 417 | $48,745 | LKR 16,085,748 | LKR 2,003,908 |
Showing distribution & top DMC agencies for Next 90 Days (Forward OTB)
| Channel | Segment | Room Nights | Share % | ADR (USD) | Revenue (USD) |
|---|---|---|---|---|---|
| Booking.com | OTA | 221 | 38.4% | $255 | $56,406 |
| Direct Website / Walk-in | DIRECT | 167 | 29.0% | $241 | $40,266 |
| Expedia | OTA | 68 | 11.8% | $236 | $16,024 |
| Tikalanka Tours (Pvt) Ltd | AGENT / DMC | 12 | 2.1% | $260 | $3,114 |
| Jetwing+ | AGENT / DMC | 13 | 2.3% | $225 | $2,924 |
| Hummingbird | AGENT / DMC | 11 | 1.9% | $257 | $2,832 |
| AUTHENTICITIES (PVT) LTD | AGENT / DMC | 9 | 1.6% | $238 | $2,146 |
| FAR OUT (PVT) LTD | AGENT / DMC | 8 | 1.4% | $208 | $1,660 |
| PERFECT LIVING BVBA | AGENT / DMC | 3 | 0.5% | $507 | $1,520 |
| Wayfarers (Pvt) Ltd | AGENT / DMC | 6 | 1.0% | $234 | $1,404 |
| Ceylon Tours Ltd | AGENT / DMC | 7 | 1.2% | $194 | $1,361 |
| Blue Lanka Tours | AGENT / DMC | 5 | 0.9% | $264 | $1,320 |
| Columbus Tours (Pvt) Ltd | AGENT / DMC | 8 | 1.4% | $153 | $1,224 |
| Lanka Sportreizen LSR | AGENT / DMC | 4 | 0.7% | $262 | $1,046 |
| Ceylon Expeditions Travels | AGENT / DMC | 6 | 1.0% | $173 | $1,038 |
| Off 2 Sri Lanka (Pvt.) Ltd | AGENT / DMC | 4 | 0.7% | $231 | $924 |
| Boutique Sri Lanka | AGENT / DMC | 3 | 0.5% | $276 | $829 |
| BAYLEA | AGENT / DMC | 2 | 0.3% | $290 | $580 |
| Jet Wings Lanka Tours (Pvt) Ltd | AGENT / DMC | 2 | 0.3% | $283 | $566 |
| Ceylon Escapes (Pvt) Ltd | AGENT / DMC | 2 | 0.3% | $276 | $552 |
| Travelorphic (Private) Limited | AGENT / DMC | 2 | 0.3% | $247 | $494 |
| TRIPFUSION (PVT) LTD | AGENT / DMC | 2 | 0.3% | $245 | $489 |
| Travel Ease Tours Private Limited | AGENT / DMC | 2 | 0.3% | $213 | $426 |
| Blue Dot Tours (Pvt) Ltd., | AGENT / DMC | 2 | 0.3% | $213 | $426 |
| Tourslanka Vacations (Pvt) Ltd | AGENT / DMC | 2 | 0.3% | $179 | $358 |
| Pan Lanka Tour and Travels (Pvt) Ltd | AGENT / DMC | 1 | 0.2% | $153 | $153 |
| House / Friends & Family | HOUSE USE | 3 | 0.5% | $0 | $0 |
| Rank | Agency / DMC Name | Room Nights | Revenue (USD) | ADR (USD) | Avg Stay (Nts) | % of Agent Segment |
|---|---|---|---|---|---|---|
| #1 | Tikalanka Tours (Pvt) Ltd | 12 | $3,114 | $260 | 2.0 | 11.4% |
| #2 | Jetwing+ | 13 | $2,924 | $225 | 2.2 | 10.7% |
| #3 | Hummingbird | 11 | $2,832 | $257 | 1.8 | 10.3% |
| #4 | AUTHENTICITIES (PVT) LTD | 9 | $2,146 | $238 | 3.0 | 7.8% |
| #5 | FAR OUT (PVT) LTD | 8 | $1,660 | $208 | 2.7 | 6.1% |
| #6 | PERFECT LIVING BVBA | 3 | $1,520 | $507 | 2.0 | 5.6% |
| #7 | Wayfarers (Pvt) Ltd | 6 | $1,404 | $234 | 2.0 | 5.1% |
| #8 | Ceylon Tours Ltd | 7 | $1,361 | $194 | 2.3 | 5.0% |
| #9 | Blue Lanka Tours | 5 | $1,320 | $264 | 5.0 | 4.8% |
| #10 | Columbus Tours (Pvt) Ltd | 8 | $1,224 | $153 | 4.0 | 4.5% |
| #11 | Lanka Sportreizen LSR | 4 | $1,046 | $262 | 1.0 | 3.8% |
| #12 | Ceylon Expeditions Travels | 6 | $1,038 | $173 | 1.5 | 3.8% |
| #13 | Off 2 Sri Lanka (Pvt.) Ltd | 4 | $924 | $231 | 1.0 | 3.4% |
| #14 | Boutique Sri Lanka | 3 | $829 | $276 | 1.0 | 3.0% |
| #15 | BAYLEA | 2 | $580 | $290 | 1.0 | 2.1% |
12-month F&B spend per occupied room night alongside Fudo POS dish/cocktail contribution and Zoho Inventory COGS Pool margin allocation.
| Month | Occ RNs | Occ % | ADR / RevPAR | Fudo F&B | F&B / RN |
|---|---|---|---|---|---|
| Jun 26 | 90 / 240 | 37.5% | $64 / $24 | LKR 1.00M | LKR 11K |
| Jul 26 | 100 / 248 | 40.3% | $164 / $66 | LKR 1.46M | LKR 15K |
| Aug 26 | 160 / 248 | 64.5% | $195 / $126 | LKR 985K | LKR 6K |
| Sep 26 | 125 / 240 | 52.1% | $147 / $76 | LKR 1.12M | LKR 9K |
| Oct 26 | 81 / 248 | 32.7% | $181 / $59 | LKR 1.42M | LKR 18K |
| Nov 26 | 176 / 240 | 73.3% | $182 / $134 | LKR 1.10M | LKR 6K |
Dish-level GP% weighted by protein/category cost tiers against Zoho Books inventory COGS. Fudo POS daily sync runs incrementally; partial-day gaps may occur if upstream API rate limits are hit.
Auto-derived from BigQuery: confirmed OTB + prior-year actual seasonal revenue, proportional F&B capture, closed Zoho OpEx + COGS (LKR 4,853,115/mo avg), and -15% OTA commission on 49% OTA share.
—
Highest closing cash across 6-month window
—
Minimum closing balance & negative cashflow months
—
Cash Trough − 1.5× (OpEx + COGS) Safety Buffer
| Month | Season / Occ % | Opening Cash | Room + F&B Inflow | OpEx + COGS + OTA | Net Cashflow | Closing Cash |
|---|