Airline Simulation

Image
Tools V-Lookups, RAND(), Tables

This project is a Monte Carlo simulation model developed for Green Airways to forecast and analyse an overbooking strategy. The model is built using Excel and is designed to simulate an overbooking strategy of 5 customers over plane capacity. The simulation looks to analyse the profit per flight when encountering no shows, and over booking resulting in bumped passengers. The simulation model is simulated over a 500-day period.