Premium Essay

Submitted By Carlitag67

Words 993

Pages 4

Words 993

Pages 4

Cost Modeling

For

Professor Douglass Smith

By

Integrated Project Process Management (MSPM - 6120 - 2)

Week 2 Application

Spring Session Section B

March 12, 2012

Abstract

Theoretically, cost modeling is a set of assumptions about future project conditions that guide the projects for organizations of cash flows (Sanghera, 2010). Financial models that are utilized in project finance oft-times are troubled with diverse array problems. The reason for failure in projects is mainly due to not clearly defining and segregating various elements of the model; as well as the failure to include crucial information pertaining to the project. It is good practice to have the person who will be responsible for performing a specific activity to estimate the costs associated with the activity (Gido and Clements, 2010). In this paper we were asked to utilize quantitative analysis to perform 5 year and 10 year cash flow calculations utilizing internal rate of return IRR and Net present value to strategically determine which analysis yields the best fit for the project at hand.

Keywords: cost modeling, cash flows, projects, quantitative, analysis, IRR, Internal rate of return, NPV, Net Present Value

Developing a baseline schedule for a project is important; in addition the aforementioned it’s also necessary to develop a baseline budget. Baseline cost components of a project depend on the nature, size and location of the project as well as the management organization, are just a few of the considerations. The project manager PM, customer, and stakeholders are interested in achieving the lowest possible overall project cost that is consistent with its investment objectives (Sanghera, 2010). Determining cost, budget, and earned value should be performed within the initiating stage of a project. Cost related…...

Free Essay

...Interpretation of Modeling and Simulation Can there be a better fit for a company out there that uses Microsoft Excel to conduct modeling to simulate their business growth other than Microsoft itself? Microsoft has made billions of dollars selling their Microsoft Office Suites and their home computer operating systems around the world. They have become one of the largest and well known companies in the world. The way that I see it, is that Microsoft’s business model, in a nutshell, is to provide goods and services in the form of software and support to paying customers. One question that may be asked in this day an age is with the advances in cloud computing and Google’s “free” gadgets, will the traditional Microsoft’s business model come to an end? What will Microsoft’s business analysts do in order to change their business model? One can only imagine that it will need to be modeled and simulated first to avoid potentially expensive mistakes. I must start off by saying that before I started my Systems Modeling Theory online class through Strayer, I thought that it may just be one of the hardest classes to understand that I’ve ever taken throughout the course of my college career. I can say now after having completed the last nine weeks of class that I was correct. What’s hard, is not understanding the concepts of why businesses would use Excel models for their business growth but rather the actual use of Excel itself. With all of the bells and......

Words: 1781 - Pages: 8

Premium Essay

...System Modeling Margaret Francies Strayer University Term Paper System Modeling Theory– CIS 331 Richard Guirguis Due on 12/8/2010 System Modeling Systems modeling or systems modelling is the approach to the study of the use of models to imagine and construct systems in business and IT development. In business and IT development the term "systems modeling" has multiple meaning. System Modeling can refer to analysis and design efforts, simulation and or system dynamics, and a study of the many uses of these models. There are different approaches to modeling: Agent based data and mathematical modeling. Quality management adopts a number of management principles that can be used by top management to guide their organizations towards improved performance. Principles such as: customer focus, leadership, people’s involvement, the process, system approach to management, continual improvement, facts, and a mutual benefit. . Decision making is a reasoning or emotional process which can be rational or irrational. The cognitive perspective is that the decision making process must be regarded as a continuous process integrated in the interaction with the environment. From a normative perspective, the analysis of individual decisions is concerned with the logic of decision making and rationality and the invariant choice it leads to it can be based on explicit assumptions or tacit assumptions. In decision making, objectives must be established and placed in the order......

Words: 662 - Pages: 3

Premium Essay

...EXCEL MODELING AND ESTIMATION IN CORPORATE FINANCE Third Edition CRAIG W. HOLDEN Max Barney Faculty Fellow and Associate Professor Kelley School of Business Indiana University Copyright © 2008 by Prentice Hall, Inc., Upper Saddle River, New Jersey 07458 To Kathryn, Diana, and Jimmy. Contents iii CONTENTS Preface ..................................................................................... vii Third Edition Changes .................................................................................... vii What Is Unique About This Book ..................................................................... x Conventions Used In This Book .......................................................................xi Craig’s Challenge ........................................................................................... xiii The Excel Modeling and Estimation Series .................................................. xiii Suggestions for Faculty Members ..................................................................xiv Acknowledgements ........................................................................................... xv About The Author ................................................................. xvi PART 1 TIME VALUE OF MONEY ..... 1 Chapter 1 Single Cash Flow ....................................................1 1.1 Present Value .......................................................................................

Words: 33587 - Pages: 135

Premium Essay

...Database Modeling Tool INF322 Instructor June 27, 2011 Database Modeling Tool The company has grown exponentially over the past 6 months and needs to develop a new database to house its financial, inventory, and client data. It has been decided to build this new database in house rather than purchase a system from a third party vendor. As part of the development of this database it is in the company’s best interest to utilize a database modeling tool to help the design effort. Utilizing a database modeling tool will offer the following benefits: 1. Simple graphic representation of the data structure. 2. Visual work flow of how data will be entered, modified, and reported. 3. Bulk editor capabilities. 4. Database design generator. 5. Database reverse engineering. 6. Logical and physical data model reporting. The tool that looks to be the best fit for the company is CA Erwin Data Modeler r8. CA Erwin Data Modeler r8 was developed by Logic Works Inc. Logic Works Inc. has been in business as a database modeling solution since 1988 (Carreon, 1996) and continues to be one of the top data modeling providers. CA Erwin Data Modeler r8 is the most balanced data modeler tool when comparing functionality, simplicity, and cost when to its competitors. CA Erwin has very user friendly graphical representation of both the logical and physical data models. No other competing modeler has both of these capabilities within the same function. It has all......

Words: 477 - Pages: 2

Free Essay

...pAssignment: Business Modeling Business Modeling Group 1: Thomas Westelaken, Sebastiaan de Monte, Chris Hoedemakers, Daniëlle Peverelli, Teije Oudshoorn Assignment: Business Modeling Group 1: Thomas Westelaken, Sebastiaan de Monte, Chris Hoedemakers, Daniëlle Peverelli, Teije Oudshoorn Assignment: Business Modeling Table of Contents 1. 2. Introduction .......................................................................................................................................... 4 Story ...................................................................................................................................................... 5 2.1. 2.2. The case (spotify) .......................................................................................................................... 5 The business model canvas........................................................................................................... 6 Customer segments (CS) ....................................................................................................... 7 Value Propositions (VP)......................................................................................................... 9 Channels (S)......................................................................................................................... 10 Customer Relationships (CR)............................................................................................... 11 Revenue......

Words: 4324 - Pages: 18

Premium Essay

...Choice Modeling: Marketing Engineering Technical Note 1 Table of Contents Introduction Description of the Multinomial Logit (MNL) Model Properties of the MNL Model S-shaped response function Inverted “U” Marginal response Elasticity of response Proportional Draw Logit Model Estimation via Maximum Likelihood Using Logit Models for Customer Targeting Using Logit Models for Customer Segmentation Determining the number of latent segments in MNL models Summary References Introduction Firms today have access to increasing amounts of market response data at the level of individual customers, including data from scanner panels, direct marketing efforts, online retailing, loyalty programs, and the like. These data include both the marketing effort directed at a customer (e.g., price discount, or specific email sent to that customer) and the associated specific behaviors (e.g., purchase, customer support) of that customer. Consequently, there is also increasing interest among marketers in developing and using response models specified at the individual level. Analyses of individual-level data are useful for firms even for making decisions about aggregate marketing actions, such as TV advertising. After all, markets are composed of individuals, and acknowledging This technical note is a supplement to the materials in Chapter 1,2, and 7 of Principles of Marketing Engineering, by Gary L. Lilien, Arvind Rangaswamy, and Arnaud De Bruyn (2007). © (All rights reserved) Gary L. Lilien...

Words: 4630 - Pages: 19

Premium Essay

...Database Modeling Kelli Clipp Business Systems Analysis INF322 Arman Kanooni February 10, 2013 This paper discusses database modeling and one tool that can be used for the process. The tool I’ve chosen is based on the material in our textbook and article ‘Modeling for the future’. Database modeling is the process of software engineering which allows for the creation of an information system. In the article ‘Modeling for the future’, they compare database modeling to constructing a house (Carreon, Wang, & Watt, 1996). This comparison is based on the fact that one would use a blueprint when building a house and database modeling can be considered as the same concept. A data model is in essence a blueprint or a plan for the database and without it the database may not be very well built, as with any program, house or building you need a plan. There are several tools available for database designers to utilize and the key is choosing the tool which is right to be used that will meet all the requirements of the database to be created. In the article ‘Modeling for the future’ they discussed and compared products from 1996, and although this article appeared to cover the four key products for database modeling at that time, the market has......

Words: 690 - Pages: 3

Free Essay

...Applied Modeling with Military Operations (non-war) Modeling or model is a simplified representation of a situation or problem and modeling is the process of building, refining, and analyzing that representation for greater insight and improved decision making. Modeling is also a mathematical or logical depiction of a system’s behavior. Simulation, is otherwise the device that implements the model. In many military operations, simulation is distinguished among three classes (rough). Live simulations, this involves real people using real equipment in the physical world (real world), like large field exercises. Virtual simulation, involves real people using simulators, flight simulators and/or actual information systems, this often provides realistic acts. Lastly, constructive simulations, this involves simulated people and systems operating in the simulated world, as in things like simulated combat, here users set the initial conditions and run the simulation to see what happens. Simulations are developed from the thoughts of human designers. All simulations are tested to assure accuracy and effectiveness, to illuminate specific issues or problems. The process that covers these mistakes and issues is associated with verification, validation and accreditation. These three sources are applied to a simulation development cycle that operated by the real world system, and is replicated and identified and the conceptual model of it is then identified. This conceptual model......

Words: 926 - Pages: 4

Premium Essay

...at MTR believe that in Year 1, their share of the potential market would most likely be 40%, at worst 20%, and at best 50%. All values between 20% and 50% are possible, with the likelihood decreasing ‘linearly’ as the values move away from 40%. Further, the average number of buys per ‘MTR’ customer is 10 chinese food trays per year. Assume this average to be normally distributed with a standard deviation of 2 trays. 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......

Words: 770 - Pages: 4

Premium Essay

...University of Phoenix Material Traffic Modeling Figure 1 shows the intersections of five one-way streets and the number of cars that enter each intersection from both directions. For example, I1 shows that 400 cars per hour enter from the top and that 450 cars per hour enter from the left. See the Applications section in Section 6.2 of College Algebra as a reference. For this assignment, use Figure 1 to answer the questions following the figure and to prepare a Microsoft® PowerPoint® presentation. [pic] Figure 1. The intersections of five one-way streets The letters a, b, c, d, e, f, and g represent the number of cars moving between the intersections. To keep the traffic moving smoothly, the number of cars entering the intersection per hour must equal the number of cars leaving per hour. 1. Describe the situation. 2. Create a system of linear equations using a, b, c, d, e, f, and g that models continually flowing traffic. 3. Solve the system of equations. Variables f and g should turn out to be independent. 4. Answer the following questions: a. List acceptable traffic flows for two different values of the independent variables. b. The traffic flow on Maple Street between I5 and I6 must be greater than what value to keep traffic moving? c. If g = 100, what is the maximum value for f? d. If g = 100, the flows represented by b, c, and d must be greater than what values? In this situation, what are the minimum......

Words: 279 - Pages: 2

Premium Essay

...SPREADSHEET MODELING IN CORPORATE FINANCE To accompany Principles of Corporate Finance by Brealey and Myers CRAIG W. HOLDEN Richard G. Brinkman Faculty Fellow and Associate Professor Kelley School of Business Indiana University Prentice Hall, Upper Saddle River, New Jersey 07458 To Kathryn, you’re the inspiration, and to Diana and Jimmy, with joy and pride. Craig CONTENTS Preface PART 1 TIME VALUE OF MONEY Chapter 1 Single Cash Flow 1.1 Present Value 1.2 Future Value Problems Chapter 2 Annuity 2.1 Present Value 2.2 Future Value 2.3 System of Four Annuity Variables Problems Chapter 3 Net Present Value 3.1 Constant Discount Rate 3.2 General Discount Rate Problems Chapter 4 Real and Inflation 4.1 Constant Discount Rate 4.2 General Discount Rate Problems Chapter 5 Loan Amortization 5.1 Basics 5.2 Sensitivity Analysis Problems PART 2 VALUATION Chapter 6 Bond Valuation 6.1 Basics 6.2 By Yield To Maturity 6.3 System Of Five Bond Variables 6.4 Dynamic Chart Problems Chapter 7 Stock Valuation 7.1 Two Stage 7.2 Dynamic Chart Problems Chapter 8 The Yield Curve 8.1 Obtaining It From Bond Listings 8.2 Using It To Price A Coupon Bond 8.3 Using It To Determine Forward Rates Problems Chapter 9 U.S. Yield Curve Dynamics 9.1 Dynamic Chart Problems PART 3 CAPITAL BUDGETING Chapter 10 Project NPV 10.1 Basics 10.2 Forecasting Cash Flows 10.3 Working Capital 10.4 Sensitivity Analysis Problems Chapter 11 Cost-Reducing......

Words: 49278 - Pages: 198

Premium Essay

...Vilnius Gediminas Technical University Jelena Mamčenko Lecture Notes on INFORMATION RESOURCES Part I Introduction to Dta Modeling and MSAccess Code FMITB02004 Course title Information Resourses Course volume 3,0 cr. (4,50 ECTS cr.) Teaching methods (Full-time, daytime studies): Lectures - 16 h per semestre Laboratory works - 32 h per semestre Individual work - 72 h per semester Course aim Understandig of models and system of information resourses. Jelena Mamčenko Introduction to Data Modeling and MSAccess CONTENT 1 Introduction to Data Modeling ............................................................................................................... 5 1.1 Data Modeling Overview ............................................................................................................... 5 1.1.1 Methodology .......................................................................................................................... 6 1.1.2 Data Modeling In the Context of Database Design................................................................ 6 1.1.3 Components of A Data Model................................................................................................ 6 1.1.4 Why is Data Modeling Important? ......................................................................................... 6 1.1.5 Summary ................................................................................................................................ 7 1.2......

Words: 16719 - Pages: 67

Premium Essay

...William Youngblood and Nuri Mahmoud Math Econ – Modeling Paper April 10th, 2012 Developed by the Austrian school of Economic thought, malinvestment refers to investments of firms being poorly allocated due to what they think is artificially low cost of credit and an unsustainable increase in the money supply. This is often blamed on a central bank. By incorporating this concept of malinvestment into the national income model, we can observe and measure the affects on National income as well as its repercussions on our economy as well as foreign economies. Malinvestment is caused by an incorrect prediction of the future at the time of investment and result in capital losses. We will use a Kenysenian-like model for national income and adjust the investment variable to incorporate both the initial investment and malinvestment. Our endogenous variables are those we can predict within the model after putting in the appropriate exogenous variables. Each segment will contribute towards Y, which is the National Income of a country represented in trillions of dollars. The main endogenous variables contributing to national income are Consumption (C), Investment (I), and Government spending (G). Consumption is marked by what individuals and companies will spend to operate after first taking taxes out. Therefore the equation will read [C = a + b (Y-T)]. Investment also plays a large roll in determining national income; in the standard equation investment is......

Words: 427 - Pages: 2

Premium Essay

...A tutorial in managerial accounting concepts and financial modeling using Excel Assignment 1: Introduction We will begin our work this semester with a case called Caribbean Internet Café [hereafter, CIC]. In the CIC case, David Grant wants to open an Internet Café in Kingston, Jamaica. This simple business setting is familiar; how many coffee shops, drive-up or otherwise, can you think of that are within walking distance of campus? Even if you are not a coffee-holic, the operation of one of these places should be fairly self-evident. This assignment will help to fulfill a number of major objectives of the course: 1. The CIC case makes use of a relatively familiar context in which to introduce many of the managerial accounting concepts we will deal with this semester. The familiarity of the context should enable you to associate managerial accounting terminology with real world phenomena. 2. The structure of this series of exercises also provides an opportunity to develop your skills in using Excel to do financial modeling. Irrespective of your preferences for a career choice, financial modeling will be a critical skill in your professional life. Marketers and HR specialists take note: there is no avoiding the numbers. 3. The majority of you are still relatively early in your path through the School of Business program. Case analyses will be an important element in several of your subsequent courses. One key to successful case analysis is meticulous organization of......

Words: 5100 - Pages: 21

Premium Essay

...Source: S. G. Powell and K. R. Baker, 2004. The Art of Modeling with Spreadsheets. New York: Wiley & Sons. Copyright © 2004 by John Wiley & Sons, Inc CHAPTER 1 INTRODUCTION MODELS AND MODELING Modeling is the process of creating a simplified representation of reality and working with this representation in order to understand or control some aspect of the world. While this book is devoted to mathematical models, modeling itself is a ubiquitous human activity. In fact, it seems to be one of just a few fundamental ways in which humans understand the world. As an example, a map is one of the most common models we encounter. Maps are models because they simplify reality by leaving out most geographic details in order to highlight the important features we need. A state road map, for example, shows major roads but not minor ones, gives rough locations of cities but not individual addresses, and so on. The map we choose must be appropriate for the need we have: a long trip home across several states requires a regional map, while a trip across town to find a new doctor’s office requires a detailed street map. In the same way, a good model must be appropriate for the specific uses intended for it. A complex model of the economy is probably not appropriate for pricing an individual product. Likewise, a back-of-the-envelope calculation may be inappropriate for acquiring a multibillion-dollar company. Models take many different forms: mental, visual, physical, mathematical...

Words: 4929 - Pages: 20