price for profit
Remember, B14 is our Cost Per Impression number. In our example, that’s $0.51.
The Screens + Overtime number is B15 , and that’s $0.21 in the example. But now, we are doing a multicolor job with two screens. Therefore, the formula grabs the number from C2 to use as a multiplier for the number in B15 .
In this case, that’s $0.21 for B15 x 2 for C2 = $0.42.
Let’s look at this again. $0.51 + $0.42 = $0.93.
We need to add some markup right? It works the same way as before with adding a 30% markup. Remember you can increase or decrease this amount.
$0.93 x 1.3 = $1.21.
Bingo. The wonderful thing about spreadsheets is that it will do the math for you if the formula is set up correctly.
All of the other Keystone Cells in Row 7 work the same way. They use the screen count number in Row 2 as the multiplier for the Screen + Downtime number from cell B15 . This method goes all the way across Row 7 with the functionality in the formula.
34
© 2018 Marshall atkinson consulting, llc
Made with FlippingBook - Online catalogs