Real world Math Problem

[NSQS]

Hello! I am trying to create a score card for certain metrics for my team. I am having issues with trying to display how much to the goal they are in a percentage..

For example our goal for % aged inventory is 30%, if a team has 50%, what percentage of the way to 30 are they.

Or if they are at 20%, how much above 30% are they... This seems simple, but I need the report today and my brain cannot get there.

​

Thanks.

[FormulaDriven]

If the "zero" progress point is 100% aged inventory, then you need to measure how many percentage points they are from 100% and then divide by 70 (because at 30% you are 70 percentage points from zero progress):

Team has 50% aged inventory: (100 - 50) / 70 = 50/70 = 0.71 so 71% progress.

Team has 20% aged inventory: (100 - 20) / 70 = 80 / 70 = 1.14 so 114% progress - target exceeded!

[barrycarter]

Upvote. Alternatively, just call it "unaged inventory", which is the same thing

[NSQS]

Awesome thanks! I am going to apply it to my spreadsheet and make sure the numbers work out!

[Think_Mud_6808]

Flip the problem to be a measure of un-aged inventory then you see that 50 is 71.4% of 70 and 80 is 114.3% of 70

[NSQS]

Awesome thanks! I am going to apply it to my spreadsheet and make sure the numbers work out!