I've been asked to produce a report on the effect of vendor delays on my timeline.
I have a team of 6 engineers who are supposed to be a PC roll out team. The Vendor is delayed because of various applications other parts haven't been tested in the new environment. Which is leaving the rollout team idle for x amount of days. This is a given but how do I record this time and the knock on effect on the timeline.
On paper the engineers should be knocking out 150 to 160 laptops per week. They work 8 hour days, so one per hour. We are rolling out 1700 pieces. How can I report this in excel, with the time constantly being impacted because of various applications and or infrastructure sometimes not being in place?