I want to calculate how many flight tickets I would need to buy if I have a total of 6 men working in three (3) teams two (2) at the time at a building site for 4 weeks in a row that is projected to take 20 weeks. This way I always have 4 men on site, with one team overlapping the other. I also would like for the calculation to be variable, i.e. changing the duration to 40 weeks and the crew size etc. So far my calculations in Excel have been very static and only work for a specific set of rules. Any help?
So far I have tested a calculation for a construction duration of 10 weeks. You always have two teams working out and one team home. You also know that you have at least two tickets (1 tour/retour) for each team member. For this exact situation I got it to a total of 24 tickets. You start by sending two teams awy (4 tickets). One team is working 4 weeks and the other is working 2 weeks. Then the 3rd team is sent in, and the 2 week team sent home and the next team is then working 4 weeks. This way you always have 4 tickets every time (2 leaving and 2 returning) This occurs 6 times in 10 weeks. 6 times 4 (the total amount of individuals traveling each time) is 24. This is correct and all. But what if I chnge the duration to 40 weeks and the crew size from 2 to 4 or 8?! Confuses me a lot! Any help would be greatly appreciated! KR Martin Andreas
Try to look at one variable at a time. Notice that crew size doesn't really matter, it just scales the overall answer. So assume crew size is $1$. Similarly the duration each crew stays and overall time for the job can be seen to be essentially scaling the overall result (some constant addition might be there). Now, try to solve the problem if at any given time, you need $r$ teams on site, instead of just $2$.