1
Agenda December 5
Detailed Simulation Model
Detailed Simulation Model
College Fund Investment
Case 16.1, Investing for College.xlsx
Your next door neighbor has a 12-year old
daughter and he wants to pay her first years
tuition in 6 years = $17.5K
Tw
1
Agenda September 12
Standard Probability Distributions
2
Introduction
Several distributions for random variables
commonly occur in a variety of business
applications
Weve already discussed the General Discrete
Normal
Binomial
Text also discusses th
1
Agenda October 31
Time Series Analysis and Forecasting
2
Time Series Analysis and Forecasting
Time series data
Tracks one or more numerical variables over time
Time periods could be hours, days, weeks, months,
quarters, years, etc.
Forecasting
Pred
1
Agenda November 7
Introduction to Optimization
2
Introduction to Optimization
Optimization is the process of finding
the best solution to a problem, given a
limited set of options
3
Key Elements of an Optimization Problem
Decision variables
Variables
1
Agenda October 24
Sarah Gets a Diamond De-Brief
Midterm Examination Review
2
Sara Gets a Diamond De-brief
Dummy Variables?
3
Sara Gets a Diamond De-brief
Nonlinear Transformations?
4
Sara Gets a Diamond De-brief
Interaction Variables?
5
Competition Resu
1
Agenda November 16
Sensitivity Analysis
Island Sunglasses
Two Product Mix Model
2
But firstwhere was Prof. Barnes?
2016 Institute for Operations Research and
Management Science Annual Meeting
Readmission prediction for heart failure patients
Intelli
1
Agenda November 9
Building Optimization
Models in Excel
Island Sunglasses
Two Product Mix Model
Homework #4 released
2
Building Optimization Models in Excel
Excel has its own terminology for optimization
Changing cells contain values of the decision
1
Agenda November 28
Introduction to Simulation
2
Introduction to Simulation
Simulation is an extremely useful tool that can be
used to incorporate uncertainty explicitly into
spreadsheet models
Rather than make assumptions about how things behave
on av
1
Agenda November 21
Detailed Optimization Model
Sonoma Valley Wines Part
2
Sonoma Valley Wines
George is starting a wine business for which
he will sell bottles of Petite Sirah (PS) and
Sauvignon Blanc (SB)
Key inputs
Initial budget: $10,000
Cost of
1
Agenda November 30
Introduction to @Risk
Homework #5 releasedlast one!
@RISK Software
Excel-based simulation add-on
Key features
Built-in functions to generate observations from
many probability distributions
Also, fit probability distributions to
1
Agenda August 24
Data Exploration
Descriptive Statistics
2
Data Exploration
An important first step in using data to make
better decisions is data exploration
A large proportion of successful data mining efforts is
devoted to data exploration!
In o
H D
Maximize tetal contribution = revenue - east Case 2: Max revenues
Revenue = p d(p)
Ceet = c d(p) |
LOGIT PRF
Demand fu netien: d(p)=C exp(-(a+bp).~" [1+exp(-(a+bp)]
Parameters
C 1000 Given
a -5 Given
b 1 Given
Unit variable cost 5|Given
Deeiaian
A E L
vlaximize total contribution = revenue - coat Case 2: Max revenues, P>=VC
Revenue = p dcfw_p)
Boat = c d(p)
-0G IT PRF
Demand iu nction: d(p)=C exp(-cfw_a+bp) r [1+expcfw_-cfw_a+bp)]
Darametere
3 1000 Given
a -5 Given
J 1 Given
Jnit variable cos
Maximize total contribution = revenue - oost Case 1: Max profits
Revenue = p d(p)
Cost = o d(p)
LOGIT PRF
Demand fu notion: d(p)=C expcfw_-(a+bp) I [1+exp(-(a+bp)]
Parameters
C 1000 Given
a -5 Given
b 1 Given
Unit variable cost 5|Given
Daoision variable [
BUDT 758Y Database Management Systems
SQL Server Management Studio
and Visual Studio
!
Yiying Xiao
Naga Sirisha Madgula
!
Microso@ SQL Server
www.microso@.com/en-us/sqlserver/
Lee-758Y-Act00
1
!
Outline
IntroducHon to Microso@
BUDT 758Y Database Management Systems
Lecture 11: Data and DB Administra>on
!
DR. ADAM LEE
!
Objec>ves
Dene terms.
List func>ons and roles of data/database administra>on.
Describe role of data dic>onaries and informa>on
BUDT 758Y Database Management Systems
Lecture 00: Outside Textbook
!
DR. ADAM LEE
adamlee@rhsmith.umd.edu
!
Outline
DBMS comparison
Release
PlaEorm
DBMS products
Example database downloads
Example large databases (at US g
BUDT 758Y Fall 2015 Homework #4 SQL DDL
Due by 11:59pm, Wednesday, October 14th, 2015.
Note: The file name must be renamed to yourLastName_yourFirstName_HW4.docx.
Repeat steps below for the Projects, Inc. normaliz
BUDT 758Y Fall 2015 Homework #2 Relational Model
Due by 11:59pm, Wednesday, September 23rd, 2015.
Note: The file name must be renamed to yourLastName_yourFirstName_HW2.docx.
Repeat steps below for the Projects, Inc