1. Given the attached cost/supply/demand data for goods shipments form three cities to three destinations, formulate a transportation network model (define decision variables). 2. Present the model formulation in an Excel spreadsheet. Include the Cost per unit to deliver data array. Include the complete Shipping Model(changing cells), showing the capacity of each shipping facility. Present the Received/Shipped line totals and the Demand line on the spreadsheet. 3. Clearly cite the optimized minimization value of the objective function noted in an inserted text box directly on the spreadsheet. 4. Define the objective function in the spreadsheet. 5. Formulate the constraints using Solver. 6. Solve using the transportation network model using solver. 7. Interpret the results. 8. Present notes on the model inserted in text boxes, directly in available space in the spreadsheet. 1. Given the attached cost/supply/demand data for goods shipments form three cities to three destinations, formulate a transportation network model (define decision variables). 2. Present the model formulation in an Excel spreadsheet. Include the Cost per unit to deliver data array. Include the complete Shipping Model(changing cells), showing the capacity of each shipping facility. Present the Received/Shipped line totals and the Demand line on the spreadsheet. 3. Clearly cite the optimized minimization value of the objective function noted in an inserted text box directly on the spreadsheet. 4. Define the objective function in the spreadsheet. 5. Formulate the constraints using Solver. 6. Solve using the transportation network model using solver. 7. Interpret the results. 8. Present notes on the model inserted in text boxes, directly in available space in the spreadsheet