I am unsure how to set up in excel and find optimal solution. Thanks so much.

If the Merits want the weighted average risk level of their investments to not exceed 4, how much money will the need to set aside for Lisa's education and how should they invest it? Formulate an Lp model for this problem Create a spreadsheet model for this problem, and solve it using Solver. What is the optimal solution? A natural gas trading company wants to develop an optimal trading plan for the next 10 days. The following table summarizes the estimated prices per thousand cubic feet (cf) at which the company can buy and sell natural gas during this time . The company may buy gas at the " Ask" price and sell gas at the "Bid" price. The company currently has To maintain the required pressure in the gas transmission pipeline system, the company can inject no more then Assume extractions occur in the morning and injection occur in the evening. The owner of the storage facility charges a storage fee of (The average dialy inventory is computed as the average of each day's beginning and ending inventory.) Create a spreadsheet model for this problem and solve it. What is the optimal solution? Assuming price forecasts for natural gas change on a daily basis how would you suggest the company in this problem actually use your model? If the Merits want the weighted average risk level of their investments to not exceed 4, how much money will the need to set aside for Lisa's education and how should they invest it? Formulate an Lp model for this problem Create a spreadsheet model for this problem, and solve it using Solver. What is the optimal solution? A natural gas trading company wants to develop an optimal trading plan for the next 10 days. The following table summarizes the estimated prices per thousand cubic feet (cf) at which the company can buy and sell natural gas during this time . The company may buy gas at the " Ask" price and sell gas at the "Bid" price. The company currently has To maintain the required pressure in the gas transmission pipeline system, the company can inject no more then Assume extractions occur in the morning and injection occur in the evening. The owner of the storage facility charges a storage fee of (The average dialy inventory is computed as the average of each day's beginning and ending inventory.) Create a spreadsheet model for this problem and solve it. What is the optimal solution? Assuming price forecasts for natural gas change on a daily basis how would you suggest the company in this problem actually use your model