How do I solve this problem in excel? I started working on it, but I'm a bit stuck. Please show me how to do it, your help is greatly appreciated. Thumbs up guaranteed for best answer :)

Oilco has oilfields in San Diego and Los Angeles. The San Diego field can produce up to 500,000 barrels per day and the Los Angeles Field can produce up to 400,000 barrels per day. Oil is sent from the fields to a refinery, either in Dallas or Houston. Each refinery has a capacity of 380,000 barrels per day. To refine 1000 barrels costs $5700 at Dallas and $6000 at Houston, refined oil is shipped to customers in Chicago and New York. Chicago customers require 400,000 barrels per day and New York customers require 300,000 barrels per day the cost of shipping 1,000 barrels of oil (refined or unrefined) between cities are shown in the input data table. Using a network modeling structure, determine how to minimize the total cost of meeting all demands. Unit shipping costs (per 1000 barrels) Houston New York3 Chicago From Los Angeles4 Dallas $3,250 $3,400 $3,300 $3,350 Capacity 400,000 500,000 San Diego1 Dallas2 $3,600 $3,550 $3,100 $3,200 Houston5 Capacity Refine Cost (000 brl) 380,000 $5,700 380,000 $6,000 Demand 300,000 400,000