Homework Help is Here – Start Your Trial Now!
Math
Probability
Greenserv has five projects to assign to five individuals. The labor cost in dollars of each possible assignment is summarized in the table. Person Project 1 Project 2 Project 3 Project 4 Project 5 Albert 22 21 25 26 30 Wilfred 25 19 22 27 28 Anthea 29 25 22 34 20 Natalia 20 23 27 26 24 Peter 24 48 19 24 27 This information is inputted into an Excel spreadsheet Anignmnt le laal d Incet Page layut Fermulas D She Qa From Tee Fie Heme Revie Ve Tet meuht yeu de Frm e Cometio 1 HH D Analy Hemove Duplicate Adancal Calm Dta von Manage tata Med Anali t 7, Sel Fem Oer tnng Refesh l lot Fite Whatt Forecat Goup Ungup Sutetal Fam at Sourn Connection Quany- Racant teur tinks Sert a Rter Deta Tees Foat Oute Anye M 2 Person 3 Albert 4 Wilfred Project 1 Project 2 Project 3 Project 4 Project 5 22 21 25 26 30 25 19 22 27 28 5 Anthea 6 Natalia 7 Peter 29 25 22 34 20 20 23 27 26 24 24 48 19 24 27 10 Project 1 Project 2 Project 3 Project 4 Project 5 Total Projects Supply 11 Albert 1 12 Wilfred 13 Anthea 1 14 Natalia 15 Peter 1 1 16 Total Assigned 17 Total Workers 1. 1. 1 18 19 Total Cost = 104 20

Greenserv has five projects to assign to five individuals. The labor cost in dollars of each possible assignment is summarized in the table. Person Project 1 Project 2 Project 3 Project 4 Project 5 Albert 22 21 25 26 30 Wilfred 25 19 22 27 28 Anthea 29 25 22 34 20 Natalia 20 23 27 26 24 Peter 24 48 19 24 27 This information is inputted into an Excel spreadsheet Anignmnt le laal d Incet Page layut Fermulas D She Qa From Tee Fie Heme Revie Ve Tet meuht yeu de Frm e Cometio 1 HH D Analy Hemove Duplicate Adancal Calm Dta von Manage tata Med Anali t 7, Sel Fem Oer tnng Refesh l lot Fite Whatt Forecat Goup Ungup Sutetal Fam at Sourn Connection Quany- Racant teur tinks Sert a Rter Deta Tees Foat Oute Anye M 2 Person 3 Albert 4 Wilfred Project 1 Project 2 Project 3 Project 4 Project 5 22 21 25 26 30 25 19 22 27 28 5 Anthea 6 Natalia 7 Peter 29 25 22 34 20 20 23 27 26 24 24 48 19 24 27 10 Project 1 Project 2 Project 3 Project 4 Project 5 Total Projects Supply 11 Albert 1 12 Wilfred 13 Anthea 1 14 Natalia 15 Peter 1 1 16 Total Assigned 17 Total Workers 1. 1. 1 18 19 Total Cost = 104 20

Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter10: Sequences, Series, And Probability
Section10.8: Probability
Problem 32E
See similar textbooks
icon
Related questions
Question
The formula that needs to be inputted in Cell G12 is: The formula that needs to be inputted in Cell B19 is: (Note: There is no need to include the $ sign). In the Solver Window, the formula that needs to be typed in 'By Changing Variables Cells' Dialog Box is: In the Solver Dialog Box, the solving method that needs to be selected is the: Anthea is assigned Project The minimum total cost (in $) for the optimal assignment is
Transcribed Image Text:The formula that needs to be inputted in Cell G12 is: The formula that needs to be inputted in Cell B19 is: (Note: There is no need to include the $ sign). In the Solver Window, the formula that needs to be typed in 'By Changing Variables Cells' Dialog Box is: In the Solver Dialog Box, the solving method that needs to be selected is the: Anthea is assigned Project The minimum total cost (in $) for the optimal assignment is
Greenserv has five projects to assign to five individuals. The labor cost in dollars of each possible assignment is summarized in the table. Person Project 1 Project 2 Project 3 Project 4 Project 5 Albert 22 21 25 26 30 Wilfred 25 19 22 27 28 Anthea 29 25 22 34 20 Natalia 20 23 27 26 24 Peter 24 48 19 24 27 This information is inputted into an Excel spreadsheet Amignment Problems Eecel - Excel File Home Incert Page Layout Formulas Data Review View O Tel me what you want to do. là From Accens Show Querien DConnections Clear BCarmeldate -ERemove Duplicates Ralatiorahipa Calumru Data Validation Manage Data Modal 國Flmh Fil 丽 Data Analysis 2, Saher à From Web Là From kot E From Table New B Properties T Raupply 31 Sort What-if Forecast Group Ungroup Subtetal Analyais- Sheet From Other Existing Refresh Fiter Test to Sourcen Cornectiona Query - La Recert Sourcas Al Ede Links TAdvanced Get Eter nal Cata Get & Transform Connedions Sort a Fiter Data Tools Forecast Outine Analyce J17 A B E F G M 2 Person Project 1 Project 2 Project 3 Project 4 Project 5 3 Albert 22 21 25 26 30 4 Wilfred 25 19 22 27 28 5 Anthea 6 Natalia 29 25 22 34 20 20 23 27 26 24 7 Peter 24 48 19 24 27 8. 10 Project 1 Project 2 Project 3 Project 4 Project 5 Total Projects Supply 11 Albert 1 1 12 Wilfred 1 1 1 13 Anthea 1 1 1 14 Natalia 1 1 15 Peter 1 1 1 16 Total Assigned 1 1 1 17 Total Workers 1 1 18 19 Total Cost = 104 20 100 OO1L O OO 10
Transcribed Image Text:Greenserv has five projects to assign to five individuals. The labor cost in dollars of each possible assignment is summarized in the table. Person Project 1 Project 2 Project 3 Project 4 Project 5 Albert 22 21 25 26 30 Wilfred 25 19 22 27 28 Anthea 29 25 22 34 20 Natalia 20 23 27 26 24 Peter 24 48 19 24 27 This information is inputted into an Excel spreadsheet Amignment Problems Eecel - Excel File Home Incert Page Layout Formulas Data Review View O Tel me what you want to do. là From Accens Show Querien DConnections Clear BCarmeldate -ERemove Duplicates Ralatiorahipa Calumru Data Validation Manage Data Modal 國Flmh Fil 丽 Data Analysis 2, Saher à From Web Là From kot E From Table New B Properties T Raupply 31 Sort What-if Forecast Group Ungroup Subtetal Analyais- Sheet From Other Existing Refresh Fiter Test to Sourcen Cornectiona Query - La Recert Sourcas Al Ede Links TAdvanced Get Eter nal Cata Get & Transform Connedions Sort a Fiter Data Tools Forecast Outine Analyce J17 A B E F G M 2 Person Project 1 Project 2 Project 3 Project 4 Project 5 3 Albert 22 21 25 26 30 4 Wilfred 25 19 22 27 28 5 Anthea 6 Natalia 29 25 22 34 20 20 23 27 26 24 7 Peter 24 48 19 24 27 8. 10 Project 1 Project 2 Project 3 Project 4 Project 5 Total Projects Supply 11 Albert 1 1 12 Wilfred 1 1 1 13 Anthea 1 1 1 14 Natalia 1 1 15 Peter 1 1 1 16 Total Assigned 1 1 1 17 Total Workers 1 1 18 19 Total Cost = 104 20 100 OO1L O OO 10
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
SEE MORE TEXTBOOKS