Solve through Excel Solver

Question 4: [5+5] The concessionaire for Carnegie Hall has developed a table of conditional values for the various alternatives (stocking decision) and states of nature (size of crowd). Alternative 1 Alternative 2 Alternative 3 Large 19,000 22,000 15,000 Average 12,000 16,000 12,000 Small |-2,000 16,000 5,000 The concessionaire has no idea what sort of crowd might materialize it has been decades since the Del Aires last performed together, but there has been a resurgence in interest thanks to a re-release of the classic movie Horror of Party Beach. Determine: (a) the optimal alternative if the concessionaire is an optimist. (b) the optimal alternative if the concessionaire is a pessimist