Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Specify decision variables, objective function, constraints . Solve using excel solver very clearly and write down optimal solution 3) The Burger Doodle restaurant chain purchases
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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