Question: based on this problem what will my updated excel solution look like. if possible please show me what my answer will look like on excel

Problem 4:10 points Milford Lumber Company ships construction materials from three wood-processing plants to three retail stores. The shipping cost, monthly production capacities, and monthly demand for framing lumber are given below and in the supplement Excel file. Formulate a linear optimization model for this problem, implement your model on a spreadsheet, and use Excel Solver to find a solution that minimizes total distribution costs. See Supplement E for a discussion of modeling and solving transportation problems. Clarify your constraints. like slide 30
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
