View snips please

NOTES +320 +570 +410 +550 +50 1. The node labeled Beg Inv is the Beginning Inventory of 120 units. 2. Cells beginning with P are Production nodes. The numbers that follow represent a certain month. 3. Cells beginning with D are Demand nodes. The numbers that follow represent a certain month. 4. The small numbers at the bottom of each node represent the node number. There are 10 nodes in the network 5. The node labeled Fin Inv is the Final Inventory of 50 units that should be carried forward to the next month. Beg Fin $1.50 $1.50 $1.50 D2 $1.50 D1 D3 D4 Inv Inv Ib = 0 Ib = 50 Ib = 50 Ib = 50 Ib = 50 3 1 10 -120 $46 Ib = 400 $45 Ib = 400 $49 Ib = 400 $47 Ib = 400 P3 P1 P2 P4 2 4 -540 -440 -490 -530 note: Ib =lower bound Acme Manufacturing Node Min Flow From To Cost Net Flow Supply/Demand $0.00 0.0 -..... $49.00 $1.50 400 0.0 2 ............ 0.0 50 3 3 $45.00 400 0.0 4 $1.50 50 0.0 $46.00 400 0.0 $1.50 50 0.0 ............. 0.0 $47.00 400 8 -............ $1.50 50 0.0 9. 10 Total Cost 00000000 0000|0 00_0 Question 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 16 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell 10. 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 Excel. 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 Excel. 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? NOTES +320 +570 +410 +550 +50 1. The node labeled Beg Inv is the Beginning Inventory of 120 units. 2. Cells beginning with P are Production nodes. The numbers that follow represent a certain month. 3. Cells beginning with D are Demand nodes. The numbers that follow represent a certain month. 4. The small numbers at the bottom of each node represent the node number. There are 10 nodes in the network 5. The node labeled Fin Inv is the Final Inventory of 50 units that should be carried forward to the next month. Beg Fin $1.50 $1.50 $1.50 D2 $1.50 D1 D3 D4 Inv Inv Ib = 0 Ib = 50 Ib = 50 Ib = 50 Ib = 50 3 1 10 -120 $46 Ib = 400 $45 Ib = 400 $49 Ib = 400 $47 Ib = 400 P3 P1 P2 P4 2 4 -540 -440 -490 -530 note: Ib =lower bound Acme Manufacturing Node Min Flow From To Cost Net Flow Supply/Demand $0.00 0.0 -..... $49.00 $1.50 400 0.0 2 ............ 0.0 50 3 3 $45.00 400 0.0 4 $1.50 50 0.0 $46.00 400 0.0 $1.50 50 0.0 ............. 0.0 $47.00 400 8 -............ $1.50 50 0.0 9. 10 Total Cost 00000000 0000|0 00_0 Question 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 16 would be the supply or demand at Node 1. Describe in detail the interpretation of the value in Cell 10. 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 Excel. 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 Excel. 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