#219 New column on Budget Setup page (Estimated actual)

1.4.0
open
Stefano
Budgeting (17)
5
2016-07-24
2009-08-20
Webmaster33
No

New column would be needed on Budget Setup page: Estimated (actual)

Currently we can see, if all the estimated costs are realized, what will be the Estimated yearly summary.
However, I can not see, if my yearly spendings, will be possible to be kept based on spendings until now
The Estimated (actual) column should be calculated with this formula:
Daily estimated cost = Estimated (Year) / 365
Estimated (actual) = Daily estimated cost * Days elapsed

Example:
Estimated cost: monthly $100 = $1200 / year
Daily estimated cost = 1200 / 365 = $3,287 per day
On 1st august days elapsed is: 180 days
Estimated (actual) = 3,287 * 180 = $591,66
If I see, that I spent $500, then everything is all right.
If I see $800, then it should be displayed with RED and BOLD, because I will spend more than estimated until the end of the year.

Currently there are the following columns:
- Category
- Sub-Category
- Frequency
- Amount
- Estimated
- Actual

It should be changed to:
- Category
- Sub-Category
- Frequency
- Amount
- Estimated (Year)
- Actual
- Estimated (actual)

Discussion

  • Stefano

    Stefano - 2012-05-04
    • labels: 833061 --> Budgeting
     
  • Nikolay

    Nikolay - 2013-11-24
    • Group: 0.9.9.1 --> 1.0.1.0
     
  • Stefano

    Stefano - 2016-07-24
    • assigned_to: Stefano
    • Group: 1.0.1.0 --> 1.3.0
     
  • Stefano

    Stefano - 2016-07-24
    • Group: 1.3.0 --> 1.4.0
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks