please show excel file/ formula

thank you i will thumbs up!

Q6. A campaign manager for a political candidate must arrange the shipment of 150 cartons of campaign buttons from three button producers (A, B, C) to two campaign headquarters (1 and 2). The supplies and demands, and the per-carton transportation costs, are shown below CAMPAIGN HEADQUARTERS 2 Supply 50 $5 Producers A B 1 $4 $3 $3 90 50 $4 $2 90 50 Demand The manager is considering to add another location (buttons producer) to supply for the campaign headquarters. The new locations (N1 and N2) will supply 50 units. Transportation costs for N1 location to campaign headquarters (1, 2) are $3, $1 per carton, respectively, for N2 location, the costs are $4, 82, respectively. Which location would result in the lower costs for the system? EXTRA CREDIT 6