PLEASE SHOW SCREENSHOTS OF THE STEPS AND FORMULAS USED IN PART B FOR SOLVER IN EXCEL TO FIND THE OPTIMAL SOLUTION. **this is critical for the solution** Please read the question!!! Please do not copy someone else's answer. I have already seen those and it is not what I need!!! Stop spamming the same answer everyone else is giving or else I will report it. A business executive has the option to invest money in two plans: Plan A guarantees that each dollar invested will earn $0.90 a year later, and plan B guarantees that each dollar invested will earn $2.50 after 2 years. In plan A, investments can be made annually, and in plan B, investments are allowed for periods that are multiples of 2 years only. How should the executive invest $500,000 to maximize the earnings at the end of 3 years? a) Define the variables and formulate the objective function and its constraints. b) Use solver to find the optimal solution. PLEASE SHOW SCREENSHOTS OF THE STEPS AND FORMULAS USED IN PART B FOR SOLVER IN EXCEL TO FIND THE OPTIMAL SOLUTION. **this is critical for the solution** Please read the question!!! Please do not copy someone else's answer. I have already seen those and it is not what I need!!! Stop spamming the same answer everyone else is giving or else I will report it. A business executive has the option to invest money in two plans: Plan A guarantees that each dollar invested will earn $0.90 a year later, and plan B guarantees that each dollar invested will earn $2.50 after 2 years. In plan A, investments can be made annually, and in plan B, investments are allowed for periods that are multiples of 2 years only. How should the executive invest $500,000 to maximize the earnings at the end of 3 years? a) Define the variables and formulate the objective function and its constraints. b) Use solver to find the optimal solution