PLEASE SOLVE USING EXCELS SOLVER ADD-IN AND EXPLAIN STEP BY STEP.Miford Lumber Company ships construction materials from three wood-processing plants to three retail slares. The shipping cost, maretify production capacities, and monthly demand for framing lumber are given below. \table[[Plant,Stere A,Store B,Store C,Capacity],[1,
$2.80
,
$6.10
,
$5.50
,340],[2,
$3.80
,
$2.30
,
$3.70
,620],[3,
$3.30
,
$4.20
,
$6.20
,
$20