Suppose you are setting up a linear programming model like the one seen below (it has some resemblance to the ones seen in the sections 3.1-3.3 slides, particularly the basketball / football example seen in part 3). Assume that range names are not being used (and that you won't create them, so specify cell references instead). Assume that the company wants to maximize profit based on a production plan of cars and trucks that satisfies the constraints on steel and aluminum. Question 7 What could you put in F16 to calculate the amount of steel used? I am open to whether you use the Excel function that is especially suited to this calculation or if you just want to specify the formula without the Excel function. Questions 810 continued on following page using the above info and screenshot... Make Unconstiained Varibbles Non-Negative Select a Solving Method: Sohing Methed Select the GRG Nonlineat engine for Solver Problems that are imooth nonlinear. Select the 19 Simplex engine for finear Solver Problems, and select the Evolutionany engine for Solver problems that are non-smooth. Question 8 What should you put in the "Set Objective" fleld of the Solver Parameters window? Question 9 What should you put in the "By Changing Variable Celis" field of the Solver Parameters window? Question 10 When adding the aluminum constraint, what would you put in the Cell Reference and Constraint fields of the Add Constraint window seen below? Separate the two parts of your answer with commas. If 1 is the number of oranges and 2 is the number of grapefruits, and each orange has 60mg of a nutrient and each grapefruit has 40mg of a nutrient, how would you specify a constraint based on oranges and grapefruits if you wanted to have at least 800mg of the nutrient? Question 6 If O is the number of oranges and G is the number of grapefruits, and each orange sold leads to $1.50 profit and each grapefruit sold leads to $2.25 profit, how would you specify the objective if you wanted to maximize profit? Suppose you are setting up a linear programming model like the one seen below (it has some resemblance to the ones seen in the sections 3.1-3.3 slides, particularly the basketball / football example seen in part 3). Assume that range names are not being used (and that you won't create them, so specify cell references instead). Assume that the company wants to maximize profit based on a production plan of cars and trucks that satisfies the constraints on steel and aluminum. Question 7 What could you put in F16 to calculate the amount of steel used? I am open to whether you use the Excel function that is especially suited to this calculation or if you just want to specify the formula without the Excel function. Questions 810 continued on following page using the above info and screenshot... Make Unconstiained Varibbles Non-Negative Select a Solving Method: Sohing Methed Select the GRG Nonlineat engine for Solver Problems that are imooth nonlinear. Select the 19 Simplex engine for finear Solver Problems, and select the Evolutionany engine for Solver problems that are non-smooth. Question 8 What should you put in the "Set Objective" fleld of the Solver Parameters window? Question 9 What should you put in the "By Changing Variable Celis" field of the Solver Parameters window? Question 10 When adding the aluminum constraint, what would you put in the Cell Reference and Constraint fields of the Add Constraint window seen below? Separate the two parts of your answer with commas. If 1 is the number of oranges and 2 is the number of grapefruits, and each orange has 60mg of a nutrient and each grapefruit has 40mg of a nutrient, how would you specify a constraint based on oranges and grapefruits if you wanted to have at least 800mg of the nutrient? Question 6 If O is the number of oranges and G is the number of grapefruits, and each orange sold leads to $1.50 profit and each grapefruit sold leads to $2.25 profit, how would you specify the objective if you wanted to maximize profit
