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

Strategic Modeling Essay

785 words - 4 pages


Spreadsheet Models for Business Decision Problems


Assignment 1[1]
(Due 11:30 pm, Jan 7th 2014)

Malgudi Tindi Room (MTR) Inc. is a well-known food processing major operating from Bangalore. Its product offerings vary from assorted pickles, instant packaged foods (dosa mix, idly mix etc), spices and snacks. It is looking at developing a new microwavable ‘chinese food tray’ consisting of sweet corn soup in a plastic pouch, ‘hakka’ noodles and gobi manchurian. This product is targeted towards young urban working professionals and families with young working parents. Based on an initial analysis, the decision makers at MTR Inc ...view middle of the document...

Truncate the distribution at ‘zero’ trays at the lower end and 50 at the upper end.
4. The variable cost of producing this item in Year 1 is either Rs 20 or Rs 25. It is a function of the production technology used to make this item. At the moment, there are two alternatives being considered, with each being equally likely.
5. The proposed sales price for this item in Year 1 is Rs 40.
6. As per current thinking, the sales price and the variable cost of producing this item is ‘budgeted’ to increase by 5% annually.
7. The initial fixed cost of developing this product, as well as developing the technology for producing it in a large scale, is likely to be Rs 3 crore or Rs 5 crore. Assume each to be equally likely and that it is incurred in year 0.
8. Currently, there is only one competitor in the market who is likely to offer a competing product. Each year, there is a 20% chance that a new competitor will enter the market with a similar product offering. The market can ‘accommodate’ at most four competitors. That is, once there are four competitors in the market, other potential competitors would be ‘discouraged’ from entering it.
9. The impact of fresh competitors entering the market is best described as follows: In Year t (t>1), the estimated sales for MTR...

Other Papers Like Strategic Modeling

Planners Lab Essay

302 words - 2 pages Planners lab Successful financial planning is a critical success factor for every organization. The Planners Lab (PL) is not restricted to financial planning, but this is a primary focus. Example applications include strategic planning, financial planning, capital budgeting, balanced scorecards, engineering project investment analysis, merger and acquisition analysis, and sales forecasting. Planners Lab models are written in an

Corporate Planning Essay

2180 words - 9 pages in India on strategic planning has not taken off. There are very few studies on corporate planning practices in India firms. Of late some leading Indian management education institutions have begun to offer short duration executives development programmes on corporate planning. A quick examination of the teaching materials used in these programmes clearly shows a predominance of materials originally developed in the United States. This is not

System Design and Analysis Chapter One

849 words - 4 pages organizational levels with a wide array of tools that can improve quality and job performance. Database management systems 7. Describe four organizational levels of a typical business and their information requirements. Top management - needs information for strategic planning, those that affect the company's future survival and growth. Middle management - needs information for tactical planning. Lower management - needs information for

Decision Making

1870 words - 8 pages Running head: DECISION MAKING Decision Making Bonnie K. Hinsdale Grand Canyon University BUS 660 November 24, 2010 Decision Making The purpose of this paper is to explore how a company can become an analytic competitor. Questions as to what are the sources of Decision Making to an analytic competitor will also be discussed. A discussion on how influential quantitative modeling is and its utility in

Business Analytics

495 words - 2 pages Business Analytics- * Exploring data to find new patterns and relationships (data mining) * Explaining why a certain result occurred (statistical analysis, quantitative analysis) * Experimenting to test previous decisions (A/B testing, multivariate testing) * Forecasting future results (predictive modeling, predictive analytics) Answers the Important Questions Such As: -Why did it happen? Will it happen again? What will

Google Error Leaks Website Owners' Personal Info

5699 words - 23 pages attempts have been made in using mostly business terminology and business language while describing the requirements in this document. Very minimal and commonly understood Technical terminology is used. Use case / Designer approach is used in modeling the business requirements in this document. [Delete the approach that is not applicable.] 2 Intended Audience The main intended audience for this document are the business owners of the

Baxter Healthcare Corporation

1356 words - 6 pages into a new corporate culture that is supported from the top down, demonstrated by strong CEO commitment and role modeling. A major result of this strategic assessment has been that Baxter redefined and expanded the work-life experience to encompass more categories of conflicts experienced by employees. Baxter, in conjunction with MK Consultants, developed the four-level The Work and Life Pyramid of Needs, which rests on a base of Respect (the

Business Performance Management

5965 words - 24 pages (Simulations in the modeling environment can be performed on real historical data.) [pic] Figure 6. BPI architecture Strategic performance management systems The strategic performance management systems allow for the definition, monitoring, and management of strategic business measures. These systems are an evolution of the business intelligence reporting systems to strategic management systems that provide key performance indicators and

Data Mining

989 words - 4 pages TAKING A CLOSER LOOK AT DATA MINING Student’s Name: Maria Dang Teacher’s Name: Mr. Di Pietro Date due: Wednesday, September 11th, 2012 Class: ICS 3U1 Period: 1 Abstract: The following sections will discuss upon the topic, data mining; it is written to those who are of interest. As a matter of fact, data mining is just recently gaining a considerable amount of attention from a wide range of individuals, involving various strategic and

Use of Real Options Theory

1789 words - 8 pages Business 650, Managerial Finance Use of Real Options Theory Financial Management/Modeling I April 18, 2011nstructor: Abstract At a previous employment environment, the president of the corporation acted on a whim, rather than, conducting a series of testing for his expansion to go into other businesses ventures. Within a few short months, the plan was abandoned for lack of profitability. As an employee, I thought of this as a failure

Soccer Penalty And Game Theory

774 words - 4 pages possibilities are to kick right, left or in the middle; the goalkeeper's actions can be to jump right, left or stay in the middle. One wants to maximize of scoring, the other one wants to minimize it. Modeling such strategic interactions clearly calls to the “Game Theory” which means that the payoff of one player depends on the decisions and actions of the other one. They are interacting because they have to take the decisions of the other

Related Essays

Marriott Case Study

759 words - 4 pages INDUSTRY RELATED WORD LIST Investment Banking Consultant private equity Leadership venture capital Re-engineering techniques Corporate finance systems professional project finance strategic planning valuation case research methods financial analysis SAP forecasting BAAN competition analysis Peoplesoft country and risk analysis CFA MIS data modeling Commercial Banking relational databases lending

Logical Modeling In Systems Analysis

3183 words - 13 pages developed using the information engineering approach, a subapproach of the traditional, emphasizing strategic planning and data modeling. In the object-oriented approach, the system is defined as a collection of interacting objects that communicate through message exchange. The class diagram is the equivalent of the entity relationship diagram but also shows logical methods in addition to entities and attributes. The use case diagram is

Lost Leaf Essay

1024 words - 5 pages utilize effective strategies is a necessary skill for academic success. Many students, especially students with learning disabilities (LD), are ineffective and inefficient strategic learners. CSI enables students to become strategic and self-regulated learners (Dole, Nokes, & Drits, 2009; Pressley, Woloshyn, Lysynchuk, Martin, Wood, & Willoughby, 1990). Using proven procedures associated with explicit instruction including process

Controllers Essay

655 words - 3 pages with a great eye for detail, strong analytical skills and a strong desire to truly understand the financial markets. Those who join us will be able to operate at a fast pace and in a constantly changing risk environment. Market Risk Strategies is responsible for designing and implementing market risk measurement models as well as approving pricing models used by the firm. The group is comprised of two teams: Risk Modeling and Derivatives