Please show formulas an solver inputs, thanks

B D E F 1 Dexter Office Supplies has 3 manufacturing facilities located in Denver, Atlanta and Chicago 2 and ships to 4 retail outlets located in Boston, Dallas, LA and St. Paul. 3. The company wants to maximize profit of shipping one of its higher-volume products, boxes of standard copy paper. 5 The profit per unit (box of paper shipped) for each of the delivery routes along with 6 limits on supply and demand for the coming month are provided in the table below. 7 8 profit per unit DESTINATIONS (SHIPPED TO) Limit on number of boxes Manufacturing that can be 10 Facility BOSTON DALLAS ST. PAUL supplied 11 DENVER $7 $11 $13 1000 12 ATLANTA $20 $17 $12 $10 900 13 CHICAGO $8 $18 $13 $16 1500 14 DEMAND 550 720 650 800 15 9 LA $8 16 17 1 Develop an Excel model of this transportation problem and generate Solver solution reports Dexter Ready U 19 H > 5 MI $ - % lipboard 488 22 Font Alignment Conditional Format as Cell Formatting Table Styles Styles 5 Number 11 x fc B D E F G H Manufacturing Facility DENVER ATLANTA profit per unit DESTINATIONS (SHIPPED TO) Limit on number of boxes that can be BOSTON DALLAS LA ST. PAUL supplied $7 $11 $8 $13 1000 $20 $12 $10 900 $8 $18 $13 $16 1500 550 720 650 800 CHICAGO $17 DEMAND 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 Dexter ady Type here to search C