price for profit
The new (wrong) formula looks like this =SUM((C14+(C15*H2))*1.3).
Cells C14 and C15 are empty. Cursor over the “C” in the formula and change that to a “B” so it reads =SUM((B14+(B15*H2))*1.3) instead.
Now the math works.
So in our example, the Keystone Price for a 7-color print for quantities of 144-299 is $2.57 for the decoration. Remember, this is added to the marked up shirt cost. To fill out all the other colors, just repeat the steps above. Google Sheets will replace the “B” in our pasted formula with the column the cell is in. You just need to edit it back. Here’s a show of how that might look for that filled out row:
39
© 2018 Marshall atkinson consulting, llc
Made with FlippingBook - Online catalogs