Mathematical model for Chapter 1, problem 1.2 Part A
Objective
Set price that will maximize profit if Global exclusively operates domestic
What is the price x that optimizes profit z?
Formulas
Yh=4000-5x. Yh =demand in units in home market, x=unit price i
Step By Step Instructions on Setting Up Different Problems in Solver
1. Understand the OBJECTIVE.
a.
b.
c.
d.
e.
Maximizing Profit
Minimizing Cost
Determining Product Mix
Finding the Minimum Distance for a route/routes.
The OBJECTIVE should always be stat
Problem 3-3
Number of units
Revenue
Labor cost
Profit
Constraints
Cutting
Sewing
Finishing
Packing
Max Junior
Max Travel
Max Deluxe
Min Junior
Min Travel
Min Deluxe
Junior
300.00
$5.75
$4.13
$1.62
Travel
300.00
$6.95
$5.62
$1.33
Deluxe
300.00
$7.50
$6.17
Step By Step Instructions on Setting Up Different Problems in Solver
The steps in setting up a model using Excel Solver are as follows:
1. Understand the OBJECTIVE.
a.
b.
c.
d.
e.
Maximizing Profit
Minimizing Cost
Determining Product Mix
Finding the Minim
Problem 5-13
Shipments:
From
Central
Rock
Acme
Flow in
Job 1
0.0
250.0
2250.0
2500.0
To
Job 2
0.0
0.0
3750.0
3750.0
Job 3 Flow out
1100.0 1100.0
3750.0 4000.0
0.0 6000.0
4850.0
Unit costs:
From
Central
Rock
Acme
Job 1
$9
$7
$4
To
Job 2
$8
$11
$3
Job 3
$7
K. Adam Kidd
QSO-510: 4-2 Data Set
January 17, 2016
(a) Plot the scatterplot that displays one quantitative variable against another. Make sure that the
independent variable is on the x axis and the dependent variable is on the y axis. Please label the ti
Staff Scheduling
Decision Variables
Starting day
SU
MO
TU
WE
TH
staf
11
4
0
2
0
FR
SA
3
0
Objective Function
Minimum number of
Employees needed
Cost
Constraints
SU
MO
TU
WE
TH
FR
SA
0
Total
16
440
1
1
1
1
1
0
0
18
400
0
1
1
1
1
1
0
18
440
0
0
1
1
1
1
1
17
Integer and binary programming are special cases of linear programming. These type of problems put additional constraint
programming allows decision variables to be either 0 or 1. In binary programming a decision variable with value 1 is not se
Typically
AppleBerry MP3 Player: Make vs. Buy
OBJECTIVE:
INPUTS:
AB wants to determine how many of each model it should build itself and how many of each model it sh
Marketing
32 GB CURVY 64 GB CURVY
On site Cost
off site Cost
$
$
$
150 $
75 $
115 $
250
125
175
On
Problem 4-20
Profit
Constraints
Labor
Material
Storage
X
Y
$4
$5 =SUMPRODUCT(B5:C5,$B$4:$C$4)
1
6
8
2
6
4
=SUMPRODUCT(B7:C7,$B$4:$C$4)
=SUMPRODUCT(B8:C8,$B$4:$C$4)
=SUMPRODUCT(B9:C9,$B$4:$C$4)
LHS
<=
10
<=
36
<=
40
Sign RHS
Problem 4-20
Solution value
Pro
Microsoft Excel 14.0 Answer Report
Worksheet: [Module 6 problem set.xlsx]P5-13 (a)
Report Created: 2/8/2017 3:12:11 PM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time
Microsoft Excel 14.0 Answer Report
Worksheet: [Module 3 problem set.xlsx]P3-3
Report Created: 1/20/2017 9:13:15 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.
Sales
City
7451 Los Angeles
11221 Los Angeles
9525 San Francisco
3986 San Diego
11667 San Diego
11649 San Francisco
9010 San Diego
5686 Los Angeles
9121 San Francisco
8703 San Francisco
4369 San Diego
5936 Los Angeles
9990 San Diego
5217 San Diego
5582 Sa
Flair Furniture
Number of units
Profit
Constraints:
Carpentry hours
Painting hours
Maximum chairs
Minimum tables
Refer to Section 2.3 "Formulating a Linear Programming Problem" of Balakrishnan et al.
T
Tables
320.0
$7
C
Chairs
360.0
$5
3
2
4
1
1
1
T: No.
Microsoft Excel 14.0 Answer Report
Worksheet: [Module 3 problem set.xlsx]P3-3
Report Created: 1/20/2017 9:13:15 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.
Flair Furniture
T
Tables
Number of units
Profit
Constraints:
Carpentry hours
Painting hours
Maximum chairs
Minimum tables
C
Decision variable names are
Chairs
shown here for information only.
Labels, such
ashave
onesno
shown
They
role ininthe Solver
row 4
Problem 4-20
Profit
Constraints
Labor
Material
Storage
X
Y
$4
$5 =SUMPRODUCT(B5:C5,$B$4:$C$4)
1
6
8
2
6
4
=SUMPRODUCT(B7:C7,$B$4:$C$4)
=SUMPRODUCT(B8:C8,$B$4:$C$4)
=SUMPRODUCT(B9:C9,$B$4:$C$4)
LHS
<=
10
<=
36
<=
40
Sign RHS
Problem 4-20
Solution value
Pro
Excel Function
AVERAGE
Description
Example
Calculates the arithmetic mean by adding a group AVERAGE(A1:A6)
of numbers in given cells and then dividing by the
count of those numbers
Adds all numbers in a range of cells
IF
MEDIAN
IF (A2>5,B1+B2, B1-B2)
Retu
1.
What factors should the assistant chief consider in determining the presence of gender
bias in firefighter promotion?
2.
Is the promotional status of recently promoted firefighters independent of their gender?
3.
What reasons should the assistant chief
QSO 320 Milestone Four Guidelines and Rubric
Overview: You will now use the provided final project raw data set and Milestone Four Business Scenario, and help management decide on the right mix of
wines to sell based on newly derived profit information, w