Using Solver for Linear Programming
I- Installing Solver
1- Office 2003
In Excel, select ToolsSolver.
If Solver does not appear on the menu under Tools, select ToolsAdd-ins and then check the
box next to Solver Add-in. Solver then will display in the Tool
Chapter 2 Reading Notes
1. An Introduction to Linear Programming
a. Linear programming is a problem-solving approach developed to help
managers make decisions.
b. In all linear programming problems, the maximization or minimization of
some quantity is the
http:/www.modernscientificpress.com/Journals/ViewArticle.aspx?
XBq7Uu+HD/8eRjFUGMqlRQYRj4DDs07rBArx5El0Qw50pW/3AonfkedsfsgbXoNB
Decision Making in Agriculture: A Linear Programming Approach
The paper discusses how linear process modeling is used to determ
Chapter 1 Reading Notes
1. Introduction
a. Management science, an approach to decision making based on the scientific
method, makes extensive use of quantitative analysis.
i. Two other widely known and accepted names for the body of
knowledge involving qu
Chapter 3 Reading Notes
Linear Programming: Sensitivity Analysis and Interpretation of Solution
1. Sensitivity analysis is the study of how the changes in the coefficients of an
optimization model affect the optimal solution.
a. Because sensitivity analys
Chapter 7 Reading Notes
Integer Linear Programming
1. Integer Linear Programming
a. A class of problems that are modeled as linear programs with the additional
requirement that one or more variables must be integer are called integer
linear programs.
i. I
Chapter 6 Reading Notes
Distribution and Network Models
1. Supply Chain Models
a. A supply chain describes the set of all interconnected resources involved in
producing and distributing a product.
i. In general, supply chains are designed to satisfy custo
Sampling is widely used in business for gathering information to draw
conclusions about _. a population
One of the advantages for taking a sample instead of conducting a
census is this: _. - a sample can save money when data
collection process is destruct
A statistic calculated from sample data and used to estimate a
population parameter is called _. a point estimate
A range of values around the statistic calculated from sample data and
used to estimate a population parameter is called _.
- an interval est
Chapter 4 Quiz
The joint probability of any two events is always equal to the product of
the marginal probabilities of those two events. False
If the conditional probability of an event A given another event B is
same as the marginal probability of the ev
In a uniform distribution, the mean is the value that lies halfway
between the endpoints. True
Random variables, which are usually generated from experiments in
which the observations or things are measured rather than
counted, are _. continuous random va
Chapter 3 Quiz
The median and the second quartile of a data set are always equal.
True
Depending on the numbers in a data set the sum of deviations from
the arithmetic mean for the set of numerical data may be greater than
or less than zero. False
Standa
The number of defective items, X, in a batch of 100 items is unknown
prior to inspection. X is an example of a continuous random variable.
- False
The number of students score A for a final exam is an example of a
discrete random variable. True
In a distr
In this lecture we will begin using samples to make
inferences about single populations.
Page 1
There are a number of primary objectives in this lecture. First we will
differentiate between point and interval estimations. We will then
compute interval est
Introduction to Chapter 8
Statistical Inference: Estimation for Single Populations
Now we have finally reached the point at which we can do inferential statistics, which are essential to a
great many business, technical, and scientific endeavors. Estimati
In the last lecture we discussed discrete distributions and only briefly introduced
continuous distributions. The introductory pdf document for Chapter 6 introduces
the general topic as well as the uniform distribution, and the remainder of this ppt
focus
Further Comments on Ch 5 discrete distributions - understanding the reasoning behind them
Binomial Distributions
The textbook has a discussion similar to the one I give below, but it does not use the tree concept and is
vague about some of the other conce
Ch8 Problems
Problem 4
According to Runzheimer International, the average cost of a domestic trip for business
travelers in the financial industry is $1,250. Suppose another travel industry research
company takes a random sample of 22 business travelers i
Ch7 Problems
Problem 1
For each of the following research projects, list three variables for stratification of
the sample.
a. A nationwide study of motels and hotels is being conducted. An attempt
will be made to determine the extent of the availability o
Ch8 Problems
Problem 2
A small lawnmower company produced 1500 lawnmowers in 1990. In an effort to
determine how maintenance free the units were, the company decided to conduct a
multi-year study of the 1990 lawnmowers.
A sample of 200 owners of these law
Ch7 Problems
Problem 2
If every eleventh item is systematically sampled to produce a sample size of 75
items, approximately how large is the population?
Page 1 of 2
Solution 2
Use formula for systematic sampling:
K
N
n
Where K = size of selection interval
Ch7 Problems
Problem 4
In an effort to cut costs and improve profits, many U.S. companies have been turning to
outsourcing. In fact, according to purchasing magazine, 54% of companies surveyed
outsourced some part of their manufacturing process in the pas
Ch8 Problems
Problem 1
A candy company fills a package of Halloween candy with individually wrapped pieces
of candy. The number of pieces of candy per package varies because the package is
sold by weight. The company wants to estimate the number of pieces
Ch7 Problems
Problem 3
The Statistical Abstract of the United States published by the U.S. Census Bureau reports
that the average annual consumption of fresh fruit per person is 99.9 pounds. The
standard deviation of fresh fruit consumption is about 30 po
Ch6 Problems
Problem 1
The U.S. Bureau of Labor Statistics reports that the average annual salary in the
metropolitan Boston area is $45,121. Suppose annual salaries in the
metropolitan Boston area are normally distributed, with a standard deviation of
$4
Ch5 Problems
Problem 5
According to a recent survey, the probability that a passenger files a complaint with the
Department of Transportation about a particular U.S. airline is 0.000014.
Suppose 100,000 passengers who flew with this particular airline are
Ch5 Problems
Problem 2
In a study by Peter D. Hart Research Associates for the NASDAQ Stock Market, it was
determined that 20% of all stock investors are retired people. In addition, 40% of all U.S.
adults invest in mutual funds.
a. Suppose a random sampl
Ch6 Problems
Problem 3
According to the Air Transport Association of America, the average operating cost of an
MD-80 jet airliner is $2,087 dollars per hour. Suppose the operating costs of an MD-80
jet airliner are normally distributed with a standard dev