THULIR TECH SOLUTIONSService DivisionMockup · sample data
Executive MIS

Job profitability

Price against cost. Which work is worth doing, not only which work is getting done.

US-054 · US-055 · US-056
Revenue
₹4.18 L
26 jobs closed
Cost
₹2.41 L
labour ₹1.68 L · parts ₹0.73 L
Base margin
₹1.51 L
39.0% · how well we delivered
Opportunity premium
₹26,000
9 jobs
Total margin
₹1.77 L
42.3% · how well we traded
Negative margin
4
jobs · ₹9,400 lost
Uncosted hours
14 h
no rate in force

By customer

closed jobs, this period
CustomerSegmentJobsPriceCostMargin%
AYYAN INDUSTRIAL SOLUTIONSAd-Hoc8₹1,52,000₹78,400₹73,60048%
FemmevitaAd-Hoc5₹94,000₹51,200₹42,80046%
Sri Balaji HospitalAd-Hoc3₹61,000₹34,900₹26,10043%
KTPL MedicalContract9₹98,000₹71,400₹26,60027%
Cine Projection CoAd-Hoc1₹13,000₹5,200₹7,80060%

KTPL is on agreed rates set in April. At 27% against a 45% book average, those rates are worth revisiting at renewal (AC-056-005).

By engineer

margin on the jobs each one closed
EngineerLevelJobsHoursLabour costBase priceBase margin%
RamachandranSenior Engineer17142₹79,520₹2,46,000₹1,24,30051%
BaleswarEngineer7138₹57,960₹1,02,000₹22,40022%
MuthuEngineer396₹44,000₹4,300₹4,30010%

Base price and base margin only — opportunity premiums are excluded here. A premium reflects what the situation was worth to the customer, not anything the engineer did, so it never moves an engineer's figure (AC-056-009). Read this alongside the performance scorecards, not instead of them: a low margin can mean slow work, hard boards, or rework the engineer absorbed, and Muthu's three jobs are too few to conclude anything from.

Jobs at a loss

4 jobs
JobCustomerPrice sourcePriceCostMarginWhy
WO/26-27/00318KTPL MedicalService rate₹9,800₹9,310₹490Reworked under warranty
WO/26-27/00402KTPL MedicalService rate₹4,200₹5,100−₹900Rate below actual effort
WO/26-27/00429Cine Projection CoNot chargeable₹0₹6,240−₹6,240Non-repairable write-off
WO/26-27/00433Deccan RadiologyNot chargeable₹0₹2,750−₹2,750Quotation rejected after diagnosis

Two of these are the business working as intended — a write-off and a rejected quote both cost real hours. The middle one is a rate that no longer covers the work, which is the finding worth acting on.

Opportunity premium captured

₹26,000 · 9 jobs
ReasonJobsPremiumMostly
Urgent turnaround5₹15,400Femmevita, Sri Balaji Hospital
Scarce component2₹6,200Cine Projection Co
Out of hours1₹2,800KTPL Medical
Site attendance1₹1,600AYYAN INDUSTRIAL

Reported in its own right, because it is a commercial result rather than a delivery one. It counts fully towards the company's margin and not at all towards any engineer's (AC-062-003).

14 hours in this period carry no labour rate and are costed at zero. Margin above is overstated by roughly ₹5,900 until those rates are set (AC-056-006).