Type each cost section's subtotal (lumber, sheathing, labor...) and your markup rates. You get what a price swing in each section does to your cost and bid, ranked, and how far a section can rise before a bid you already gave loses its profit. The same engine as --sensitivity in the whole-house takeoff. A what-if, not a forecast. Nothing leaves your browser.
Stack. Materials carry tax, then contingency on materials plus tax. Labor and allowances are added after. Overhead is a percentage of that total, profit a percentage of total plus overhead.
Swing. One section is scaled by the swing and the stack is redone, so tax, contingency, overhead and profit move with it. A 0% swing gives your own bid back.
Break-even. Overhead and profit are held at today's dollars; the rise in one section that uses up all the profit is the profit divided by the cost each 1% adds.
Questions
If lumber goes up 15%, what happens to my bid?
With lumber 18,000, sheathing 6,500, roofing 5,200 and labor 22,000, 7% tax and 5% contingency on materials, 10% overhead and 10% profit, the cost is 55,367.95 and the bid 66,995.22. Lumber alone up 15% adds 3,033.45 to cost and 3,670.47 to the bid, which is 5.48%. The prices are the ones you type; the calculator only restacks them.
How much can a section rise before a fixed bid loses its profit?
Holding the bid at 66,995.22 and overhead and profit in dollars, lumber can rise 30.12% before the 6,090.47 of profit is gone, labor 27.68%, sheathing 83.4% and roofing 104.25%. Everything up 15% together takes the bid to 77,044.50.