BusinessMaster-Item Master

Item Master


 Item Master overview

Items are at the heart of any Manufacturing and Service business. Whether it is something you make, buy, sell, or even use internally, managing Items is the key foundation for Inventory, and many of the transactions and decisions you make daily.

We have a very flexible, and powerful Item Master out of the box in BusinessMaster, our Small Business Software Toolkit, It is very easy to implement by importing lists from pre-existing source like QuickBooks, Excel, or other data sources. In addition, we can easily help you customize the form, the style, and the interaction for your unique needs.

Want to know more?

We are very interested in talking with you about your needs. We want to make sure we are a good fit, and understand what you are trying to accomplish, and the best way we know how is some quick discussion. Please contact us via the link to get the process started.

Let's schedule a demo of our awesome Small Business Software Toolkit while we are at it!

Manufacturing Software and QuickBooks

QuickBooks + Manufacturing: It is possible!


All too often we hear from potential customers who have either purchased versions of QuickBooks that claim to handle manufacturing, or contracted with consultants who claim they can make QuickBooks fit their manufacturing processes. They all want to solve the problem of Manufacturing and QuickBooks

Needless to say, it isn't pretty, and its very expensive.

Manufacturing Software and QuickBooks

We have said before, QuickBooks is an amazing program, and that's why it doesn't work. It is perhaps the best small business accounting program out there when measured on several key metrics (things like cost, learning curve, support resources, code maturity etc . . .). But it has inherent design flaws when it comes to tracking manufacturing.

But that is not the end of the story.

Integrating the software IS the solution

When done right, integration between programs can be very effective. You get a "best of breed" concept, without compromising all the pieces. BusinessMaster, our Small Business Software Toolkit, comes already able to integrate with QuickBooks. And there is a lot of flexibility to expand on it.

We can bring data in from QuickBooks. That's a helpful element. However we push data back to QuickBooks, and thats where we see the most power.

Data FROM QuickBooks

When setting up BusinessMaster initially, importing QuickBooks data helps avoid some of the biggest difficulties in implementation: Data Entry Time, and Data Entry Errors. Simply importing Customers, Vendors, Items etc.... saves huge costs and hassle.

After setup, it is possible to import from QuickBooks to do advanced reporting and inter-relating data to the Manufacturing System.

Data TO QuickBooks

In the day to day operations, sending data to QuickBooks is a serious benefit. Here are some basic examples already available:

  • Export of Invoices. When the customer is new, BusinessMaster will automatically add the new customer. Same with any new items.
  • Export of Bills. When a new vendor is added, BusinessMaster will automatically add the Vendor to QuickBooks.
  • Export of Payments Received against Invoices.
  • Export of Journal Adjustments for Progressive Billing, including reversal of Deposits. These can be separate from A/R.
  • Export of Labor Collection processed for Payroll.

Inventory: The big problem

Inventory is hard enough to manage itself. How much quantity on hand is one part of the problem, but how much it's worth is another. It's important to understand the function of Inventory Valuation within the accounting package, and then develop a process on how to handle it.

There are many ways to value Inventory on hand, and BusinessMaster provides 3 right out of the box:

  • Standard Cost
  • Current Cost
  • Average Cost

Even these terms mean different things to different users. But at the very minimum, you can get a value of on hand inventory if you maintain your counts correctly. It takes some practice and tweaking, but you CAN do it.

The next piece is to update QuickBooks with the value. There are different strategies to do this, and it really depends on your financial reporting, your preferences, and your complexity. Essentially, we see most organizations boil it down to either of these:

  1. Purchase all goods to COGS(Cost of Goods Sold) and Expense accounts. When they are exported as Accounts Payable (Bills) one side of the accounting entry is A/P, the other COGS/Expense. Periodically, you count inventory, and make adjustments to the Inventory Asset accounts to the right value.
  2. Purchase all goods to Inventory Asset accounts. Then periodically you report on what you have used, and adjust the COGS/Expense accounts.

If the above isn't clear, trust us, we understand. We have seen very simple and very complex approaches, and they each have their merits. Any good accountant will see the issues and provide advice on how to handle it. We can adapt to how your finance team wants to run it. If your financial team doesn't know how to approach this, that is a bigger problem than HOW you track it. We aren't accountants, but we know how to work with them, and that's key.

In closing, we want to re-iterate. QuickBooks is a fantastic solution for Manufacturers, as long as they use it for the Accounting! When it comes to Item management, Inventory Planning, Production Planning, and other unique elements of the manufacturing process, stick to software designed for that. Then Integrate wherever needed.

 

 

Want to know more?

We are very interested in talking with you about your needs. We want to make sure we are a good fit, and understand what you are trying to accomplish, and the best way we know how is some quick discussion. Please contact us via the link to get the process started.

Let's schedule a demo of our awesome Small Business Software Toolkit while we are at it!

BusinessMaster-Address Book

Address Book


Address Book rundown, and some possibilities for use.

The Address Book is a key part of the CORE module of BusinessMaster managing the details of WHO you do business with. Often this data is in someones head, their smart phone, or their email program, yet is important for many different users within the organization.

We provide basic data elements, the classic address fields, phone numbers, emails, and a free-form list that can be used as-is, or as the base of a customized contact manager.

We also provide functional elements like  contact management, document links, and integration with Item pricing/costing. These can be expanded and developed to suit your specific needs during implementation.

Want to know more?

We are very interested in talking with you about your needs. We want to make sure we are a good fit, and understand what you are trying to accomplish, and the best way we know how is some quick discussion. Please contact us via the link to get the process started.

Let's schedule a demo of our awesome Small Business Software Toolkit while we are at it!

BusinessMaster Overview

A quick overview of the basic structure of BusinessMaster.

The goal of this video is to show a basic overview of our key modules, and give you some ideas on what you might do with them. This is by no means a complete or comprehensive overview. We prefer to do an online demonstration, and interact with you to see where your points of interest are, and determine if our framework is a good fit.

Inventory Software Basics

Inventory Software Basics


Inventory is a significant element in mastering the small business.

You know you have cash in the bank (we hope you do!). You know you have some invoices out there waiting for your customers to write you a check. You also have money (in some cases a LOT of money) in other places. Are you aware of how much capital you have tied up

  • Sitting in shelves, pallet racks etc... on the shop floor
  • In bins stashed around work spaces, in trucks, and toolboxes
  • In the process of manufacturing, but not yet turned into salable products
  • Finished Goods sitting around waiting to be shipped

This is called Inventory. There are even more in depth, sophisticated elements of Inventory, but our goal is to cover what it truly takes to get the basics of Inventory up and running in a small business using Inventory Software.

Why tracking Inventory is crucial

 

Tracking Inventory is crucial because inventory is basically cash on the shop floor rather than in your bank account.

 

And its isn't just the amount of money, it's the LOST PRODUCTIVITY when the manufacturing team can't continue because there is no raw materials. I've literally seen a full stop on the shop floor, and 5-6 people stop, look at each other, and then sit down and wait.


Do the math

(Quantity of workers (lets say 6)) X (minutes sitting (lets say 10)) X (Average Burden Rate per hour (lets say $50))

This equals 1 hour lost time, and at least $50 in costs.

But wait, there is more...

How much SALES or PROFIT would that hour produce? You lost that as well.


So there is a balance to be maintained. You need enough inventory to keep production going, but every bit of inventory you have extra on the shop floor is cash you cannot use or put to work. I've also seen companies buy so much raw materials to avoid running out, they cannot make payroll.

So there are several factors to tracking Inventory, the time it takes to manage it, as well as the potential impact

Tracking Inventory: Manual vs Inventory Software Systems

Before we go further, let us be clear. You can manage Inventory using a couple of simple manual techniques. Here is a quick list of a few, some of which might work for certain organizations that are either very small or very simple:

Manual

  1. Visual: This is where your operation uses very consistent raw materials, and they are large enough and organized on shelves or racks easily visible by whomever is responsible for managing Inventory. It also presumes raw materials are used quickly in relation to when they are needed. I've literally seen organizations where someone scheduling production or materials pick up a phone, look out through the door, and manage inventory in real time with the supplier.  They simply place an order based on what they can see, and as long as they don't run out, everything is fine.
  2. Systematic: There are basic systems that track Inventory using differing kinds of structures.
    1. Min/Max: Each Item you want to track Inventory. Each container (bin, shelf, spot etc...) has some kind of label or sign that shows the MINimum and the MAXimum amount you want to have for that item. Periodically someone walks around and notes how much they need to get to the MIN amount. If the amount on hand is the MAX amount, they can decide to reset the MAX amount to something lower.
    2. KANBAN: This system uses a series of cards/signs that help the operation respond to Inventory levels, oriented around a PULL type system. Demand for inventory drives the process from consumption. It can be a very effective system, especially in LEAN manufacturing systems. You need to have very little limits on resupplying, And some good grasp on future demand.

Inventory Software

For any but the most simple, or small organizations, manual systems cost more than they can save. The time it takes, the lack of accuracy, and the inability to adjust to increased demand (even worse if the increase is temporary) make it hard to keep up. We need a small business software system.

All Inventory software is going to track 2 basic types of transactions at a minimum. There are always more and more concepts to dig into, but lets stay focused.

Inventory really is like a bank account on the shop floor, and every bank account needs a register

The Ins and Outs of Inventory

The amount of Inventory a software system calculates is basically the sum of all the Ins (deposits) and the Outs (withdrawals). The remainder is your balance. That is how much you have right now. Of course in most checkbooks, you have checks you will need to write in the future, as well as checks you wrote but haven't been "cashed" yet. More on these later.


A good small business software system will track the Ins and Outs as they happen, and calculate that information on demand for the user. Here are some simple examples of Ins and Outs

Examples of Ins

Receiving purchased materials
Putting Inventory back from a return from a customer
Receiving parts from manufacturing back into Inventory

Examples of Outs

Shipping products to customers
Consuming raw materials in manufacturing
Loss from scrap, quality rejections, and theft


Good Inventory Software will track the transactions listed above. This means that you will need to conduct those transactions within the same Small Business Software system:

Sales Orders and Shipping: Entering what Customers want, and tracking how you and when you ship them. This is normally making packing slips (for product based operations), or having projects passing a certain point in manufacturing. At this point, you have many of the elements of Invoice/Accounts Receivable, which drive accounting.

Purchasing and Receiving: Entering what you buy from Vendors, and tracking when and how you receive them. This is normally entering Purchase Orders for each item, and receiving it by entering the information from the Vendors Packing Slips. At this point, you have the elements of Voucher/Accounts Payable, which drive accounting.

Adjustments: Transactions that take away or add Inventory but don't go through the above transactions. Scrap, Rejects, Theft, and periodic adjustments.


These simple elements work together to provide inventory information to you. But like many things, just having information isn't good enough. Using it is the point. It's an important element of any good small business software system that manages inventory to provide elements that focus your attention to relevant pieces.

Part Numbers: Each item you wish to track needs it's own part number, unique and usable.
Part Elements: Costs, Prices, and groupings are key. If you want more than just HOW MUCH Inventory is on hand, but HOW MUCH VALUE is on hand, you need to track costs, prices etc... If you want to know inventory for a group of related parts, there needs to be ways to related parts like Product Codes, Inventory Codes etc...
Transaction History: The numbers are important, but also the chronology of HOW you got to your number can be very important when you need to verify or audit your Inventory numbers. Having the transaction identifiers (Sales Order Number, Purchase Order Number etc...) are very helpful.

These elements may seem overwhelming, but in reality any good system has these. They might use differing terms, or have unique elements of how they track them. The important part is to have a good strategy on what parts you need to track, how much you need to track, and what elements are the most effective. .

 

Want to know more?

We are very interested in talking with you about your needs. We want to make sure we are a good fit, and understand what you are trying to accomplish, and the best way we know how is some quick discussion. Please contact us via the link to get the process started.

Let's schedule a demo of our awesome Small Business Software Toolkit while we are at it!

Planit Enterprise: The good, the bad, the ugly

Planit Enterprise: Focusing solutions on woodworking


Our roots are in woodworking. Here are some lessons we learned licensing and partnering with a vertical software company.

Our Small Business Software Toolkit, BusinessMaster, has deep roots in woodworking/ custom cabinet manufacturing. We took the framework we had developed previously throughout a series of installations, and then began to standardize it over 12-18 months in a growing, dynamic woodworking shop.

The previous installations started in a custom machine shop, and then migrated through a molded cable assembly facility, and a disposable medical cable start-up. Each step incorporated unique elements of business process management. Most of the focus had been on  Labor Collection/Job Costing (Machine Shop), MRP (Cable Assembly), and Work Order management (Medical Device start-up). The last organization was an executive management team already clear on their objectives, and designing the whole organization to be ISO 9001 certified.

The implementation into woodworking brought new dynamics into play. There are 2 main categories of cabinet manufacturing, custom and "modular".

  • In modular cabinets, the end products are part number based, consistent products built to a more classic BOM (Bill of Materials) scenario. This is similar to the Cable Assembly and Medical Device companies.
  • In custom cabinet manufacturing, the end product is a mix of products, some similar, and others potentially completely different than any other products previously made. This is essentially project based manufacturing, where the materials, the labor, the specifications are all associated with a project (or set of sub-project we call phases).

As BusinessMaster progressed in adapting and responding the unique needs of the organization, a framework took shape, and we began to reach out to other woodworking companies who implemented the small business software toolkit. Eventually, Planit Solutions approached us about licensing the software we developed, and begin to sell it as an incorporated part of their woodworking solutions.

The next 3 years was a huge learning curve, and here are our observations.

Eating Elephants is Hard

BusinessMaster had become a very broad and deep solution by this point. We had modules addressing most of the key elements of small businesses. The "suite" of modules were marketed, sold, installed, and supported as a whole concept.

The result was unnecessarily complex. We had significant flexibility in installation and implementation where we could identify a specific need of an organization and alter the installation and support. However we still were unduly influenced by the context of the whole program. Most organizations benefit from focusing on one or two main elements and mastering them.

Good:
  • The breadth and depth of the program allowed for constant expansion and benefit.
Bad:
  • Trying to implement several different layers of software defers the return on investment, and impedes momentum. It simply becomes too hard/too much to achieve.

Simple Not Sexy

We go over some of this in our article here. We noticed that the most powerful solutions in terms of overall performance we the more boring, simple, rudimentary ones. Most users love the idea of finite capacity labor scheduling by work center, but the real power was often just having shared, up to date contact information, or the most recent vendor used on a Purchase Order for an item. It was lots of simple, direct data that had the biggest impact in the day to day war for profit.

Good:
  • Taking advantage of every small, simple solution regardless of how boring puts immediate benefits to work. This creates the proper foundation for the more sophisticated, specialized elements later.
Bad:
  • Focusing on the more sophisticated pieces without the proper foundations leaves profit on the table, and frustrated users in the dust.

Evaluate first, Install Second

Technical evaluation is key prior to implementation. The customer may want solutions x, yet they might not be ready to support it. If the right players are not in place, the solution wont succeed. Taking an honest evaluation, and targeting the areas the client is ready to do, rather than aspiring to do, is the only realistic way to help the client achieve what they want. Throwing the client into unsupportable changes without advising them before hand is a disservice to the client.

Good:
  • Evaluate what IS, not what SHOULD BE. Base your go forward plan on what can be sustained, and grow from there.
Bad:
  • Chasing a vision of what could be without proper strategy and evaluation is leaping before looking.

 

Conclusions

There are more ideas than we have space to present. Essentially what we learned by working with Planit was:

  • Market research was left up to the sales team, who wanted/needed new products to sell.
  • The market DID need business process management.
  • No one realized up front that the majority of the potential customers were unable to support such a large bite of technical solutions, even though they WANTED to implement them.
  • The solution was as much business process development, training, consulting, as it was software. For example, many organizations needed to understand the WHY of Purchasing and Purchase Orders, as much as they needed a WAY to make Purchase Orders.

We learned a lot working on the Planit Enterprise product. It allowed us to help a lot of woodworkers, and at the same time adapt and refine our products even more. We still support and customize Planit Enterprise customers, and find that the woodworking industry is full of some of the smartest, most innovative organizations out there.

 

Want to know more?

We are very interested in talking with you about your needs. We want to make sure we are a good fit, and understand what you are trying to accomplish, and the best way we know how is some quick discussion. Please contact us via the link to get the process started.

Let's schedule a demo of our awesome Small Business Software Toolkit while we are at it!

The best software solutions are simple, not sexy

The best software solutions don't normally look like "one of the cool kids".


When looking at small business software solutions, we tend to look for:

  • The most powerful looking, sounding, or appearing.
  • The most sophisticated, most cool, most modern (and maybe even have a new acronym!)
  • The  most intricate and detailed.

However, there is still a fundamental rule about finding a customer or vendor phone number in your organization:


"The quickest, fastest tool for getting a contact phone number in your organization is still the Rolodex"


best software solution?http://shaneb.me/tech-review-camcard/

Think about this before you rush to your conclusion that we are crazy, outdated, or perhaps even a technological Luddite . . .If your problem is you can't quickly find a customers phone number, the best software solution isn't even software. By the time you open your email/contact manager, get your smartphone, or some other technology you can reach 2 feet, and get to the letter, if not the very entry you are looking for.

Lots of solutions are like this. We can create sophisticated, multi-layered tools (and there are good reasons we will get into later in the article), but it's important to rethink what the best solutions is.

Let's bring more clarity:

  • A Rolodex is great if you only have one user needing contact information. If you have more users needing the same information, it can be horrible.
    • Anytime someone needs a phone number, you have to stop, get up, and interrupt the Rolodex master, and get what they need.
    • If the  user doesn't have a great memory, the have to write the details down before they walk away.
  • A Rolodex is great if the contact detail doesn't change often. If it does, you can find yourself in a mess.
    • Changes require copying and rewriting the WHOLE card perfectly. Any error will be permanently committed, and recopied at every change.
    • Every change has to be conducted by the Rolodex master. When someone else requests a change, they have to submit the change, and wait for the update (assuming it did get updated).
  • A Rolodex is great if you already KNOW what you are looking for. If you don't know the index name, it can be almost impossible o get the information.
    • If you index by company name, you need to know the company name. If you index by the name, you need to know the name (first or last?). What if you only remember the last name and city?
    • The index makes sense to the Rolodex master, but no one else might even think that way.

"So clearly, a Rolodex is the best solution when you only have one user who needs the information, manages the information, and knows the information."


If you are still hanging with the "Rolodex" metaphor, then lets think of how it applies generically to information within an organization. How do we develop the best software solution for your organization?

Determine the Real User(s)

Is there one central user/role in the organization? Are there other users that can benefit from this information? Can the information be used in other processes in the organization?

Determine how Dynamic the Data is

Does the data change often? Is it all the data, or just key elements? Does the data need to be validated before it is updated?

Determine how Users Access the Data

Do users already know what they want? Will users ever need to find data by partial elements? Will users need to access the data in the middle of other processes? Is the data critical to a process, or can it wat?

Determine Data Validation

Is it faster to empower users to update information directly rather than run through a "gatekeeper (or vice versa)? Do you need a history of the changes, or just the current values?


Clearly, this is a bigger thing than it seems . . .

Take the above and walk through a mental exercise. Instead of a customers phone number, substitute a vendors. Or an Inventory Item. Or a Purchase Order. Or a Sales Order. Or a Item Standard Cost. Or a received payment.

All these data elements are important. Some closing thoughts to think about:

In some cases a Rolodex (or in modern equivalence a printed report or binder) for a key user is the fastest way for them to have access to a piece of data.

Multi-User access is a key element in designing the best software solution. If you have multiple users (or processes using the data), you must centralize and possibly control access.

Controlling who updates data is worth the extra effort in designing the best software solution for your organization. Sometimes it is overkill and not worth it.

In the real world, it can often be the smallest, simplest solutions that gain you the most benefit. Let's revisit the idea of finding the contact details for a customer.

Look for Time Savings, Data Integrity/Quality, System Stability

A key element in evaluating whether a solution is effective or not comes down to the following questions:

  • Does it save time? Just think about a 10 user office, saving 5 minutes a day. Sounds infinitesimal. However that's 50 total minutes a day,  On a classic 5 day work week, that's 250 minutes (4 hours).  52 weeks results in 216 hours.  That is almost 5.5 work weeks. What would you do if you hired someone (for free) who already knew your organization, was already in your systems, didnt need retraining, for almost 6 weeks?
  • Does the data have integrity? Is it accurate? Is it relevant? Is it accessible? It is easy to manage and validate?Is it protected from theft, damage, or disruption?
  • Is the system stable? Is it sustainable? Is it backed up and can it be restored in case of errors or misuse? Can it scale and grow?

Building the best software software solution for your organization can take a lot of thought. Don't assume the latest and greatest is the answer. And don't assume it's not. Evaluate what it is you really need, and why. Then look at the solution. Avoid investing in bells and whistles, and look for the key elements of a real solution, fit for your organization.

Want to know more?

We are very interested in talking with you about your needs. We want to make sure we are a good fit, and understand what you are trying to accomplish, and the best way we know how is some quick discussion. Please contact us via the link to get the process started.

Let's schedule a demo of our awesome Small Business Software Toolkit while we are at it!

BusinessMaster: Overview

BusinessMaster, the Small Business Software Toolkit by Master Solutions


BusinessMaster handles the following categories of activity. Each section contains far more detail than can be described in this simple list.

BusinessMaster is broken down into a set of modules. Each module represents classic activities, however ALL of them are interconnected. Following is a short list of features as a top level overview. Click on each section as see more, along with some demo videos to help you see the potential.

  • CORE Module:
    • Address Book and basic Contact Management
    • Items and Inventory; Bills of Material, Labor and Work
    • Purchasing, Receiving, and Vouchering to Accounts Payable. Purchasing can be pegged to specific projects
    • Sales Orders, Packing/Shipping, and Invoicing to Accounts Receivable
    • Tracking of Invoice Payments
  • PROJECTS Module
    • Project based manufacturing and Project Management
    • Unlimited Phases against a Job, with each Phase having it's own schedule, and connected details
    • Project based Billing, with special advanced elements to handle Deposits and Revenue booking
  • MRP/Planning
    • Materials Planning using MRP concepts
    • Can change demand to work against BOM based Work Orders, Projects or Both
    • MRP can run against Labor separate from Materials
    • Multiple Inventory warehouses
    • Automatic planning based on projected Inventory and rules
  • Work Orders
    • BOM based work orders moving in and out of WIP.
    • Can be auto planned from MRP, as well as created from Sales Orders
  • Time Collection
    • Simple, integrated Time Collection against projects, and calculated for Payroll as well as Job Costing.
  • Job Costing
    • Roll up of materials and labor to analyze against price for profit analysis
    • Real time % to budget.
    • Breakdown by Phase, Customer, Project Type
  • Accounting Export to Quickbooks
    • Export AP, AR, Payments and Labor to Quickbooks.
    • Receive data from Quickbooks for quick startup.

Each BusinessMaster component can be customized both in HOW you use it, and the source code itself.

Want to know more?

We are very interested in talking with you about your needs. We want to make sure we are a good fit, and understand what you are trying to accomplish, and the best way we know how is some quick discussion. Please contact us via the link to get the process started.

Let's schedule a demo of our awesome Small Business Software Toolkit while we are at it!