Please provide solutions & fill out excel table

Directions Submit your file (pdif of word) with your ansuers, you can iment portions of your Excel file (e.g., as a picture) to supports your ansuers. Submit your solutions to Btskboard by midright toright. Problem 1 (5 pts): Railroad Investment: A Capital Budgeting Problem Background: At the turn of the 20th century, the ralkad industry is bocening, Irvestors and congloneates are keen to capitalise on this surge, eyeing several promising rafroad comparies. With a strategic borian of three years, the imestors ain to divest interosts in six companies, timing the sales to optimixe reverse as compary valus increase amid the boom. The dhallenge lies in deciding which companies to sell each your, considerirg the constraint that at least one but no more than three companies must be dvested anamlly. Investment Opportunities: The following table represents the projected reverase (in millions of dollars) from the sab of the six companies over the rext three years. These figures account for the expected growth in the railroad industry. Please de the following: - Formulate the LP in algetrai form to solve this jroblem. - Solve the LP and provile the solation. - Add anotber constraint that A and B cannot be sold in the same year. Directions Submit your file (pdif of word) with your ansuers, you can iment portions of your Excel file (e.g., as a picture) to supports your ansuers. Submit your solutions to Btskboard by midright toright. Problem 1 (5 pts): Railroad Investment: A Capital Budgeting Problem Background: At the turn of the 20th century, the ralkad industry is bocening, Irvestors and congloneates are keen to capitalise on this surge, eyeing several promising rafroad comparies. With a strategic borian of three years, the imestors ain to divest interosts in six companies, timing the sales to optimixe reverse as compary valus increase amid the boom. The dhallenge lies in deciding which companies to sell each your, considerirg the constraint that at least one but no more than three companies must be dvested anamlly. Investment Opportunities: The following table represents the projected reverase (in millions of dollars) from the sab of the six companies over the rext three years. These figures account for the expected growth in the railroad industry. Please de the following: - Formulate the LP in algetrai form to solve this jroblem. - Solve the LP and provile the solation. - Add anotber constraint that A and B cannot be sold in the same year