Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For each linear programming formulation, please clearly state the three elements (definition of decision variables and their measurement units, objective function and constraints). Please
For each linear programming formulation, please clearly state the three elements (definition of decision variables and their measurement units, objective function and constraints). Please briefly explain each constraint, such as "capacity limit for resource A". Problem 2 Delectation Delicatessen is the best take-out sandwich shop in the neighborhood, and business is booming. Business is so good that it can sell all of the sandwiches that it can make. Delectation only sells two types of sandwiches: the "Surf-n-Turf" which sells for $6.95, and the Fish-n-Fowl which sells for $5.50. Ingredient lists from the recipes for the two sandwiches are: The Fish-n-Fowl: 0.25 pounds of tuna fish salad 0.5 pounds of sliced turkey 2 slices of rye bread 1 slice of pumpernickel bread The Surf-n-Turf: 0.40 pounds of sliced roast beef 0.25 pounds of tuna fish salad 1 slice of rye bread 1 slice of pumpernickel bread Delectation gets all of its meats and breads from Edith's Wholesale Restaurant Supply. Based on conversations he has had with his customers, delectation's proprietor Joe has become convinced that it is the high quality of Edith's ingredients, as well as the deli's unique sandwich recipe, that makes Delectation Deli so popular. To assure a steady supply of ingredients, Delectation has entered into a long-term contract with Edith where, for a fixed sum of money, Edith's delivers 60 pounds of roast beef, 200 pounds of tuna salad, 260 pounds of turkey, 60 loaves of rye bread, and 32 loaves of pumpernickel bread each day. Assume that a loaf of bread has a dozen of slices. (a) Delectation wants to determine the number of Fish-n-Fowl and the number of Surf-n-Turf sandwiches it should make each day to maximize the deli's revenues. Formulate this problem as a linear program. (b) Implement the formulation in a spreadsheet and solve the problem using a spreadsheet optimizer (Excel Solver). Attach a one-page printout showing your model implementation in Excel and a one-page printout of the answer report.
Step by Step Solution
★★★★★
3.33 Rating (150 Votes )
There are 3 Steps involved in it
Step: 1
Decision variable The decision variable is the number of each item that should be made In t...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