price for profit
This is the easy way to dial in your pricing for quantity.
As you can see in the formula area, the markup number for the cell B4 isn’t 10% like it was on Example Pricing 1 , it’s now 40%. Playing with the markup percentage for the cell formulas is how you slice and dice your own pricing theory for your shop.
Like before, this is all based on the relational value to your Keystone Cell price, which is built on your own shop costs.
It is the cell formulas that make this work.
That’s why with Example Pricing 1 the range goes from $1.37 for a 1 color for 12-23 quantity to $1.51 for a 6 color 1000-2499 quantity.
On Example Pricing 2 , the range goes from $2.25 for a 1 color for 12-23 quantity to $0.70 for a 6 color 1000-2499 quantity. VARIATIONS So hopefully you’ve been following along and have made sense of the mechanics of how this spreadsheet pricing system works. 9 All with the same shop cost starting points. $0.51 for the Cost per Impression and $0.21 for the Screens + Downtime .
37
© 2018 Marshall atkinson consulting, llc
Made with FlippingBook - Online catalogs