For each linear programming formulation, please clearly state the three elements (definition of decision variables and...

Transcribed Image Text:

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. 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.

Answer rating: 100% (QA)

Decision variable The decision variable is the number of each item that should be made In t... View the full answer