Maintaining an accurate forecast is tricky in terms of securing your team’s utilization for the coming months. Combining these stats with actual sales and a target goal is even more cumbersome and sometimes downright impossible.
One of the most common pitfalls in predicting revenue from utilization is detecting future deltas and being able to act on securing more business for that time. The tricky part isn’t closing deals and generating more business, but rather doing so in high times when business is booming. It’s easy therefore to be blinded by that short-term success.
With the help of handyman, Insights, you’ll be able to forecast revenues, highs, and lows, and whether or not your team is progressing towards its target.
To achieve this, we use the same principles as for accrued sales where we add two custom fields to the order row; start date and end date. This sets the duration for the project and calculates a daily value over time to show generated revenues instead of having them booked as a peaked one-off. Once in place, our BI-consultants can help set up an explore (where you build reports) specifically for accrued sales used to visualize forecasted revenues as below.
Use measures like Sales (Net), Pipeline (Net), and Target/Quota to generate a simple visualization of what’s to come in terms of revenue – i.e. what’s going on in week 14 in this dashboard?