Hi,
My mind has gone blank - what would be the formula to calculate sales for a given NP% at a given %GP?
I've been using Excel's Goal Seek to flex the sales to give the desired %NP.
Replies (5)
Please login or register to join the discussion.
Tried again today - still struggling.
Can't say I've ever worked this way through, though.
I seem to start with the sales, and then work through to what the NP ends up being.
Do you know, I got similar to Paul - but then must have been a little confused..
Must be that A level maths I didn't take :)