price for profit
Keystone Formula Let’s take a look at the formula for cell B7 . You will need to decide if this formula works for your shop. It can be found near the top of the spreadsheet in the formula area. =SUM(B14+B15)*1.3 This means we are adding together the figures in cells B14 and B15 and then multiplying them by 1.3 .
Here’s the decision for you. 1.3 represents a 30% markup on your costs. If in your shop you use a higher or lower rate, here is where you would change it. For example, let’s say you want to use 50% as the markup instead. Just change 1.3 to 1.5 in the formula area. This represents your baseline price.
So for the Pricing Example 1 , for the quantity 144-299 the price for a 1 color screen-print location would be $0.94. This is the baseline charge that all of the other prices on the spreadsheet will use for their calculations. Make sure for your Price List that this is the price you are comfortable in charging your customers. Remember, this is based on your actual costs. If the number in B7 seems too high, based on what you have been charging that could explain why you aren’t making the money that you think you should be. You just aren’t charging enough.
With me so far? Good.
Price Increase for Ordering Less The next concept to review is that as the quantity decreases, we want to charge more. As this is a spreadsheet, we can do this easily
31
© 2018 Marshall atkinson consulting, llc
Made with FlippingBook - Online catalogs