Monthly run rate of various products

Modified on Thu, 14 Mar 2024 at 01:11 PM

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
Monthly run rate products UDDC formula sales amount Business Intelligence Support Business Intelligence Articles Business Intelligence Training

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article