please use excel solver and lp model to solve. please and thank you!

3) (7 points) A company must build then ship products from two manufacturing plants to three retail centers. Manufacturing plant X can produce up to 5000 units at a cost of $20 per unit; manufacturing plant Y can produce up to 9000 units at a cost of $25 per unit. The additional shipping costs per unit are in table below. Each retail center requires 4500 units. How should the company build then ship the products to meet demand at minimum cost? MP X ($20) MP Y (525) Requirement RC 1 $2 $5 4500 RCZ $7 $9 4500 RC 3 $4 $3 4500 Capacity 6000 9000 a) Set up the LP Model. Include it or your Excel work below. b) Solve the LP. What are your answers and total cost? Explain what each variable answer means. I c) How much are you spending on shipping costs in your optimal answer from b)? d) Assume you can run overtime production at manufacturing plant X to produce up to an extra 1500 units, but it will increase the production cost by 15% from $20 to $23. What is the new optimal solution? Did the overall cost decrease and if so, by how much