Woodworking Business

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

ERP for a moulding shop

12/1/17       
David Waldmann Member

Website: vermonthardwoods.com

We have been using EVO-ERP (and/or it's predecessor, DBA) since 2000.

We primarily make "moulding" (including flooring). And we sell both our actual moulding as well as flooring in many different ways with various added services.

The features of EVO are mostly fitting with our needs, but there are just ongoing problems and I am at the point again of looking for other solutions. We did this exercise about 10 years ago, spent a BOAT-load of money and hundreds of hours on a new system and then never implemented it because of one feature that is absolutely essential to our business that didn't function the way they said it did. They wanted another $25k to add it and we dropped the project.

We are looking for a full featured ERP system that is designed to handle both make to order and make to stock, and can handle all the intricacies of working with wood (notably BF, SF, LF and variable yield). It should be able to handle multiple BOMs and Routings as we often change what/how we buy stock based on how busy we are, what our suppliers have available, or price.

I know most ERP systems make a big deal about scheduling, but that is probably the least important aspect for us and I don't know that we would even use it.

We just need what I would call The Basics - one system that can handle an order from the quote/estimate through purchasing materials as necessary, invoicing, accounting/GL and all the sub-parts that go along with each of those.

One of the sticking points I have run across (and it was the feature that tripped us up last time) is the ability to process credit card payments through the system, including being able to save CC info for our many repeat customers. While we are mostly B2B, most of our customers are M&Ps and pay by credit card. Dollar wise it's only maybe 20% of our business, but transaction wise it's at least 80%. There is simply no way we will revert to getting credit card info from the customer each and every time we make a sale - the time needed to do that would kill us, and from a customer perspective I know that I hate it when that happens to me.

Anyone have an ERP system they are simply thrilled with? Or one that you strongly advise staying away from?

12/1/17       #2: ERP for a moulding shop ...
Pat Gilbert

I advise against any.

Years ago I went to Store Fixture seminar on estimating put on by the NASFM

An attendee came up to me on break and said I don't get it 5 years ago everybody was hot on ERP, now everyone is back to spread sheets.

I get it you want to have a single source for information. Me thinks this is another holy grail type deal.

I know a guy who used to sell ERP software that cost $10,000,000. He said he quit selling it because years after selling the software to companies it did not increase efficiency one iota.

You might be better off looking at accounting solutions that would solve the problem. With maybe some custom programming.

12/2/17       #3: ERP for a moulding shop ...
Larry

We've spent way too much on software and it rarely does everything the seller claims. That or it takes so much input time as to not make it worth the trouble.

12/2/17       #4: ERP for a moulding shop ...
David Waldmann Member

Website: vermonthardwoods.com

For those who don't use an ERP,

How do you ensure you have materials on hand for upcoming jobs?

How do you determine if you made money on a particular job?

How do you convey instructions and bills of materials to the shop floor?

How do you keep track, on an ongoing weekly/monthly basis, the financial performance of the company?

How do you keep track of sales orders, purchase orders, work orders, accounts payable and receivable, and enable anyone that needs access to that information to get it as needed?

We are not a large company - 7 production employees and 5 admin/sales. But I cannot imagine operating at our current level without an ERP. We had Peachtree 20 years ago, and made it work, but it was clunky. It felt like using a jointer to straighten boards instead of a ripsaw, or a shaper to make fully profiled window casing (yeah, we used to do that too).

12/4/17       #5: ERP for a moulding shop ...
cabinetmaker

David

What do you use ?

Currently we are using Shoptech, but @ about my limit

12/4/17       #6: ERP for a moulding shop ...
David Waldmann Member

Website: vermonthardwoods.com

We are using Evo-ERP, a modernized version of DBA (now called DBA-Classic).

IIRC it was originally introduced in the late '80s. While it is a 100% Windows compliant implementation, it is still rooted in DOS, and the database structure is slightly short of archaic.

Evo-ERP

12/4/17       #7: ERP for a moulding shop ...
Alan F. Member

Pat,
The big problem in the Store Fixture industry back then was there were so many options, colors ,configuration that when companies got to the product configurator side is was extremely time consuming and difficult.

That was a good seminar.

Some time around 2005 a major store fixture MFG took over an account we used to service. There was a roll around condiment cart with applied panels. All in rift oak, pretty simple to build. They had us do them as it took them 14 weeks to produce a one off like that based on the time it took to build in their ERP system.

Molding and flooring with a defined product line would be much simpler to build and add options.

We have worked for other store fixture mfg that have ERP systems working. I think it might of become easier than it was 16-17 years ago.

Still the custom configuration part is the time issue if you use ERP for BOM in a make to order environment.

12/4/17       #8: ERP for a moulding shop ...
Pat Gilbert

Yeah the seminar was good, they were not pushing ERP, did I imply that it wasn't?

I remember talking to a guy at the show that worked for one of the big hardware manufacturers. He said that they loved their ERP/MRP software.

I think you nailed it, the setup time/opportunity cost is too much for custom/short run work.

Maybe David's setup lends itself to ERP software, but it seems to me that he should at least consider good accounting software.

12/5/17       #9: ERP for a moulding shop ...
Jerry Cunningham

Have you looked into lean systems instead? It seems to me that if Toyota can run a multi-billion dollar production facility making a product that contains 70,000 parts with a Kanban system using index cards, you don't really need a fancy software program to tell you what boards to send through the moulder.

12/5/17       #10: ERP for a moulding shop ...
Jerry Cunningham

I forgot to mention that for your credit card processing and order entry you should consider an ecommerce store front. Too many wood product companies have website that are blogs/informational only. By having your site set up an an e-commerce system you can easily make sales.

The two most popular and easy to work with are Shopify or BigCommerce. We use BigCommerce because they allow a lot more product options than Shopify, and if you partner with their CC processor the rates are lower.

12/6/17       #11: ERP for a moulding shop ...
David Waldmann Member

Website: vermonthardwoods.com

Jerry,

Kanban won't work for our manufacturing. The advantage Toyota has is that they have very limited options. Yes, a huge variety of final products based on those options, but for instance you can't order Burgundy Kangaroo leather interior no matter how much you pay or how long you're willing to wait.

While a good part of our production is from a discrete list of materials, there are lots of raw materials that we purchase as needed for orders in house. For instance 6/4 Cherry. I may have a little bit left from the last time we had a job for it, but I am not going to maintain 500-1,000-10,000 BF, as I just don't use it often enough.

We do use an index card system for supplies and some of our secondary products, so I am familiar with the process and can see it working very well in certain circumstances. However I don't believe our primary manufacturing is one of them. Even with the secondary products, we mostly don't use it. We are talking about natural wood moulding, and we make it into custom sized frames to order. It's not like a box of bolts, where each one is that same and you can put 2 boxes on the shelf and order/pull another when the first one get emptied. We often will pull all the material in the bay out to find the right 2-3 pieces we need to make the order, and then put the rest back. We can't even make level lines that trigger an order when below a certain stacked volume, as everything is sorted by length and depending what lengths you have you can have vastly different total quantities, and/or a "hill and valley" effect that makes determining a level difficult, and some items are in 2-3 bins because of needed volume. Besides that, because many of our mouldings are similar enough to be grouped into "families" that save setup time, with ERP we are able to look at all items in each family, check current levels, determine stocking level on-the-fly based on usage, and print out a report of how much to make of each one. Manually trying to do that could take hours per week. One more - a customer just called and wanted to know if we had something in stock. With an ERP system I was able to tell them within seconds on the call, rather than having someone physically check and then call them back.

I like the idea of using online for CC and letting someone else deal with the PCI etc. But I don't see shutting off our in-house processing. While most of our customers do have email now, many are not comfortable using the internet. We get most of our orders by phone, then fax, and lastly a combination of email and/or our online ordering system. I would be afraid that forcing our customers to use the internet to place and pay for orders would cause a general revolt. If we were getting all orders via the internet I'd want them to be ported directly into whatever I was using to create orders and do invoicing.

BTW, I do have and use Quickbooks for 4 other low-volume-transaction companies that we run, so I'm familiar with it, and can't see using it to run this business.


View higher quality, full size image (1008 X 756)

12/10/17       #12: ERP for a moulding shop ...
Jason  Member

Have you researched this software ?
http://mouldingcalculator.com/wood-moulding-estimating/

12/11/17       #14: ERP for a moulding shop ...
David Waldmann Member

Website: vermonthardwoods.com

Jason - I had looked at that a while ago, looks like it's a bit more advanced now and cloud based (not sure I am willing to go to the cloud at this point).

Still looks like it's primarily for pricing. Their website doesn't seem very reliable (which is troubling for a cloud based software company) so I didn't get to explore everything yet.


Post a Response
  • Notify me of responses to this thread
  • Subscribe to email updates on this Forum
  • 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)