Woodworking Business Forum

You are not logged in. [ Login ] Why log in
(NOTE: Login is not required to post)

Tracking Jobs

5/8/16       
Nick Cook

I'm a shop of 5 full time and me. Is there a
a software recommendation for taking a job from site measurement to final cabinet job delivery? I have a person who takes site measurements and a person who enters the design into our software for output to the shop. I don't have a cohesive way of collecting and distributing all the data. I'm interested in a step to take, that gets us away from paper and allows everyone access to the information they need. We use a CNC machine and finish our own cabinetry. We are primarily a Face Frame shop but are moving more toward frameless. Also mostly residential.

5/8/16       #2: Tracking Jobs ...
Pat Gilbert

There are a number of ERP solutions, I would highly recommend that you don't waste your resources on these.

Just get some app that works on your smart phones and analyze the data as best you can with a spread sheet or a simple data base.

5/8/16       #3: Tracking Jobs ...
Gary B.

Nick,

Out of curiousity, what is your engineering software now? The best system is the simplest one that handles all the requirements...For you that may mean something like evernote in the cloud, or a master spreadsheet.

I would sit down in and think for a few minutes about what exactly you want to track, and where you need this information. Likely it's a lot more then you realize at first glance.

Another thing worth mentioning is opportunity cost. Let's assume that you make a great product, and have excellent customer service, at a price your market is willing to pay. Putting GOOD systems in place today that can scale with your company with your company will pay huge dividends in the future.

I would suggest you take a hard look at a database driven system. In fact, if you're at all comfortable with computers, it will pay off in the long run to create your own database driven application. FileMaker for macs, or Access for Pc's make it pretty easy for almost anyone to create a suitable program for their business. Templates abound for Access (and likely FileMaker, I just don't use Macs), and it's completely user definable.

The cost of something like this is simply time...but you'll get exactly what you want.

5/9/16       #4: Tracking Jobs ...
Nick Cook

At this time we put job site measurements on paper, these we input to cabinet design software. Prior to job site measurements we meet with a potential customer to determine the particulars for that customer (wood species, door style, finish type etc). After all this is collected it has to be disseminated to the production floor and go through the shop. The Access approach your talking about would be good for pulling all this together? I'm looking for something to get from the initial meeting with a customer all the way to a final checklist after install and do it better than I'm doing it now. Right now it's a lot of paper and not so much in the computer for everyone concerned to easily access. I've tried three ring binders with all the information but I'd like something better.

5/9/16       #5: Tracking Jobs ...
Gary Balcom

Nick,

OK, I see that is all your interested in tracking....what about job specific materials and the related PO's, Time tracking, and estimated vs Actual project times after the fact, email correspondence, etc.

If that is all you need to track, the simplest would be to use something like evernote to keep it all organized, or Bluebeam (a PDF software)...

I like Bluebeam because it is super simple, and you can just pull all the information together as 1 master PDF per project. But, it's not a database.

5/9/16       #6: Tracking Jobs ...
Nick Cook

Gary,

Can you search within the Bluebeam software?
Also, let's say one of our team is on a job site taking measurements for a job. How would he use Bluebeam? Would he have a laptop or tablet and input the information? Then let's say I have the shop drawings for the assembly of cabinets that I created in the design software. These drawings are saved to the Bluebeam also? So Bluebeam is just a place to put everything in a folder?

5/9/16       #7: Tracking Jobs ...
pat gilbert

Nick

Gary talks about opportunity cost. In your search ERP software will appear to be the solution. But the opportunity cost is big, and your likely hood of success is small.

I went to a NASFM meeting about estimating. I was on a break having a smoke and another shop owner told me he went to this same seminar 5 years earlier and everyone was abuzz with buying ERP software. Then 5 years later no one was talking about it and they were all back to spread sheets.

I wish I had this piece of information before I had bought the ERP software I had bought. As the opportunity cost was high and was not worth it.

I do remember one guy said was worth it but he worked for a very large company with thousands of employees.

I would think more along the lines of a simple Lean type solution.

5/9/16       #8: Tracking Jobs ...
Gary Balcom

Nick,

Bluebeam is available on an Ipad, or a tablet. If you subscribe to Bluebeam Studio (which is free in it's basic form), you can interact with others on the same PDF. So, you can have people onsite marking up drawings, while someone is at the office, looking at the same set.

An easy way to think of it is that bluebeam can be the glue that holds all this information in one place...you can add photos, shop drawings, emails, even scanned notes into one file that describes everything about that project. Or several files, it's really up to you.

5/9/16       #9: Tracking Jobs ...
robert

If you are just talking about managing the process try Trello, Evernote, or Wrike. If you have to process data then your talking about something like Access, File Maker, or Excel.

5/9/16       #10: Tracking Jobs ...
Jay  Member

Website: http://www.hwccustomcabinetry.com

Nick,

I can appreciate your situation! The responses here are good. Developing a scaleble system is the right answer, not something you will likely do in an hour or two, or a simple reply from one of us here, though hopefully we stimulate your thinkng. As we have grown from a couple man shop to about 10 of us now, we are continuing to refine our system of these very processes you mention.
Lot's of pieces to the puzzle as you know, but i would avoid ERP as Pat mentioned, at least at our small sizes.
We use a blend of Business Partner software for Estimating, which also generates reports needed for ordering special items, finishes, materials specified for the job, and other details. This coupled with KCD shop & install drawings and CNC code (through Cad-code, not one button) gives us most of the shop/install info we need to keep track of.

We have not found a PC solution yet that communicates the big picture things well (Visually). We use a 4x8 magnetic marker board to track big picture job status and communicate key milestones to different 'departments', while allowing me to manage the business. Watching some lean flow videos has been helpful in identifying how this board should be laid out, and what info to keep on it.

Paul Akers 2 second lean stuff has been helpful to keep us looking for strong visual controls and not get wrapped up in 'cool' techno stuff that does not really fit.

FWIW, my employees have come up with some of our best solutions as I have tried to encourage them in identifying problems (things that bug them) and making improvements!

Best to you Nick!

5/9/16       #11: Tracking Jobs ...
robert

Here's a Trello example of a manufacturing process from A to Z. What I like about Trello is that the free version is quite robust and the pay version is inexpensive. Everyone on the team access it on computer, tablet or phone and you can set parameters who can can what. You can upload any documents you want for team reference. What I like most is everyone is on the same page and knows the status of the project.

https://trello.com/b/5TYY4ru5/manufacturing-pipeline

Trello

5/9/16       #12: Tracking Jobs ...
ranliker

if you're looking at Trello or Evernote, look at MS OneNote as well. I liked it better than Evernote when I compared both, but that's been a couple of years ago. Trello was intriguing, but we have Onenote going well and didn't think it was worth the time to really investigate and/or change over.

We also use MS Access. It seems to me that you will need some Visual Basic to get it really the way you want it. I think it takes a good bit of effort to get it where you want it. I haven't done much to ours for a few years; it's time I go back in and clean things up and get it to better match where we want it. But it is a very powerful program. My $0.02 and I hope I didn't overcharge!

5/9/16       #13: Tracking Jobs ...
Nick Cook

Thanks for all the good ideas. So basically anyone that has to input data (job site measurements, info from meeting with a customer etc) inputs to one of these platforms and then anyone with access to the job file can see the information. So I would need to buy tablets or lap tops for the access points. For you guys who use these are you completely away from paper? Also as an owner are you free from questions? Is it possible to get all the information in and then send the job on it's way? And everyone involved has all the needed information. The assembler the finisher the installer. Anyway this is what I'm working on.

5/10/16       #14: Tracking Jobs ...
cabinetmaker

Nick

You truly need to stop and refocus your shop procedures. The floor needs only the production information - so whatever is coming to the router or saw is what needs to be cut.

Our office can look @ all the info, but with so many revisions, our facilty shreds the old drawings and keeps only the final to production set. Period. This has cut down a lot of BS

Our procedure for any work is this

Reqeuest for Quote,

Quote turns in to Work Order and drawings are generated. Once approved, a Bill of Materials is generated. We buy from that. From that point forward all changes are accounted for on different "Work Orders," because in reality, it is added work

I am with Pat on an ERP and we are installing E2 Shoptech currently. It gives us fences and triggers and will tell us Mrs Jones Kitchen cannot go htrough a process on a certain day, install, assembly, finish, etc because we already have that time allotted for Mr Smith.

A lot of the chaos came to a screaching hault with set in stone procedures that we decided to put in place and I am taking weekends off, well @ least Sundays and now a lot of Saturdays too.

Thanks Pat !

6/26/16       #15: Tracking Jobs ...
Jim Conklin  Member

Website: http://www.jhconklin.net

We use a combo of Trello and Dropbox. Currently tracking 40 some projects.

On projects with detailed specs or drawings we put them on dropbox in pdf format and link them in Trello so everyone can get at them. We have Trello notifications set "on" for all members, so everyone gets an alert that something has changed.

As others have said, it forced us to standardize our workflow - which has been great. Where something doesn't fit, we use the Trello labels to indicate the weirdness - such as "out at sub" or "waiting special materials", etc.

  • Post a Response to this thread
  • notify me of responses to this topic
  • To receive email notification of additions to this forum thread,
    enter your name and email address, and then click the
    "Keep Me Posted" button below.

    Please Note: If you have posted a message or response,
    do not submit this request ... you are already signed up
    to receive notification!

    Your Name:
    E-Mail Address:
    Enter the correct numbers into the field below:
     

    Date of your Birth:



    Return to top of page

    Buy & Sell Exchanges | Forums | Galleries | Site Map

    FORUM GUIDELINES: Please review the guidelines below before posting at WOODWEB's Interactive Message Boards (return to top)

  • WOODWEB is a professional industrial woodworking site. Hobbyist and homeowner woodworking questions are inappropriate.
  • Messages should be kept reasonably short and on topic, relating to the focus of the forum. Responses should relate to the original question.
  • A valid email return address must be included with each message.
  • Advertising is inappropriate. The only exceptions are the Classified Ads Exchange, Machinery Exchange, Lumber Exchange, and Job Opportunities and Services Exchange. When posting listings in these areas, review the posting instructions carefully.
  • Subject lines may be edited for length and clarity.
  • "Cross posting" is not permitted. Choose the best forum for your question, and post your question at one forum only.
  • Messages requesting private responses will be removed - Forums are designed to provide information and assistance for all of our visitors. Private response requests are appropriate at WOODWEB's Exchanges and Job Opportunities and Services.
  • Messages that accuse businesses or individuals of alleged negative actions or behavior are inappropriate since WOODWEB is unable to verify or substantiate the claims.
  • Posts with the intent of soliciting answers to surveys are not appropriate. Contact WOODWEB for more information on initiating a survey.
  • Excessive forum participation by an individual upsets the balance of a healthy forum atmosphere. Individuals who excessively post responses containing marginal content will be considered repeat forum abusers.
  • Responses that initiate or support inappropriate and off-topic discussion of general politics detract from the professional woodworking focus of WOODWEB, and will be removed.
  • Participants are encouraged to use their real name when posting. Intentionally using another persons name is prohibited, and posts of this nature will be removed at WOODWEB's discretion.
  • Comments, questions, or criticisms regarding Forum policies should be directed to WOODWEB's Systems Administrator
    (return to top).

    Carefully review your message before clicking on the "Send Message" button - you will not be able to revise the message once it has been sent.

    You will be notified of responses to the message(s) you posted via email. Be sure to enter your email address correctly.

    WOODWEB's forums are a highly regarded resource for professional woodworkers. Messages and responses that are crafted in a professional and civil manner strengthen this resource. Messages that do not reflect a professional tone reduce the value of our forums.

    Messages are inappropriate when their content: is deemed libelous in nature or is based on rumor, fails to meet basic standards of decorum, contains blatant advertising or inappropriate emphasis on self promotion (return to top).

    Libel:   Posts which defame an individual or organization, or employ a tone which can be viewed as malicious in nature. Words, pictures, or cartoons which expose a person or organization to public hatred, shame, disgrace, or ridicule, or induce an ill opinion of a person or organization, are libelous.

    Improper Decorum:   Posts which are profane, inciting, disrespectful or uncivil in tone, or maliciously worded. This also includes the venting of unsubstantiated opinions. Such messages do little to illuminate a given topic, and often have the opposite effect. Constructive criticism is acceptable (return to top).

    Advertising:   The purpose of WOODWEB Forums is to provide answers, not an advertising venue. Companies participating in a Forum discussion should provide specific answers to posted questions. WOODWEB suggests that businesses include an appropriately crafted signature in order to identify their company. A well meaning post that seems to be on-topic but contains a product reference may do your business more harm than good in the Forum environment. Forum users may perceive your references to specific products as unsolicited advertising (spam) and consciously avoid your web site or services. A well-crafted signature is an appropriate way to advertise your services that will not offend potential customers. Signatures should be limited to 4-6 lines, and may contain information that identifies the type of business you're in, your URL and email address (return to top).

    Repeated Forum Abuse: Forum participants who repeatedly fail to follow WOODWEB's Forum Guidelines may encounter difficulty when attempting to post messages.

    There are often situations when the original message asks for opinions: "What is the best widget for my type of shop?". To a certain extent, the person posting the message is responsible for including specific questions within the message. An open ended question (like the one above) invites responses that may read as sales pitches. WOODWEB suggests that companies responding to such a question provide detailed and substantive replies rather than responses that read as a one-sided product promotion. It has been WOODWEB's experience that substantive responses are held in higher regard by our readers (return to top).

    The staff of WOODWEB assume no responsibility for the accuracy, content, or outcome of any posting transmitted at WOODWEB's Message Boards. Participants should undertake the use of machinery, materials and methods discussed at WOODWEB's Message Boards after considerate evaluation, and at their own risk. WOODWEB reserves the right to delete any messages it deems inappropriate. (return to top)


  • Forum Posting Help
    Your Name The name you enter in this field will be the name that appears with your post or response (return to form).
    Your Website Personal or business website links must point to the author's website. Inappropriate links will be removed without notice, and at WOODWEB's sole discretion. WOODWEB reserves the right to delete any messages with links it deems inappropriate. (return to form)
    E-Mail Address Your e-mail address will not be publicly viewable. Forum participants will be able to contact you using a contact link (included with your post) that is substituted for your actual address. You must include a valid email address in this field. (return to form)
    Subject Subject may be edited for length and clarity. Subject lines should provide an indication of the content of your post. (return to form)
    Thread Related Link and Image Guidelines Thread Related Links posted at WOODWEB's Forums and Exchanges should point to locations that provide supporting information for the topic being discussed in the current message thread. The purpose of WOODWEB Forums is to provide answers, not to serve as an advertising venue. A Thread Related Link that directs visitors to an area with inappropriate content will be removed. WOODWEB reserves the right to delete any messages with links or images it deems inappropriate. (return to form)
    Thread Related File Uploads Thread Related Files posted at WOODWEB's Forums and Exchanges should provide supporting information for the topic being discussed in the current message thread. Video Files: acceptable video formats are: .MOV .AVI .WMV .MPEG .MPG .MP4 (Image Upload Tips)   If you encounter any difficulty when uploading video files, E-mail WOODWEB for assistance. The purpose of WOODWEB Forums is to provide answers, not to serve as an advertising venue. A Thread Related File that contains inappropriate content will be removed, and uploaded files that are not directly related to the message thread will be removed. WOODWEB reserves the right to delete any messages with links, files, or images it deems inappropriate. (return to form)