This problem requires to use excel. I want get the detailed solution of this problem, can someone explain it to me?

Your company uses freight contractors to move truckload lots of product from production facilities to customer distribution centers. Production facilities are located in Las Vegas NV, Cleveland OH, and Ciudad Juarez, Chihuahua. Production costs are the same at each facility. The availability of production capacity at each facility is not yet known, but it may not always be possible to ship from the closest facility. You will build a spreadsheet that can be used to compute the cost of any proposed trucking plan. The demand for next month is as follow: State Truckloads San Francisco 85 Denver CO 162 In the United States, the cost of contracted linehaul1 trucking is about $1.45 per mile. Delays associated with crossing the border from Ciudad Juarez to El Paso TX adds about SYS per truckload. i] What values did you use for intercity distances, and how did you determine them? Build a spreadsheet model that you can use to make many experiments. What is the total cost of meeting demand under the following trucking plans? ii} All demand is supplied from Las Vegas. iii) All demand is supplied from Cleveland. iv) All demand is supplied from I{Iiudad Juarez. v} Demand to the following cities are as follow: San Francisco: halffrom Ciudad Juarez and half from Las Vegas; Denver: 41 from Las Vegas and the rest from Ciudad Juarez; Chicago: 135 from Cleveland, 60 from Ciudad Juarez and the rest from Las Vegas; Dallas: 48 from Ciudad Juarez and the balance from Las Vegas. 53-51117.\