90.2K

Verified Solution

Link Copied!

Specify decision variables, objective function, constraints . Solve using excel solver very clearly and write down optimal solution

3) The Burger Doodle restaurant chain purchases ingredients from four different food suppliers. The company wants to construct a new central distribution center to process and package the ingredients it uses in its menu items before shipping them to their various restaurants. The suppliers transport the food items in 40 -foot tractor-trailer trucks. The coordinates of the four suppliers and the annual number of truckloads that will be transported to the distribution center are as follows: Determine the set of coordinates for the new distribution center that will minimize the total miles traveled from the suppliers. decision variables, objective function and constraints. B. Create a spreadsheet model for the problem and use Solver to find the optimal solution. Separate input data from calculations. Include all the input data provided in the Word problem and use Excel to perform calculations. c. Provide a screenshot of the model. Use '=FORMULATEXT' to show the calculation for the objective function and the left hand side of the constraints. d. Provide a screenshot of the Answer Report including the top section with the log from Solver. C. What is the optimal location for the new distribution center and total miles traveled from the suppliers? Communicate the recommendation in plain English. It is acceptable to use tables for clarity. 3) The Burger Doodle restaurant chain purchases ingredients from four different food suppliers. The company wants to construct a new central distribution center to process and package the ingredients it uses in its menu items before shipping them to their various restaurants. The suppliers transport the food items in 40 -foot tractor-trailer trucks. The coordinates of the four suppliers and the annual number of truckloads that will be transported to the distribution center are as follows: Determine the set of coordinates for the new distribution center that will minimize the total miles traveled from the suppliers. decision variables, objective function and constraints. B. Create a spreadsheet model for the problem and use Solver to find the optimal solution. Separate input data from calculations. Include all the input data provided in the Word problem and use Excel to perform calculations. c. Provide a screenshot of the model. Use '=FORMULATEXT' to show the calculation for the objective function and the left hand side of the constraints. d. Provide a screenshot of the Answer Report including the top section with the log from Solver. C. What is the optimal location for the new distribution center and total miles traveled from the suppliers? Communicate the recommendation in plain English. It is acceptable to use tables for clarity

Answer & Explanation Solved by verified expert

See Answer