price for profit
Once we get the Keystone Cell populated, the rest of Column naturally falls into place.
Like in previous examples, we’ll need to edit the Keystone Cell for each column on the spreadsheet so the pricing for each additional color will be correct. This is simply a matter of adding the value from B16 into the formula for each column Keystone Cell .
To do this, click on cell C7 . The formula currently is: =SUM((B14+(B15*C2))*1.3)
We’ll need to add in B16 , so it uses the Extra Charge value in the calculation. All we need to do is to add that into the formula so it reads: =SUM((B16+B14+(B15*C2))*1.3) We’ll do this for the rest of Row 7 so that each Keystone Cell in each Column has the correct formula. What interesting about this third number is that you can use that for adding in any extra cost or circumstance you wish. It, of course, doesn’t have to be $0.35.
The sky is the limit on what that Extra Charge could be. Maybe it is just a few pennies. Maybe you could use it for an added fee for walk-in traffic, or an online store.
Play around with it and discover how it can work for your shop.
43
© 2018 Marshall atkinson consulting, llc
Made with FlippingBook - Online catalogs