Making a gross profit margin sales bundle.

[chopper89]

Hello,

I am trying to make a sales bundle to offer to customers. I have it all done but the issue I am running into is with the unit amounts. I would like the add a section for "Units requested" and have that cell multiply with the "Cost" cell. Then have those cells trickle down to GP and GPP%, is this possible?

 

[Saba Sabaratnam]

Hi you could use this approach by entering the following cells.


B11 = B4*B9
B12 = =B5*B9
B13 = B11-B12
B15 = B13/B11

Kind regards

Saba