price for profit
=SUM(B7*0.9) This is the formula we are using in this example to decrease the base price by 10% for the quantity discount. One thing to remember is that most of the cost of running the shop is tied up in the Downtime . The more you print, the more money your shop is making. The economy of scale kicks in and your costs drop the longer you keep your presses churning without stopping. For larger quantities for this example Price List each cell below the next decreases in price based on a 10% drop.
Click the cells B9 , B10 , and B11 and review how the formula changes for each.
So now that we have the 1 color column set, let’s take a look at how multi-color prices are constructed.
Multi-Color Pricing Just like with our 1 color, the multi-color base price uses a Keystone Cell as well. Let’s shift over to Column C and take a look at how this is constructed.
When you click on cell C7 it has a more complicated formula.
=SUM((B14 + (B15*C2))*1.3) If you are not familiar with spreadsheets that looks like a leftover math quiz question from high school. Yikes!
Let’s break that down so it’s easier to understand.
33
© 2018 Marshall atkinson consulting, llc
Made with FlippingBook - Online catalogs