please provide a detail answer with whatever is needed

everything with excel formulas

2. The ABC company is very happy with your work and the optimal shipping schedule for Problem 1 above. The company also determined the manufacturing cost, distribution center cost and selling price at the customer centers. These costs are listed in the following tables From Shipping Costs in Manufacturing $ amount Cost per box Gurley Bismarck $35 $40 $90 65 30 $70 50 25 $80 $12 $15 Nashville Tracy Richmond DC Cost per box From Gurly Bismarck Selling Price/box Shipping Costs in S amount To Harrisburg To Jacksonville To Dallas 35 25 46 45 30 40 $200 $220 $180 To Portland 60 45 $240 a Prepare a profit matrix, i.e., profit of each shipping path (30) b. The company wants you to find a shipping schedule to maximize total monthly profit. Define variables, write the objective function and constraints for maximizing monthly profit. (20) c Create an Excel worksheet with formulas and determine an optimal shipping schedule d Attach Initial and final worksheet and a copy of the Solver parameters. (40) e. Attach the shipping schedule either typed one or written with your hand