Instructions: Solve using Excel Solver. Create the linear programming model and get the optimal solution to the problem. (Follow the steps and format in the photo below)2. A farmer has 1000 acres of land on which he can grow com, wheat, and soybean. The following table lists the cost of preparation for each acre, man-days of work required and profit yielded in $. The farmer has $100,000 for preparation and can count on 8000 man-days of work. How will the farmer allocate his land to get maximum profit? Cost ($)Work DaysProfit ($)Corn100730Wheat1201040Soybean70820 FOR EACH PROBLEM, the following muct be Inoluded in your ancwer:1. Definition of deolcion variablec and LP model2. Boreenchot of input coreen (cimlar to the figure below)1 Eample3 Imput DutaProduct P1Product P2LHS TotasS Constants6 Obective Function7 Machine 18 Machine 29 Machine 310 Nonnegtivity3040800110011123 Dupur Reuts14IS Solution3. Soreenchot of Answer Report (eimilar to figure below; Inolude headinge withtimectamp)Taget CeCelNameOrignl va ial valCetentien HS TetahAdjustae cCrigial valu Final Vale00CellNameSIS SelutionaKS SokatenContrantsCelFormlaseS Not ngs rdng1 se BrdingNameStatanMaksOS Manes TotatSoda Machne 2S TetahMahS Total4. Conoluciondl

Let x acre of land be allocated for corn y acre of land be allocated for wheat z acre of land be…

Answered: A farmer has 1000 acres of land on…

Algebra and Trigonometry (6th Edition)

6th Edition

ISBN:9780134463216

Author:Robert F. Blitzer

Publisher:Robert F. Blitzer

ChapterP: Prerequisites: Fundamental Concepts Of Algebra

Section: Chapter Questions

Problem 1MCCP: In Exercises 1-25, simplify the given expression or perform the indicated operation (and simplify,...

See similar textbooks

Related questions

Question

100%

Instructions: Solve using Excel Solver. Create the linear programming model and get the optimal solution to the problem. (Follow the steps and format in the photo below)

2. A farmer has 1000 acres of land on which he can grow com, wheat, and soybean. The following table lists the cost of preparation for each acre, man-days of work required and profit yielded in $. The farmer has $100,000 for preparation and can count on 8000 man-days of work. How will the farmer allocate his land to get maximum profit?