27. Darten Restaurants owns and operates several different restaurant chains, including Red Snapper and the Olive Grove. The company is considering opening a number of new units in Ohio. There are 10 different sites available for the company to build new restaurants, and the company can build either type of restaurant at a given site. The following table summarizes the estimated NPV of the cash flows (in millions) resulting from locating each type of restaurant at each of the sites and also indicates which sites are within 15 miles of each other. Site Red Snapper NPV Olive Grove NPV Other Sites within 15 Miles 1234567820 $11.8 $16.2 2,3,4 13.3 13.8 1,3,5 19.0 14.6 1,2,4,5 17.8 12.4 1,3 10.0 13.7 2,3,9 16.1 19.0 7 13.3 10.8 6,8 18.8 15.2 17.2 15.9 5,10 14.4 16.8 9 a. Suppose the company does not want to build two units from the same chain within 15 miles of each other (for example, it does not want to build two Red Snappers within 15 miles of each other nor is it willing to build two Olive Groves within 15 miles of each other). Create a spreadsheet model to determine which (if any) restaurant it should build at each site in order to maximize total NPV. b. What is the optimal solution? c. Now additionally suppose the company does not want to build a Red Snapper unless it also builds an Olive Grove at another site within 15 miles. Modify your spreadsheet model to determine which (if any) restaurant it should build at each site in order to maximize total NPV. d. What is the optimal solution?
27. Darten Restaurants owns and operates several different restaurant chains, including Red Snapper and the Olive Grove. The company is considering opening a number of new units in Ohio. There are 10 different sites available for the company to build new restaurants, and the company can build either type of restaurant at a given site. The following table summarizes the estimated NPV of the cash flows (in millions) resulting from locating each type of restaurant at each of the sites and also indicates which sites are within 15 miles of each other. Site Red Snapper NPV Olive Grove NPV Other Sites within 15 Miles 1234567820 $11.8 $16.2 2,3,4 13.3 13.8 1,3,5 19.0 14.6 1,2,4,5 17.8 12.4 1,3 10.0 13.7 2,3,9 16.1 19.0 7 13.3 10.8 6,8 18.8 15.2 17.2 15.9 5,10 14.4 16.8 9 a. Suppose the company does not want to build two units from the same chain within 15 miles of each other (for example, it does not want to build two Red Snappers within 15 miles of each other nor is it willing to build two Olive Groves within 15 miles of each other). Create a spreadsheet model to determine which (if any) restaurant it should build at each site in order to maximize total NPV. b. What is the optimal solution? c. Now additionally suppose the company does not want to build a Red Snapper unless it also builds an Olive Grove at another site within 15 miles. Modify your spreadsheet model to determine which (if any) restaurant it should build at each site in order to maximize total NPV. d. What is the optimal solution?
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:27. Darten Restaurants owns and operates several different restaurant chains, including
Red Snapper and the Olive Grove. The company is considering opening a number of
new units in Ohio. There are 10 different sites available for the company to build
new restaurants, and the company can build either type of restaurant at a given site.
The following table summarizes the estimated NPV of the cash flows (in millions)
resulting from locating each type of restaurant at each of the sites and also indicates
which sites are within 15 miles of each other.
Site
Red Snapper
NPV
Olive Grove
NPV
Other Sites within
15 Miles
1234567820
$11.8
$16.2
2,3,4
13.3
13.8
1,3,5
19.0
14.6
1,2,4,5
17.8
12.4
1,3
10.0
13.7
2,3,9
16.1
19.0
7
13.3
10.8
6,8
18.8
15.2
17.2
15.9
5,10
14.4
16.8
9
a. Suppose the company does not want to build two units from the same chain
within 15 miles of each other (for example, it does not want to build two Red
Snappers within 15 miles of each other nor is it willing to build two Olive Groves
within 15 miles of each other). Create a spreadsheet model to determine which
(if any) restaurant it should build at each site in order to maximize total NPV.
b. What is the optimal solution?
c. Now additionally suppose the company does not want to build a Red Snapper
unless it also builds an Olive Grove at another site within 15 miles. Modify your
spreadsheet model to determine which (if any) restaurant it should build at each
site in order to maximize total NPV.
d. What is the optimal solution?
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education