price for profit
Does this guarantee that the shop will make $50,000 at the end of the year? Of course not. However, it does add that into the Cost per Impression so you can set up and fund an account. Change your Profit Goal Total So, let’s say you don’t want $50,000 to be your profit goal for the spreadsheet. Maybe you want it to be $25,000 or $100,000. What do you do then? Easy. Simply select the cell B31 so that the formula shows in the area like in the above example. Then change the numerator in the formula to the profit goal you want to use.
For example, let’s say the shop wanted to use $100,000 instead of $50,000. Click B31 , so the formula shows in the area at the top.
Choose 50,000 and change to 100,000.
In our example, the formula changes the result in cell B31 from $0.05 to $0.09 per impression.
Remember, if you use the Cost per Impression total from the previous years average as the basis for your pricing, and include the Profit Bucket number in your pricing calculations, you will need to hit at least the same number of impressions to achieve your goal.
Looking at our calculations from the worksheet we can now see:
Overhead .............. Consumables....... Labor..................... Energy...................
$0.04 $0.04 $0.38 $0.02 $0.48
Total..
Profit Bucket.......
$0.09
Cost Per Impression $0.57
19
© 2018 Marshall atkinson consulting, llc
Made with FlippingBook - Online catalogs