please answer this on excel we have to use excel or we get a 0.

Revisit the class work and practice the problem we solved in class. Build an Excel spreadsheet model for the following problem and solve for maximum profit: A pipe manufacturer can make four different types of pipes X1,X2,X3, and X4. Following Table summarizes key resources used for manufacturing: Profit margin for the X1,X2,X3, and X4 pipes are $11,$12.6,$13.7, and $16.8 per unit of production. A) Determine the product mix (how much of each pipe) should the firm make to maximize its profit. Assume all quantity manufactured can be sold. B) Assume that the marketing department wants at least 100 units of each pipe to be made. What will be the profit in this case? First solve for part A. Copy your spreadsheet into a new worksheet, add the new constraint in this sheet and solve