PLEASE PROVIDE THE ANSWERS USING MICROSOFT EXCEL WITH THE SOLVER TOOL. If someone posts an answer that is already posted I will report the answer. I know how to do the problem but I need to translate it into Microsoft excel with the solver tool.

Two opposing armies, Red and Blue, must each decide whether to attack or defend. These decisions are made without knowledge of the opposing army's decision. The payoff table, in terms of value of property gained or lost for the Red Army, appears below. Any gains for the Red Army are losses for the Blue Army. Blue Army Attack Defend 30 50 40 0 Red Army Attack Defend a. What is the optimal mixed strategy for the Red Army? b. What is the optimal mixed strategy for the Blue Army