Break-Even

This widget presents the sum of displays your total sales for a given period compared , and compares it to a predefined target called "break-even target". 

Calculation

There are 2 different possible outputs:

The widget sums 

Settings

1. The target has already been achieved: The exceeded sales is displayed.
2. The target has not been achieved yet. It go through all the future opportunities that are in the selected period and predict the date when the target will be achieved.

To determine at which date the break-even target is susceptible to be reached, the expected close date and the expected amount of your opportunities are taken into account: the opportunities are sorted by most recent expected close date, and the projected date will correspond to the expected close date of the opportunity from which the break-even target would be exceeded if all the prior opportunities are won.

For example, if my sales to date is at $50,000.00 AUD at the 1st of January, and if I have 3 opportunities in my pipe:

• Opp1 which has an expected amount of $15,000.00 AUD, and that I expect to close on the 15th of Jan
• Opp2 which has an expected amount of $40,000.00 AUD, and that I expect to close on the 29th of Jan
• Opp1 which has an expected amount of $30,000.00 AUD, and that I expect to close on the 15th of Feb

If my break-even target is set at $100,000.00 AUD, then:

• the projected date will be 29th of Jan, because on the 29th of Jan. I am supposed to have been closed Opp1 and Opp2, which represents an addition of $15,000.00 + $40,000.00 = $55,000.00 to my total sales, which would bring me at $105,000.00.
• the number of opportunities to close is then 2.

Settings

• The target may be changed by clicking on it, a form will appear where the value can be edited.
• Time period selection: Only the invoices issued during the selected time period will be counted in the sales total.

Image AddedImage AddedImage Added