Register free!
Search
 
     

Click for Weather
Reply
 
Thread Tools Display Modes
  #1  
Old 12-07-2010, 03:05 PM
aksobe aksobe is offline
Junior Member
 
Join Date: Oct 2010
Location: Juneau, Alaska
Posts: 10
Snowplow bid estimate calculator

It has not snowed any decent amount in my area yet, so I have had some spare time on my hand. Here is a little calculator I wrote that will estimate costs for those of us who only plow one truck with no employees.

This is for estimating ONLY. After calculating equipment costs per hour, factoring in office costs, insurance, and other expenses, It will spit out an estimate of your costs per hour all based on the amount of billable hours you get per year (number of storms times billable hours per storm). You can enter the amount of profit you would like to earn. The very last section of the calculator will let you estimate a bid by entering the time you spend plowing an area, and the time it takes to drive there.

There are 3 sections and all must be filled out in top to bottom order.
You have to expand the last two sections to see them.

If people like this, I can build more complicated calculators that factor in employees, other trucks, sanding, ect ect.

If you have any questions or suggestions, or just criticism, by all means please post your thoughts below!

If you would like me to edit this calc to customize it for you, add a field or two, let me know, maybe I will find some free time and just do it for you!

Here is the link

http://www.snow-2-go.com/plowcalc/snowcalc.htm

________________________________________________
David - Snow-2-Go
1999 F250 superduty xcab with 7'6" trippedge snow-way plow with downpressure and wireless controller
2000 F250 superduty single cab with 8'2" Boss V-blade plow
John Deere 410 14,000 lb backhoe loader

Last edited by aksobe; 12-07-2010 at 03:37 PM.
Reply With Quote
  #2  
Old 12-07-2010, 03:19 PM
aksobe aksobe is offline
Junior Member
 
Join Date: Oct 2010
Location: Juneau, Alaska
Posts: 10
employees and more equipment

if you have employees and more than one truck you can still use this calculator. when entering plow and truck costs add up all the trucks and enter the number. for example under cost to replace truck add up all your trucks (15,000 + 20,000 + 18,000) and enter the total.

Under Hourly wage owner should make enter the total you and your worker should make (for example you want to make 25 per hour plus 2 workers at 25 an hour = 75 per hour.

remember to multiply prep time by the number of workers you have

the field "Minimum you should change per hour to break even" will be invalid (to make it valid, add the total amount you are paying your workers (in the above example, 50 bucks)

________________________________________________
David - Snow-2-Go
1999 F250 superduty xcab with 7'6" trippedge snow-way plow with downpressure and wireless controller
2000 F250 superduty single cab with 8'2" Boss V-blade plow
John Deere 410 14,000 lb backhoe loader

Last edited by aksobe; 12-07-2010 at 03:37 PM.
Reply With Quote
  #3  
Old 12-07-2010, 03:55 PM
REAPER's Avatar
REAPER REAPER is offline
2000 Club Member
 
Join Date: Nov 2004
Location: 60050
Posts: 2,230
Pretty slick and looks easy to use.
__________________
Rock w/plow, salt shaker and vinegar.
Wicked Warnings Wired!
Reply With Quote
  #4  
Old 12-07-2010, 04:06 PM
Jguck25's Avatar
Jguck25 Jguck25 is offline
Senior Member
 
Join Date: Oct 2009
Location: USA, New Hampshire
Posts: 495
Very very cool . I like that. Im probably going to use that in the future.
Thanks for helping everyone out
__________________
2005 F350 Diesel-fisher XLS
Fisher 1.5 Yard Polycaster
2003 Warren aluminum 2 yard sander
1999 F350 Turbodiesel Dump 9' Fisher MM1
1999 Hi-Way 2.5 yard sander
2002 F250 5.4 extended cab short bed-9.5' XtremeV


Reply With Quote
  #5  
Old 12-07-2010, 04:25 PM
Fatality's Avatar
Fatality Fatality is offline
Senior Member
 
Join Date: Jul 2009
Location: Normal, IL
Posts: 211
Very cool! Great work!
__________________
Changing Seasons Lawn and Landscape, LLC
Reply With Quote
  #6  
Old 12-07-2010, 05:29 PM
aksobe aksobe is offline
Junior Member
 
Join Date: Oct 2010
Location: Juneau, Alaska
Posts: 10
Hey by the way the software I am using for this costs $250-$300 depending on version. I have the 30 day trial. If you cant or do not want to donate, please give me some feedback on what to change.. spelling errors... more fields... more calculations... errors... ways to simplify... whatever. If I get enough interest I will buy the software and keep updating this calculator... otherwise I would like to polish it up before the 30 days runs out. The tool has definitely helped me understand my costs and I would love to have a peer-reviewed version. Thanks for the interest guys!
__________________
________________________________________________
David - Snow-2-Go
1999 F250 superduty xcab with 7'6" trippedge snow-way plow with downpressure and wireless controller
2000 F250 superduty single cab with 8'2" Boss V-blade plow
John Deere 410 14,000 lb backhoe loader
Reply With Quote
  #7  
Old 12-07-2010, 05:35 PM
Propony Propony is offline
Member
 
Join Date: Nov 2009
Location: Rolling Meadows, IL.
Posts: 54
Very cool.
__________________

Professional Snow & Ice Management
Palatine, IL. 60067
Reply With Quote
  #8  
Old 12-07-2010, 10:42 PM
aron7676 aron7676 is offline
Junior Member
 
Join Date: Dec 2010
Location: Kansas City, MO
Posts: 20
Suggestion!

I think that adding in a Salts and Sands section would be nice.
Maybe input the price you pay for material, time spent loading/driving to site, and how much is spread per plow. Oh and of course your profit margin.


Edit:
I think that having a version of this calc available for smart phones would be advantageous for me. I'm sure I'm not the only one.
I could attempt to get one working on android. I'm still a noob programmer.

Last edited by aron7676; 12-07-2010 at 10:44 PM. Reason: additional Idea.
Reply With Quote
  #9  
Old 12-07-2010, 11:08 PM
EvenCutLawnCare EvenCutLawnCare is offline
Senior Member
 
Join Date: Aug 2008
Location: West Plains, Missouri
Posts: 207
Any way to add in fuel costs? Looks like a great tool!!!
Reply With Quote
  #10  
Old 12-08-2010, 03:06 AM
aksobe aksobe is offline
Junior Member
 
Join Date: Oct 2010
Location: Juneau, Alaska
Posts: 10
Quote:
Originally Posted by EvenCutLawnCare View Post
Any way to add in fuel costs? Looks like a great tool!!!
Fuel cost is already in the calculator under truck expences. Should ask for the amount you spend on fuel weekly.
Reply With Quote
  #11  
Old 12-08-2010, 07:04 PM
aron7676 aron7676 is offline
Junior Member
 
Join Date: Dec 2010
Location: Kansas City, MO
Posts: 20
Lightbulb smartphone app

If there is any intrest at all, I will try and whip the app out asap, otherwise, I doublt I will ever get to it.

If aksobe would send his source code to me @ aaronhurst.tech@gmail.com, I could make it almost match this online version. I would have this app in the free category of the market, or I would share an activation code with this forum. Id only price it at a dollar or something with a trial version available.

Thanks guys.

Last edited by aron7676; 12-08-2010 at 07:07 PM. Reason: spelled a name wrong
Reply With Quote
  #12  
Old 12-08-2010, 07:43 PM
aksobe aksobe is offline
Junior Member
 
Join Date: Oct 2010
Location: Juneau, Alaska
Posts: 10
OK, I made a sanding/salting version of the calculator. http://www.snow-2-go.com/sandcalc/sandcalc.htm
__________________
________________________________________________
David - Snow-2-Go
1999 F250 superduty xcab with 7'6" trippedge snow-way plow with downpressure and wireless controller
2000 F250 superduty single cab with 8'2" Boss V-blade plow
John Deere 410 14,000 lb backhoe loader
Reply With Quote
  #13  
Old 12-09-2010, 10:45 AM
A.M. Landscape A.M. Landscape is offline
Junior Member
 
Join Date: Jan 2010
Location: Lake Zurich, IL
Posts: 13
Smart Phone App

I would be very interested in a smart phone app for this. I think it would be very helpful. I tried it out and it seemed to work well. Great job aksobe!
__________________
--
Andy -- A.M. Landscape & Design LLC
1999 F-250 SuperDuty 4X4 5.4V8 w/ 8.5' Western Pro and Wings & Swenson Vbox
1995 Dodge Ram 1500 4X4 5.9V8 w. 8' Western Pro & SaltDogg Tailgate Spreader
1996 Chevy K3500 Dump w/ Swenson Vbox
2001 GMC C2500 w/ 7.5' Boss V
2000 Ford F350 SuperDuty w/ 8' Western
2000 Chevy K2500 w/ 8' Western
1995 Dodge Ram 2500 4x4 w/ 8' Western Pro and Wings
Bobcat 751 w/ bucket and blade
Many tailgate spreaders
10 Toro Snowblowers
Reply With Quote
  #14  
Old 12-09-2010, 11:26 AM
Holland's Avatar
Holland Holland is offline
Senior Member
 
Join Date: Aug 2010
Location: Galena, IL
Posts: 605
Very Nice!
__________________
2003 GMC 2500HD REGULAR CAB DURAMAX
Western Ultramount 8 1/2 Ft Pro
1994 GMC SONOMA >>>SUPERCHARGED LS IN THE WORKS<<<
5.7L 5 SPD http://www.youtube.com/watch?v=yufWPxZ83JQ
2014 HONDA PIONEER 700-4
2011 HONDA RANCHER 420 AT
Reply With Quote
  #15  
Old 12-09-2010, 11:51 AM
aron7676 aron7676 is offline
Junior Member
 
Join Date: Dec 2010
Location: Kansas City, MO
Posts: 20
Okay, I will start working on It over the weekend. It may not be as fancy as his, but if he shares his code, I will have the same equations.
Reply With Quote
  #16  
Old 12-10-2010, 03:55 PM
gus1234 gus1234 is offline
Junior Member
 
Join Date: Dec 2010
Location: Eau Claire Wisconsin
Posts: 7
could you put somethig togeather for snow blowing.
Reply With Quote
  #17  
Old 12-15-2010, 07:51 AM
Ferrisdiesel Ferrisdiesel is offline
Member
 
Join Date: Dec 2008
Location: West Warwick, RI
Posts: 32
A smart phone app would be totally awesome!!!
Reply With Quote
  #18  
Old 12-15-2010, 08:53 AM
aron7676 aron7676 is offline
Junior Member
 
Join Date: Dec 2010
Location: Kansas City, MO
Posts: 20
app

Im working on it. getting the screen to allow that much info is a little challenging, but Im working on it. I havent made a multi page app before :/

Having snow ovetr the weekend and finals yesterday and tomorrow arent really helping me out
Reply With Quote
  #19  
Old 12-15-2010, 12:16 PM
aksobe aksobe is offline
Junior Member
 
Join Date: Oct 2010
Location: Juneau, Alaska
Posts: 10
Aaron,

I already have a iphone app designed and polished, just waiting admission to the appstore at apple.

There is also a smartphone web based version.

Please do not try and use my source code.

Thanks, Dave
__________________
________________________________________________
David - Snow-2-Go
1999 F250 superduty xcab with 7'6" trippedge snow-way plow with downpressure and wireless controller
2000 F250 superduty single cab with 8'2" Boss V-blade plow
John Deere 410 14,000 lb backhoe loader
Reply With Quote
  #20  
Old 12-20-2010, 06:08 PM
Ferrisdiesel Ferrisdiesel is offline
Member
 
Join Date: Dec 2008
Location: West Warwick, RI
Posts: 32
Thumbs up

I used both of these calculators the other day and it really made life alot easier. I added on a little extra, but other than that it was very close to what I was thinking. I cannot wait til you make up the smart phone app! What a great idea!
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump





Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012 PlowSite.comô Moose River Media
All times are GMT -5. The time now is 03:45 AM.

Page generated in 0.05019 seconds with 7 queries