Case Db

In: Business and Management

Submitted By xiaozhezhe
Words 1927
Pages 8
http://www.studymode.com/essays/Deutsche-Brauerei-1479857.html# http://www.studymode.com/essays/Deutsche-Brauerei-286871.html?topic Deutsche Braueri

I. Introductory Paragraph

Deutsche Brauerei has been a family owned and operated corporation for 12 generations, which has created a high level of focus and control. Each generation has kept the management and operations processes relatively simple, centered on brewing practices and quality. Deutsche Brauerei’s rapid growth in recent years can be attributed to several factors. First and foremost, the company’s success is centered on the product itself, which has won numerous quality awards and is quite popular in Germany. Another contributing factor to the recent growth may have been a bit inadvertent. The purchase of new equipment in 1994, which was necessary as a result of a fire that destroyed the old equipment, allowed the company to increase brewing capacity and efficiency. Finally, Deutsche Brauerei’s decision to enter the Ukranian market in 1998 contributed significantly to the rapid growth. The collapse of the U.S.S.R. brought market reforms, and Deutsche Brauerei jumped on the opportunity to enter the fragmented beer industry, capture the large population and capitalize on the prime location in Europe. Lukas Schweitzer was savvy enough to hire local expert Oleg Pinchuk away from a competitor as the marketing manager, and Oleg was instrumental in building the business in Ukraine by securing accounts and implementing the field warehousing to support distributors. Deutsche’s beer was hugely popular in the Ukraine almost immediately, and volume sales more than offset the depreciation of the Ukrainian currency. Sales in Ukraine accounted for 28% of Deutsche’s total sales, and skyrocketed from 4,262 euros in 1998 to 25,847 euros in 2001.
II. Statement of the Case Problem

Greta, niece of Lukas and a…...

Similar Documents

Db Testing

...the bug, is architecture a problem? What component is responsible, who can fix the problem? Data Is app server running properly, is Sys Admin hardware at fault? Copyright Sammamish Software Services 2003. All rights reserved. DBA QA 6 Copyright Sammamish Software Services 2003. All rights Reserved 6 8/26/2004 Complexity of database interaction Web Service Data Store Data Store Web Client Internet Web Server Intranet Client Computer Multiple Data Stores: Oracle, SQL Server, DB2, etc. 7 Copyright Sammamish Software Services 2003. All rights reserved. Copyright Sammamish Software Services 2003. All rights Reserved 7 8/26/2004 Why test database objects? ! ! ! If you don’t test DB objects, stored procedures and views, you’re missing critical application functionality Increasingly stored procedures and views are used on the database backend in modern applications Application functionality is moved to the database, Why? ! ! ! Performance optimization by the DBMS Security: access can be limited Robustness against hacks Copyright Sammamish Software Services 2003. All rights reserved. 8 Since you’re a tester, you always ask “why”? Why am I here? What’s the point? With the increasing use of data on the internet and in every application, the need for skilled testers in databases is growing quickly. Stored procedures are increasingly used by experienced database developers to ease the complexity of calls to......

Words: 5030 - Pages: 21

Db Case

...Contents I. OBJECTIVE 3 II. ABOUT THE COMPANY 3 III. ISSUES AT HAND 5 (1) The approval of the 2001 financial budget/ Ukrainian expansion 5 Analysis 5 (2) Company’s reliance on short-term debt financing 8 Analysis 8 (3) Quarterly dividend payments 8 Analysis 8 (4) Compensation plan for Oleg Pinchuk 9 Analysis 9 IV. CONCLUSION 10 V. RECOMMENDATIONS 11 I. OBJECTIVE Greta Schweitzer, a recent member of the Board of Directors at Deutsche Brauerei as well as an MBA with experience as a commercial loan officer, has the task of advising her uncle, Lukas Schweitzer, the MD of the company, on some important decisions regarding Deutsche Brauerei. The main issues at hand as of January 2001 are: (1) The approval of the 2001 financial budget (2) Company’s excessive reliance on short-term debt financing (3) Decision regarding the quarterly dividend declaration (4) Decision regarding a compensation plan for Oleg Pinchuk, the sales and marketing manager at Deutsche Brauerei. The objective of this report is to suggest key pointers about the company’s financial performance and health to Greta, so as to enable the Board of Directors to take informed and profitable decisions regarding the future of Deutsche Brauerei. II. ABOUT THE COMPANY Deutsche Brauerei, a beer manufacturing company, was founded in 1737 and has been a family owned and operated corporation for 12 generations. The company’s main focus has been on the brewing process and......

Words: 2286 - Pages: 10

Db Oracle

...DB (duomenų bazė) apibrėžimas ir pavyzdžiai Galimi veiksmai su DB Duomenų bazių valdymo sistemos (DBVS) DBVS funkcijos 1. DBVS turi minimalizuoti duomenų perteklių (dubliavimą), t.y. reikia projektuoti sistemą taip, kad skirtingos tos pačios organizacijos tarnybos nenaudotų “savų” duomenų ar “savų” failų kopijų 2. DB turi būti suprojektuota taip, kad tuo pat metu keli vartotojai galėtų naudotis ta pačia DB. Tai pasiekiama taikant duomenų blokavimą, t.y. kai vienas vartotojas keičia DB įrašą, kiti vartotojai tuo pat metu gali peržvelgti ar net keisti kitus įrašus. 3. DB turi būti vientisa, t.y. jei ji atitinka tam tikras duomenų saugojimo sąlygas, ji turi išlaikyti tas sąlygas ir atliekant įvairius keitimus DB. Pvz. Studento_bakaluro kurso numeris negali būti didesnis už 4, o magistranto daugiau nei 2. Atliekant pakeitimus reikia tikrinti šių sąlygų užtikrinimą, 4. DB duomenys neturi prieštarauti . Tam pačiam objektui bazėje negali būti kelių įrašų, tai ir neleis jo aprašyti skirtingai. 5. DB saugumas. Turi būti numatyti veiksmai, kurie apsaugo duomenis bazėje nuo tyčinio ar netyčinio sunaikinimo, pakeitimo ar nesankcionuoto duomenų peržiūrėjimo. Tam administratorius naudoja priemones , kurios leidžia suteikti tam tikras teises į duomenų vartojimą. DBVS pagal tas suteiktas vartotojams teises prižiūrivisus vartotojo veiksmus. 6. Neplanuotų užklausų organizavimas DB tipai, jų projektavimas ir keliami reikalavimai Viena iš DB tipų yra Reliacinė duomenų bazė......

Words: 6730 - Pages: 27

Ip4 Db

...Describe when and why central banks buy either their own currency or the currency of another nation in an effort to control exchange rates. This is called the monetary policy which aims to control money supply and interest rate to control the amount of money circulating in an economy. Countries do this for several reasons: * Reduce inflation: Inflation happens because there are too much money in the economy. Therefore, they can buy their own currency (by selling assets) to reduce the amount of money in the economy => reduced inflation * Reduced current account deficit (surplus): In this case, central banks "buy" the currency so it will be to reduce the current account surplus, thus putting downward pressure to inflation. This is because as there are less money in the economy, the value of the money goes up i.e. its exchange rate relative to other currencies go up, making its export less competitive and imports more competitive, reducing current account surplus. * Stability: Although this is not explicitly said, countries do aim for a stable exchange rate so that investor confidence can be confident enough to invest. This is done by controlling the money supply (as said above.) The central banks efforts to control exchange rates by either buying its own or another nations currency is called the monetary policy. The goal of this is to limit the amount of money circulating in the economy by controlling the money supply and the interest rate. What did the......

Words: 331 - Pages: 2

Benefits of Db and Gathering Information Techniqeusts

...considerable redundancy in the stored data, which results in wastage of storage space. By having centralized database most of this can be avoided. 2) Integrity can be enforced: Integrity of data means that data in database is always accurate, such that incorrect information cannot be stored in database. In order to maintain the integrity of data, some integrity constraints are enforced on the database. 3) Inconsistency can be avoided : When the same data is duplicated and changes are made at one site, which is not propagated to the other site, it gives rise to inconsistency and the two entries regarding the same data will not agree. 4) Standardizing can be enforced for all users, control who can access the DB, data can be shared, can encrypted the DB, DBMS has the responsibility to backup and recovery, etc. Deploying a centralized DBMS increases speed, improves data management, and over the course of time, decreases costs. Any business starts up to maximize profit and the DBMS will give you that flexibility. As all business owners and managers know, accuracy and consistency is essential for maintenance of company records. For example, the restaurant business, it can track pattern of the VIP customers, spending habits, your sales, input customer physical address (if they approve) for advertisements and coupons, if customers calls in for a reservation (assign table and waiter ahead of time), etc. A flat file database is a database that stores data in a plain...

Words: 941 - Pages: 4

Litrature Review Dbs

...MRP: Literature review. 1.0 Introduction 1.1 Background of the company. Development bank of Singapore (DBS) is a leading consumer bank based in Singapore. DBS is one of the largest financial services groups in Asia, with operations in 16 markets. It’s the largest bank in Singapore as measured by assets and a leading bank in Hong Kong. DBS has the largest retail network in Singapore with 79 Branches Island wide. DBS has leading positions in consumer banking, treasury and markets, asset management, securities brokerage, equity and debt fund raising in Singapore. DBS Singapore claims to have in-depth knowledge of global market and financial expertise and offer products and services in corporate banking, Private banking, personal banking and enterprise banking. 1.2 Research title, questions and research objectives. The proposed research title chosen for this project is “Analysis and review of organizational environment at DBS”. This project would outline the following objectives: i) Outline the influence of organizational environment on the company. ii) The role of organizational environment on company’s growth process. iii) Review the impact of change in organizational environment. 1.3 Research Rationale. Firstly, cross cultural management and managing change is becoming increasingly important in today’s world where company’s trying to expand globally are associating people, organization and countries together and this is where management across culture comes......

Words: 2107 - Pages: 9

Mgt625 Db

...no immunity in Country C and therefore can be brought up on charges in Country C. It can be considered ethical for MBI to bring up charges against Country D in Country C’s courts since that is where the company’s branch is located. Since Country D is currently using the tanks provided on their front lines, the company has a right to expect payment. The legal aspects of bringing up charges in Country C’s court for Country D’s army will depend on the two countries legal systems. If the two countries are allies or peaceful with each other, Country C’s courts may not be willing to jeopardize the alliance or peace to settle this dispute, likewise, if the two countries are at war with each other or enemies, Country C may be willing to hear the case in its courts just to seek vengeance or to inflict punishment on the county. Depending on the countries legal system and what was signed in their contract, the company may legally be able to seek retribution in Country C’s courts. The US business who deals with manufacturing and selling military equipment will deal with problems with foreign military agents. One problem that can arise is that the same country who buys the equipment may use that equipment against the US, the US has many allies and selling only to them would probably not be a wise decision for the company, however if the company only sells “last year’s model” to the countries who are not our allies, then the US will stay ahead of anyone who might want to use them......

Words: 2814 - Pages: 12

Mgt615 Db

...leadership diversity has three steps. Step one is to respond to the shift in the consumers demographic by providing empirical evidence of the linkage between diversity and performance. The second step is diversity ensures competitiveness which links investments in diversity to financial outcomes and organizational metrics of success. The third step is to provide imperative to the business case by making organization leadership responsible for cultural competence as a performance measure (Dotson & Nuru-Jeter, 2012). In 2006, Rush University Medical Center formed a committee to review the work within the institution. Rush benefitted from the senior leaders establishing clear goals, organizing its research to develop programming for diversity that is useful, determining the best way to allocate funds, and focusing on the shortage of females and minorities in leadership roles (Clapp, 2010). References: Clapp, J. R. (2010). Diversity Leadership: The Rush University Medical Center Experience. Hospital Topics, 88(2), 61-66. Dotson, E. & Nuru-Jeter, A. (2012). Setting the Stage for a Business Case for Leadership Diversity in Healthcare: History, Research, and Leverage. Journal of Healthcare Management, 57(1), 35-44. Gunelius, Susan. (7 Nov. 2007). More men in executive positions than women 10:1 ratio. Retrieved from Women on Business: http://www.womenonbusiness.com/more-men-in-executive-positions-than-women-101-ratio. Nahavandi, Afsaneh. (2012). The Art and Science of......

Words: 1614 - Pages: 7

Geography Db

...DB 1: Geography posted by Stacy Harris Thu Dec 9 23:48:28 2010 According to yourdictionary.com, Geography is defined as the study of the earth and all of its features. This also includes the human race and the effect that humans play on the earth. NationalGeographic.com states that there are five themes in Geography. These themes are location, place, human/environment interactions, movement, and regions. If I would have not read this article, I would think that location, place, and region are just about the same. But as I read the article, I found this was not the case. Location refers to the latitude and longitude of an exact spot on a map or globe. Places are defined by the characteristics that distinguish them from other places. For instances, the animal population of certain place makes it unique, as well as other features like mountains and even human architecture. Region refers to an area on earth that is unified by a specific attribute. These attributes can be either human or physical and can include things like climate,religious, political, cultural, and many others. Movement is used to study the way people and products move from one place to another through interactions and travel. It is also used to study resources and where they are located around the earth and how these resources are dispersed throughout the world. Human interaction/environment is used to describe the way that people interact with the world around them. This interaction can be both positive and......

Words: 322 - Pages: 2

Db Hw1

...primarily exists for use like accessed to the database for querying, updating, and generating reports. DBA: people who administer the database, DBMS and related software. End user: people whose job requires access to the database for querying, updating, and generating reports. Canned transaction: using standard types of queries and updates. Deductive database system: database system which provides capabilities for defining deduction rules for inferencing new information from the stored database facts. Persistent object: stored in the database and persist after program termination. Transaction-processing application: application that the information processing that is divided into individual. 1.3 Main characteristics: Self-contained nature of a db system. Insulation between programs and data. Data abstraction. Support of multiple views of the data. Sharing of data and multiuser transaction processing. For traditional file systems, it cannot allow users to concurrent access to the data. 1.5 Casual end users: occasionally access the database, but they may need different information each time. Naive or parametric end users: Their main job function revolves around constantly querying and updating the database, using standard types of queries and updates. Sophisticated end users: who thoroughly familiarize themselves with the facilities of the DBMS in order to implement their own applications to meet their complex requirements. Standalone users: maintain personal databases by using......

Words: 3269 - Pages: 14

Dbs Research

...Regional Morning Pack DBS Group Research . Equity 01 October 2009 Spotlight On (SP) Hiap Seng: Undervalued oil and gas play (Initiate Coverage) BUY; S$0.69; HSE SP; Price Target: 12-Month S$0.90 • • • • Huge 40-60% discount to peers is unwarranted. Expect high dividends of 4.0-4.5 Scents per share. Margins improvement to support earnings growth. Initiate coverage with a BUY rating. 30% upside to our target price of S$0.90. Ideas & Updates REGIONAL US Fed: Two collision courses SINGAPORE Banking: Positive uptick in loans Hiap Seng (Initiate Coverage) – See Spotlight MALAYSIA Tanjong PLC: Attractive yield play BUY; RM15.00; TJN MK; Price Target: 12-month RM19.25 HONG KONG PUBLIC HOLIDAY THAILAND Charoen Pokphand Foods – See Spotlight (TB) Charoen Pokphand Foods: Earnings surge, costs remain low BUY; Bt7.95; CPF TB; Price Target: 12-Month Bt9.60 (Prev Bt7.50) • • • 3Q09F will beat record high 2Q09 earnings Promising outlook with firm product prices, low raw material costs, and improving margins Raised earnings, and TP to Bt9.60. Undemanding valuation, 21% upside, maintain BUY. Singapore Research Team – 6533 9688 research@dbsvickers.com www.dbsvickers.com “In Singapore, this research report or research analyses may only be distributed to Institutional Investors, Expert Investors or Accredited Investors as defined in the Securities and Futures Act, Chapter 289 of Singapore.” “Recipients of this report, received from DBS Vickers Research (Singapore) Pte Ltd......

Words: 21991 - Pages: 88

Db Unit 3

...DB UNIT 3 500 words only Assignment Type: Discussion Board Deliverable Length: 4-6 paragraphsThe Discussion Board (DB) is part of the core of online learning. Classroom discussion in an online environment requires the active participation of students and the instructor to create robust interaction and dialogue. Every student is expected to create an original response to the open-ended DB question as well as engage in dialogue by responding to posts created by others throughout the week. At the end of each unit, DB participation will be assessed based on both level of engagement and the quality of the contribution to the discussion.At a minimum, each student will be expected to post an original and thoughtful response to the DB question and contribute to the weekly dialogue by responding to at least two other posts from students. The first contribution must be posted before midnight (Central Time) on Wednesday of each week. Two additional responses are required after Wednesday of each week. Students are highly encouraged to engage on the Discussion Board early and often, as that is the primary way the university tracks class attendance and participation.The purpose of the Discussion Board is to allow students to learn through sharing ideas and experiences as they relate to course content and the DB question. Because it is not possible to engage in two-way dialogue after a conversation has ended, no posts to the DB will be accepted after the end of each week.With all of the......

Words: 346 - Pages: 2

Db Exercises

...______________FROM hotel; 7) What is the average price of a room? SELECT ______________FROM room; 8) What is the total revenue per night from all double rooms? SELECT ______________FROM room WHERE ______________; 2. Consider the following schema definitions: Branch (branchNo, street, city, postcode) Staff (staffNo, fName,lName, position, sex, DOB, salary, branchNo) PropertyforRent (propertyNo, street, city, postcode, type, rooms, rent, ownerNo, staffNo, branchNo) Client (clientNo, fName, lName, telNo, prefType, maxRent) PrivateOwner (ownerNo, fName, lName, address, telNo) Viewing (clientNo, propertyNo, viewDate, comment) Registration (clientNo, branchNo, staffNo, dateJoined) For each case below, fill in the blanks such that the SQL queries correspond to the English language queries stated. 1. List the address of all branch offices in London or Bristol. SELECT ______________ FROM ______________ WHERE city=’London’ ______________ 2. List the staff with a salary between $10000 and $30000. SELECT staff_No FROM Staff WHERE ______________ 3. List the staff in descending order of salary. SELECT staff_No, salary FROM Staff ORDER BY ______________ 4. Find the number of different properties viewed in April 2004. SELECT ______________ FROM Viewing WHERE viewDate BETWEEN ‘1-Apr-04’ AND ’30-Apr-04’ 5. Find the minimum, maximum and average staff salary. ......

Words: 934 - Pages: 4

Sae Db Guide

...A PRACTICAL GUIDE TO dB CALCULATIONS This is a practical guide to doing dB (decibel) calculations, covering most common audio situations. You see dB numbers all the time in audio. You may understand that 3 dB is considered a just noticeable change in volume level. But, you haven't a clue how to figure out how to figure out what 24 dBm from your mixing console means to your amplifier rated for 1.4V input sensitivity. You may be aware that dB calculations involve "logs" (logarithms). Thanks to a little technology, you can do dB calculations without knowing a thing about the mathematics of logs, anti-logs, ratios, exponents, or even much about math. Unfortunately, there is no real substitute for doing these calculations, but there is a substitute for having to figure out how to do the calculations. This article figures most of that out for you. Along the way the math is explained to some extent so that you might understand what you are doing. Some of the whys about audio calculations are also explained. This guide is necessarily long in order to cover many situations where you might need to use dB. But, if you understand the calculations, you will find that most of them repeat the same things in different ways. If you begin to see this, it means you are beginning to understand how to calculate dB. INTRODUCTION First, you will need to use a scientific calculator. Your Mac computer has one that you can use. To open it from Finder, click on the “Go” menu, then...

Words: 3907 - Pages: 16

Econ224-Unit 1 Db

...ECON224- Unit 1 DB Cheri Bolin July 19, 2011 Proponents of free market systems argue that free enterprise leads to more efficient production and better response to changing consumer preferences. Others point to the fact that markets are not perfect. Before beginning my classes, I really hadn’t thought about the economy other than the hardships it has brought my family and I over the past several years. After completing Microeconomics I had a bigger picture of the “small” part of our economic system. The inner workings of our economy and its effects on our country as a whole, somewhat fascinated me. I really do not know much about free markets or free enterprise but what I do know, I do have an opinion on. I agree yes- free markets are not perfect but with that said, I believe that is why they work so well. Now, there are some good and bad qualities of a free market and enterprise, just like everything else in this country. In my opinion, other markets and enterprises, such as protected or forced markets are incorrect. When individuals put decisions, basically our well-being, in the hands of our government and politicians, they are asking to be told what, when and how to live their lives. Now don’t get me wrong, I do believe that there are some great laws, we have in place but most of them are downright ignorant. If we had the choice as individuals whether we would prefer a free market and enterprise, I am sure that 75% of the U.S. would be all for it. The ability......

Words: 420 - Pages: 2