Product Selector Worksheet Challenge

[excelwizardnonotyet]

Hello everyone
This is my first post on here, so please be easy on me!!

I was hoping that someone could help me in creating a worksheet for work.

Basically, I have a product, lets call it a Deadlock A, this costs £5.40. To go with this I need to add a Cylinder A which costs £15.45.
However I now have an alternative supplier who will offer their equivalent products at costs of £6.00 and £12.01 respectively. However, I can only get this better prices when buying the two products together on the same order. If I was just to order 10Nr Deadlocks, the price could go up to £8.00.

On a project, I may have for instance 10Nr Deadlocks and 10Nr Cylinders, which will cost £208.50 from my existing supplier, and £180.10 from the new supplier. Obviously in this case I will select the new supplier to save me £28.40

However on a different project, I may need to have 10Nr Deadlocks but only 1Nr Cylinders which will cost £69.45 and £72.01 respectively. So in this case I would be better off in selecting my original supplier.

I wondered if someone would be able to help me create a little tool so that I can select the type and quantity of product I want to use, and Lookup to see what is the best deal for me.

I would just mention that there is not just Deadlocks and Cylinders, but a variety of different products. Maybe we could use two product classifications, such as Lockcases (Deadlocks, Sashlocks, Latchs etc) and Cylinders.

I hope that makes some sense, like to hear from someone wanting to take up a challenge!

Thanks!!

[excelwizardnonotyet]

Hello everyone, can anyone help me out on this one?

[vlady]

Hello

If you could prepare at least a dummy worksheet (Scratch)with the above data's and upload it , someone could have a better understanding it.

We are here to help on solving problems that you may encounter, preferably not making a worksheet.
That's why you go first, i mean create a workbook based on your idea.