Sahawatthanakit (1988) Co., Ltd.
SAHAWATTHANAKIT(1988) · Make It Smart
Digital Tools for Industrial SMEs · 11

Job Costing & Pricing Calculator (Thai + English editions)

Fixed price · instant download after payment · no quote needed

A Thai metal-fabrication shop owner pricing a job at a bench, work order and calculator in front of him, his own welding shop behind.
The first sheet of the file, showing a five-step guided tour with all five status cells amber and reading “not done yet”, and two file-health lights green.
Sheet 0, “Guided tour” — five steps that tick themselves only once you have done them · each status cell is a formula reading your own cells, so it stays amber until you replace the factory sample with your business’s numbers. Not a checklist someone pre-ticked for you.
The job pricing sheet, with a fixed-cost warning banner pinned at the top, a month selector in the top-right corner, three sample jobs below it, and columns for cash floor, break-even, lowest price, price to quote, plus green, red and prohibited status lights.
The “Price a job” sheet — fill the yellow cells and it returns cash floor, break-even, lowest acceptable price and the price to quote · the three sample rows in the file show three genuinely different decisions: priced by the system (🟢) · pushed below full overhead recovery, which a quiet month can still accept (🔴) · pushed until cash actually leaves the building, which must be refused (⛔) · the top banner sits inside the frozen pane, so it stays on screen even at job 60 — and the “month in view” cell lets you look back at earlier months.
The settings sheet, showing monthly fixed costs, hours actually sold, hourly wage and target margin, with a factory-value column and status lights.
The “Settings” sheet — the first two cells matter more than anything else in the file: monthly fixed costs, and the hours you actually sell. The system uses those two to spread fixed cost across every job · every cell keeps its “factory value”, and a status light fires when an entry is out of range or contradicts another.
The per-customer summary sheet, showing revenue, profit and job count for each customer.
The “Per customer” sheet — once jobs are done, look back and see which customers actually made you money and which ones ate your time.
The self-test sheet with 24 cases, showing normal cases, deliberately broken ones such as divide-by-zero, negative values and billion-scale numbers, and cases that force every price-driven status light to fire, with a column comparing the result against what it should be.
The “Self-test” sheet — 24 cases: 10 normal · 10 deliberately broken (divide by zero · negatives · empty rows · billion-scale numbers) · 4 that force every price-driven status light to fire · the right-hand column recomputes what the answer should be and compares live. See for yourself that no cell errors and no light is wrong.

Screenshots of the file you actually receive — the figures shown are sample defaults, and every cell is yours to change.

One purchase, two files. You receive both the English (Thailand) edition shown in the screenshots above and the Thai edition — generated from the same formulas, so the two can never disagree about a number.

An Excel file for businesses that sell work as jobs — enter materials, on-site hours and freight, and it returns the four numbers you have to keep apart when a customer pushes back on price: the cash floor (below it, every job you take drains the bank), break-even, the lowest price that still clears your minimum margin, and the price you should quote. It spreads fixed costs across jobs by the hours you actually sell, and prices the cost of waiting for payment from the credit days — netting off the part your own suppliers finance for you. A five-step status light 🟢🟠🟡🔴⛔ separates "does not carry its full share of overhead, but in a quiet month it beats turning it down" from "take this and real cash leaves the building". It warns when a wage is being counted twice against salaries already sitting in fixed costs. A banner frozen to the top of the pricing sheet shows how much of this month's fixed cost no job has picked up yet, and projects from your actual pace what the shortfall will be — so you can go find work mid-month instead of learning about it when it is too late to fix. Every setting keeps a "factory value" to copy back from when you break something. A self-test sheet runs 24 cases (10 normal, 10 deliberately broken, 4 that force every price-driven status light to fire) so you can see for yourself the formulas hold. The first sheet is a five-step guided tour that ticks itself only once you have done the step for real. One purchase, two files: the Thai edition and this English (Thailand) edition, generated from the same formulas. No macros — Excel, LibreOffice and Google Sheets all open it.

Launch price · until 31 Dec 2026

฿999≈ US$30Regular price ฿1,490Complete · one-time payment

This price includes 7% Thai VAT (goods ฿933.64 + VAT ฿65.36) — nothing else is added. You are charged ฿999 THB; the US$ figure is an approximate guide at today's rate and your bank converts at its own. Cards from any country are accepted.

  • ✓Two editions in one purchase — Thai and English files, identical formulas.
  • ✓Download immediately after payment — no waiting.
  • ✓The manual lives inside the file (first sheet) — usable without anyone training you.
  • ✓Every default is yours to change, and a “factory value” column restores the original when you break something.
  • ✓A plain .xlsx with no macros — opens in Excel, LibreOffice and Google Sheets.
  • ✓A full Thai tax invoice can be issued — deductible as a company expense (registered company).
  • ✓Buy in your company’s name — enter the company name and 13-digit tax ID at checkout and we issue the tax invoice to match.

We send the files to this address as soon as payment clears.

Pay by PromptPay or credit/debit card through Stripe (secure, industry-standard encryption).

What support covers

This is a finished file sold outright, once. It does not include installation, training or per-customer customisation — the common questions are answered in the manual inside the file.