which formula should i use

New Contributor

Hi I'm trying to figure out the best deal to order my items.

I have the the amount of the item  that cost me to purchase ,the quantity  of the item and how much i can make from the quantity combined.  So my question is there a formula i can make to see which items i can purchase to make the best profit,

 

3 Replies
Why not provide some sample data to clarify what you want !
I have 10 shirts that cost me 185.00 for 10 of them, They said I can make 1500. if I sold all of them so I m asking what shirts would be the best to purchase since they are all different prices

@cherylparsons1975 

With everyone's permission, here is a suggested solution ... in the file

 

Hope I could help you with these information / file.

 

NikolinoDE

I know I don't know anything (Socrates)