develop a Linear programming model and a solver solution with answer and sensitivity reports:

Dexter Office Supplies has $3$ manufacturing facilities located in Denver, Atlanta and Chicago and ships to $4$ retail outlets located in Boston, Dallas, LA and St$.$ Paul.

The company wants to maximize profit of shipping one of its higher$-$volume products, boxes of standard copy paper.

The profit per unit $($box of paper shipped$)$ for each of the delivery routes along with

limits on supply and demand for the coming month are provided in the table below.

$\backslash$table$[[\backslash$table$[[$Manufacturing$],[$Facility$]],\backslash$table$[[$profit per unit$],[$DESTINATIONS $($SHIPPED TO$)]],4],[$BOSTON$,$DALLAS,LA$,$ST$.$ PAUL,$\backslash$table$[[$Limit on$],[$number of boxes$],[$that can be$],[$supplied$]]],[$DENVER$,$$$7,$$$11,$$$8,$$$13,1000],[$ATLANTA$,$$$20,$$$17,$$$12,$$$10,900],[$CHICAGO$,$$$8,$$$18,$$$13,$$$16,1500],[$DEMAND$,550,720,650,800,]]$

$1$ Develop an Excel model of this transportation problem and generate Solver solution with Answer and Sensitivity reports.

What is the maximum profit from shipments?

$2$ On a separate sheet, reformulate the problem to determine if there is an ALTERNATIVE optimal solution Name the sheet ALTER$\_$SOLUTION.