Quant Analysis

In: Business and Management

Submitted By lehm4895
Words 1040
Pages 5
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 in your progress submission, I will provide specific instructions on how to fix them, and in the following weeks after that, you may submit additional progress reports to make sure you are on the right track. I will provide feedback on your progress if you ask for it.
3. Flexible situation: Read/understand the case, have some ideas about what method you will use to solve it and how you will set up the Excel model, and have a feasible plan that will help you finish the case by the final deadline. In this case, you can submit a draft or partially-complete Excel worksheet and I will provide feedback based on your submission.
Case: Location, Distribution, and Capacity Expansion at a Beer Manufacturer
A Case Study of Location, Distribution, and Capacity Expansion Decisions at Anadolu Efes
Case Description and Objectives
This case study involves the application of linear programming and integer linear programming methods in solving a distribution and capacity planning problem at Anadolu Efes Beverage Group. Faced with intense competition and anticipated increase in beer demand that will surpass the current production capacity, the company wants to optimize its malt and beer…...

Similar Documents


...Analysis & interpretation of financial statements – Ratio Analysis 1 Ratio Analysis Application • Ratio analysis is a means to an end. The end being to understand a company’s results for a year using its financial statements. • Ratio analysis may highlight unusual results or clarify trends, enabling various users of accounts to make informed decisions relating to the company. • For ratios to be useful, comparisons must be made - on a year to year basis, or between companies. On their own they are useless for any sensible decision making. 2 Ratio Analysis 1 Lecture example 1 How do the following users of financial statements benefit from ratio analysis? (a) Shareholders (b) Potential investors (c) Bank and other capital providers (d) Employees (e) Management (f) Suppliers (g) Government 3 Ratio Analysis Lecture example 1 (a & b) Shareholders and potential investors will use ratios to help them come to a decision on buying or selling the share of the company. (c) Banks and other providers of loan capital will assess whether further loans should be made to the company. (d) Management will use ratios to highlight weak performing areas in order to focus their attention on these areas. (e) Employees may use them as a basis for wage negotiation. (f) Suppliers may use ratios to assess creditworthiness. (g) Governments may use them for statistics or for assessing the worthiness of a government grant. 4 Ratio Analysis 2 Categories of......

Words: 1991 - Pages: 8

Quant Analyst

...subjective priors based on the literature.Yet differences in opinion in the academic literature leave the door open for different choices that can compromise the resulting rankings. The New GCI is generated in a two-stage process. First, the weights for aggregating individual indicator scores to an overall country score are obtained using panel data for over 130 countries and up to 7 years (2001–07).The weights obtained from estimating the model are going to be kept constant over time. Additional years of data will be used to check the stability of the model over time. Second, the index score for a particular country in a given year is calculated by summing its weighted indicator values. The New GCI model uses principal component analysis (PCA) to aggregate individual indicators (or categories of indicators).The premise of the PCA method is that within a “conceptual category,” indicators are highly correlated and related to the underlying phenomenon that is being measured.Within the area of microeconomic competitiveness, the degree of correlation between indicators is very high.The New GCI model thus applies a two-step PCA procedure. First, a separate aggregation is computed for COS and for each of the four components of the NBE. Second, these five components are aggregated into an overall score for microeconomic competitiveness.75 Figure 7 provides a sample calculation, showing the specific scores calculated for the indicators in company......

Words: 452 - Pages: 2

Case Analysis

...After reading this chapter, you are expected to be able to: 1. make the students understand the reasons for the existence of firms 2. analyse the production theory with two variable inputs 3. demonstrate the least cost factor combination While going through this analysis students may feel it is a revision of the indifference curve and the budget line. Isocost and isoquants play the same role in producer’s equilibrium as that played by the budget line and indifference curves in consumer’s equilibrium. Isocost curve is a producer’s budget line while isoquant is his indifference curve. Isoquant is also called as equal product curve or production indifference curve or constant product curve. Isoquant indicates various combinations of two factors of production which give the same level of output per unit of time. The significance of factors of productive resources is that, any two factors are substitutable e.g. labour is substitutable for capital and vice versa. No two factors are perfect substitutes. This indicates that one factor can be used a little more and other factor a little less, without changing the level of output. It is a graphical representation of various combinations of inputs say Labour(L) and capital (K) which give an equal level of output per unit of time. Output produced by different combinations of L and K is say, Q, then Q=f (L, K). Just as we demonstrate the MRSxy in respect of indifference curves through hypothetical data, we demonstrate......

Words: 1597 - Pages: 7


...Starbucks Strategy Analysis | Business Strategy | Assignement | 24/05/2010 | | | | “Making your organisation fit for purpose” Starbucks Coffe Company is the world leading brand in roasting and distributing coffee. The company owns now more than 15 000 coffee shops around the globe: it is settled in North America, Latin America, Europe, Middle-East and Asia. The diversity and depth of its offer (from smooth to extra roasted coffee, African, Arabian or Latin, and all the muffins, cookies and sandwiches) allow them to count on an international exposure that has last for many years. Still, their business tends to be flattening. And the number of competitors in their core-business market, even if the competition stays way back them, is growing constantly. Considering these facts, the objective of Starbucks is to strengthen its leadership on the market. We were then approached by Starbucks in this particular goal. In this folder, you will find an entire analysis of the external environment of Starbucks Coffee Company: the macro-environment, the competitors and market and the stakeholders’ expectations will lead to being aware of opportunities and threats. Then, we went on the study of the internal capabilities: the resources and competences, the sustained competitive advantage and the diagnosis of strategic capability that will permit us to define Starbucks’ strengths and weaknesses. [Thus, owing to the results obtained, we endeavour to recommend Starbucks......

Words: 285 - Pages: 2

Econometric Analysis

...ECONOMETRIC ANALYSIS. INDEX: - Introduction..................................................................................3 -Background....................................................................................8 -Empirical Analysis.........................................................................9 -Conclusion.....................................................................................31 -Bibliography..................................................................................31 * INTRODUCTION: For many years it has tried to explain and predict economic phenomena. In the present work we destructive her to perform an econometric study of the function of the number of travelers who occupy tourist accommodation in Andalusia. The data required for such analysis have been collected from the database of the Institute of statistics and cartography of Andalusia, for easy access through the official website (http://www.juntadeandalucia.es/institutodeestadisticaycartografia/index.html). The National Statistical Institute(NSI) sends every month to the Institute of statistics of Andalusia provisional results which offers survey during the previous month in the eight Andalusian provinces. The survey is exhaustive in all provinces, except in some categories where sampling procedures are performed. The estimates are published disaggregated by categories up to the level that allows the maintenance of statistical confidentiality. The......

Words: 6633 - Pages: 27

Quant. Methods

...6-3 Consumer Behaviour * relationship between stimulus and response 6-4 * cultural factors (6-5) * combination of values, beliefs, behavior * acquired through socialization processes * why are values and beliefs important to marketers? * Forms their needs, shapes their wants * Tells us about their preferences * Subcultures * Determined based on: * Nationalities * Religions * Racial groups * Geographic regions * French Canadians (subculture) – 22% of population * Immigrants * Aboriginals * Asian Canadians * Chinese Canadians * Have different consumption patterns * Social Classes (6-7) * Based not only on income but also occupation * Different media for different income groups * Upper income groups watch news or talk shows * Lower income watch sports related programs or drama shows * Viewing pattern and consumption pattern varies depending on their social class * Social Factors * Reference groups * People that consumers are influenced by * Primary and secondary ref groups: pressure to conform * People you spend time with put pressure on you to conform to their lifestyle * Aspirational groups * People whom you don’t belong to but want......

Words: 1124 - Pages: 5


...BQBA 6211 A1 – Quantitative Methods & Managerial Decision-Making – Fall 2014 Instructor: Dr. Eileen Stock Phone: (254) 466-5598 E-mail: eileen.stock@hotmail.com **See or Email me regarding any questions on assignments at least two days before their due date so that there is sufficient time for me to adequately respond** Course Description: An introduction to and application of the methods of formulating and analyzing business information using statistical techniques. Prerequisites: BQBA 2302. Learning Outcomes: Upon completion of this course, students will be able to: 1. Demonstrate an ability to read, analyze, and interpret business data 2. Use statistics to provide evidence in analyses and managerial decision making 3. Apply appropriate statistical techniques to analyze business and financial data MBA Program Learning Outcomes: 1. Master of Business Administration graduates will develop both analytical and creative approaches to problem solving within their dynamic industries using values-driven leadership. 2. Each graduate will recognize the role of management in the development and execution of corporate policy and strategic plans. 3. Graduates will have a comprehensive business foundation for business decision making and leading in rapidly changing business environments. Materials: 1. Textbook, Statistics for Business and Economics,12th Edition, by McClave, Benson, and Sincich ISBN: ......

Words: 784 - Pages: 4


...Harley-Davidson Case Analysis Harley-Davidson Case Analysis Rayzhaun Jones Mississippi Valley State University Strategic Management Dr. Jimmie S. Warren Abstract With the growing global economy, companies are looking for ways to improve their market share. Many excellent firms have learned how to beat their competitors through the implementation of new management, marketing, and manufacturing techniques. Harley-Davidson is one of those excellent companies whom have challenged traditional ideas. We intend to show through this case study that any company can follow Harley-Davidson’s techniques and lead them to excellence. Mission Statement “We fulfill dreams through the experiences of motorcycling by providing to motorcyclists and too the general public an expanding line of motorcycles, branded products, and services in selected market segments.” Vision Statement “Harley-Davidson is an action-oriented, international company, a leader in its commitment to continuously improve its mutually beneficial relationships with stakeholders. Harley-Davidson believes the key to success is to balance stakeholders’ interests through the empowerment of all employees to focus on value-added activities. Company Profile and Case Analysis Harley-Davidson Inc. is an American motorcycle manufacturer. Harley-Davidson specializes in the sales of heavyweight motorcycles that are designed for cruising on highways. Harleys have a distinct design and exhaust sound that have......

Words: 1011 - Pages: 5


...CHAPTER IX STRENGTHS, WEAKNESS, OPPORTUNITIES, AND THREATS ANALYSIS Strategic planning is a tool for organizing the present on the basis of the projections of the desired future. A strategic plan is a road map to lead an organization from where it is now to where it would like to be in five or ten years.It is necessary to have a strategic plan for your organization. In order to develop a comprehensive plan for your organization which would include both long- range and strategic elements.One of the most important parts of the strategic planning process is the examination of the internal and external environment of the business. The strengths or weaknesses of the business can be seen by considering its internal environment. On the other hand, the external environment factors of the business define the threats and opportunities it will face. Strengths, Weaknesses, Opportunities, and Threats analysis can be used for all sorts of decision making and proactive thinking rather than relying in habitual or instinctive reactions in the business. Specifically, SWOT analysis is basic straight-forward model that assesses what an organization can and cannot do as well as its potential opportunities and threats. SWOT analysis is essential in a business in accomplishing its objectives and what obstacles must be overcome or minimized to achieve the desired result. It is but inevitable for business enterprises to be faced with serious problems and be burdened with critical decision......

Words: 380 - Pages: 2

Mary Quant: a Woman Who Completed Women and the Youth Culture

...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 Britain desperately wanted something “British-like,” something of their own. Furthermore, the social issues for wanting individualism, having a will to express their own selves, and second wave of feminism, more liberated life styles for women, erupted across the Western countries. New definitions of youth and femininity were epitomized through fashion typically created by Mary Quant, a British fashion designer. She had not only helped translating a generation of women, but also helped the failing British fashion industry into a thriving commercialism. Mary Quant was born in London, 1934. She studied illustration at Goldsmith College of Art and met her future husband, Alexander Plunket Greene and a former solicitor, Archie Mcnair. When she failed to become an art teacher, she teamed up with her husband and Mcnair to open up a boutique called Bazaar in Kings Road, London. In the beginning, she planned to buy clothes from the private wholesalers and sell it as retail items at her boutique, but with the limited designs,......

Words: 1068 - Pages: 5

Overview of Quant vs Qual Articles

...A Bundle Strategy Including Patient Hand Hygiene to Decrease Clostridium difficile Infections (2014), the sample size used in this research was 520 bed tertiary care facility called Shadyside which is part of the University of Pittsburgh Medical Center. The sample size is representative of the population. Results of Data Analysis     According to the article by Pokrywka et al., (2014), beginning in July 2009 to June 2010, the infection control panel investigated 336 positive toxin results for c-diff infection. Of these toxins, 116 were determined to be a hospital-acquired cases. Of these 87 cases met the HA definition. And 29 were determined to be HAE cases with a prior admission within the previous three months. 87 cases were identified to be HCA, 69 cases were CA, and 64 cases were determined to be prior positive patients with reoccurrence and continuing toxin positivity. The rate of c-diff infection during the intervention period was 6.95 per 10,000 patient days (116cases/166,838 patient days x 10,000). In comparison, the rate for fiscal year 2009 was 10.45, with 164 cases (129 HA cases and 35 HAE cases) in 156,956 patient days. The data analysis for this article, the application of a chi-square test indicated that the statistical significance was p=0.0009 (Pokrywka et al., 2014). The p-value primarily describes the likelihood that the outcome (in this case the reduction in c. diff cases) happened by chance (Schmidt & Brown, 2012). The p-value in this study......

Words: 1437 - Pages: 6


...1. EXECUTIVE SUMMARY Financial analysis is the starting point for making plans, before using any sophisticated forecasting and planning procedures. Understanding the past is a prerequisite for anticipating the future. Financial analysis is the process of identifying the financial strength and weakness of the firm by properly establishing relationship between the items of the balance sheet and the profit and loss account. Financial analysis can be undertaken by management of the firm, or by parties outside the firm, viz. owners, creditors, investors and others. The nature of analysis will differ depending on the purpose of the analyst. 1. Investors: Who invested their money in the firm’s shares, are most concerned about the firm’s earnings. They more confidence in those firm’s that show steady growth in earnings. As such, they concentrate on the analysis of the firm’s present and future profitability. They are also interested in the firm’s financial structure to that extent influence the firm’s earning ability and risk. 2. Trade creditors and financial institution: they are interested in firm’s ability to meet their claims over a very short period of time. Their analysis will, therefore, confine to the evolution of the firms liquidity position. And the financial institutions are interested in the financial statements of the borrowing concern to ascertain its short- term as well as long-term solvency and also it profitability. 3. Suppliers: On the other hand, are......

Words: 2052 - Pages: 9

Quant Calci

...1. Calculating mean, std dev and variance of a single variable data set Calculate the population variance and standard deviation for the data set: Steps a. 2nd 7 – Invoke the Data function b. 2nd CE|C – Invoke the Clear work function c. Enter the 5 values 1. X01 = 30 + ENTER 2. Down arrow 3. Y01 =1 (all y’s to be 1) + ENTER 4. X02 = 12 and so on. 5. After Y05 = 1 + ENTER d. 2nd 8 – Invoke the Stat function e. If you see LIN, press 2nd + ENTER multiple times till you see 1-V (1 variable) f. Press down arrow key g. N =5 which is the sample size h. X bar = 22 which is mean. -> one of the answers that we require i. S x = 6.67 which is sample std dev j. Sigma x = 5.96 which is pop std dev -> one of the answers that we require. k. Square of above = 35.6 which is pop variance - > one of the answers that we require ------------------------------------------------- 2. Calculating the Expected value using probability weights Using calci - Same as #1: Steps a. Enter the probabilities as y values in percentage i.e. 10, 20, 30 and 40 b. Enter the EPS as X values c. 2nd Stat mode should remain 1-V d. Press down arrow e. N = 100 indicating sum of probabilities is correctly entered as 100% f. X bar = expected value of EPS = 1.28 g. ------------------------------------------------- Sigma x = standard deviation of EPS = 0.27129...

Words: 250 - Pages: 1


...Topic Gateway Series Strategic Analysis Tools Strategic Analysis Tools Topic Gateway Series No. 34 Prepared by Jim Downey and Technical Information Service 1 October 2007 Topic Gateway Series Strategic Analysis Tools About Topic Gateways Topic Gateways are intended as a refresher or introduction to topics of interest to CIMA members. They include a basic definition, a brief overview and a fuller explanation of practical application. Finally they signpost some further resources for detailed understanding and research. Topic Gateways are available electronically to CIMA Members only in the CPD Centre on the CIMA website, along with a number of electronic resources. About the Technical Information Service CIMA supports its members and students with its Technical Information Service (TIS) for their work and CPD needs. Our information specialists and accounting specialists work closely together to identify or create authoritative resources to help members resolve their work related information needs. Additionally, our accounting specialists can help CIMA members and students with the interpretation of guidance on financial reporting, financial management and performance management, as defined in the CIMA Official Terminology 2005 edition. CIMA members and students should sign into My CIMA to access these services and resources. The Chartered Institute of Management Accountants 26 Chapter Street London SW1P 4NP United Kingdom T. +44 (0)20 7663 5441 F.......

Words: 3971 - Pages: 16

Quant Investments Probability

...Quant Investments “It had not been a particularly good year for Quant Investments”, mused Alain over his pate de foie gras and champagne. It was lunchtime on Christmas Eve, and his three colleagues Belén, Carlos and Dawood had already set off on holiday to far-off, exotic locations. The four of them had worked as a close team of analysts for the past 15 months since graduating as MBAs, and Alain realised that their performances had not come up to expectations. Alain feared that all four may lose their jobs shortly. At this moment of low spirits, Xavier, one of the senior partners whom Alain had always found remarkably candid, joined him for lunch. “Well, Alain, I’m sure you have heard rumours about the board meeting this morning. The future of the four of you was discussed and a decision was taken to release one of you. I can’t tell you who - the Chairman is writing to you all immediately. However, I can say that we were unable to make the decision on merit, so we made it at random. The Chairman took one of four cards, each of which had one of your names on the back!” “So, I have a one in four chance of being out of work after Christmas”, said Alain. He felt relieved, as he had thought the odds might be worse. “But of course you know definitely who it is”, he added. Alain felt he could leach rather more out of the partner. “Since we both know that at least two out of Belén, Carlos or Dawood will definitely have a job here next year, if you tell me the name of...

Words: 1075 - Pages: 5