Monitoring KPI on weekly, monthly and Week todate basis

%3CLINGO-SUB%20id%3D%22lingo-sub-2278861%22%20slang%3D%22en-US%22%3EMonitoring%20KPI%20on%20weekly%2C%20monthly%20and%20Week%20todate%20basis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2278861%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20considering%20of%20monitoring%20Key%20Performance%20indicators%20on%20weekly%20target%20vs%20weekly%20actuals.%3C%2FP%3E%3CP%3EI%20plan%20to%20%3A%3C%2FP%3E%3CP%3E1)%20Replace%20the%20monthly%20targets%20and%20actuals%20with%20Weekly%20targets%20and%20actuals%20(Wk1%20to%20Wk52)%3CBR%20%2F%3E2)%20Maintain%20the%20Month-to-date%20(MTD)%20and%20the%20Year-to-Date%20(YTD)%20monitoring%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20sure%20but%20I%20think%20the%20biggest%20challenge%20is%20to%20translate%20the%20week%20to%20monthly%20and%20current%20week%20todate.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2278861%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

I am considering of monitoring Key Performance indicators on weekly target vs weekly actuals.

I plan to :

1) Replace the monthly targets and actuals with Weekly targets and actuals (Wk1 to Wk52)
2) Maintain the Month-to-date (MTD) and the Year-to-Date (YTD) monitoring

 

I am not sure but I think the biggest challenge is to translate the week to monthly and current week todate.

0 Replies