Need the answer for a,d and e a. Formulate a linear programming model for thisproblem on a spreadsheet.b. Use the spreadsheet to check if (x, X2, X3} 3 (1, 2, 2)is a feasible solution and, if so, what the daily costwould be for this diet. How many units of eachnutritional ingredient would this diet proviie datly?3.13varehomadec. Take a few minutes to use a trial-and-ecror appr0schwith the spreadsheet to develop your best guess forthe optimal solution. What is the daily cost for yourmonthsmonthsquite dsolution?d. Use Solver to find an optimal solution.unounother he. Express the model in algebraic form.monthsMaureen Laird is the chief financial officer for the Alvaexpensfive mElectric Co., a major public utility in the Midwest. The com-pany has scheduled the construction of new hydroelectric plants5, 10, and 20 years from now to meet the needs of the growingpopulation in the region served by the company. To cover thechangilease aevery i 234 5ormulation and Applicationsproblem having theThe space requirement and 1leasing periods are as followsassets produce income 5, 10, and 20 years from now, and thotincome is needed to cover minimum cash flow requirements inMonthMinimumthose years, as shown in the following table.1.AcceptableLevelIncome per Unit of Asset4.08Minimum09110Cash FlowYearAsset 1Asset 2Asset 3Required$2 million4 millionLeasing Period(Months)$8 million5.$4 million$1.6 billioning model for this2 million2 million400 million6 million8 million1.2 billionn choosing for thesheet to check eachMaureen wishes to determine the mix of investments in thesele, for the value ofassets that will cover the cash flow requirements while minimiz-ing the total amount invested.asible guess has thea) Formulate a linear programming model for thisproblem on a spreadsheet.b. Use the spreadsheet to check the possibility of pur-chasing 100 units of asset 1, 100 units of asset 2, and200 units of asset 3. How much cash flow would thismix of investments generate 5, 10, and 20now? What would be the total amount invested?lution.ned farm. To sup-The objectives o minimrm, Fred also raisesing the space reqrements.a. Indicate why thilem by identifyiefits being soughb. Identify verbally-Indhe quantities of thealfa) that should beof these feed types,years frommeet certain nutri-number of units ofTake a few minutes to use a trial-and-error approachwith the spreadsheet to develop your best guessfor the optimal solution. What is the total amountinvested for your solution?ined within a kilo-straints on theseg table, along withof performancec. Convert these vis.and the measurexpressions in td. Formulate a spreMinimumKilogramKilogram ofTankageDailyRequirementof Alfalfatify the data cell:and the other o09180tion for each o08150207209UCT function. T09e. Summarize the3.14.Consider the followbenefit-trade-off problemmodel for thisUse Solver to find an optimal solution.Summarize the model in algebraic form.and A4):, X) = (1, 2, 2)at the daily costunits of each3.13.2.13 Web Mercantile sells many household productsuch an online catalog. The company needs substantialMinimize Cowarehouse space for storing its goods. Plans now are beinemade for leasing warenouse storage space over the next fivesubject toprovide daily?-error approachmonths. Just how much space will be required in each

Question

Accepted Answer

Answered: Image /qna-images/answer/ba6768b7-9f01-4577-9642-5bfb623eba61.jpg