Calculation of Months of stock challenge

Support - Assistance technique
1

Dear All,
Has any one done something around calculating months of stock (MOS) for each reporting entity.

I am having challenge calculating MOS indicator which is calculated as

Stock on hand (reported monthly) / average monthly consumption (entered annually - constant throughout months in the year)

  • The Average monthly consumption (AMC) is constant throughout the year, so i set the data set for entering AMC data annual
  • Can not apply annualized indicator, as this different from target which can be distributed in the 12 months
    Any quick guidance will be very much appreciated

Regards,

···

Peter Dotto Lubambi,

Skype: plubambi
Mobile: +255 786 087 087

2

Dear Team,
Any idea on this?

Regards,

···

On Wed, Sep 13, 2017 at 1:17 PM, Peter D Lubambi plubambi@gmail.com wrote:

Dear All,
Has any one done something around calculating months of stock (MOS) for each reporting entity.

I am having challenge calculating MOS indicator which is calculated as

Stock on hand (reported monthly) / average monthly consumption (entered annually - constant throughout months in the year)

  • The Average monthly consumption (AMC) is constant throughout the year, so i set the data set for entering AMC data annual
  • Can not apply annualized indicator, as this different from target which can be distributed in the 12 months
    Any quick guidance will be very much appreciated

Regards,

Peter Dotto Lubambi,

Skype: plubambi
Mobile: +255 786 087 087

Peter Dotto Lubambi,

Skype: plubambi
Mobile: +255 786 087 087

3

Hello Peter,

Use a program rule with assign value if you are using tracker or an indicator if you are using the aggregate. Is this logistics use case?

Alex

···

Peter Dotto Lubambi,

Skype: plubambi
Mobile: +255 786 087 087

On Wed, Sep 13, 2017 at 1:17 PM, Peter D Lubambi plubambi@gmail.com wrote:

Dear All,
Has any one done something around calculating months of stock (MOS) for each reporting entity.

I am having challenge calculating MOS indicator which is calculated as

Stock on hand (reported monthly) / average monthly consumption (entered annually - constant throughout months in the year)

  • The Average monthly consumption (AMC) is constant throughout the year, so i set the data set for entering AMC data annual
  • Can not apply annualized indicator, as this different from target which can be distributed in the 12 months
    Any quick guidance will be very much appreciated

Regards,

Peter Dotto Lubambi,

Skype: plubambi
Mobile: +255 786 087 087