On the tab labeled "Network Diagram", I have provided a visual representation of the network for Problem #9 on Page 227. On the tab labeled "Production Plan," you will see the integration of the general framework of the network integrated into Excel. Carefully read the statement of the problem in the textbook and then review the model to familiarize yourself with the integration of the LP into Excel.
+
+
On the tab labeled "Network Diagram", I have provided a visual representation of the network
On the tab labeled "Network Diagram", I have provided a visual representation of the network for Problem #9 on Page 227. On the tab labeled "Production Plan," you will see the integration of the general framework of the network integrated into Excel. Carefully read the statement of the problem in the textbook and then review the model to familiarize yourself with the integration of the LP into Excel.
Proceed to the Solutions tab where you will find five questions. To answer each question, you will be required to consult the Network Diagram, enter values into the spreadsheet and then transfer some information to ASPE. In your response to each question, start by entering the appropriate information into the spreadsheet or ASPE and then answer the remainder of the question in a written response. Each question is worth 4 points: 2 points for making the correct inputs to the spreadsheet or ASPE and 2 points for a clear, concise, grammatically
Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! '
1[- t.ky\9ohls,dflghbn. ;/tion 1 (4 Points): In the Column labeled "To" (Column D), fill in the numbers of the appropriate nodes based on your review of the network diagram. The Cost information in the model should be helpful in filling out this column. Describe what the "To" nodes represent in the model.
Question 2 (4 Points): In the Column labeled "Supply/Demand" (Column I), fill in the appropriate Supply (should be typed as a negative number) or Demand (should be typed in as a positive number) for the respective node. For example, Cell I6 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell I10.
Question 3 (4Points): There are two constraints in this problem: first is the relationship between the Net Flow and Supply/Demand. Describe this relationship and then incorporate the constraint in RSPE.
Constraint:
Question 4 (4 Points): The second constraint is the relationship between the Flow (decision variables) and the minimum number of units that must be moved from each node. Describe this relationship and then incorporate the constraint in RSPE.
Flow ($B6:$B16) >= Min ($A$6:$A$14)
Question 5 (4 Points): The formula for the Objective Function in Cell E16 is missing. Enter the appropriate formula and describe what is being calculated in that cell. Once you have entered the formula and the two constraints from Questions 3 and 4 above, solve the model. What is the optimal solution?
,36321;'452/582
152., 6ilujyk,./or Problem #9 on Page 227. On the tab labeled "Production Plan," you will see t'p,mhgfdcqwsdrftvgbnm./he integration of the general framework of the network integrated into Excel. Carefully read the statement of the problem in the textbook and then review the model to familiarize yourself with the integration of the LP into Excel.
Proceed to the Solutions tab where you will find five questions. To answer each question, you will be required to consult the Network Diagram, enter values into the spreadsheet and then transfer some information to ASPE. In your response to each question, start by entering the appropriate information into the spreadsheet or ASPE and then answer the remainder of the question in a written response. Each question is worth 4 points: 2 points for making the correct inputs to the spreadsheet or ASPE and 2 points for a clear, concise, grammatically
Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! '
1[- t.ky\9ohls,dflghbn. ;/tion 1 (4 Points): In the Column labeled "To" (Column D), fill in the numbers of the appropriate nodes based on your review of the network diagram. The Cost information in the model should be helpful in filling out this column. Describe what the "To" nodes represent in the model.
Question 2 (4 Points): In the Column labeled "Supply/Demand" (Column I), fill in the appropriate Supply (should be typed as a negative number) or Demand (should be typed in as a positive number) for the respective node. For example, Cell I6 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell I10.
Question 3 (4Points): There are two constraints in this problem: first is the relationship between the Net Flow and Supply/Demand. Describe this relationship and then incorporate the constraint in RSPE.
Constraint:
Question 4 (4 Points): The second constraint is the relationship between the Flow (decision variables) and the minimum number of units that must be moved from each node. Describe this relationship and then incorporate the constraint in RSPE.
Flow ($B6:$B16) >= Min ($A$6:$A$14)
Question 5 (4 Points): The formula for the Objective Function in Cell E16 is missing. Enter the appropriate formula and describe what is being calculated in that cell. Once you have entered the formula and the two constraints from Questions 3 and 4 above, solve the model. What is the optimal solution?
,36321;'452/582
152., 6ilujyk,./On the tab labeled "Network Diagram", I have provided a visual representation of the network for Problem #9 on Page 227. On the tab labeled "Production Plan," you will see the integration of the general framework of the network integrated into Excel. Carefully read the statement of the problem in the textbook and then review the model to familiarize yourself with the integration of the LP into Excel.
Proceed to the Solutions tab where you will find five questions. To answer each question, you will be required to consult the Network Diagram, enter values into the spreadsheet and then transfer some information to ASPE. In your response to each question, start by entering the appropriate information into the spreadsheet or ASPE and then answer the remainder of the question in a written response. Each question is worth 4 points: 2 points for making the correct inputs to the spreadsheet or ASPE and 2 points for a clear, concise, grammatically
Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! '
1[- t.ky\9ohls,dflghbn. ;/tion 1 (4 Points): In the Column labeled "To" (Column D), fill in the numbers of the appropriate nodes based on your review of the network diagram. The Cost information in the model should be helpful in filling out this column. Describe what the "To" nodes represent in the model.
Question 2 (4 Points): In the Column labeled "Supply/Demand" (Column I), fill in the appropriate Supply (should be typed as a negative number) or Demand (should be typed in as a positive number) for the respective node. For example, Cell I6 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell I10.
Question 3 (4Points): There are two constraints in this problem: first is the relationship between the Net Flow and Supply/Demand. Describe this relationship and then incorporate the constraint in RSPE.
Constraint:
Question 4 (4 Points): The second constraint is the relationship between the Flow (decision variables) and the minimum number of units that must be moved from each node. Describe this relationship and then incorporate the constraint in RSPE.
Flow ($B6:$B16) >= Min ($A$6:$A$14)
Question 5 (4 Points): The formula for the Objective Function in Cell E16 is missing. Enter the appropriate formula and describe what is being calculated in that cell. Once you have entered the formula and the two constraints from Questions 3 and 4 above, solve the model. What is the optimal solution?
,36321;'452/582
152., 6ilujyk,./On the tab labeled "Network Diagram", I have provided a visual representation of the network for Problem #9 on Page 227. On the tab labeled "Production Plan," you will see the integration of the general framework of the network integrated into Excel. Carefully read the statement of the problem in the textbook and then review the model to familiarize yourself with the integration of the LP into Excel.
Proceed to the Solutions tab where you will find five questions. To answer each question, you will be required to consult the Network Diagram, enter values into the spreadsheet and then transfer some information to ASPE. In your response to each question, start by entering the appropriate information into the spreadsheet or ASPE and then answer the remainder of the question in a written response. Each question is worth 4 points: 2 points for making the correct inputs to the spreadsheet or ASPE and 2 points for a clear, concise, grammatically
Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! '
1[- t.ky\9ohls,dflghbn. ;/tion 1 (4 Points): In the Column labeled "To" (Column D), fill in the numbers of the appropriate nodes based on your review of the network diagram. The Cost information in the model should be helpful in filling out this column. Describe what the "To" nodes represent in the model.
Question 2 (4 Points): In the Column labeled "Supply/Demand" (Column I), fill in the appropriate Supply (should be typed as a negative number) or Demand (should be typed in as a positive number) for the respective node. For example, Cell I6 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell I10.
Question 3 (4Points): There are two constraints in this problem: first is the relationship between the Net Flow and Supply/Demand. Describe this relationship and then incorporate the constraint in RSPE.
Constraint:
Question 4 (4 Points): The second constraint is the relationship between the Flow (decision variables) and the minimum number of units that must be moved from each node. Describe this relationship and then incorporate the constraint in RSPE.
Flow ($B6:$B16) >= Min ($A$6:$A$14)
Question 5 (4 Points): The formula for the Objective Function in Cell E16 is missing. Enter the appropriate formula and describe what is being calculated in that cell. Once you have entered the formula and the two constraints from Questions 3 and 4 above, solve the model. What is the optimal solution?
,36321;'452/582
152., 6ilujyk,./On the tab labeled "Network Diagram", I have provided a visual representation of the network for Problem #9 on Page 227. On the tab labeled "Production Plan," you will see the integration of the general framework of the network integrated into Excel. Carefully read the statement of the problem in the textbook and then review the model to familiarize yourself with the integration of the LP into Excel.
Proceed to the Solutions tab where you will find five questions. To answer each question, you will be required to consult the Network Diagram, enter values into the spreadsheet and then transfer some information to ASPE. In your response to each question, start by entering the appropriate information into the spreadsheet or ASPE and then answer the remainder of the question in a written response. Each question is worth 4 points: 2 points for making the correct inputs to the spreadsheet or ASPE and 2 points for a clear, concise, grammatically
Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! '
1[- t.ky\9ohls,dflghbn. ;/tion 1 (4 Points): In the Column labeled "To" (Column D), fill in the numbers of the appropriate nodes based on your review of the network diagram. The Cost information in the model should be helpful in filling out this column. Describe what the "To" nodes represent in the model.
Question 2 (4 Points): In the Column labeled "Supply/Demand" (Column I), fill in the appropriate Supply (should be typed as a negative number) or Demand (should be typed in as a positive number) for the respective node. For example, Cell I6 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell I10.
Question 3 (4Points): There are two constraints in this problem: first is the relationship between the Net Flow and Supply/Demand. Describe this relationship and then incorporate the constraint in RSPE.
Constraint:
Question 4 (4 Points): The second constraint is the relationship between the Flow (decision variables) and the minimum number of units that must be moved from each node. Describe this relationship and then incorporate the constraint in RSPE.
Flow ($B6:$B16) >= Min ($A$6:$A$14)
Question 5 (4 Points): The formula for the Objective Function in Cell E16 is missing. Enter the appropriate formula and describe what is being calculated in that cell. Once you have entered the formula and the two constraints from Questions 3 and 4 above, solve the model. What is the optimal solution?
,36321;'452/582
152., 6ilujyk,./On the tab labeled "Network Diagram", I have provided a visual representation of the network for Problem #9 on Page 227. On the tab labeled "Production Plan," you will see the integration of the general framework of the network integrated into Excel. Carefully read the statement of the problem in the textbook and then review the model to familiarize yourself with the integration of the LP into Excel.
Proceed to the Solutions tab where you will find five questions. To answer each question, you will be required to consult the Network Diagram, enter values into the spreadsheet and then transfer some information to ASPE. In your response to each question, start by entering the appropriate information into the spreadsheet or ASPE and then answer the remainder of the question in a written response. Each question is worth 4 points: 2 points for making the correct inputs to the spreadsheet or ASPE and 2 points for a clear, concise, grammatically
Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! '
1[- t.ky\9ohls,dflghbn. ;/tion 1 (4 Points): In the Column labeled "To" (Column D), fill in the numbers of the appropriate nodes based on your review of the network diagram. The Cost information in the model should be helpful in filling out this column. Describe what the "To" nodes represent in the model.
Question 2 (4 Points): In the Column labeled "Supply/Demand" (Column I), fill in the appropriate Supply (should be typed as a negative number) or Demand (should be typed in as a positive number) for the respective node. For example, Cell I6 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell I10.
Question 3 (4Points): There are two constraints in this problem: first is the relationship between the Net Flow and Supply/Demand. Describe this relationship and then incorporate the constraint in RSPE.
Constraint:
Question 4 (4 Points): The second constraint is the relationship between the Flow (decision variables) and the minimum number of units that must be moved from each node. Describe this relationship and then incorporate the constraint in RSPE.
Flow ($B6:$B16) >= Min ($A$6:$A$14)
Question 5 (4 Points): The formula for the Objective Function in Cell E16 is missing. Enter the appropriate formula and describe what is being calculated in that cell. Once you have entered the formula and the two constraints from Questions 3 and 4 above, solve the model. What is the optimal solution?
,36321;'452/582
152., 6ilujyk,./s tab where you will find five questions. To answer each question, you will be required to consult the Network Diagram, enter values into the spreadsheet and then transfer some information to ASPE. In your response to each question, start by entering the appropriate information into the spreadsheet or ASPE and then answer the remainder of the question in a written response. Each question is worth 4 points: 2 points for making the correct inputs to the spreadsheet or ASPE and 2 points for a clear, concise, grammatically
Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! '
1[- t.ky\9ohls,dflghbn. ;/tion 1 (4 Points): In the Column labeled "To" (Column D), fill in the numbers of the appropriate nodes based on your review of the network diagram. The Cost information in the model should be helpful in filling out this column. Describe what the "To" nodes represent in the model.
Question 2 (4 Points): In the Column labeled "Supply/Demand" (Column I), fill in the appropriate Supply (should be typed as a negative number) or Demand (should be typed in as a positive number) for the respective node. For example, Cell I6 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell I10.
Question 3 (4Points): There are two constraints in this problem: first is the relationship between the Net Flow and Supply/Demand. Describe this relationship and then incorporate the constraint in RSPE.
Constraint:
Question 4 (4 Points): The second constraint is the relationship between the Flow (decision variables) and the minimum number of units that must be moved from each node. Describe this relationship and then incorporate the constraint in RSPE.
Flow ($B6:$B16) >= Min ($A$6:$A$14)
Question 5 (4 Points): The formula for the Objective Function in Cell E16 is missing. Enter the appropriate formula and describe what is being calculated in that cell. Once you have entered the formula and the two constraints from Questions 3 and 4 above, solve the model. What is the optimal solution?
,
On the tab labeled "Network Diagram", I have provided a visual representation of the network for Problem #9 on Page 227. On the tab labeled "Production Plan," you will see the integration of the general framework of the network integrated into Excel. Carefully read the statement of the problem in the textbook and then review the model to familiarize yourself with the integration of the LP into Excel.
Proceed to the Solutions tab where you will find five questions. To answer each question, you will be required to consult the Network Diagram, enter values into the spreadsheet and then transfer some information to ASPE. In your response to each question, start by entering the appropriate information into the spreadsheet or ASPE and then answer the remainder of the question in a written response. Each question is worth 4 points: 2 points for making the correct inputs to the spreadsheet or ASPE and 2 points for a clear, concise, grammatically
Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! '
1[- t.ky\9ohls,dflghbn. ;/tion 1 (4 Points): In the Column labeled "To" (Column D), fill in the numbers of the appropriate nodes based on your review of the network diagram. The Cost information in the model should be helpful in filling out this column. Describe what the "To" nodes represent in the model.
Question 2 (4 Points): In the Column labeled "Supply/Demand" (Column I), fill in the appropriate Supply (should be typed as a negative number) or Demand (should be typed in as a positive number) for the respective node. For example, Cell I6 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell I10.
Question 3 (4Points): There are two constraints in this problem: first is the relationship between the Net Flow and Supply/Demand. Describe this relationship and then incorporate the constraint in RSPE.
Constraint:
Question 4 (4 Points): The second constraint is the relationship between the Flow (decision variables) and the minimum number of units that must be moved from each node. Describe this relationship and then incorporate the constraint in RSPE.
Flow ($B6:$B16) >= Min ($A$6:$A$14)
Question 5 (4 Points): The formula for the Objective Function in Cell E16 is missing. Enter the appropriate formula and describe what is being calculated in that cell. Once you have entered the formula and the two constraints from Questions 3 and 4 above, solve the model. What is the optimal solution?
,36321;'452/582
152., 6ilujyk,./or Problem #9 on Page 227. On the tab labeled "Production Plan," you will see t'p,mhgfdcqwsdrftvgbnm./he integration of the general framework of the network integrated into Excel. Carefully read the statement of the problem in the textbook and then review the model to familiarize yourself with the integration of the LP into Excel.
Proceed to the Solutions tab where you will find five questions. To answer each question, you will be required to consult the Network Diagram, enter values into the spreadsheet and then transfer some information to ASPE. In your response to each question, start by entering the appropriate information into the spreadsheet or ASPE and then answer the remainder of the question in a written response. Each question is worth 4 points: 2 points for making the correct inputs to the spreadsheet or ASPE and 2 points for a clear, concise, grammatically
Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! '
1[- t.ky\9ohls,dflghbn. ;/tion 1 (4 Points): In the Column labeled "To" (Column D), fill in the numbers of the appropriate nodes based on your review of the network diagram. The Cost information in the model should be helpful in filling out this column. Describe what the "To" nodes represent in the model.
Question 2 (4 Points): In the Column labeled "Supply/Demand" (Column I), fill in the appropriate Supply (should be typed as a negative number) or Demand (should be typed in as a positive number) for the respective node. For example, Cell I6 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell I10.
Question 3 (4Points): There are two constraints in this problem: first is the relationship between the Net Flow and Supply/Demand. Describe this relationship and then incorporate the constraint in RSPE.
Constraint:
Question 4 (4 Points): The second constraint is the relationship between the Flow (decision variables) and the minimum number of units that must be moved from each node. Describe this relationship and then incorporate the constraint in RSPE.
Flow ($B6:$B16) >= Min ($A$6:$A$14)
Question 5 (4 Points): The formula for the Objective Function in Cell E16 is missing. Enter the appropriate formula and describe what is being calculated in that cell. Once you have entered the formula and the two constraints from Questions 3 and 4 above, solve the model. What is the optimal solution?
,36321;'452/582
152., 6ilujyk,./On the tab labeled "Network Diagram", I have provided a visual representation of the network for Problem #9 on Page 227. On the tab labeled "Production Plan," you will see the integration of the general framework of the network integrated into Excel. Carefully read the statement of the problem in the textbook and then review the model to familiarize yourself with the integration of the LP into Excel.
Proceed to the Solutions tab where you will find five questions. To answer each question, you will be required to consult the Network Diagram, enter values into the spreadsheet and then transfer some information to ASPE. In your response to each question, start by entering the appropriate information into the spreadsheet or ASPE and then answer the remainder of the question in a written response. Each question is worth 4 points: 2 points for making the correct inputs to the spreadsheet or ASPE and 2 points for a clear, concise, grammatically
Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! '
1[- t.ky\9ohls,dflghbn. ;/tion 1 (4 Points): In the Column labeled "To" (Column D), fill in the numbers of the appropriate nodes based on your review of the network diagram. The Cost information in the model should be helpful in filling out this column. Describe what the "To" nodes represent in the model.
Question 2 (4 Points): In the Column labeled "Supply/Demand" (Column I), fill in the appropriate Supply (should be typed as a negative number) or Demand (should be typed in as a positive number) for the respective node. For example, Cell I6 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell I10.
Question 3 (4Points): There are two constraints in this problem: first is the relationship between the Net Flow and Supply/Demand. Describe this relationship and then incorporate the constraint in RSPE.
Constraint:
Question 4 (4 Points): The second constraint is the relationship between the Flow (decision variables) and the minimum number of units that must be moved from each node. Describe this relationship and then incorporate the constraint in RSPE.
Flow ($B6:$B16) >= Min ($A$6:$A$14)
Question 5 (4 Points): The formula for the Objective Function in Cell E16 is missing. Enter the appropriate formula and describe what is being calculated in that cell. Once you have entered the formula and the two constraints from Questions 3 and 4 above, solve the model. What is the optimal solution?
,36321;'452/582
152., 6ilujyk,./On the tab labeled "Network Diagram", I have provided a visual representation of the network for Problem #9 on Page 227. On the tab labeled "Production Plan," you will see the integration of the general framework of the network integrated into Excel. Carefully read the statement of the problem in the textbook and then review the model to familiarize yourself with the integration of the LP into Excel.
Proceed to the Solutions tab where you will find five questions. To answer each question, you will be required to consult the Network Diagram, enter values into the spreadsheet and then transfer some information to ASPE. In your response to each question, start by entering the appropriate information into the spreadsheet or ASPE and then answer the remainder of the question in a written response. Each question is worth 4 points: 2 points for making the correct inputs to the spreadsheet or ASPE and 2 points for a clear, concise, grammatically
Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! '
1[- t.ky\9ohls,dflghbn. ;/tion 1 (4 Points): In the Column labeled "To" (Column D), fill in the numbers of the appropriate nodes based on your review of the network diagram. The Cost information in the model should be helpful in filling out this column. Describe what the "To" nodes represent in the model.
Question 2 (4 Points): In the Column labeled "Supply/Demand" (Column I), fill in the appropriate Supply (should be typed as a negative number) or Demand (should be typed in as a positive number) for the respective node. For example, Cell I6 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell I10.
Question 3 (4Points): There are two constraints in this problem: first is the relationship between the Net Flow and Supply/Demand. Describe this relationship and then incorporate the constraint in RSPE.
Constraint:
Question 4 (4 Points): The second constraint is the relationship between the Flow (decision variables) and the minimum number of units that must be moved from each node. Describe this relationship and then incorporate the constraint in RSPE.
Flow ($B6:$B16) >= Min ($A$6:$A$14)
Question 5 (4 Points): The formula for the Objective Function in Cell E16 is missing. Enter the appropriate formula and describe what is being calculated in that cell. Once you have entered the formula and the two constraints from Questions 3 and 4 above, solve the model. What is the optimal solution?
,36321;'452/582
152., 6ilujyk,./On the tab labeled "Network Diagram", I have provided a visual representation of the network for Problem #9 on Page 227. On the tab labeled "Production Plan," you will see the integration of the general framework of the network integrated into Excel. Carefully read the statement of the problem in the textbook and then review the model to familiarize yourself with the integration of the LP into Excel.
Proceed to the Solutions tab where you will find five questions. To answer each question, you will be required to consult the Network Diagram, enter values into the spreadsheet and then transfer some information to ASPE. In your response to each question, start by entering the appropriate information into the spreadsheet or ASPE and then answer the remainder of the question in a written response. Each question is worth 4 points: 2 points for making the correct inputs to the spreadsheet or ASPE and 2 points for a clear, concise, grammatically
Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! '
1[- t.ky\9ohls,dflghbn. ;/tion 1 (4 Points): In the Column labeled "To" (Column D), fill in the numbers of the appropriate nodes based on your review of the network diagram. The Cost information in the model should be helpful in filling out this column. Describe what the "To" nodes represent in the model.
Question 2 (4 Points): In the Column labeled "Supply/Demand" (Column I), fill in the appropriate Supply (should be typed as a negative number) or Demand (should be typed in as a positive number) for the respective node. For example, Cell I6 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell I10.
Question 3 (4Points): There are two constraints in this problem: first is the relationship between the Net Flow and Supply/Demand. Describe this relationship and then incorporate the constraint in RSPE.
Constraint:
Question 4 (4 Points): The second constraint is the relationship between the Flow (decision variables) and the minimum number of units that must be moved from each node. Describe this relationship and then incorporate the constraint in RSPE.
Flow ($B6:$B16) >= Min ($A$6:$A$14)
Question 5 (4 Points): The formula for the Objective Function in Cell E16 is missing. Enter the appropriate formula and describe what is being calculated in that cell. Once you have entered the formula and the two constraints from Questions 3 and 4 above, solve the model. What is the optimal solution?
,36321;'452/582
152., 6ilujyk,./On the tab labeled "Network Diagram", I have provided a visual representation of the network for Problem #9 on Page 227. On the tab labeled "Production Plan," you will see the integration of the general framework of the network integrated into Excel. Carefully read the statement of the problem in the textbook and then review the model to familiarize yourself with the integration of the LP into Excel.
Proceed to the Solutions tab where you will find five questions. To answer each question, you will be required to consult the Network Diagram, enter values into the spreadsheet and then transfer some information to ASPE. In your response to each question, start by entering the appropriate information into the spreadsheet or ASPE and then answer the remainder of the question in a written response. Each question is worth 4 points: 2 points for making the correct inputs to the spreadsheet or ASPE and 2 points for a clear, concise, grammatically
Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! '
1[- t.ky\9ohls,dflghbn. ;/tion 1 (4 Points): In the Column labeled "To" (Column D), fill in the numbers of the appropriate nodes based on your review of the network diagram. The Cost information in the model should be helpful in filling out this column. Describe what the "To" nodes represent in the model.
Question 2 (4 Points): In the Column labeled "Supply/Demand" (Column I), fill in the appropriate Supply (should be typed as a negative number) or Demand (should be typed in as a positive number) for the respective node. For example, Cell I6 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell I10.
Question 3 (4Points): There are two constraints in this problem: first is the relationship between the Net Flow and Supply/Demand. Describe this relationship and then incorporate the constraint in RSPE.
Constraint:
Question 4 (4 Points): The second constraint is the relationship between the Flow (decision variables) and the minimum number of units that must be moved from each node. Describe this relationship and then incorporate the constraint in RSPE.
Flow ($B6:$B16) >= Min ($A$6:$A$14)
Question 5 (4 Points): The formula for the Objective Function in Cell E16 is missing. Enter the appropriate formula and describe what is being calculated in that cell. Once you have entered the formula and the two constraints from Questions 3 and 4 above, solve the model. What is the optimal solution?
,36321;'452/582
152., 6ilujyk,./s tab where you will find five questions. To answer each question, you will be required to consult the Network Diagram, enter values into the spreadsheet and then transfer some information to ASPE. In your response to each question, start by entering the appropriate information into the spreadsheet or ASPE and then answer the remainder of the question in a written response. Each question is worth 4 points: 2 points for making the correct inputs to the spreadsheet or ASPE and 2 points for a clear, concise, grammatically
Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! '
1[- t.ky\9ohls,dflghbn. ;/tion 1 (4 Points): In the Column labeled "To" (Column D), fill in the numbers of the appropriate nodes based on your review of the network diagram. The Cost information in the model should be helpful in filling out this column. Describe what the "To" nodes represent in the model.
Question 2 (4 Points): In the Column labeled "Supply/Demand" (Column I), fill in the appropriate Supply (should be typed as a negative number) or Demand (should be typed in as a positive number) for the respective node. For example, Cell I6 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell I10.
Question 3 (4Points): There are two constraints in this problem: first is the relationship between the Net Flow and Supply/Demand. Describe this relationship and then incorporate the constraint in RSPE.
Constraint:
Question 4 (4 Points): The second constraint is the relationship between the Flow (decision variables) and the minimum number of units that must be moved from each node. Describe this relationship and then incorporate the constraint in RSPE.
Flow ($B6:$B16) >= Min ($A$6:$A$14)
Question 5 (4 Points): The formula for the Objective Function in Cell E16 is missing. Enter the appropriate formula and describe what is being calculated in that cell. Once you have entered the formula and the two constraints from Questions 3 and 4 above, solve the model. What is the optimal solution?
,
