Retail Predictive Application Server (MOSC)

MOSC Banner

MFP RETAIL - COGS CALCULATION

edited Feb 24, 2017 12:24PM in Retail Predictive Application Server (MOSC) 3 commentsAnswered

Hi,

I'm analyzing the module MFP RETAIL release 15.0, looking into the workbook "Develop and publish Department Target (task Preseason Create MFP)" the measure Wp COGS C is calculated in the following way: MOWPCOGSC = (MOWpSlsNetR + MOWpMkdR + MOWpShrinkR) * ( 1- MOWpCMUp ).

I have a doubt about calculation because it's based on Wp Sales Net VAT R (MOWpSlsNetR) - that have the same value of Wp Sales R (MOWpSlsR) if the VAT is 0% - and on meassure Wp Markdown R.

So in this case the measure Wp Sales R (MOWpSlsR) representing sales that already includes the markdown with this formula --> MOWpSlsR = MOWpSlsRegR + MOWpSlsClrR + MOWpSlsProR

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center