Kindly solve the below using excel solver (simplex linear programming) showing all the formulas and calculation

40 tons $2.000/ton $1 $400/ton produced M1 30 tons max. 70 tons max. $1,700/ton 30 tons max P 100 tons needed $1,600/ton 50 tons max. $800/ton 70 tons max. 60 tons M2 $1.100/ton produced 50 tons max. Management now wants to determine the most economic plan for shipping the iron ore from the mines through the distribution network to the steel plant. (a) Formulate a linear programming model for this