CASE 2. "The Possibility"Restaurant 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 "The Possibility." Angela and Zooey knew in advance that at least initially they could not offer a full, varied menu of dishes. They had no idea what their local customers' 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 menu 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 fish dinner will be approximately $12, and the profit from a beef dinner will be about $16. Required: 1. 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 using the Excel solution. 2. If Angela and Zooey increased the menu price on the fish dinner so that the profit for both dinners was the same, what effect would that have on their solution? 3. Suppose Angela and Zooey reconsidered the demand for beef dinners and decided that at least 20% of their customers would purchase beef dinners. What effect would this have on their meal preparation plan?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
100%

Create a step-by-step excel, using the solver engine to generate the decision variable
solution. Generate an ANSWER REPORT and a SENSITIVITY REPORT. I WILL UPVOTE. THANK YOU

CASE 2. "The Possibility"Restaurant
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 "The
Possibility."
Angela and Zooey knew in advance that at least initially they could not offer a full, varied menu of
dishes. They had no idea what their local customers' 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 menu 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
fish dinner will be approximately $12, and the profit from a beef dinner will be about $16.
Required:
1. 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 using the Excel solution.
2. If Angela and Zooey increased the menu price on the fish dinner so that the profit for both dinners
was the same, what effect would that have on their solution?
3. Suppose Angela and Zooey reconsidered the demand for beef dinners and decided that at least 20%
of their customers would purchase beef dinners. What effect would this have on their meal
preparation plan?
Transcribed Image Text:CASE 2. "The Possibility"Restaurant 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 "The Possibility." Angela and Zooey knew in advance that at least initially they could not offer a full, varied menu of dishes. They had no idea what their local customers' 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 menu 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 fish dinner will be approximately $12, and the profit from a beef dinner will be about $16. Required: 1. 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 using the Excel solution. 2. If Angela and Zooey increased the menu price on the fish dinner so that the profit for both dinners was the same, what effect would that have on their solution? 3. Suppose Angela and Zooey reconsidered the demand for beef dinners and decided that at least 20% of their customers would purchase beef dinners. What effect would this have on their meal preparation plan?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 7 images

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.