Please using excell

A B D E G H M N 0 P Q R S V 1 Consider a Wednesday morning flight from City A to City B. The aircraft has 100 seats and two fare classes: Y (first class), which sells for $300, and Q (economy class), which sells for $100. The demand for Y class seats is randomly distributed between 10 and 30 seats. class demand is also randomly distributed between 40 and 130 seats. For this flight, we make the simplifying assumption that the Q class passengers make reservations before the Y class passengers. Thus, the decision problem becomes how many Y class passengers to accept before closing the plane to Q class passengers. If we leave seats empty, there is the potential that there will not be any Y class passengers to demand them, but if we fill the seats with Q class passengers, then we may not have seats for the high-paying Y class passengers. Also, assume that any unmet demand due to lack of seats will be lost to other airlines. Complete the Excel file given below considering the following strategy, calculate the total revenue and the total empty seats for 30 3 weeks period; 4 Strategy: no control-passengers are permitted to purchase tickets as long as seats are available. 5 6 7 Total_Seats: Y class Q class 8 Price $ 300,00 $ 100,00 9 Demand [10, 30] [40, 130] 2 100 10 11 Strategy Y sales Week Q demand Y demand sales 12 13 Revenue Empty Seats 1 14 15 2 3 4 5 16 17 18 19 20 21 6 7 8 9 10 22 23 24 11 12 13 25 26 14 A B D E G H M N 0 P Q R S V 1 Consider a Wednesday morning flight from City A to City B. The aircraft has 100 seats and two fare classes: Y (first class), which sells for $300, and Q (economy class), which sells for $100. The demand for Y class seats is randomly distributed between 10 and 30 seats. class demand is also randomly distributed between 40 and 130 seats. For this flight, we make the simplifying assumption that the Q class passengers make reservations before the Y class passengers. Thus, the decision problem becomes how many Y class passengers to accept before closing the plane to Q class passengers. If we leave seats empty, there is the potential that there will not be any Y class passengers to demand them, but if we fill the seats with Q class passengers, then we may not have seats for the high-paying Y class passengers. Also, assume that any unmet demand due to lack of seats will be lost to other airlines. Complete the Excel file given below considering the following strategy, calculate the total revenue and the total empty seats for 30 3 weeks period; 4 Strategy: no control-passengers are permitted to purchase tickets as long as seats are available. 5 6 7 Total_Seats: Y class Q class 8 Price $ 300,00 $ 100,00 9 Demand [10, 30] [40, 130] 2 100 10 11 Strategy Y sales Week Q demand Y demand sales 12 13 Revenue Empty Seats 1 14 15 2 3 4 5 16 17 18 19 20 21 6 7 8 9 10 22 23 24 11 12 13 25 26 14