Original Relativize the Profits Worker 72 1 2 3 A 5 6 4 Job B 8 7 5 Job B C 6 9 93 Assignn Worker Job 1 2 3 Total Profi

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 and excel file to show formulas used) 

3
A
X
B1
5
6
7
8
9
10
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
File
5.
Undo
A
AutoSave
Home
Ready
Off H MGMT 3213_Homework_12_LastName_FirstName
Insert Draw
Page Layout
Formulas Data
X
Calibri
Α' Α
A
V
Paste
Clipboard
V
✓ X ✓ fx
B
76°F
Mostly cloudy
12
BIU
Font
D
✓ 11 W
V
無牌車
A
5
6
4
A
C
Original
1
Worker
2
3
Job
Relativize the Profits
B
(Subtract each number from the
1
largest number in the table)
Worker
2
3
Job
Row Reduction
(Subtract lowest number in each row
1
from each number in row)
Worker
2
3
Column Reduction
Job
B
(Subtract lowest number in each
column from each number in column
1
Worker
21
of row reduction table, then test for
optimum assignment)
3
Modification (only if needed)
Job
(re-test for optimum assignment)
B
1
Worker
2
3
D&R #5 Problem #1 Problem #2 Problem #3
Accessibility: Good to go
A
A
F
Job
B
A
S
875
G
C
6
9
C
C
C
===
0
Review View Help
V
ak
3
Alignment
J
Assignments
H
Worker Job
1
2
3
Total Profit =
K
Profit
DELL
Search (A
Ge
$
.00
V
L
OF
Transcribed Image Text:3 A X B1 5 6 7 8 9 10 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 File 5. Undo A AutoSave Home Ready Off H MGMT 3213_Homework_12_LastName_FirstName Insert Draw Page Layout Formulas Data X Calibri Α' Α A V Paste Clipboard V ✓ X ✓ fx B 76°F Mostly cloudy 12 BIU Font D ✓ 11 W V 無牌車 A 5 6 4 A C Original 1 Worker 2 3 Job Relativize the Profits B (Subtract each number from the 1 largest number in the table) Worker 2 3 Job Row Reduction (Subtract lowest number in each row 1 from each number in row) Worker 2 3 Column Reduction Job B (Subtract lowest number in each column from each number in column 1 Worker 21 of row reduction table, then test for optimum assignment) 3 Modification (only if needed) Job (re-test for optimum assignment) B 1 Worker 2 3 D&R #5 Problem #1 Problem #2 Problem #3 Accessibility: Good to go A A F Job B A S 875 G C 6 9 C C C === 0 Review View Help V ak 3 Alignment J Assignments H Worker Job 1 2 3 Total Profit = K Profit DELL Search (A Ge $ .00 V L OF
ou need from online tuto
1. Use the assignment method to determine the best way to assign workers to jobs, given the following
cost information. Compute the total cost for your assignment plan.
JOB
A
B
C
1
5
8
6
Worker
2
6
7
9
3
5
3
2. Rework Problem 1. treating the numbers in the table as profits instead of costs. Compute the total profit.
in
Transcribed Image Text:ou need from online tuto 1. Use the assignment method to determine the best way to assign workers to jobs, given the following cost information. Compute the total cost for your assignment plan. JOB A B C 1 5 8 6 Worker 2 6 7 9 3 5 3 2. Rework Problem 1. treating the numbers in the table as profits instead of costs. Compute the total profit. in
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 6 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.