i need help in for a assignment in excel solver

Assignment $\backslash$#$6-$ Tamales Routing

Instructions:

You need to work as an individual $-$ NO GROUP WORK. You must printout support materials for your answer $($remember in PDF and submit to GaView$).$ You will have to use the Solver function within Excel to find the answer. Include a "print screen shot" or similar method of your solver setup $($box with target cell, $\backslash (\backslash$min $/\backslash$max $\backslash ),$ constraints, etc.$)$

Purpose:

This assignment is preparing you for future assignments to come in the SCM major. This is a deliberately easy problem to let you check the visual result with the Excel solution!

Requirements:

It is due as identified on the syllabus. NO LATE WORK. Upload on PDF file or hand in during class for all your work and answers all the questions below.

The Hot Tamales Shipment

The Ortega Food Company needs to ship $100$ cases of hot tamales from its warehouse in Tijuana to a distributor in New York City at minimum cost. The costs per case associated with shipping between various cities are:

A $"-"$ for a city pair indicates no shipping capacity exists on that lane $($i$.$e$.,$ there are no trucks moving directly from LA to Chicago.$)$

$1.$ Draw the network representation of this problem. $($hand or computer, put in PDF$)$

$2.$ Solve the problem using Excel's Solver. Be sure to include a copy of your spreadsheet and the print screen capture of the solver function.

$3.$ What is the correct route to minimize cost? What is the lowest possible cost?

$4.$ What would happen if the route from Tijuana to Denver went to $\backslash (\backslash$$ $28\backslash )?$

$5.$ Are there any other considerations to choosing this route? In other words, what OTHER $($non$-$math$)$ things should you consider based on your knowledge of the real world and logistics$?$ Don't short change this answer!!!