Microsoft Dynamics NAV Cost Accounting: Is My Business Profitable?
>As a consultant; I hear business owners asking about the viability of their company. Just looking at the monthly Financial Statements is not sufficient any more. When economic times are good, profitably seemed certain, and the Financial Statements were enough. But now the profitability of the business is very thin. Owners and managers struggle to understand why profit is so low and how to stop the falling trend. There is more relevance for the expression, “the devil is in the details.” Business owners cannot wait for monthly and quarterly financial reports to let them know how they are doing. Managing the business has to happen on a weekly or even daily basis and a Job by Job basis too.
Your Business needs to implement Cost Accounting. Let’s face the facts, no one likes Cost Accounting. It is time-consuming, prone to error, too detailed, and worst of all confusing. The good news is that if you keep it simple; Cost Accounting can be quick, rewarding, and it can give you the information you need to make great business decisions. Make your cost tracking efforts provide usable information.
Examples: Is my projected cost at completion close to my original estimate? Is my cost of materials running too high? Do I have the Resources available to complete the job on time? Which customer produces the best profit margins? The key to a solid solution is real-time data. You can’t make a good decision on out-of-date information.
There are three primary sources of costs: Labor, Materials, and Subcontractors. Your reporting is dependent on accurate tabulation of this data. Let’s review each of these three cost components in more detail.
First, most jobs are very Labor intensive. This means many man hours or crew hours need to be accounted for. As you enter the hours you can apply a shop rate to come up with the cost of labor. I do not recommend you use personal pay rates within job costing, it is too emotional.
Second, most jobs have some material component too. This might be lumber, steel, boxes, welding coils, gas, or any of a thousand material items. The material might be pulled from stock inventory or purchased uniquely to your job. In fact the estimated material often becomes the demand for the procurement process (BOM into MRP engine).
Third is subcontracting. This might be a local vendor or a remote vendor who will perform some service or process that you don’t or can’t perform in-house. Example: Metal Plating might be more efficient to send out than to create a department to do the work in-house. It is often much less expensive to ‘sub it out’ than to do the work in-house. Or you can use the subcontractor as an additional resource when your in-house staff is over loaded.
These three cost sources usually make up 80% of the cost of a Job. Other costs such as transportation, equipment, overhead, or supervision might make up the remainder. The accounting side comes from the need to enter employee time cards, vendor invoices, material usage tickets, and travel expenses. Your cost accounting software needs to become a tool to do the tabulation of the mounds of raw data. When you have 150 active jobs, 70 shop employees, 30 field employees, and 15 subcontractors all working simultaneously you must have a software solution to sort, group, sub-total, and filter the thousands of daily job cost entries.
By the way, if you really want timely and accurate Job Cost Reporting, this Video Presentation on The Job Manager Software for Microsoft Dynamics NAV will lay it out for you.





