BUS 4024 Business Decision-Making Through Advanced Analytics

Assignment Help Case Study
Reference no: EM133192874

BUS 4024 Business Decision-Making Through Advanced Analytics - George Brown College

Assignment Objective:
In this assignment, you will be implementing a range of management sciences analytical techniques to solve problems related to; decision analysis, waiting time and queueing, computer based simulation, and inventory management.

In this assignment you will be producing a written report FOR EACH case study, containing the following deliverables:

Component 1: Executive Summary of Solution Approach and Recommendations

• For each solution implementation provide a brief summary of; Presenting Problem, Solution Approach (include assumptions and sensitivities), Recommendations.
• Your audience is a business sponsor (not a management scientist) and information should be summarized in that context (2 to 3 paragraphs max)
• Ensure that all responses to case study questions are addressed (and clearly labelled) and integrated into your executive summary.
• In the APPENDIX of each Case Report please include the following:
1. The mathematically modelled solution(s) must be written (where applicable using an equation editor, not hand written with; variable names clearly defined (i.e. NOT X1, X2, ... etc.)
2. Where applicable, include clearly labelled and commented copies of all output solution and sensitivity reports for each executed solution scenario in your case
• Submit the completed report as XX_Case_Name_Report.doc file. (where XX is the enrolled group number (or First and Last Initials if a non-group assignment), followed by the Case Name)
• Solutions must be executable (in .xls)

Component 2: Executable Solution Implementation and Program Solution and Supplementary or Supporting Output

• Submit your executable implementation as a separate additional file named XX_Case_Name_Implementation. (where XX is the enrolled group number (or First and Last Initials if a non-group assignment), followed by the Case Name)
• Solutions must be executable (in .xls formats)

Instructions:

Case 1: Orca Carbon Capture

Perform a decision tree analysis of this problem for Orca and indicate the recommended solution. Is this the decision you believe the company should make? Explain your rationale.

Case 2: GBC Emergency Preparedness
A. First, consider a single-server waiting line model in which the available emergency vehicles are considered to be the server. Assume that victims arrive at the staging area ready to be transported to a hospital on average every 7 minutes and that emergency vehicles are plentiful and available to pick up and transport victims every 4.5 minutes. Compute the average waiting time for victims. Next assume that the distribution of service times is undefined, with a mean of
4.5 minutes and a standard deviation of 5 minutes. Compute the average waiting time for the victims.
B. Next consider a multiple-server model in which there are eight emergency vehicles available for transporting victims to the hospitals, and the mean time required for a vehicle to pick up and transport a victim to a hospital is 20 minutes. (Assume the same arrival rate as in Part !.) Compute the average waiting line, the average waiting time for a victim, and the average time in the system for a victim (waiting and being transported)
C. For the multiple-server model in Part B., now assume that there are a finite number of victims,
18. Determine the average waiting line, the average waiting time, and the average time in the system.
D. From the two hospitals' perspectives, consider a multiple-server model in which the two hospitals are servers. The emergency vehicles at the disaster scene constitute a single waiting line, and each driver calls ahead to see which hospital is most likely to admit the victim first, and travels to that hospital. Vehicles arrive at a hospital every 8.5 minutes, no average, and the average service time for the emergency staff to admit and treat a victim is 12 minutes. Determine the average waiting line for victims, the average waiting time, and the average time in the system.
E. Next, consider a single hospital, S. Michael's, which in an emergency disaster situation has 5 physicians with supporting staff available. Victims arrive at the hospital on average every 8.5 minutes. It takes an emergency room team, on average, 21 minutes to treat a victim. Determine the average waiting line, the average waiting time, and the average time in the system.

F. For the multiple-server model in Part E., now assume that there are a finite number of victims,
23. Determine the average waiting line, the average waiting time, and the average time in the system.
G. Which of these waiting line models do you think would be the most useful in analyzing a disaster situation? How do you think some, or all , of the models might be used together to analyze a disaster situation? What other types of waiting line models do you think might be useful in analyzing a disaster situation?

Case 3: Staples
Suppose the bank offers Kayla a commission discount (from 2.25% to 2.0%) on any loan amount eval to or greater that $500,000. What would Staple's optimal loan amount be?

Attachment:- Business Decision-Making Through Advanced Analytics.rar

Reference no: EM133192874

Questions Cloud

How should donated services be recorded : What criteria must be met before a not-for-profit organization can record donated services? If the criteria are met, how should donated services be recorded?
Sympathetic branch of the autonomic nervous system : Glendale Community College-How is the sympathetic branch of the autonomic nervous system similar or different from the parasympathetic branch?
Research paper on medical records and informed consent : Assignment - Write a Research Paper on the topic: Medical Records and Informed Consent
Content analysis worksheet : SOC 400 Grand Canyon University-As a student of sociology, it is essential to be able to conduct a content analysis and explain its purpose in social research.
BUS 4024 Business Decision-Making Through Advanced Analytics : BUS 4024 Business Decision-Making Through Advanced Analytics Assignment Help and Solution, George Brown College - Assessment Writing Service
How environmental issue of wild fires impact local community : How does the environmental issue of wild fires impact your local community? The nation? Is it of global significance? Exploratory/Inquiry Essay
What did you already know about the content : Roughly introducing the content and what the article is about. What did you already Know about this content? What do you Want to know? (bit more)?
Comment on health and medical discussion : Comment on Health and Medical Discussion - AS health care providers we are to let the patient be proactive in their health care decisions
Evaluate the possible ethical considerations : Capella University-Complete a 6 page analysis in which you discuss and evaluate the possible ethical considerations found in the research articles

Reviews

Write a Review

Case Study Questions & Answers

  From the scenario, prioritize the attributes of golds reling

From the scenario, prioritize the attributes of Golds Reling's brand from the brand map presented in the scenario according to the attributes that you believe would be most important to the new tablet's target market. Provide support for your respons..

  Discuss critically infosys current and future strategy

Discuss critically Infosys current and future strategy. What advice would you give Kris Gopalakrishnan and KShop has resulted in information overload among staff. What operational measures would you suggest to overcome such challenges?

  Review tarmac business case for diversity

Review Tarmac's Business Case for Diversity and the Learning Resources. Think about Tarmac's approach to managing diversity and how it relates to organisational behaviour concepts and human resource processes.

  Enron case shared activity

Enron was the first nationwide natural gas pipeline network in the United States. As the company grew, executives shifted the company's primary focus from energy delivery and infrastructure to investing in the stock market.

  Ebay inc internet success or fairy tale

Read the case study "eBay Inc.: Internet Success or Fairy Tale? "and answer the question below,   Use the 2002 financial statement data to replicate the Meyer's report calculations that illustrate the conclusion based on the 2001 data reached in the ..

  Mintendo game girl case study

Which option delivers the maximum profit for the supply chain: Sandra's plan, Bill's plan, or no promotion plan at all? How does the answer change if a discount of $10 must be given to reach the same level of impact that the $5 discount received?

  Splash soft drinks case study

Splash Soft Drinks Inc. (SSD) has recently achieved sales that exceeded its expectations after it introduced a new beverage that was greatly welcomed by their customers. The company is currently considering opening a new plant to which some of the pr..

  Details of the task using tesco plc

Details of the task Using Tesco plc (www.tesco.com) as a case study, prepare a report of no more than 2,500 words that:

  What are the common manifestations of alcoholic cirrhosis

What are the common manifestations of alcoholic cirrhosis? Which of these are secondary to hepatocellular failure? Which are secondary to portal hypertension?

  Judge the extent to which the marketing plan at just us

From the case study, judge the extent to which the marketing plan at Just Us! is outdated. Propose two (2) ways that Just Us! could improve the customer experience and thus sustain future growth.

  Read natasha kingery case and answer the questions

Read the DATA CASE on pages 126-127 about Natasha Kingery who is considering furthering her education and is seeking financial advice. Determine the interest rate she is currently earning on her inheritance by going to Yahoo!

  Identify the relevant facts of the case study

Imagine you are the financial controller of XYZ Ltd a corporation that is a very large donor to HOHO. You have recently become aware that its TV advertising has resulted in the charity violating the 25% expenditure ratio for its charity drive.    Id..

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