For those who are interested I put together another spreadsheet
.
One that you can save to your own PC and plug in your own numbers to easily see the big picture. All you have to do is click on the attachment (
the attachment at the bottom... not the screenshot) and do a Save As to your local computer, the only requirement is that you have Microsoft Excel on your PC to open the file. (The spreadsheet is small but I had to ZIP it as XLS was not a valid file format for attachment. When you save the file just double click on it to extract the spreadsheet)
The spreadsheet is protected so you cant accidentally overwrite the formulas. There are 3 cells for you to enter numbers. The 3 cells are in
RED.
How to use:
Step 1 - Figure out what your price per 1/8th will be for your particular product. Enter it in the cell and all the numbers adjust automatically.
Step 2 Figure out how many lbs. you can produce per grow and enter it in the cell
Step 3 Figure out how many grows you can do per year and enter it in the cell.
How to read the spreadsheet.
In my example screenshot $50 is the price for 1/8th. As you can see
if you sold a pound in quantities of 1/8th then you would make $6400 per lb. Obviously if someone were to buy a whole pound you would want to give them a price break. If you were to give them a 50% break you can see the price for the lb. would be $3200.
The 2nd chart is meant to help you predict per grow and annual earnings with given discounts. Lbs. per grow is for you to enter how many lbs. you pull per grow. In my example I used 1.25 to demonstrate how you would enter portions of a lb. In my example the grower produces 1 & ¼ lb. per grow cycle and does 2 grows per year. If the grower gives a 20% discount for their product they would make $12,800 /yr.
Personally I only grow a couple of ounces per grow and I dont sell so I have no actual experience in the whole wheeling and dealing thing. This chart is meant for those that are so inclined to peddle their wares
but have trouble figuring out the numbers.
Happy growing
HERE'S THE ATTACHMENT:
View attachment Price2.zip
