PLEASE SHOW WORK AND FORMULAS IN EXCEL!! THANK YOU!!

(2) (3 pts) A hotel numbers its fare classes from higher to lower as 1, 2, 3 and 4. The room prices for these classes are pi=$300, p2=$250, p3=$200, P4=$150. The demands for these fare classes are denoted by D1, D2, D3 and D4. These demands turn out to have uniform distributions with the following ranges: Di [0, 10), D2 [0, 10), D3 [0, 10], D4 [0, 10). a) Use EMSR-a heuristic to find the protection level y3 for classes {1, 2, 3}? b) Use EMSR-a heuristic to find the protection level y2 for classes {1, 2}? c) Use EMSR-a heuristic to find the protection level y for class {1}