3- Suppose you have the information of some of chickens farms (F1 , F2) as fallow: E G chicken chicken Age in months chicken discount new Numbers of total farms no color price $ rate chicken price...

None

Extracted text: 3- Suppose you have the information of some of chickens farms (F1 , F2) as fallow: E G chicken chicken Age in months chicken discount new Numbers of total farms no color price $ rate chicken price chicken in the farm price $ 1 F1 3 1000 F2 4 w ? 2000 ? F2 5 в ? 1500 F1 w 2000 6 F1 3 w ? ? 1500 F2 B 3000 1- Find the chicken price depending on the chicken age and color as fallow : Chicken age >= 6 months and chicken color B → 3$ Chicken age >=6 months and chicken color W > 2.5 $ chicken age <6 months="" and="" chicken="" color="" b=""> 2$ chicken age <6 months="" and="" chicken="" color="" w=""> 1.5 $ 2- Find the discount rate depending on chicken color as fallow : Chicken color B > -3% , chicken color W > -2% 3- Find the new chicken price for each farm, where new price%3Dold price+(discount rate*old price) 4- Find the total price for each farm. 5- In cell D10 find sum of total price of chicken color W and chicken age [4..8] months