- Messages
- 291
- Reaction score
- 1,576
- Points
- 153
s12, q11
http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s12_qp_2.pdf
y isn't it =IF((I2/60)>5,INT(I2/300),1) and is =INT(1+I2/300)*G2 ??? Student of the year plz help if u can
see dear,
your formula means that if the no of hours is more than five then, the no of drivers should be min/300 or else 1.
but the ques says,
'Each driver can only drive for 5 hours and then cannot drive again during each journey.'
so what if the ans for I2/300 is 1.05, the comp will just show 1 driver, and what about the extra .05 hours, the same driver cant drive.
to get the right ans you first divide the total mins ie I2 by 300=5hrs, so you get the no of 300min in I2, and that becomes your no of drivers.
but you add 1, so that you have a driver for the extra time(which is less than 5hrs) after all 5hrs are done.
and finally you multiply that by G2, to get the total no of drivers needed for the journey, bcz there are more than 1 trucks for the journeys and till now we only found for 1 truck.and im sure you know why to add INT.
for eg: if the ans for I2/300=2.38, (so we know that we need 2 drivers,+an extra one for the .38 mins)
then +1=3.38, then INT=3, so we get 3 drivers.
and if G2(ie the no trucks)=4,
then 3*G2=12.
so now we get the total drivers for that journey.
Hope you understood.....??