Please help with this linear programming problem. I'm having difficulty knowing how to put it into an excel document with the formulas. Please send an excel sheet with formulas. Thank you.

Refer to the following link: Excel Easy (2016). Transportation Problem, Retrieved from: http://www.excel-easy.com/examples/transportation-problem.html#solve-model(Links to an external site.)

This is a classic transportation problem. The goal in this problem is to minimize transportation cost, based on required consumer demand and available factory capacity.

Recreate and solve this problem in Solver, as discussed at the web site. Be sure to obtain the final optimized results as shown at the bottom of the page. Note that the problem at the web site uses range names...use of ranges names is not required in your file.