Need help with max profits

[bignoxes]

Hi, I need to setup a worksheet that will calculate the maximum profits based on several scenarios. Suppose I make widgets A through F to sell or rent. Widgets A through F all have different costs to make and will sell at different prices. For example – 100 Widget A costs $5 each and can either sell for $8 or rent for $1. 50 Widget B costs $8 each and can sell for $10 or rent for $1.50, etc. How can I set up a worksheet that will give me the best outcome by either selling and/or renting Widget A, B, etc. to maximize profit? Thanks.