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.
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
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
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
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.
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 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
1200.00
$5.75
$4.13
$1.62
Travel
750.00
$6.95
$5.62
$1.33
Deluxe
300.00
$7.50
$6.17
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
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
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
Name: *
Homework Assignment #2
Service Strategy and Encounter (Chapters 2 & 4)
Multiple Choice Questions (Service Strategy)
Select the best answer. The quiz includes one bonus question.
1. The qualifier for an airline offering short commuter flights is:
a
Name: *
Homework Assignment #3
New Service Development (Chapter 3)
Multiple Choice Questions (New Service Development)
Select the best answer. The quiz includes two bonus questions.
1. Which of the following is not a characteristic of a production-line ap
Data Summary
Sum - Sales
Sales Rep
Bill
Jane
Joe
Total Result
Type Wine
Organic
Red
White
Total Result
$23,336
$95,536
$127,049
$245,921
$69,742
$111,937
$88,126
$269,805
$73,096
$91,888
$86,529
$251,513
$166,174
$299,361
$301,704
$767,239
Answer. 1
The o
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
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
Name: *
Homework Assignment #1
Chapter 1: The Service Economy
Multiple Choice Questions (The Service Economy)
Select the best answer. The quiz includes two bonus questions.
1. Which one of the following, according to Daniel Bell, is not true of pre-indust
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
Name: *
Homework Assignment #4
Chapter 6: Service Quality
Multiple Choice Questions (Service Quality)
Select the best answer. The quiz includes one bonus question.
1. Which of the following dimensions of service quality is most important to customers?
a.
Undergraduate Course Syllabus
QSO 320: Management Science Through Spreadsheets
Center: Online
Course Prerequisites
MAT 240
Course Description
This course introduces the student to mathematical techniques that may be used to aid decision making. Topics
may
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