Prоblem 1 (30 pоints)а. The number оf units expected to be sold is normаlly distributed with the meаn of 120 units and stand deviation of 5 units. If Rand ( ) is a random number between 0 and 1, then write down the function in EXCEL and the proper expression to simulate sales. (10 points)b. The simulation in Excel is to use to evaluate the potential net profit of the overbooking strategy in an airlines company. The capacity of the airplane from GFK to MSP is 120 seats. Due to the no show, the airline tends to overbook up to 125 tickets. Please use “if” function in Excel to express the number of boarded passengers. Use “X” as the number of boarded passengers. (10 points)c. The simulation in Excel is to use to evaluate the potential net profit of the overbooking strategy in an airlines company. The capacity of the airplane from GFK to MSP is 120 seats. Due to the no show, the airline tends to overbook up to 125 tickets. Please use “if” function in Excel to express the number of overbooking customers without seats. Use “Y” as the number of overbooking customers without seats in the airport. (10 points)