(Use this file to answer only number 2 and show formulas used)
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
(Use this file to answer only number 2 and show formulas used)
Transcribed Image Text:ile
2
AutoSave
V
Undo
A
Home
Paste
Off HMGMT_3213_Homework_12_Jones_Sydni
Insert Draw Page Layout
Calibri
S
(G
B I U
Clipboard
V
V
X ✓ fx
B
Original
Relativize the Profits
(Subtract each number from the
largest number in the table)
Row Reduction
(Subtract lowest number in each row
from each number in row)
Column Reduction
(Subtract lowest number in each
column from each number in column
of row reduction table, then test for
optimum assignment)
Modification (only if needed)
(re-test for optimum assignment)
B
5
6
7
18
29
30
31
Ready Accessibility: Good to go
69°F
Clear
Worker
Worker
Worker
Worker
Worker
D&R #5 Problem #1
V
✓ 11
V
Font
1
2
3
1
21
3
H
2
3
E
A
5
6
4
A
1
2
3
A
A
0
Search (Alt+Q)
Formulas Data Review View
Help
A^
= =
A
V
ak
= = = = = @ -
Alignment
H
1
Worker
1
2
3
A
V
Job
B
Job
B
C
Job
B
C
Job
B
C
2
3
Problem #2 Problem #3
F
Job
B
8
7
5)
A
V
C
9
3
C
O
ab
Assignments
Job
Total Profit
-
K
Profit
DOLL
General
$ - % 9
0 .00
0
Number
[
M
00
O
N
Transcribed Image Text:8:53
Get live
from onl
SEARCH
number frc
Row Reduc
number in
lowest nun
Worker 21
assignmen
optimum a
#2 Problem
CCC===0
Worker Jot
OF
ou n
Worker
3
4
6
A
JOB
C
2. Rework Problem 1. treating the numbers in the table as profits instead of costs. Compute the total profit.
cost information. Compute the total cost for your assignment plan.
1. Use the assignment method to determine the best way to assign workers to jobs, given the following
2. Rework Problem 1, treating the numbers in the table
AA
ou need from online tuto
2
5
3 6
7
1
5
in
8
6
B
LTE
rtleby →
today
TH SOLVER
23 Job
rom each
btract
umn 1
for
L Problem
75 G C 69
nents H
bartleby.com
$.00 VL
tuto
Ć
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 4 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.