Register free!
Search
 
     

Click for Weather
Reply
 
Thread Tools Display Modes
  #1  
Old 03-11-2006, 06:21 PM
TheHotShotKid TheHotShotKid is offline
LawnSite Member
 
Join Date: Feb 2006
Location: Ohio
Posts: 169
spreadsheets

How are you using them in your lighting business?
Reply With Quote
  #2  
Old 03-11-2006, 10:34 PM
TheHotShotKid TheHotShotKid is offline
LawnSite Member
 
Join Date: Feb 2006
Location: Ohio
Posts: 169
Anyone using spreadsheets?
Reply With Quote
  #3  
Old 03-12-2006, 08:30 AM
Mike & Lucia Mike & Lucia is offline
LawnSite Member
 
Join Date: Jun 2005
Location: Millington, NJ
Posts: 66
Smile

I can't live without my Excel spreadsheets! I have built templates to calculate cost and pricing for project installation. It allows me to change fixture types, models, markups, etcetera. I can adjust my overall gross profit to be more competitive if necessary or increase the margin if there is reason for that, also. Knowing exact cost allows me to "see" what I can and can't do with the final price. I rarely adjust quoted price at a closing meeting, however, if it is a multiple phase project, I can discount in order to incent client to sign for more work. This idea is based on lower cost to mobilize crews, efficiency in ordering materials, and better planning, all of which save me real dollars as opposed to breaking the job into separate pieces.

I also have my secretary keep my most often used products in a different spreadsheet with their most recent price changes. This allows me to have MY pricing at my fingertips, on my Palm Pilot, at all times. We will also use this template to place an order with our distributors by fax, eliminating errors. Easy for us and they love it because we include part numbers. We ask them to attach a copy of the fax (purchase order) to our invoice, which goes a long way to streamlining her work in the office.

Another way we use spreadsheets is after the project is complete. Taking copious notes in the field, allows me to compare my actual cost, as-built, with my proposal. Sometimes we'll spend a bit more time or wire than originally planned, sometimes less. It keeps us close, and allows for better planning on each subsequent project.

Bottom line: I'm a student of cost-accounting. With out spreadsheets, I'm a fish out of water!

Mike

PS: I noticed you re-posted your query. It is frustrating when a good question goes un-answered. I thought we would get a good exchange going on my post regarding service / maintenance agreements and Paul was the only member to respond. Maybe some will take a second look at my post, however it has fallen back a page or two.
Reply With Quote
  #4  
Old 03-12-2006, 08:38 AM
Flow Control's Avatar
Flow Control Flow Control is offline
LawnSite Bronze Member
 
Join Date: Jan 2006
Location: Ohio/Florida
Posts: 1,273
Hey Kid,

I have family in Ohio, what part are you from?
Reply With Quote
  #5  
Old 03-12-2006, 11:03 AM
TheHotShotKid TheHotShotKid is offline
LawnSite Member
 
Join Date: Feb 2006
Location: Ohio
Posts: 169
Mike and Lucia would you mind sharing with us the program that you use for spreadshhets. By chance would it happen to be Microsoft Excel?
Reply With Quote
  #6  
Old 03-12-2006, 11:16 AM
Flow Control's Avatar
Flow Control Flow Control is offline
LawnSite Bronze Member
 
Join Date: Jan 2006
Location: Ohio/Florida
Posts: 1,273
That would by far be the most generous thing of all time since others are selling isimilar programs for 100usd. What part of Ohio are you from Hot Shot.
Reply With Quote
  #7  
Old 03-12-2006, 08:57 PM
SamIV SamIV is offline
LawnSite Senior Member
 
Join Date: Jul 2002
Location: Southern LA
Posts: 325
He's not from Ohio, he's from New Jersey.

Sam IV
Reply With Quote
  #8  
Old 03-12-2006, 09:13 PM
NightScenes's Avatar
NightScenes NightScenes is offline
LawnSite Silver Member
 
Join Date: Dec 2005
Location: Kingsland, Texas
Posts: 2,192
Quote:
Originally Posted by SamIV
He's not from Ohio, he's from New Jersey.

Sam IV
I was thinking of a place much much much hotter that New Jersey, if you know what I mean. I love this ignore feature!!
__________________

Paul R Gosselin, Sr., CLVLT(#0632)
NightScenes Corporation
President, AOLP
www.night-scenes.com
www.facebook.com/NightScenes
Reply With Quote
  #9  
Old 03-13-2006, 12:06 AM
Pro-Scapes's Avatar
Pro-Scapes Pro-Scapes is offline
LawnSite Platinum Member
 
Join Date: Apr 2005
Location: South Mississippi
Posts: 4,224
Quote:
Originally Posted by TheHotShotKid
Mike and Lucia would you mind sharing with us the program that you use for spreadshhets. By chance would it happen to be Microsoft Excel?

Quote:
Originally Posted by Mike & Lucia
I can't live without my Excel spreadsheets! .
If your not going to take the time to READ someones reply when you start a thread dont start it.

BTW that was great info mike. Would it be possible to email me a copy so I can see your layout so I can customize it for me ?
Reply With Quote
  #10  
Old 03-13-2006, 07:35 AM
Flow Control's Avatar
Flow Control Flow Control is offline
LawnSite Bronze Member
 
Join Date: Jan 2006
Location: Ohio/Florida
Posts: 1,273
Quote:
Originally Posted by nightscapespaul
I was thinking of a place much much much hotter that New Jersey, if you know what I mean. I love this ignore feature!!
I was thinking big
Reply With Quote
Reply

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 ©1998 - 2012, LawnSite.comô - Moose River Media
All times are GMT -4. The time now is 02:40 PM.

Page generated in 0.09997 seconds with 7 queries