Replies

1. 
   BobKovacs | Dec 10, 2002 03:30am | #1

   Kuhls-

   Give me a little more info on what you'd like to accomplish with the sheet, what types of jobs you do, etc., and I can put something together for you in Excel. 

   Bob Kovacs

   http://www.constructivesolutions.org

1. 
   kuhlsinc | Dec 10, 2002 11:41pm | #3

   We are a high end remodeler that has taken off. We are sustaining our growth and are constantly trying to make sure our growth doesn't get out of control. It seems that at every turn we are re-inventing the wheel. I know that there is a program out there that would work for us. We have looked at a couple of them but the all seem to be so damn complicated and have way too many bells and whistle that I really don't need. (who needs the exchange rate in Japan)

   So I was hoping to have a program that would be simple.

   Job balance sheet:

   (accounts receivable)

   job total

   payment schedule

   change orders (dates and discriptions)

   deductions (money off planned receivables)

   (accounts payable)

   all payments to vendors

   all payments to subs (sub listed by trade)

   labor weekly

   all of the payables should be broken down by bid and actual.

   This is a very rough idea of what I was thinking, and I'm sure that I will evolve it constantly.

   I appriate any advice that you may have or help me with.

   If you need any more info fell free to e-mail me at [email protected]

   Thanks alot

   Dan

2. 
   riverr1 | Dec 10, 2002 06:41am | #2

   Geeesh guy, what do you expect if you use a Mac. Who wants a computer that is virus free, easy to use, has killer graphics and doesn't have to get plowed off of some cliff every couple of years because of upgrades. Damn, you must be a liberal and I bet you voted for Brown????

   ;-)

   Don

3. 
   BossHog | Dec 11, 2002 01:43am | #4

   I've attached an excel spreadsheet I used to estimate the cost of a spec house I built recently.

   It probably isn't exactly what you're looking for, but it's pretty detailed, and might give you some ideas.

   Give light and the darkness will disappear of itself.

4. 
   buzbldr | Dec 11, 2002 10:03pm | #5

   Kuhls

   I developed a job costing spread sheet for myself in XL and for my purpses works great. Most of the stuff you asked it to include is not included in mine (but sounds like where I am heading with mine).

   I have used an XL discussion group extensively to get the formulas I needed.

   http://www.mrexcel.com/board/viewforum.php?forum=2&45371

   These guys/gals are extremely knowledgable and willing to help. You need your basic layout developed and then have to ask for the formulas you require.

   I have been developing mine for about six months now. I have three databases for hours,materials,subs. These databases are turned in to PivotTables which extract data based on employee time (for payroll purposes), customer hours (total hours on job by employee and total), materials per customer, subs per customer etc etc. Every friday evening I sit down for about an hour and input to the databases from employee time cards, invoices from suppliers, invoices for subs. Then all I have to do is bring up Smith.xls (customer invoice) and all totals are automatically updated from the databases. Likewise for payroll purposes, I change two dates and all employee time is computed, automatically multiplied by wage and viola (sp) payroll amounts are ready for the bookkeeper. I have to manually insert draws paid for the month, but then, this 'developing' idea is still developing. Probably never reach conclusion as ideas for change are constant.

   If you would like a sample of the workbook email me. buz[nospam]@seasurf.net Be sure and delete the [nospam] :-)