1. Assuming that Frank will invest all $100,000, develop a linear programming model to determine the amount to be placed in each investment so that the total risk will be minimized while meeting the four portfolio goals, by a) first write out the complete formulation, b) then use Excel Solver to find the solution. (Hints: Risk is calculated by amount invested on a product multiplied by its associated risk factor; for example, if 5100 is invested in Atlantic Lighting, then its associated risk is 100x25=2500.)