Product categories
Landed cost and list price per category| Category | Landed cost | List price | Mix % | GP/sheet at list | GP % at list | Mark-up % | ||
|---|---|---|---|---|---|---|---|---|
| Weighted average | — | — | — | — | — | — |
Every channel sells the same category mix, so the model runs on the weighted average landed cost and weighted average list price. Shifting mix toward a higher-priced category raises margin without touching price or discount. Mix percentages are normalised, so they need not add to exactly 100.
Employer statutory contributions
Employer portion only · rate applied to monthly wage| Contribution | Rate % | Rate above threshold % | Wage threshold | Wage ceiling | Local | Foreign |
|---|
Threshold switches the rate above a wage level — EPF drops from 13% to 12% above RM5,000. Set 0 for a single rate.
Ceiling caps the wage the rate applies to — SOCSO and EIS stop at RM6,000. Set 0 for no cap.
Local / Foreign controls which staff each contribution applies to. Every manpower row picks a profile.
SOCSO and EIS are legislated as contribution tables rather than pure percentages, so treat these as forecasting approximations and confirm exact figures with your payroll provider.
Ceiling caps the wage the rate applies to — SOCSO and EIS stop at RM6,000. Set 0 for no cap.
Local / Foreign controls which staff each contribution applies to. Every manpower row picks a profile.
SOCSO and EIS are legislated as contribution tables rather than pure percentages, so treat these as forecasting approximations and confirm exact figures with your payroll provider.
Tax, fee ceiling and logistics
| Corporate tax basis | SME bands apply per entity. Confirm eligibility — a corporate shareholder can disqualify it. | |
| Flat tax rate % | Used only when basis is Flat rate. | |
| Management fee ceiling % | Warns when the fee table totals more than this. | |
| Sheets per 40ft container | Drives the containers-per-month metric. |
Sales and channel margin
Cost basis: weighted landed costDrag ⠿ to reorder| Channel | Sheets/mo | Disc % | Unit price | Unit cost | GP/sheet | GP % | Sheets/yr | Revenue/yr | GP/yr | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Total | — | — | — | — | — | — | — | — |
Manpower
Profile controls which statutory contributions apply| Role | Pax | RM/mo ea | Profile | Basic/yr | Statutory/yr | Stat % | Total/yr |
|---|
Fixed operating expenses
Key in monthly| Item | RM/mo | Non-cash | RM/yr | ||
|---|---|---|---|---|---|
| Total fixed | — | — |
Variable expenses
% of a revenue or cost base| Item | % | Base | Non-cash | RM/yr | ||
|---|---|---|---|---|---|---|
| Total variable | — |
Management fee
% of consolidated PBT before fee · no statutory| Recipient | % of PBT | Group RM/yr | NI share RM/yr | RM/mo | ||
|---|---|---|---|---|---|---|
| Total | — | — | — | — |
Shared with Norand Sdn Bhd — edit here or there, both stay in sync. Charged on consolidated PBT before fee, then split between entities in proportion to each one's own PBT before fee. Zero in a loss year.
Profit & loss — Norand Industries Sdn Bhd
Annual| Revenue | 100.0% | — |
| Cost of goods sold — sheets × weighted landed cost | — | — |
| Gross profit | — | — |
| Manpower — basic salary | — | — |
| Manpower — employer statutory | — | — |
| Fixed operating expenses | — | — |
| Variable expenses | — | — |
| Total operating expenses | — | — |
| PBT before management fee | — | — |
| Total management fee | — | — |
| Profit before tax | — | — |
| Corporate tax | — | — |
| Profit after tax | — | — |
Sales and channel margin
Cost basis: transfer price from NIDrag ⠿ to reorder| Channel | Sheets/mo | Disc % | Unit price | Unit cost | GP/sheet | GP % | Internal | Sheets/yr | Revenue/yr | GP/yr | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Total | — | — | — | — | — | — | — | — |
Tick Internal for related-party volume such as Figment, so it can be excluded from commission and tracked separately.
Manpower
Profile controls which statutory contributions apply| Role | Pax | RM/mo ea | Profile | Basic/yr | Statutory/yr | Stat % | Total/yr |
|---|
If a director is paid a director's fee rather than a salary, set the profile to None — fees do not attract EPF, SOCSO or EIS.
Fixed operating expenses
Key in monthly| Item | RM/mo | Non-cash | RM/yr | ||
|---|---|---|---|---|---|
| Total fixed | — | — |
Variable expenses
% of a revenue or cost base| Item | % | Base | Non-cash | RM/yr | ||
|---|---|---|---|---|---|---|
| Total variable | — |
Marketing and creative commission sits entirely in Norand Sdn Bhd. Norand Industries carries no commission line, so its variable expenses are provisions only.
Management fee
% of consolidated PBT before fee · no statutory| Recipient | % of PBT | Group RM/yr | NSB share RM/yr | RM/mo | ||
|---|---|---|---|---|---|---|
| Total | — | — | — | — |
Profit & loss — Norand Sdn Bhd
Annual| Revenue | 100.0% | — |
| Cost of goods sold — purchases from NI at transfer price | — | — |
| Gross profit | — | — |
| Manpower — basic salary | — | — |
| Manpower — employer statutory | — | — |
| Fixed operating expenses | — | — |
| Variable expenses | — | — |
| Total operating expenses | — | — |
| PBT before management fee | — | — |
| Total management fee | — | — |
| Profit before tax | — | — |
| Corporate tax | — | — |
| Profit after tax | — | — |
Key metrics
Group—Gross margin—
—PBT before fee—
—Net margin—
—Contribution / sheetAfter landed + variable cost
—Breakeven sheets/mo—
—Margin of safetyHeadroom above breakeven
—Op. cash / monthBefore fee, tax, working capital
—Containers / month—
Channel value chain
Where each channel's margin lands, by entity| End channel | Sheets/mo | Disc % | End price | Landed | NI GP/sh | NSB GP/sh | Group GP/sh | Group GP % | Group GP/yr | % of group GP |
|---|---|---|---|---|---|---|---|---|---|---|
| Total | — | — | — | — | — | — | — | — | 100.0% |
Group GP per sheet is gross profit only — it does not absorb fixed cost. Once past breakeven, fixed cost is already paid for, so this is the right basis for judging whether one more sheet is worth selling.
Consolidation bridge
Intercompany eliminated| Norand Industries — total revenue | — | |
| Norand Sdn Bhd — total revenue | — | |
| Less: intercompany sales NI → NSB (eliminated) | — | |
| Group external revenue | 100.0% | — |
Consolidated profit & loss
Annual| External revenue | 100.0% | — |
| Cost of goods sold — total sheets × weighted landed cost | — | — |
| Gross profit | — | — |
| Manpower basic — NI | — | — |
| Manpower basic — NSB | — | — |
| Employer statutory — NI | — | — |
| Employer statutory — NSB | — | — |
| Fixed operating expenses — NI | — | — |
| Fixed operating expenses — NSB | — | — |
| Variable expenses — NI | — | — |
| Variable expenses — NSB | — | — |
| Total operating expenses | — | — |
| PBT before management fee | — | — |
| Total management fee | — | — |
| Profit before tax | — | — |
| Corporate tax — NI | — | |
| Corporate tax — NSB | — | |
| Total tax | — | — |
| Profit after tax | — | — |
Entity comparison
Where the profit sits| Line | Norand Industries | Norand Sdn Bhd | Group |
|---|---|---|---|
| Revenue | — | — | — |
| Gross profit | — | — | — |
| Gross margin % | — | — | — |
| Manpower — basic | — | — | — |
| Manpower — statutory | — | — | — |
| Fixed operating expenses | — | — | — |
| Variable expenses | — | — | — |
| PBT before fee | — | — | — |
| Management fee | — | — | — |
| Tax | — | — | — |
| Profit after tax | — | — | — |
| Net margin % | — | — | — |
Statutory contributions by type
Employer portion, annual| Contribution | Norand Industries | Norand Sdn Bhd | Group | % of basic salary |
|---|---|---|---|---|
| Total statutory | — | — | — | — |
| Basic salary base | — | — | — |
Distribution summary
Annual—Group profit after tax—
—Dividend pool—
—Retained in company—
—Management fee paidPerformance-linked, before tax
—Total paid to peopleFee + salary + retainer + commission
—Total to people + owners—
—Dividend yield on capital—
—Capital paybackYears at this dividend rate
Dividend policy
Term sheet settings| Paid-up capital — group | Used to work out each holder's capital in and yield. | |
| Dividend payout % of PAT | 50 means a 50/50 split — half distributed, half retained. | |
| Dividend surtax rate % — individuals | Applied only to the portion above the threshold, and only to holders marked as individuals. | |
| Surtax threshold — RM per year | Dividend income below this is not surtaxed. |
Dividends are single-tier — already taxed at company level, so no further tax on the company. The surtax sits with the individual, not the company, and does not change group cash flow. Confirm the current rate and threshold with your tax agent before relying on these figures.
Shareholders and income sources
Link each person to the lines they are paid from| Name | Role | Equity % | Individual | Loan to company | Management fee | Salary | Retainer | Commission | ||
|---|---|---|---|---|---|---|---|---|---|---|
| Total | — | — |
The dropdowns attribute existing P&L lines to a person — they never add cost. A person can hold zero equity and still appear here, which is how a consultant on a retainer plus commission shows up. Equity percentages are normalised, so the pool is always fully allocated.
Income by person
Annual, before personal income tax| Name | Equity % | Capital in | Mgmt fee | Salary | Retainer | Commission | Total earned | Dividend | Surtax | Dividend net | Total income | RM/mo | Yield on capital |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Total | — | — | — | — | — | — | — | — | — | — | — | — | — |
Total earned is performance and service pay — management fee, salary, retainer and commission. It is a cost inside the P&L, taken before profit.
Dividend is a return on ownership, paid out of profit after tax. Salary attracts EPF and personal income tax; management fee and dividend do not attract EPF. Personal income tax is not modelled here.
Dividend is a return on ownership, paid out of profit after tax. Salary attracts EPF and personal income tax; management fee and dividend do not attract EPF. Personal income tax is not modelled here.
Where the money goes
From gross profit to the people who receive it| Group gross profit | 100.0% | — |
| Operating costs excluding people | — | — |
| Salaries and retainers to people listed above | — | — |
| Commission to people listed above | — | — |
| PBT before management fee | — | — |
| Management fee — performance linked | — | — |
| Corporate tax | — | — |
| Profit after tax | — | — |
| Dividend to shareholders | — | — |
| Retained in the business | — | — |