Formulate liner programming model

Assignment Help Operation Management

Reference no: EM132254701

How do I formulate a liner programming model in excel from the problem below? Angela Fox and Zooey Caulfield were food and nutrition majors at State University, as well as close friends and roommates. Upon graduation Angela and Zooey decided to open a French restaurant in Draperton, the small town where the university was located. There were no other French restaurants in Draperton, and the possibility of doing something new and somewhat risky intrigued the two friends. They purchased an old Victorian home just off Main Street for their new restaurant, which they named %u201CThe Possibility.%u201D Angela and Zooey knew in advanced that at least initially they could not offer a full, varied menu of dishes. They had no idea what their local customer%u2019s tastes in French cuisine would be, so they decided to serve only two full-course meals each night, one with beef and the other with fish. Their chef, Pierre, was confident he could make each dish so exciting and unique that two meals would be sufficient, at least until they could assess which items were most popular. Pierre indicated that with each meal he could experiment with different appetizers, soups, salads, vegetable dishes, and desserts until they were able to identify a full selection of menu items. The next problem for Angela and Zooey was to determine how many meals to prepare for each night so they could shop for ingredients and set up the work schedule. They could not afford too much waste. They estimated that they would sell a maximum of 60 meals each night. Each fish dinner, including all accompaniments, requires 15 minutes to prepare, and each beef dinner takes twice as long. There is a total of 20 hours of kitchen staff labor available each day. Angela and Zooey believe that because of the health consciousness of their potential clientele they will sell at least three fish dinners for every two beef dinners. However, they also believe that at least 10% of their customers will order beef dinners. The profit from each beef dinner will be approximately $16, and the profit from a fish dinner will be about $12. Formulate a linear programming model for Angela and Zooey that will help them estimate the number of meals they should prepare each night and solve this model graphically.

Reference no: EM132254701

Questions Cloud

What other forms of marketing communications starbucks : Find out what other forms of marketing communications Starbucks uses in Canada and the United States. Does it advertise?

Research two project management tools : Research two project management tools.

Medical center orders outpatient radiology examination : When a physician within a medical center orders an outpatient radiology examination, the patient is asked to pre-schedule the examination at the hospital

Furniture corporation manufactures two products : The Outdoor Furniture Corporation manufactures two products, benches and picnic tables, for use in yards and parks.

Formulate liner programming model : How do I formulate a liner programming model in excel from the problem below?

Perform analysis of the problem facing snowclear : Perform an analysis of the problem facing Snowclear and its legal department and prepare a report that summarizes your analyses and final recommendations.

Organizational benefit and legal perspective : Explore the ramifications of using StrengthsFinder as a selection technique, from both an organizational benefit and a legal perspective.

Take advantage of this technology to reach consumers : Write a few paragraphs about how the introduction of the television allowed advertisers to take advantage of this technology to reach consumers.

The department head to whom the five of you report : You and four other supervisors are at a meeting with your immediate boss, the department head to whom the five of you report.

User Account

All Pages