The decision models to be used is decision tree in excel

Assignment Help Operation Management
Reference no: EM131234596

Galen Development Company Case

The decision models to be used is Decision Tree in Excel

The Bill Galen Development Company (BGD) is considering the purchase and commercial development of a piece of property.

The property is now zoned residential; BGD needs a variance from the city in order to do commercial development on a property.

The asking price for the property is a firm $300,000. BGD estimates it can construct a shopping center for an additional $500,000 and sell the completed center for approximately $950,000.

A variance application costs $30,000 in fees and expenses, and there is only a 40% chance that the variance will be approved.

Regardless of the outcome, the variance process takes two months.

If BGD purchases the property and the variance is denied, the company will sell the property and receive net proceeds of $260,000.

BGD can also purchase a three-month option on the property for $20,000, which would allow time for it to apply for the variance.

Finally, for $5,000 an urban planning consultant can be hired to study the situation and render an opinion as to whether the variance will be approved or denied.

The city council has been reluctant to grant variances, so there is a 60% probability the consultant will predict denial of the variance.

A friend of Bill, a professor at the local university, estimates the following conditional probabilities for the consultant’s opinion:

P(consultant predicts approval | approval granted) = .70

P(consultant predicts denial | approval denied) = .80

BGD has contracted with you to determine / recommend the optimal strategy regarding this parcel of property.

Use decision trees to solve problems, prepare a report that will help BGD make their decision in this situation.

Utilize the quantitative analysis approach in your report as follows:

1. Defining the problem: Describe what the problem entails.

2. Developing a model: Develop a decision tree for the problem identified in Step 1, using the Excel TreePlan add-in

3. Acquiring the data: Describe the data used in the decision tree and how you acquired the data.

4. Solve the problem using the decision tree developed in Step 2.

a. What are the expected returns for each of the possible strategies?

b. What are the maximum potential losses for the possible strategies?

c. What strategy do you recommend and why?

5. Testing the solution: Does the decision tree produce results that are accurate and complete.

6. Analyzing the results: What does the information you prepared in Steps 1-5 tell you about the decision situation?

7. Implementing the results: How would you implement the results?

Reference no: EM131234596

Questions Cloud

What is the current state of the russian economy : Write a one page memo. Moscow is teaming with new construction sites high-end cars and new restaurants. I am the CEO of a growing international restaurant chain. What is the 'current' state of the Russian economy and should you look to as a potential..
Evaluate influence of international data-coding standards : Evaluate the influence of international data-coding standards, HL7, DICOM, and web standards on the practice of medicine. As an information technology manager, how would you go about convincing your organization to adopt a major HMIS standard, such a..
Create your own annotated bibliography : When searching for sources it is helpful to develop a system of organization. One of the most commonly used methods of organizing sources is to keep an annotated bibliography. Create your own annotated bibliography with the sources you are using for ..
Appropriate for the transportation model : The Dover manufacturing Company has plants in Cleveland, Chicago, Houston, and Seattle. It ships products MX 13 from these plants to warehouses in Los Angeles, Denver, and Omaha. The freight costs per unit for shipping from Cleveland are respectively..
The decision models to be used is decision tree in excel : The decision models to be used is Decision Tree in Excel. The Bill Galen Development Company (BGD) is considering the purchase and commercial development of a piece of property. The property is now zoned residential; BGD needs a variance from the cit..
Piece of diagnostic equipment at two plants : A medical equipment company produces a piece of diagnostic equipment at two plants, and must supply this product to three medical centers. Formulate and solve this problem in AMPL. State the optimal solution and optimal objective function value.  Sup..
Decides to award contract without full and open competition : What purpose is served by requiring a written justification when a federal agency decides to award a contract without full and open competition. Give an actual example or a theoretical example of such a solicitation
Convicted of driving under the influence : Two individuals were convicted of driving under the influence (DUI). Adam, a first offender, received the following sentence: five days in jail, a $4000 fine, loss of driver's license for 6 months, and an interlock device for two years.
Activist troublemaker : Roland Fallon, a “activist troublemaker,” witnessed a friend intentionally stop traffic on a busy Austin, Texas, street so that a car could enter traffic.  Two officers approached Fallon’s friend to talk to him.  Fallon began shouting at the officers..

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd