How to Prepare WIP Reports for Long-Term Contracts
Work-in-progress (WIP) reports are frequently used by manufacturers, media and film companies, construction contractors, and other entities to help management track inventory and gauge profit on long-term projects. Regularly monitoring these reports can help maximize profitability and uncover problems before they get out of hand.
What should be included?
There are many ways to create WIP reports, including spreadsheet programs and accounting software add-ons. Whichever method you use, the report should track key information for each project in progress, such as:
- Contract price (including approved change orders)
- Estimated job costs
- Estimated gross profits
- Costs incurred to date
- Revenues recognized
- Percentage of completion
- Billings to date
- Billings in excess of earnings or earnings in excess of billings
Most companies with long-term contracts run monthly WIP reports. But proactive managers run them weekly. Warning: The process requires a current and accurate assessment of estimated costs to complete each project. Otherwise, the information will be incorrect and could be misleading.
How can you spot trouble?
WIP reports can help you identify problems and take corrective action before the problems spiral out of control. For example, say a job is 25% complete but your costs incurred to date are 40% of budget. That’s not good, but thanks to your WIP report, you’ll have time to investigate, make adjustments and, one hopes, get the project back on track.
WIP reports also indicate whether a job is under billed or over billed. Either situation is a potential red flag of financial trouble. But, in many cases, there’s a benign explanation. For example, under billing (that is, billing that fails to keep pace with a job’s progress) may be attributable to cost overruns, inefficient project management or sluggish billing.
WIP reports can also help you spot “profit fade.” This is the gradual decline in projected gross profits over the course of a job. There are several potential causes of profit fade, including inaccurate estimates, lax project management and sloppy change order practices. Again, a WIP report can tip you off to project discrepancies before the job gets too far along.
WIP reports may seem overwhelming at first, but they can be powerful management tools once you understand the terminology used and conditions that raise a red flag. If you have questions about WIP reports and how to create and use them to monitor WIP on a regular basis, JLK Rosenberger can help. For more information, call us at 949-860-9902 or click here to contact us.