(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...
icon
Related questions
Question

(Use this file to answer only number 2 and show formulas used)

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: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
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
Ć
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
steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.