Information Systems

Case Study: Managing Job Costs and Timeline

Situation...

This designer and producer of custom-designed products has about 100 jobs in process at any point in time, and uses QuickBooks Enterprise for its financial statements. Labor, both for design and production, comprises the great majority of the product's total cost.

Problem...

While QuickBooks Enterprise was sufficient for financial reporting, it had no features to conveniently manage this type of business. While goods purchased for specific jobs were coded to the job in QuickBooks, such purchases accounted for only 20% to 25% of total cost. Our client had no easy, flexible mechanism to capture and track labor hours by job, thus lacking visibility of their largest cost. Finally, a Microsoft Excel spreadsheet was used to manage the jobs as they were processed, yet — because this was not an appropriate product for this use — getting accurate information to make decisions was a constant problem.

Solution...

To address these issues, we:

  • Identified a third-party tool to programatically extract data from QuickBooks on a scheduled basis.
  • Developed a simple web-based time tracking application to collect time by employee, classified by customer job codes or internal company codes, drawing employee name and customer job codes from QuickBooks.
  • Developed a job management application, drawing purchased materials from QuickBooks, obtaining labor hours and values from the time tracking application, and allowing web-based setup and tracking of key production steps and dates.

With these components in place, we then trained employees on using these tools to capture time by job and accurately track jobs through production. While this data was accumulating, we developed several analyses to manage job costs and timelines, including:

  • Job Summary Report, showing key steps and their status (complete, incomplete, or not applicable).
  • Labor Hours by Employee, permitting comparison of employee productivity with their peers.
  • Job Profitability Report, showing estimated job margin at projected completion.
  • Hot Jobs Report, showing jobs which are due in the next 2 weeks, are due within 4 weeks and at risk of slippage, or are projected to end up below desired gross margin percentage.

Time Tracking Application

Above, a third-party utility allows us to extract information from QuickBooks and put it into the SQL Server databases underlying the Time Tracking Application and Job Data Warehouse. Drawing key information from QuickBooks ensures data consistency and forces process discipline — for example, a job cannot be setup in the Job Data Warehouse until it has been setup in QuickBooks.

Job Set Up Screen

Above, the Job Setup Screen allows authorized users to define overall job information, specify steps applicable to a certain job, and enter dates and other key information for the relevant steps.

Time Tracking Screen - Left SideTime Tracking Screen - Right Side

Above, the Time Tracking Screen allows a user to pick the job code — either customer jobs or internal time codes — being reported, and then specify time for the relevant day. An audit trail is maintained of changes to each line item on the screen.

Job Summary Report

Above, the Job Data Warehouse pulls together the information extracted from QuickBooks, as well as the current contents of the Time Tracking Application — these account for about 95% of the end product's total cost. The data warehouse contains various analyses and reports, all with drill-down and drill-around functionality, and with the ability to export to various programs. Managers use the "Job Summary Report" to visually monitor the 100+ jobs in process, and identify those showing potential delivery date or cost issues.

Results & Benefits...

Executives and managers now have accurate job status information no more than one day old, and visibility of the "Hot Jobs" requiring focused attention. Armed with this information, department managers can adapt to changed conditions, and account service representatives can keep customers updated on the status of their orders.

For the first time ever, executives and managers can determine which jobs are unprofitable and why this occurred, seek change orders from customers when warranted, plan the need for overtime work and temporary employees, and compare performance of specific employees to estimated labor hours.

Conclusion...

Prior to this project, executives and managers had only historical financial information, without the ability to analyze reasons for unplanned results. Our work gave them the tools to plan and track specific costs by job, manage overtime costs by better using temporary labor, and identify employees requiring development to improve their performance.

For More Information...

To discuss how technology usage and business process improvements could be applied to the issues facing your business, call us at 336.297.4200 to schedule a no-obligation consultation, or click here to contact us online.

Get a business boost now by calling Todd at 336.297.4200 or request information here.

Learn about our quality of service by visiting the  client testimonials page.

Information Systems - multiple computer monitors

Not sure what you need? Use our Decision Tool.

Find the right technology for your company.

Popular Case Studies

Applying Technology to Reduce Unbilled Charges

Accession Inventory graphSometimes, brute force gets a job done. Sometimes, a little finesse is all it takes. Other times, you need to combine the two to accomplish your goal!

Investing vs Spending

AvaCare-screen-shot-v4What's the difference "investing" and "spending"? From the perspective of current cash outlays, nothing is different - yet, taking the long view, there's a great deal of difference.

Deliver Major Cost Savings by Using Technology and Improving Process

Read how this fast growing company partnered with Todd Herman Associates, and found short-term and long-term cost savings through technology and process.

Making Reports Useful: A Case Study

Read how a CIO found a profitable innovation idea in the way the business delivers lab reports.

Activity Versus Achievement

Establish Accountability and Evalutate Results

The Wall of Knowledge

Clarifying Business Needs

Ending the Spreadsheet

Managing Job Costs and Timelines

Tip of the Iceberg

Delivering Meaningful Information to Executives

Todd Herman Associates

336.297.4200

620 Green Valley Road
Suite 104
Greensboro, NC 27408
/strong>

About Todd Herman Associates

Todd Herman Associates is a business technology consulting firm focused on non-routine technology issues such as replacing QuickBooks, getting two systems to "talk" to each other, shrinking process cycle time, and taming large volumes of data.