Answered step by step
Verified Expert Solution
Link Copied!

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

imageimage

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Electronic Commerce

Authors: Gary Schneider

9th edition

538469242, 978-0538469241

More Books

Students also viewed these Accounting questions

Question

Explain the Pascals Law ?

Answered: 1 week ago

Question

What are the objectives of performance appraisal ?

Answered: 1 week ago

Question

State the uses of job description.

Answered: 1 week ago

Question

Establish identity. cos( + k) = (-1)k cos , k any integer

Answered: 1 week ago

Question

How intense is the grief for them?

Answered: 1 week ago