price for profit
by using a formula.
In Pricing Example 1 , let’s take a look at cell B6 . This is in the row above our base quantity, and is for 96-143. We want to charge more for ordering the lesser quantity, and in the spreadsheet we use a formula to calculate that for us. =SUM(B7*1.1) This means that whatever number is in cell B7 , our Keystone Price , the increase will be by 1.1, or 10%.
To price a 1 color screen-print location with quantities between 96-143, we would use $1.03 as the basis for the calculation. The result you get for B6 is completely dependent on what number is expressed in cell B7 . This is how the Price List works. Each cell is dependent on the one preceding it in order to return the correct calculation. We can modify the formulas of course, and we will get to that later in the eBook.
In fact, for the Pricing Example 1 , for each of the cells B5 , B4 , and B3 , they all are based on increasing the price by 10% from the cell below them. On the worksheet, click on each cell and see how the formula changes for each.
Ultimately, they are all still tied to the Keystone Cell in the number for B7 .
Next up, pricing for larger quantities.
Larger Quantities - It Works The Same Way OK, there’s your first clue. For Pricing Example 1 for each of the larger quantity cells we are using the same pricing theory,. But instead of increasing the price by 10%, we are decreasing it by the same amount. Remember, this is just a demonstration.
32
© 2018 Marshall atkinson consulting, llc
Made with FlippingBook - Online catalogs