Nutritional Guidelines:. Between 1700 and 2200 calories•At least 50 but no more than 100 grams of proteinAt least 150 grams of carbohydrates• No more than 70 grams of fatCaloriesProteinCarbohydrates FatChicken335 (140g)38gOg19 g213 (85g)Beef22g013g366 (178g)Fish39g022gRice206 (158g)4.3g45g.4g42 (12g)Beans2.6g8g.lgBread79 (30g)2.7g15g1ga. Formulate a linear programming model for this problem and solve.b. show your model solving results the optimal solutions andoptimal value of the objective function). Solve the model by using excelprice/lb$1.29$5.89$6.99$.99$1.99$1.99

In this question, First, I would formulate the LP, after this LP formulation, I would solve this…

Answered: a. Formulate a linear programming model…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Please do not give solution in image format thanku
List some of the basic ideas for solving certain important types of nonlinear programming problems?
Brady Corporation produces cabinets. Each week, itrequires 90,000 cu ft of processed lumber. The companymay obtain lumber in two ways. First, it may purchaselumber from an outside supplier and then dry it in thesupplier’s kiln. Second, it may chop down logs on its ownland, cut them into lumber at its sawmill, and finally dry thelumber in its own kiln. Brady can purchase grade 1 or grade2 lumber. Grade 1 lumber costs $3 per cu ft and when driedyields 0.7 cu ft of useful lumber. Grade 2 lumber costs $7per cubic foot and when dried yields 0.9 cu ft of usefullumber. It costs the company $3 to chop down a log. Afterbeing cut and dried, a log yields 0.8 cu ft of lumber. Bradyincurs costs of $4 per cu ft of lumber dried. It costs $2.50per cu ft of logs sent through the sawmill. Each week, thesawmill can process up to 35,000 cu ft of lumber. Eachweek, up to 40,000 cu ft of grade 1 lumber and up to 60,000cu ft of grade 2 lumber can be purchased. Each week, 40hours of time are available for…
Analyze algebraically what special case in simplex application is present in each of the LP model below. Give an explanation to support your answer. a) Maximize z = 4x1 + 2x2 Subject to: 2x1 - x2 ≤ 2 3x1 - 4x2 ≤ 8 x1, x2 ≥ 0b) Maximize z = 3x1 + 2x2 Subject to: 4x1 - x2 ≤ 8 4x1 + 3x2 ≤ 12 4x1 + x2 ≤ 8 x1, x2 ≥ 0
Solver is guaranteed to solve certain types of nonlinear programming models. T/F
Under what circumstances is the objective function more important than the constraints in al linearprogramming model?
A farm consists of 600 acres of land, of which 500 acres will be planted with corn, soybeans, and wheat, according to these conditions: At least half of the planted acreage should be in corn No more than 200 acres should be soybeans The ratio of corn to wheat planted should be 2:1 It costs $20 an acre to plant corn, $15 an acre to plant soybeans, and $12 an acre to plant wheat Formulate this problem as an LP model that will minimize planting cost while achieving the specified conditions.
Don't Hand writing in solution.
eBook Problem 11-3 Consider the following all-integer linear program: Max 1x₁ + 1x₂ s.t. 4x₁ + 6x₂ = 22 1x₁ + 5x₂ = 15 2x₁ + 1x₂ = 9 x₁.₂0 and integer a. Choose the correct graph which shows the constraints for this problem and uses dots to indicate all feasible integer solutions. (0) (III) 72 1 (1) (iv) ¹2 2 54 1
4. Consider the following linear programming problem: Maximize Z=$15x + $5y, subject to (1) 2x + y ≤ 10 and (2) 4x + 3y ≤ 24 and (3) x, y ≥ 0. Will the optimal solution change if the objective function becomes Maximize Z=$15x + $20y (constraints remain the same)? Select one: a. Can't determine given the information. b. Yes, it will change. c. No, it remains the same.
Solve Using Excel solver in Linear Optimization Problems. Must present the excel solver output including (answer report sensitivity report and limits report) 1. A calculator company produces two models of calculators at two different factories. Factory A can produce 130 scientific calculators and 25 graphing calculators per day. Factory B can produce 70 scientific and 90 graphing calculators per day. It cost $1200 per day to operate Factory A and $900 per day to operate Factory B. If the company needs to produce 460 scientific calculators and 340 graphing calculators for a big order, find the minimum cost to produce the order.(please help)
A farmer owns 450 acres of land. He is going to plant each acre with wheat or corn. Each acre planted with wheat yields $2000 profit, requires three workers, and requires two tons of fertilizer. Each acre plantedwith corn yields $3000 profit, requires two workers, and requires four tons of fertilizer. There are currently 1000 workers and 1200 tons of fertilizer available.a. Use Solver to help the farmer maximize the profit from his land.b. Confirm graphically that the solution from part a maximizes the farmer’s profit from his land.c. Use SolverTable to see what happens to the decision variables and the total profit when the availability of fertilizer varies from 200 tons to 2200 tons in 100-ton increments. When does the farmer discontinue producing wheat? When doeshe discontinue producing corn? How does the profit change for each 100-ton increment?

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

a. Formulate a linear programming model for this problem and solve. b. show your model solving results the optimal solutions and optimal value of the objective function). Solve the model by using excel