Great Western University (GWU) has a strong athletic program. Its football program has grown tremendously under the current coach: Bob Smith. As a result, the attendance for in-campus games has been on the rise. Analysis of forecasts show that the current football stadium will reach its capacity within next few years. After a serious financial analysis, GWU administrators have given approval to expand the capacity of its on-campus football stadium.
GWU's football stadium has seven sections: East, West, North lower section, North upper section, South lower section, South upper section, and Luxury Club section. The spreadsheet gives the attendance data for each section since 2000. Although any combination of sections can be selected for expansion, the GWU administrators want to increase capacity of only two sections due to complexity of the project, limitations of budget, and time constraints. To select the two sections for expansion, attendance data for each section can be used.
GWU plans to add at least 1,600 seats to the stadium. However, each section has a maximum limit for expansion. For example, only 1000 seats can be added to East zone. In addition, revenue generated from each seat and installation cost for each seat is different for each section. Furthermore, contractors would install seats in increments of 50, only. (i.e. 50, 100, 150, ....). GWU wants to find out how many seats can be installed in the selected two sections, such that it will maximize the revenue. The maximum available budget is $500,000.
The expansion will start immediately after the end of current football season and needs to be completed before start of the next season. This would allow exactly 270 days for the total project. If the project is not finished within 270 days, next year's opening game will be in jeopardy! Therefore, the construction needs to be finished early, not just on time. GWU would like to know about the probability of finishing the expansion in 270 days. The activities for the project is also given in the spreadsheet.
Objectives
1. Analyze GWU's attendance data and determine which zones need an expansion.
2. Calculate number of additional seats for each selected section.
3. Develop a network drawing for the expansion project and identify critical path(s) and calculate expected finish time.
4. Calculate the probability of finishing the project in 270 days.
5. Calculate the costs for finishing the project early (250 days or 240 days).
6. Provide recommendations on:
a. The sections need to be expanded and number of seats in each section.
b. Project management. If the probability of finishing within 270 days is less than 75%, project needs to be crashed.