please answer correctly on excel and show workings on excel

Q11. (5 points) The operations manager for SSM Bus Company wants to decide whether she should purchase a small, medium, or large new bus for her company. She estimates that the annual profits (in $000) will vary depending upon whether passenger demand is low, moderate, or high, as follows. Demand Medium Bus Low High 70 Small 50 60 Medium 40 80 90 Large 20 50 120 Prior Probability 0.3 0.3 0.4 Required What is her expected value of perfect information? Show calculation for any credit