Actual Coverage calculation in MD04

[aravind_sankar]

actual-coverage-profile.jpg

Hi Experts,

Can anyone pls help me to understand how the Actual Coverage in MD04 is being calculated? I have gone through the several threads and applied the formula which is given in thread, But i am not getting the correct value,

I have made simple scenario to understand the basics calculation, later i can correlate this with my actual calculation. Much appreciated if you can help me, Thanks

Attaching the MD04 screen with " total period" screen in DAYS

[former_member424010]

Not sure if you’re looking for an explanation or a formula.

When I try to write a formula, it doesn’t match the value that is calculated in the period totals.I would think the formula should be to calculate average daily consumption as total demand/number of days in the period (2/7 – 2/15 = 9 days).1100/9 = 122.2 per day.Using that daily consumption rate, I’d calculate that the 1000 should last (1000/122.22) 8.18 days not 8.7.

Having said that, here’s how I think it comes up with actual days of coverage of 8.7

Starting on 2/6, by the 8th day (2/14) 800 of the 1000 available will be consumed.The remaining 200 will last another .67 days (200/300).

The same approach could be used for the subsequent dates

Starting on 2/7 by the 7^th day (2/14) 600 of the 800 available will be consumed.The remaining 200 will last another .67 days.

Starting on 2/9 by the 5^th day (2/14) 300 of the 500 available will be consumed.The remaining 200 will last another .67 days.

etc

Hope this helps

[aravind_sankar]

Any help on this please ?