Krannert Graduate School of Management Purdue University MGMT 57000 SPREADSHEET MODELING AND SIMULATION Spring 2014 Instructor: Yanjun Li‚ office: KRAN 422‚ phone: 494-4525‚ e-mail: li14@purdue.edu Office Hours: Tuesday 1:00 – 4:00 pm‚ or by appointment. Course Packet: The course packet contains cases and readings from various sources. Textbook: David Hartvigsen‚ SimQuick: Process Simulation with Excel‚ 2nd Edition‚ Prentice Hall‚ 2004. (ISBN: 0-13-107880-1)
Premium Simulation Microsoft Excel Spreadsheet
sequence‚ this concept is of practical importance if we deal with a sequence of successive approximations for an iterative method‚ as then typically fewer iterations are needed to yield a useful approximation if the rate of convergence is higher. This may even make the difference between needing ten or a million iterations. Iterative methods Regular-falsi method: Like the bisection method‚ the false position method starts with two points a0 and b0 such that f(a0) and f(b0) are of
Premium Numerical analysis
Assignment: Fixed Costs‚ Variable Costs‚ and Break-Even Point Exercise 10.1 During the sixth month of the fiscal year‚ the program director of the Westchester Home-Delivered Meals (WHDM) program decides to again recompute fixed costs‚ variable costs‚ and the BEP using the high–low method. Here are the number of meals served and the total costs of the program for each of the first six months: Month Meals Served Total Costs July 3‚500 $20‚500. August 4‚000 $22‚600. September 4‚200 $23
Premium Costs Variable cost Fixed cost
You are already familiar with Microsoft Excel software. You have learnt some interesting and useful things that can be done in MS-Excel. Microsoft Excel is an electronic spreadsheet software which allows you to enter‚ calculate‚ manipulate‚ organize and analyze data in the form of tabular form. Let us learn more about data tools provide in Microsoft Excel. * Data Tools * Text to Columns * Remove Duplicates * Data Validation * Consolidate Data Tools With the powerful data
Premium Microsoft Excel Spreadsheet Microsoft
Microsoft Excel 2007: Create a macro by using Microsoft Visual Basic | Add to Favorites | In Microsoft Excel 2007‚ macros can be created using Microsoft Visual Basic. The following will show you how to create a macro using Microsoft Visual Basic: 1. If the Developer tab is unavailable‚ complete the following to display it: a. Click the Microsoft Office Button‚ and then click Excel Options. b. In the Popular category‚ under Top options for working with Excel‚ choose
Premium Microsoft Office Microsoft Excel Microsoft
you can afford for a semester of graduate school. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download‚ save‚ and open the Excel workbook named Exploring_e06_Grader_EOC.xlsx. 0 2 On the Budget worksheet‚ perform a goal seek analysis to determine what the ticket price in cell B9 would need to be if you wanted the balance in cell C34 to be $0. Accept the solution. 5 3 Beginning
Premium Spreadsheet Decimal Change
Use of Spreadsheets in Business and Technology Marty Montgomery August 25‚ 2013 Many corporations depend on spreadsheets as a fundamental (Institute of Corporate Auditors‚ 2006) device in their financial reporting and operational processes. As a result‚ the use of spreadsheets is an essential part of the information and decision-making structure for these organizations. In developing and using spreadsheets‚ organizations need to balance their ease and flexibility against the value of reliable
Premium Spreadsheet
Sales (40‚000 units) $1‚000‚000 Variable expenses 700‚000 Contribution margin 300‚000 Fixed expenses 330‚000 Net income (loss) $ (30‚000) 1. What was the company ’s break-even point in sales dollars in 2008? 2. How many additional units would the company have had to sell in 2009 in order to earn net income of $30‚000? 3. If the company is able to reduce variable costs by $2.50 per unit in 2009 and other costs and unit revenues remain unchanged‚ how many units will
Premium Variable cost Costs Management accounting
SIntroduction to Microsoft Excel 2007 Class learning objectives 1. What is Excel? • Spreadsheet uses & samples • Touring the Excel window • Learning important definitions • Navigating around the workbook 2. The Basics • Entering & editing data in cells • Inserting cells‚ rows‚ & columns • Formatting cells • Renaming‚ adding‚ & reorganizing worksheets 3. Formulas • Using mathematical operators • Using four sum methods • AutoCalculate 4. Customizing Your Spreadsheet • Gridlines 5. Finishing Up
Premium Microsoft Office Spreadsheet Microsoft
of marketing strategies. 2. Determine the impact of customer retention rates through the Customer Life Time Value. You will be responsible for analyzing the corresponding case and posting your individual work in your group discussion forum by the specified due date (see course calendar for details). Post your answers to the case questions # 2 to 3 directly in the forum‚ it will save you and your teammates some time‚ and attach the corresponding excel spreadsheet with the financial analysis
Premium Spreadsheet Marketing Microsoft Excel