How quotation pricing is calculated
The short answer
Zigaflow sets the sales price of a quotation line in one of three ways: a mark-up or a margin, both worked from the agreed cost, or a discount, worked from the list price. A supplier discount lowers the agreed cost. Type the figure on the open line and click the tick: the price is worked out when the line is saved.
Watch the walkthrough
Transcript (1:44)
Here is how Zigaflow works out the price on a quotation line.
On the Items tab, click the view icon at the right, then the cog. Display Settings opens. Switch on the pricing fields you want, such as Markup, then click Save.
The line now shows its costs and prices. List Cost and List Price come from the item. Agreed Cost and Sales Price are what this quotation uses.
Double-click the line, type a mark-up and click the tick. The sales price becomes the agreed cost plus that percentage. Fifty percent on a cost of fourteen pence gives twenty-one pence.
Type a margin instead, and the sales price becomes the agreed cost divided by one minus the margin. Fifty percent on fourteen pence gives twenty-eight pence.
A discount works from the list price, not the cost. Twenty-five percent off a list price of thirty-two pence gives twenty-four pence.
Supplier Discount takes a percentage off the list cost to give the agreed cost. Type it and click the tick. The agreed cost goes down, the sales price stays as it was, and the margin goes up.
Those are the four ways a price is set on a line: mark-up, margin, discount and supplier discount.
Steps
Choose the pricing columns to show
Watch this step (0:05)On the quotation's Items tab, click the view icon at the right of the toolbar, then the cog beside Switch View. Display Settings opens.
Switch on the fields you want. The ones used here are List Cost, Supplier Discount and Agreed Cost under Costing, List Price and Discount under Pricing, and Markup and Margin Percentage under Metrics. Click Save, the disk icon at the foot of the panel, then the cross beside it.
Read the costs and prices on the line
List Cost and List Price come from the item. Agreed Cost and Sales Price are what this quotation uses.
Here the list cost and agreed cost are 0.14 and the list price and sales price are 0.32.
Watch this step (0:21)Mark-up adds a percentage to the cost
Double-click the line, type a figure under Markup % and click the tick at the right of the line.
Sales price = agreed cost x (1 + mark-up). A mark-up of 50% on an agreed cost of 0.14 gives a sales price of 0.21.
Watch this step (0:35)Margin sets the share of the price that is profit
Type a figure under Margin % instead and click the tick.
Sales price = agreed cost / (1 - margin). A margin of 50% on an agreed cost of 0.14 gives a sales price of 0.28.
Watch this step (0:51)Discount works from the list price
Type a figure under Discount % and click the tick. Cost plays no part in this one.
Sales price = list price less the discount. A discount of 25% on a list price of 0.32 gives a sales price of 0.24.
Watch this step (1:06)Supplier discount lowers the agreed cost
Type a figure under Supplier Discount and click the tick.
Agreed cost = list cost less the supplier discount. A supplier discount of 25% on a list cost of 0.14 gives an agreed cost of 0.105. The sales price stays as it was, so the mark-up and margin on the line go up.
Watch this step (1:17)
The figures move together
Mark-up, margin and discount are three views of the same sales price, so changing one changes the others when the line is saved. In the walk-through, a 50% mark-up showed as a margin of 33.33% and a discount of 34.38% against the list price.
Tip
A figure you type takes effect when you save the line with the tick. Click the cross instead to leave the line as it was.
Frequently asked questions
Next step
Every planWas this helpful?