Please answer this question by showing the modeling steps first and then setting up and solving it in excel

Please answer this question by showing the modeling steps first and then setting up and solving it in excel

[Note: This problem does not take into the costs associated with transporting components from the central location to the three plants.] At each plant, when they mix these components to make the final product, the following set of product specifications must be met: 1. At most 30% of component 1 2. At most 50% of component 2 Silverline must meet regular gasoline demand at three suburban locations: Northwood, Westwood and Eastwood. Orders for regular gasoline distribution are: Northwood: 15,000 gallons Westwood: 20,000 gallons Eastwood: 15,000 gallons Transportation Costs: Delivery cost per gallon from each plant to each suburban location: Each destination has a different selling price. Following is the selling price per gallon by demand location: Assuming the company will sell what it produces, the objective is to maximize profits by blending the available components at each plant and transporting them to their final destinations