Using Excel, please find resource availablity, decision variable, objective function, resources constraints, and non negativity constraints. Describe the answer and its sensitivity analysis. Show Findings.

Show work using EXCEL through steps.

fx 45 records are produced by Jackson Enterprises at three different locations, 1, 2, and 3, and shipped to three sales centers named A, B and C. Company creative director Michael is H D E G 45 records are produced by Jackson Enterprises at three different locations, 1, 2, and 3, and shipped to three sales centers named A, B and C. Company creative director Michael is unconcerned with efficiency, but operations manager Tito wishes to move the product as inexpensively as possible. The cost to transport one crate from each source to each destination is indicated in the table. as well as the demand at each sales center and the supply at each manufacturing facility. 1 A $5 $6 B $6 $9 $7 S8 Total Supply 320 420 3 $7 $4 520 S6 460 Total 400 400 p B D G H 1 J L M 2 N o P Q R Resource Availability Decision Variables: Objective Function: Resource Constraints: Non-Negativity Constraints: Problem LP Formulation Solver Finding Group + X fx B D E F G . 1 J L M N Answer Report Sensitivity Analysis