NPD Summary Report - Logic

NPD Summary Sheet Logic As below

Report Parameter

NPD will run for the period : Start Date & End Date

Description

Country Wise> Division Wise> Marketing Spend> Regulatory Wise

No of SKUs

No of NPD SKU's

YTD Actual Sales

Sale USD

AOP

AOP USD

% AOP Achievement

Sales USD/ AOP USD

Adjusted
AOP

Adjusted AOP - IF Actual Launch Date <= StarteDate-1 then consider AOP from Start Date to report End Date otherwise From Actual Launch Date to report End Date.

% Adjusted AOP

Sale USD/ Adjusted AOP

Achievement vs Adjusted Budget

No Target

Count If No AOP defined in the range From Date to End Date

0 - 80%

Count if % Adjusted AOP fall range between 0 -80 %

80% - 110%

Count if % Adjusted AOP fall range between 0 -80 %

>110%

Count if % Adjusted AOP fall range between 0 -80 %

Success Rate >80%

(Count of 80%-110% + Count of >110% ) / (Count of 0-80% +Count of 80%-110% + Count of >110%)