question 1: 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 to "To" nodes represent in the model.

question 2: In the column labeled "supply/demand" (column 1), 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 exemple l, cell I6 would be the supply or demand at node 1. Describe in detail the interpretation of the value in Cell I10.

question 3: 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: 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: 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 question 3 and 4 above, solve the model. What is the optimal solution?

C D E F G H I J K L M N O a On the tab labeled "Network Diagram", I have provided a modified 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, Network Diagram and enter values into the spreadsheet on the Production Plan tab. In your response to each question, start by entering the appropriate information into the spreadsheet, hien 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 answer to the question. Questions should be answered on the solutions tab and typed in unbolded print right after the statement of the question. Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! structions Network Diagram Production Plan Solutions ce3_0619 - Excel Search Draw Data Help AutoSave OH 2 File Home Insert Arial Paste BI Clipboard - Page Layout 10 AA A s Formulas == E Review View Wrap Text Merge & Center General $ % HEX 48.9 Conditional Format as Cell Formatting Table Styles O Font Alignment Number Styles 030 4ABCDEFGHIJKLMNOPQ NOTES 410 +570 +320 +550 +50 $1.50D 2 $1.50 Beg SOD1 inv ib 0 3 03 D4 $1.50 Fin Inv 1b = 50 5 7 /lb 50 9 / 1b = 50 - 120 $49 16 = 400 $46 1 400 $461b = 400 $47 16 = 400 1. The node labeled Beg Inv is the Beginning Inventory of 120 units. 2. Cells beginning with Pare 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. P1 (P2 P3 P4 -490 -530 -540 note: lb lower bound Instructions Network Diagram Production Plan Solutions beatsaudio AutoSave of H B- ee3_0619 - Excel Search File Home Insert Draw P age Layout Formulas Data Review View He Arial 10 === Genel AA - A Wrap Text Merge & Center Paste 46 BIU - D $ Clipboard Alignment X 125 4 x C V D for A B 0 E F G H I ACN- Acme Manufacturing To Node Net Flow Supply/Demand 5 Min Flow From 6 0 0.0 7 400 0.0 8 50 0. 0 3 9 400 0. 0 4 10 500. 05 11 400 0.0 12 500.0 13 400 0.0 14 500.0 6OoAWN- Cost $0.00 $49.00 $1.50 $45.00 $1.50 $46.00 $1.50 $47.00 $1.50 Total Cost Instructions Network Diagram Production Plan Solutions C D E F G H I J K L M N O a On the tab labeled "Network Diagram", I have provided a modified 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, Network Diagram and enter values into the spreadsheet on the Production Plan tab. In your response to each question, start by entering the appropriate information into the spreadsheet, hien 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 answer to the question. Questions should be answered on the solutions tab and typed in unbolded print right after the statement of the question. Good luck, enjoy the collaboration with your teammate and as always...HAVE FUN! structions Network Diagram Production Plan Solutions ce3_0619 - Excel Search Draw Data Help AutoSave OH 2 File Home Insert Arial Paste BI Clipboard - Page Layout 10 AA A s Formulas == E Review View Wrap Text Merge & Center General $ % HEX 48.9 Conditional Format as Cell Formatting Table Styles O Font Alignment Number Styles 030 4ABCDEFGHIJKLMNOPQ NOTES 410 +570 +320 +550 +50 $1.50D 2 $1.50 Beg SOD1 inv ib 0 3 03 D4 $1.50 Fin Inv 1b = 50 5 7 /lb 50 9 / 1b = 50 - 120 $49 16 = 400 $46 1 400 $461b = 400 $47 16 = 400 1. The node labeled Beg Inv is the Beginning Inventory of 120 units. 2. Cells beginning with Pare 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. P1 (P2 P3 P4 -490 -530 -540 note: lb lower bound Instructions Network Diagram Production Plan Solutions beatsaudio AutoSave of H B- ee3_0619 - Excel Search File Home Insert Draw P age Layout Formulas Data Review View He Arial 10 === Genel AA - A Wrap Text Merge & Center Paste 46 BIU - D $ Clipboard Alignment X 125 4 x C V D for A B 0 E F G H I ACN- Acme Manufacturing To Node Net Flow Supply/Demand 5 Min Flow From 6 0 0.0 7 400 0.0 8 50 0. 0 3 9 400 0. 0 4 10 500. 05 11 400 0.0 12 500.0 13 400 0.0 14 500.0 6OoAWN- Cost $0.00 $49.00 $1.50 $45.00 $1.50 $46.00 $1.50 $47.00 $1.50 Total Cost Instructions Network Diagram Production Plan Solutions