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: 4. Angela and Zooey are considering investing in some advertising to increase the maximum number of meals they serve. They estimate that if they spend $30 per day on a newspaper ad, it will increase the maximum number of meals they serve per day from 60 to 70. Should they make the investment? 5. Zooey and Angela are concerned about the reliability of some of their kitchen staff. They estimate that on some evenings they could have a staff reduction of as much as 5 hours. How would this affect their profit level? 6. The final question they would like to explore is raising the price of the fish dinner. Angela believes the price for a fish dinner is a little low and that it could be closer to the price of a beef dinner without affecting customer demand. However, Zooey has noted that Pierre has already made plans based on the number of dinners recommended by the linear programming solution. Angela has suggested a price increase that will increase profit for the fish dinner to $14. Would this be acceptable to Pierre,

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
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:
4. Angela and Zooey are considering investing in some advertising to increase the maximum number of
meals they serve. They estimate that if they spend $30 per day on a newspaper ad, it will increase
the maximum number of meals they serve per day from 60 to 70. Should they make the investment?
5. Zooey and Angela are concerned about the reliability of some of their kitchen staff. They estimate
that on some evenings they could have a staff reduction of as much as 5 hours. How would this affect
their profit level?
6. The final question they would like to explore is raising the price of the fish dinner. Angela believes
the price for a fish dinner is a little low and that it could be closer to the price of a beef dinner without
affecting customer demand. However, Zooey has noted that Pierre has already made plans based on
the number of dinners recommended by the linear programming solution. Angela has suggested a
price increase that will increase profit for the fish dinner to $14. Would this be acceptable to Pierre,
and how much additional profit would be realized?
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: 4. Angela and Zooey are considering investing in some advertising to increase the maximum number of meals they serve. They estimate that if they spend $30 per day on a newspaper ad, it will increase the maximum number of meals they serve per day from 60 to 70. Should they make the investment? 5. Zooey and Angela are concerned about the reliability of some of their kitchen staff. They estimate that on some evenings they could have a staff reduction of as much as 5 hours. How would this affect their profit level? 6. The final question they would like to explore is raising the price of the fish dinner. Angela believes the price for a fish dinner is a little low and that it could be closer to the price of a beef dinner without affecting customer demand. However, Zooey has noted that Pierre has already made plans based on the number of dinners recommended by the linear programming solution. Angela has suggested a price increase that will increase profit for the fish dinner to $14. Would this be acceptable to Pierre, and how much additional profit would be realized?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 7 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY