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!!
Bookmarks