Consider the following information relative to a company possessing 3 production plants that supply 3 different stores. Cost to transport one unit from a particular plant to a particular store 2 Note the following information that should be included in your model: - Due to road maintenance, transporting products from Plant A to store Y is not allowed at the moment. - As part of the company's efforts to reduce transportation costs, they only make full truck shipments. This means that a truck should be fully loaded before it leaves a plant. The trucks used now have a maximum capacity of 100 units. Questions: a. Formulate the linear model for this problem which helps minimize the transportation cost. Specify the (i) decision variables, (ii) objective function,and (iii) constraints. a. Develop an Excel spreadsheet that uses the Solver function to find the optimal shipping patterns between the plants and the stores