Business Management System

← Project Management PM tool
Notes

No notes for this page.

The Beach House Fahid

Abu Dhabi · Ready

The Beach House Fahid — new project workspace. Activate, then gather materials in Project Management.

Initial setup (once): upload the three Setup Excels below (Unit Info → Price Control → Unit Status & Selling Price) to generate the Price Matrix. Day-to-day: use Price Matrix for Released / Not released and price edits, and Operations for sold / reserved / exchanged. Reference: Noble Emmerse Phrom Phong.

Initial setup (once)

Complete these Excel steps in order the first time you open the project. Download each template, fill the blue input cells, then upload. Files are stored under data/projects/bhf/uploads/.

Setup Excel Download returns the last uploaded workbook — it is not live inventory. For current sold / released / hold status, use Price Matrix → Download live inventory after the lab is ready. Re-uploading Setup Excels regenerates the Price Matrix from those files (bulk price revision) and can overwrite base statuses in units.json. Lab overrides and Ops holds still apply on top — confirm inventory after a full re-upload.

1. Unit Info

Sheets: Martix, Sales Condition, Unit Info. Blue cells are manual input. Unit Info rows match Total Number of Units. Right of Unit Code: Plan Code (layout plan stem, e.g. A13), Unit Type (dropdown), Size, Upper Floor Size, and Total Size (Size + Upper). Unit Code is the stack used with Tower + Floor for Unit Number; Plan Code is for price-card unit plan images. After House No.: Sales Status (Reserved / Exchanged / Completed / Unsold), Reservation Date, and Transacted Price (for future Operations linking).

Saved: 20260903 BHF Unit Info.xlsx · 2026-09-03 · Download copy

2. Price Control

Sheets: Investment + Control (Investment omitted when unit nature is Agency only). Rows match Underwriting / Real Asset units; project unit codes prefilled when available.

Saved: 20260902 BHF Control.xlsx · 2026-09-03 · Download copy

3. Unit Status & Selling Price

Sheets: Unit Status, Selling Price and Promotion. Rows match units with Availability = Available; project unit codes prefilled. Price 100 is filled from Price Control when uploaded. Unit Status uses a Released / Not Released / Sold dropdown. If Unit Info Sales Status is Reserved, Exchanged, or Completed, Unit Status is prefilled as Sold and locked.

Saved: 20260902 BHF Selling Price.xlsx · 2026-09-03 · Download copy

Matrix / Unit summary

Layout summary from Unit Info. Price Matrix is generated from the 3 Setup Excels (Unit Info · Price Control · Unit Status & Selling Price) when all are uploaded.

ready Open Price Matrix
4Total units
4Available
0Unavailable
2Floors
7Stack codes
4Matrix cells

By unit nature

  • Underwriting4

By unit type

  • 1 Bed2
  • Studio2

Stack codes

B502 B503 B507 B207 07 02 03

Sample: BHF 4B507, BHF 5B502, BHF 5B503, BHF 10B207

Matrix preview

Floor North-East North-East North-East South-West Col 6 Col 7 Col 8 Col 9
5 5B502 5B503 4B507
2 10B207

Generated 2026-09-10 02:15:12 UTC · from 20260903 BHF Unit Info.xlsx

Commission Payable

Two independent logs: standard for a normal unit, and bulk for multi-unit bookings. Project Management fills in a new rate; the Managing Director must review it before it is confirmed and used on bookings. Each has its own start and end dates. You can gap-fill before a future entry; future-dated approved rows can be removed. End dates close automatically when an approved entry starts inside an open range.

Standard commission

Rate for a normal (single-unit) booking. Used whenever bulk does not apply. Submitted rates stay pending until the Managing Director confirms them.

Standard Log

Rate Paid when Start End Status Created Notes
Loading…

Bulk commission

Rate for multi-unit bookings. Each entry sets how many units the bulk rate applies from. Different unit thresholds may share the same dates (for example ≥2 and ≥5 at once); a booking uses the highest threshold it meets. Submitted rates stay pending until the Managing Director confirms them.

Bulk Log

Rate Applies at Paid when Start End Status Created Notes
Loading…

Commission Receivable

Vendor AR for this project. One plan can have multiple payment trenches. Enter each trench’s buyer payment % — together they must equal this project’s Exchange % (30.0% from BMS). AR from vendor is entered per trench (not calculated). Full commission is whatever the vendor deal is (not fixed at 11%). Apply to all available units or pick specific available units from this project’s inventory. A plan that has already started cannot be edited — set an End Date first; a new overlapping plan can start the day after.

Payment Trenches

Buyer Paid Up To (%) is the cumulative share the client has paid at that trench (not an installment to add up). Example for Exchange 30.0%: 15 then 30 — the final trench must be 30.0%. AR from vendor values do add up to Full Commission.

Trench Buyer Paid Up To (%) SPA Signed AR From Vendor (%)
Units

Receivable Plans

Loading…

Day-to-day (after setup)

  1. Released / Not released: open Price Matrix → unit drawer → Set released / Set not released.
  2. Sold path: complete the sale in Operations · Booking (reserved → exchanged / complete). Do not re-upload Setup Excel for each sale.
  3. Change one unit’s list / promo / Price 100: Price Matrix → unit drawer → Edit prices.
  4. Bulk price revision: re-upload Unit Status (and Price Control if needed) as a deliberate event, then download live inventory to confirm.
  5. Download current inventory: Price Matrix → Download live inventory (includes Lab overrides, Ops locks, and Sales Toolkit holds). Setup Excel download is the archive only.