3/29/2021 1:03 PM
in reply to
James Smith
James,
I have a couple of simple excel spreadsheets, One I use as a program guide, the other I use as a price guide which gives me a budgeted amount. I have the math setup in it, I just enter the number of cases or bags, and change the price when I need to. It will calculate my costs. If I was really good, I would figure out how to tie in my program spreadsheet with my budget sheet and they would populate from one to the other.
I attached the form I use, I left a couple of prices in there to show what it would look like, you would just put the price in for your product and the number required and it should give you a total cost. You can also just type in your products in the first column.
I can attach my preliminary program, of course, I use mostly that as a guide, dates aren't always the same.
Any questions just let me know.
Mel
Melvin H. Waldron III, CGCS, Horton Smith Golf Course, City of Springfield/Greene County MO