Formulate and solve a linear programming model for this problem on a spreadsheet. Include the following:a. Algebraic model (write in a textbox placed at the bottom of the spreadsheet model)b. Spreadsheet modelAll spreadsheet models should be in one (1) excel file

Problem # 2: Transportation Problem A company has two plants producing a certain product that is to be shipped to three distribution centers. The unit production costs are the same at the two plants, and the shipping cost per unit is shown below. Distribution Center Shipments are made once per week. During each week, each plant produces at most 60 units and each distribution center needs at least 40 units. How many units should be shipped from each plant to each distribution center, so as to minimize cost