Manufacturing pricing · 6 minute read
Laser cutting cost calculation formula in Excel: free worksheet
Laser quote = (material + machine hours × machine rate + operator hours × labour rate) ÷ (1 − gross margin). Use margin as a fraction: 25% is 0.25. The free worksheet below separates cutting, piercing, setup and handling.
A useful cutting quote starts with the time a job actually occupies your machine. This worksheet uses the same arithmetic as our laser cutting cost calculator and keeps the assumptions visible so you can adapt it to your shop.
Download the Excel-compatible CSV worksheet
Free. No email. Open in Excel or LibreOffice; import with comma delimiter if needed. Enable formula interpretation only for this inspected template. Edit B2:B11 and save as XLSX to keep formatting. No macros or external workbook links.
Download worksheetWatch the one-minute laser pricing walkthrough
60 seconds · captioned · no audio. A worked example using the live tools.
Read the walkthrough transcript
Enter a 2,000 mm path at 1,000 mm/min: cutting takes 2 minutes. Add 10 one-second pierces and 10 setup minutes for 12.1667 machine minutes.
At 90 per hour the machine charge is 18.25. Setup plus 5 handling minutes at 40 per hour adds 10 labour cost. Add 20 material: production cost is 48.25.
A 25% gross margin gives 48.25 ÷ 0.75 = 64.33 before tax and any costs not included in your rates. Markup and margin are different.
Check speed units: 20 mm/s equals 1,200 mm/min. Equivalent units do not guarantee equivalent cutting results. Download the free editable CSV worksheet for Excel or LibreOffice.
Enter lengths and speeds in matching units
Put path length in B2 in mm and measured average cutting speed in B3 in mm/min. Cutting minutes in B12 is =B2/B3. A 2,000 mm path at 1,000 mm/min takes 2 minutes. A speed of 20 mm/s is 1,200 mm/min, not 20 mm/min.
Use actual cutting speed or a CAM time estimate rather than advertised maximum travel speed. Acceleration, corners and multiple passes can make length divided by speed optimistic.
Charge machine time and operator time separately
With 10 pierces at 1 second each, piercing time is 10/60 = 0.1667 minutes. Add 10 setup minutes to get 12.1667 machine minutes. At 90 currency units/hour the machine charge is 18.25.
The example operator handles setup plus 5 handling minutes: 15/60 × 40 = 10. Setup occupies both resources in this model. If your machine rate already includes the operator, set the separate labour charge accordingly to avoid double counting.
Gross margin is different from markup
Add 20 material cost to 18.25 machine cost and 10 labour cost: production cost is 48.25. For a 25% gross margin, selling price is 48.25 / 0.75 = 64.3333, or 64.33 for display. Multiplying cost by 1.25 instead produces a 20% margin.
B18 contains =B17/(1-B11/100). Enter margin from zero to below 100. Keep full precision until final currency rounding.
What must be added to a real quotation?
Include gas, consumables, maintenance and depreciation in your machine rate or add them separately. Include nesting waste, material minimums, finishing, design time, tax and delivery when applicable. The template deliberately does not invent universal rates.
Use one currency throughout. The calculator currently labels money in EUR; the worksheet is currency-neutral. Compare the estimate against actual completed jobs before quoting customers.