price for profit
A simple formula that you might use would be something like this: (Shirt Cost x Mark Up %) + (Decoration Fee) + (Screen Charge) + (Extras) = Quoted Price This is a typical Cost Plus type formula for calculating the price to quote your customer. Let’s play this out with some math that we have been working on and see if looks ok.
Our example quote is for 200 Yellow T-shirts. One color on the left chest and three colors on the back.
The shirts for the job are standard issue 100% cotton, and cost $1.87 from a major distributor. In our example, we mark up the shirts 40%, so the blank cost is $2.62 now.
Our example shop charges $20 per screen, so 3 x $20 = $60. $60/200 shirt quantity = $0.30.
Using the Pricing Example 2 from the template, the one color left chest is $0.94, and the three color back is $1.48. Total Decoration Fee is $2.42. So using that same formula: ($2.62 Shirt) + ($2.42 Decoration) + ($0.30 Screens) + ($0.00 Extras) = $5.34 quoted price
But the great thing about this quote is that the math we’ve used to build it is based on the shops data and numbers.
If you have built out your spreadsheets, use a few jobs that you have taken and requote themwith the new system. Do an assortment. Easy jobs. Hard jobs. Small quantity jobs. Ones on darks. Maybe a few sweatshirts, bandanas, or jacket orders.
Get a good mix. If the Price List doesn’t seem right, tweak it until you dial in the numbers by adjusting a few things.
Instead of writing over a worksheet, I would highly recommend Duplicating a baseline one, and then modifying that. For a refresher, this is easy to do. At the bottom of the spreadsheet you’ll see the Worksheet tab names.
46
© 2018 Marshall atkinson consulting, llc
Made with FlippingBook - Online catalogs