PLEASE USE SOLVER STEP BY STEP WITH FORMULAS FOR LIKE An automobile company produces cars in New York (NY, node 1) and New Jersey (node 2) and has a warehouse in Atlanta (node 3). The company supplies cars to customers in Houston (node 4) and Tampa (node 5). The costs of shipping a car between various locations (nodes) are listed in the worksheet Q3. For instance, it costs $140 to ship each car from NY (node 1) to New Jersey (node 2). NY can produce up to 1100 cars and New Jersey can produce up to 2900 cars. Houston must receive 2400 cars and Tampa must receive 1500 cars. Determine how to minimize the cost of meeting demands in Houston and Tampa