Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Royal Burger fast-food chain is planning to add meatless burgers to its menu. It's been testing fake-beef from three suppliers: NotLikely, AfterMeat, and Delicious. Delicious
Royal Burger fast-food chain is planning to add meatless burgers to its menu. It's been testing fake-beef from three suppliers: NotLikely, AfterMeat, and Delicious. Delicious is a startup with a very flavorful fake-beef that's inexpensive, but has high salt content. Royal is using a Blended LP model to determine what blend of fake-beef optimizes the cost per pound. Note: There are 16 ounces (oz) in a pound. The model solves for the weight of each fake-beef in 16oz of the optimal blend. There are 3 constraints on the blend: 1) salt content in milligrams(mg) must be 3000 or less; 2) a composite Flavorful Score -- in which each supplier's fake-beef has been rated from 1 to 10 -- must be 120 or more out of a possible highest score of 160(=1016oz); and 3 ) protein content must be 200mg or more. Below is the LP formulation showing Solver's optimized blend. a. Wha1 command was typed into cell E4? E4:= b. What Excel formula was put into cell E10? E10:= c. What were typed into cells F7, F8, and F9? F7: F8: F9: d. How should the following Solver window be filled out: d.1 "Solver Parameters": Set Objective: To: By Changing Variable Cells: d.2 "Subject to the Constraints": xcel e. How much of Delicious' fake beef is in 16oz of the optimal blend
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started