This website uses cookies to ensure you have the best experience. Learn more

Quant Analysis

1054 words - 5 pages

1. Ideal situation: Setup the spreadsheet model correctly and answer (in a Word document) all questions in the first part of the case. I provide feedback and you continue working on the second part. (Note: To be able to do the second part, we need to learn the content in Module 3.) Then, by December 9, you consolidate your analysis of the first and second parts, put them in a report format with the instructions given (executive summary, etc.) and submit.
2. Expected situation: Setup the spreadsheet model and provide brief answers to part I questions within the Excel worksheet. I provide feedback, and you will be working on the rest of the questions until December 9. If there is any mistake ...view middle of the document...

 The case has been created based on the authors’ past collaborations with Efes on a number of projects, which have been implemented by the company in its distribution network.
The primary objective of this case is to help you improve your skills to:
1. see the broader picture but confine the problem within practical boundaries,
2. construct a linear programming model for a reasonably large problem,
3. construct a (mixed) integer programming model for a reasonably large problem,
4. solve the models using Excel Solver,
5. perform sensitivity and what-if analysis,
6. interpret results and make recommendations.
The case also aims to provide you an understanding of the implications of implementing cost-effective solutions obtained from a mathematical model and help you to gain insights on the delicate balances in a supply chain by modifying the models and analyzing the outputs for several scenarios. The case scenario allows you to see the problem from both marketing and operations perspectives.  
Case Deliverables, Grading, and Timeline
Deliverable include a case write-up (Word document) and technical analysis worksheet (Excel file). The case write-up should include: 1) An executive summary, 2) Summary of your analysis, 3) Linear programming formulations of the problems solved, 3) Answers to all questions in the Case Analysis section below, and 4) Other findings and insights. The Excel file should include the spreadsheet models of the problems solved.
Case Analysis
The following set of questions are intended to provide a guideline in studying the case. Your analysis should provide answers to all of these questions, but does not need to be limited with them. If you provide additional insights and recommendations to the firm, please make sure that you support them with a proper technical analysis, which should also be included in your submission.
The analysis of the case can be done in two parts. In Part I, you can focus on improving the current distribution system, and in Part II, you can focus on the optimization of distribution, location, and capacity expansion decisions over the next three years.
Analysis in Part I (Improving the current distribution system.)...

Other Papers Like Quant Analysis

Bigdata Literature Review

2076 words - 9 pages different teams with complimentary analytical skills. Analytical tools that can be used include agent based modelling, neural networks, factor analysis, cluster analysis and time series analysis (Anawis 2014). McAfee & Brynjolfsson(2012) claim that big data does not require huge IT investments. One approach to build big data capability in an organisation is to first select a business unit as a testing ground with a quant friendly leader

Media Terms And Definitions Essay

2492 words - 10 pages Off Peak time viewing time. See also Dayparts. •Post analysis •Refers to the analysis prepared by the media agency after the appearance of a burst or campaign. It should be used as part of the planning process, concentrating on accountability, learning and recommendations for future activity. •Potential •The total number of people within a given area / target generally expressed in thousands. See also Universe •Profile •Shows the audience

Stata Guide

4326 words - 18 pages . Therefore it is a common practice to combine the tests with diagnostic plots to make a judgment on the severity of the heteroscedasticity and to decide if any correction is needed for heteroscedasticity. In our case, the plot above does not show too strong an evidence.  Goldfeldt-Quant test It is useful if we can correctly identify the variable we can use for splitting the sample. The above tests are simpler and more exible than Goldfeldt-Quant

Beginning of a Mod Culture and Its Influence on British Society

4017 words - 17 pages spawned and young, creative people could easily make their dreamed styled clothes and accessories come true. The Mod fashion was developing due to individual tailors and artist. However, the Mod fashion spread across the country thanks to the big designers, such as Mary Quant, who was one of the first and the biggest supporter of the new style. Miniskirts designed by her became the source of controversies and outraging. Another great designer of Mod

Alternative Investments

4991 words - 20 pages | Merger arbitrage | Fixed-Income Arbitrage | Long Short | Distressed securities | Quant Traders | Emerging Markets | | | Directional hedge fund strategies like global macro take positions in equity, bonds and currency to speculate on global macroeconomic events that will trigger and lead to huge gains in their position. Long short strategies add the possibility to short assets. Emerging Markets (EM) hedge funds belonged to this category of

Freedom And Responsibility

2141 words - 9 pages Built within the Constitution of the United States are specifically defined freedoms that are guaranteed to all citizens. Conversely, with every constitutional freedom there comes a corresponding responsibility. On September 25, 1789, the state legislature’s twelve proposed amendments were transmitted by congress, the first two dealing with congressional representation and congressional pay. The following numbers three through twelve were

Hate Crime Laws

2348 words - 10 pages On June 7, 1998, 49-year-old James Byrd Jr. of Texas accepted a ride from three white men, who then beat him severely, urinated on him, chained him by his ankles to the back of their pick-up truck, dragged him for three miles into the countryside, and dumped his corpse in front of an African-American cemetery (Graczyk). A little over a year later, a jury sentenced ring leader John King to death by lethal injection (“Man Executed for Dragging

Rational Emotional Behavior Therapy Case Study Conceptualization And Treatment Plan

2140 words - 9 pages Rational Emotional Behavior Therapy Case Study of Sarah: A Conceptualization and Treatment Plan Rational emotive behavior therapy, REBT, was developed by Albert Ellis and holds the central belief that the events in our lives do not cause our disturbances but that they are instead caused by our view of the events (Murdock, 2009). Murdock (2009) states that “people are seen as responsible for their behavior” (p. 279) but, because they are

Holidays In Albania

1636 words - 7 pages Have you ever thought about having exciting and incredibly cheap vacations? Albania might be the right choice. According to My Travel Guide, Albania is ranked the fourth among ten places worth visiting in Eastern Europe (“Top 10 Eastern European Destinations”). One can encounter three kinds of vacations in this Mediterranean country: winter, summer, and cultural. The ideal places to spend your winter vacations are the Albanian Alps. They are

A Heart Of Darkness

1748 words - 7 pages In this short story, there are frequent significant subject and ideas that make the story, "A Heart of Darkness," by Joseph Conrad, and haunting novel. The main theme is absolute white power over the natives. The theme validates the corruption, and the dependence caused by the white people as they took over the Congo. White men were giving all the power; they had no self-control, and in the end they did not use wisely. The white men became

The Aspects Of Vulnerability Among The Exploited In Medical Research

2287 words - 10 pages Essentially, everyone is in some state of vulnerability. However, some of us are more susceptible to harm due to our vulnerabilities. The susceptible are the individuals with the greatest risk. These individuals risk the loss of their autonomy, and maybe even their lives. Vulnerable populations can be found in every subset of society. However, as previously mentioned, there are some vulnerable populations that are at an even greater risk than

Related Essays

Mary Quant: A Woman Who Completed Women And The Youth Culture

1068 words - 5 pages Mary Quant: A woman who completed women and the youth culture During the 1960s, although Great Britain was referred as the empire on which the sun never sets, the nation itself was too busy in replicating and imitating culture and arts of France. Even the young nation, United States had the victory of seizing hegemony right after World War 2, which hurt the Great Britain’s pride. Not only the nation itself but also the people of Great

Essays On Economy

1107 words - 5 pages Geography i) Perspectives in Human Geography : Areal differentiation; regional synthesis; Dichotomy and dualism; Environmentalism; Quant i tat ive revolut ion and locat ional analysis; radical, behavioural, human and welfare approaches; Languages, religions and secularisation; Cultural regions of the world; Human development index. ii) Economic Geography : : World economic development: measurement and problems; World resources and their

Statistics Essay

3532 words - 15 pages ? A. ?Assigning each sophomore a number and then randomly generating 70 numbers from that list. B Randomly selecting 70 sophomores entering the university's main library on a randomly selected evening. C ?Selecting the 70 sophomores whose grade point averages (GPA) fall closest to the mean GPA of the sophomore class. D ?Randomly selecting 70

Counterparts Credit Risk Essay

1902 words - 8 pages criteria. UBS is under no obligation to update or keep current the information contained herein. Neither UBS AG nor any of its affiliates, directors, employees or agents accepts any liability for any loss or damage arising out of the use of all or any part of this material. © UBS 2010. The key symbol and UBS are among the registered and unregistered trademarks of UBS. All rights reserved. The CVA quant team explains our approach to modelling