Kindly solve option 3 from this case as an excel and kindly attach pictures before and after using SMIPLEX solver.

CASES CASE 9.1 Shipping Wood to Market In the past the company has shipped the wood by train. Alabama Atlantic is a lumber company that has three However, because shipping costs have been increasing, the al- sources of wood and five markets to be supplied. The anternative of using ships to make some of the deliveries is be- nual availability of wood at sources 1, 2, and 3 is 15, 20, ing investigated. This alternative would require the company and 15 million board feet, respectively. The amount that can to invest in some ships. Except for these investment costs, the be sold annually at markets 1, 2, 3, 4, and 5 is 11, 12, 9, shipping costs in thousands of dollars per million board feet 10, and 8 million board feet, respectively. by rail and by water (when feasible) would be the following for each route: Unit Cost by Rall (51,000's) Unit Cost by Ship (51,000's) Market Market 4 5 1 Source 1 2 3 2 3 4 5 72 1 2 3 61 69 59 45 60 63 78 55 49 61 66 56 47 31 36 38 43 33 24 28 36 24 32 35 31 26 66 The capital investment (in thousands of dollars) in ships re- quired for each million board foet to be transported annually by ship along each route is given as follows: Source 1 Investment for Ships ($1,000's) Market 2 3 238 318 270 250 283 275 268 275 303 285 293 WN 2 3 265 240 Considering the expected useful life of the ships and the Option 3: Ship by either rail or water, depending on which is time value of money, the equivalent uniform annual cost of less expensive for the particular route. these investments is one-tenth the amount given in the table. The objective is to determine the overall shipping plan that Present your results for each option. Compare. minimizes the total equivalent uniform annual cost (includ- current shipping and investment costs, so the decision on Finally, consider the fact that these results are based on ing shipping costs). You are the head of the OR team that has been assigned the option to adopt now should take into account manage- the task of determining this shipping plan for each of the ment's projection of how these costs are likely to change in the future. For each option, describe a scenario of future cost following three options. changes that would justify adopting that option now. Option 1: Continue shipping exclusively by rail. Option 2: Switch to shipping exclusively by water (except where (Note: Data files for this case are provided on the book's only rail is feasible). website for your convenience.)