Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 438 Weeks Ago, 1 Day Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Statistics Posted 01 Jun 2017 My Price 7.00

Darten Restaurants owns and operates several different restaurant chains

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.

 

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?

Answers

Alpha Geek
(8)
Status NEW Posted 01 Jun 2017 10:06 AM My Price 7.00

-----------

Attachments

file 1496314379-Answer.docx preview (271 words )
D-----------art-----------en -----------Res-----------tau-----------ran-----------ts -----------own-----------s a-----------nd -----------ope-----------rat-----------es -----------sev-----------era-----------l d-----------iff-----------ere-----------nt -----------res-----------tau-----------ran-----------t c-----------hai-----------ns,----------- in-----------clu-----------din-----------g R-----------ed -----------Sna-----------ppe-----------r a-----------nd -----------the----------- Ol-----------ive----------- Gr-----------ove-----------. T-----------he -----------com-----------pan-----------y i-----------s c-----------ons-----------ide-----------rin-----------g o-----------pen-----------ing----------- a -----------num-----------ber----------- of----------- ne-----------w u-----------nit-----------s i-----------n O-----------hio-----------. T-----------her-----------e a-----------re -----------10 -----------dif-----------fer-----------ent----------- si-----------tes----------- av-----------ail-----------abl-----------e f-----------or -----------the----------- co-----------mpa-----------ny -----------to -----------bui-----------ld -----------new----------- re-----------sta-----------ura-----------nts-----------, a-----------nd -----------the----------- co-----------mpa-----------ny -----------can----------- bu-----------ild----------- ei-----------the-----------r t-----------ype----------- of----------- re-----------sta-----------ura-----------nt -----------at -----------a g-----------ive-----------n s-----------ite-----------. T-----------he -----------fol-----------low-----------ing----------- ta-----------ble----------- su-----------mma-----------riz-----------es -----------the----------- es-----------tim-----------ate-----------d N-----------PV -----------of -----------the----------- ca-----------sh -----------flo-----------ws -----------(in----------- mi-----------lli-----------ons-----------) r-----------esu-----------lti-----------ng -----------fro-----------m
Not Rated(0)