Price for Profit Test

price for profit

Now, here comes some advanced pricing strategies shops have been using with this tool. You absolutely don’t have to do things this way. But, I wanted to show a few points that may help you dial in your Price List so it works perfectly for your shop. First, More Colors Our pricing example only goes up to six colors. You shop might have more than that. In fact, you were probably wondering how to make this work for what you do anyway.

Here’s the step by step.

For starters, enter the additional color count numbers for Row 2 under each column.

Then, copy the value in your last column of your Keystone row. In our example, that is cell G7. Select the cell to the right. For us, that’s cell H7. Paste the value into that cell.

Here’s where it gets a little tricky.

The value you pasted has a formula we need to edit so it will work for the column we’re using. It’s faster to edit a formula than write a new one. When we pasted the formula from Google Sheets shifted over some values from our formula cells. We simply need to edit them to make things work.

Made with FlippingBook - Online catalogs