-
Set availability problem
Hi,
I am not so good in math. I would be very thankful if anyone solves my problem. Thanks in advance.
I am writing a small business software. I would like to explain the problem with a simple example.
Lets assume we are running a small kiosk and we sell gift hampers. 1 gift hamper contains 8 items: 4 cookies, 2 chocolates, 2 cakes. Now lets say a customer orders 10 gift hampers.
Now the user of my software would enter 80 items:
80 items (10 gift hampers)
-- 40 cookies
-- 20 chocolates
-- 20 cakes
My software keeps track of all the items stock. Lets assume the availablity of the items is the following:
-- 30 cookies are currently available
-- 20 chocolates are currently available
-- 13 cakes are currently available
When the user enters 80 I need to show the user 48 as available. 48 because:
-- Only 30 cookies are available, which means 7 gift hampers are available, for 7 gift hampers we need 28 cookies which is the max. which can be delivered.
-- Chocolates are available, so there is nothing we have to calculate.
-- Only 13 cakes are available, which means 6 gift hampers are available, for 6 gift hampers we need 12 cakes which is the max which can be delivered.
Since the minimum gift hampers deliverable from above is 6, which means only 6 gift hampers can be delivered which is 48 items because a set or a hamper contains 8 items.
Can anyone guide me how to calculate 48?
Thanks in advance,
Tiya.