DealersEdge Professional Forums

by **MR PARTS** » Mon Apr 13, 2009 2:57 pm

Does anybody have a good template for forecasting?

by **texaslp** » Mon Apr 13, 2009 3:07 pm

Yes, it looks a lot like a dart board.

by **Darrell Langford** » Mon Apr 13, 2009 3:25 pm

We use the last 3 months and same month last year, take an average and add 8%.

by **KevvyG** » Tue Apr 14, 2009 7:49 pm

Well, I get out my darts and my rubber chickens, throw a few darts at the board, do a voodoo dance with the chickens and sacrifice a bottle of 5W20 synthetic...lol. Actually, I pretty much use the same formula as Darrell except I add 10 points instead of 8. Cheers!!

by **westover6** » Thu Apr 16, 2009 11:46 am

Dang I never even thought of the dart board!!!!!

by **bterbo1** » Thu Apr 16, 2009 12:10 pm

Are you looking for something to build a forecast for an entire year - based on historical performance data? Such as: Repair Orders by pay type, Hrs per RO by pay type, ELR by pay type, planned RO growth by pay type and parts to labor ratio by pay type?

If that is the type of forecast you are considering I have a good template that has been tweaked over the last 10 years. You can email me at bterbo1@yahoo.com and I will email it to you.

FYI - I am not a consultant (not trying to sell anything) - I am a FOD for a large dealer group.

DealersEdge Professional Forums

Forecasting

Forecasting

Forecasting

Forecasting

Forecasting

Forecasting

Forecasting

Who is online