If you have solution Message me ... otherwise DONT bid

You have 1275 rooms They are divided into 3 Categories ( Interior Room ) ( Ocean View ) ( Balcony ) This is your "room type" Their Designations are , I ; O ; B Each Category consists of 3 subdivided Sub-catagories namely 2 Sleeper rooms MAX Limit of 2 persons allowed Subdivision designation = 1 3 Sleeper rooms MAX Limit of 4 persons allowed Subdivision designation = 2 4 Sleeper rooms MAX Limit of 4 persons allowed Subdivision designation = 2 ** Set Parameter to Max 4 person occupancy . If you understand that, then you will be able to say that I1 = a Interior Room with max 2 capacity O1= a Ocean View with Max 2 capacity B1 = a Balcony with Max 2 capacity which means I2 = Interior Room ( Max 4 ) O2 = Ocean View ( Max 4 ) B2 = Balcony ( Max 4 ) OKAY Talking about people : A = Adults meaning A1= Adult Number one A2 = Adult Number two A3= Adult Number three or A3 = ( C0;C1;C2 ) A4= Adult Number four or A4 = ( C0;C1;C2 ) where as C0 = Child ( 0 - 3 years ) C1 = Child ( 4 -12 years) C2 = Child (13 -17 years ) The reason this is important because in the formula these will stay a constant C0 = R 600 C1 = R1680 C2 = R2057 ** Children can share with 2 Adults and only have C0;C1;C2 Values as indicted above So ALL Formulas start as ( A1 + A2 ) but if Adults not = 2 Then Child 1 and if need Child 2 = Adult Value to Make the Minimum equation work Now THE SCOPE OF THE PROJECT IS Create a system where the User is asked 1 Indicate number of persons 2 INDICATE HOW MANY ADULTS 3 Indicate number of children 4 How many of them C0 5 How many of them C1 6 How many of them C2 7 Cabin Type 8 How many Cabins With this data we can now identify which cabins are suitable And allocate them accordingly to the clients. That being said if Number of people input = 2 then I1 = A1 + A2 = I1 = R 4617 + R4617 O1 = A1 + A2 = O1= R4917 + R4917 B1 = A1 + A2 = B1 = R5417 + R5417 If Number of people input was 3 then I2 = A1 + A2 + A3 = I2 = R 4367 + R4367 + R4367 O2 = A1 + A2 + A3 = O2 = R4717 + R4717 + R4717 B2 = A1 + A2 + A3 = B2 = R5217 + R5217 + R5217 If formula A1+A2 +( 3rd) A3 or (C0;C1;C2)= I2;O2;B2 ** Parameter set if A=0 pretend C =A, to the first 2 Values A1 + A2 if it was 2 Adults and 1(one) child the Designation C0;C1;C2 would substitute the Value of A3 If Number of people input was 4 then I2 = A1 + A2 + A3 + A4 = I2 = R 4167 + R 4167 + R 4167 + R 4167 O2 = A1 + A2 + A3 + A4 = O2 = R 4517 + R 4517 + R 4517 + R 4517 B2 = A1 + A2 + A3 + A4 = B2 = R4967 + R4967 + R4967 + R4967 If A3 or A4 = ( C0;C1;C2 ) yhen those rates would be replaced with C0 = R 600 C1 = R1680 C2 = R2057 if more than 4 persons where selected the system will have allocations and values to be determined at the end of the project I need to know cabin allocation and Number of pax in that cabin If you can solve this you will be my hero !!