How to calculate the Monthly run rate of various products?
Sales Amount is the total amount achieved (Sales Qty * Sales Price).
UDDC Name 1 : DayslapsedFYear - Lapsed Days in the Financial year
UDDC Formula : noOfDaysByDate(date(((ifCase(month(today())<4,(year(today()))-1,year(today()))))+"- 04-01"),today())
e.g: Consider today is 7th November 2015. DayslapsedFYear as per the formula will be the number of days between the financial year start date (1st April 2015) and today, which is 221 days.
UDDC Name 2 : TotaldaysFYear (Total days in the Financial Year)
UDDC Formula : (noOfDaysByFrequency("y", 0,true)+1)
e.g: Total days in this financial year (from 1st April 2015 to 31st March 2016), which is 365 days.
UDDC Name 3 : MonthlyRunRate
UDDC Formula : (SalesAmount / DayslapsedFYear) * (TotaldaysFYear/12)
The monthly run rate can be calculated by dividing the sales amount by the total lapsed days in the financial year and multiplying it with the average number of days in a month (Total days in the financial year / 12).
e.g: Consider today is 7th November 2015. SalesAmount = 90,629.50, TotaldaysFYear=365 and DayslapsedFYear=221.Therefore MonthlyRunRate ( (90,629.50 / 221)*(365/12)) is 12,507