Please show me how to create the model in Excel.

There have been many advancements for materials used in cars that can

make the car lighter and more fuel efficient, while not sacrificing safety. A

car manufacturer is considering design changes in its top$-$selling car to

reduce the weight of the car by at least $400$ pounds to improve its fuel

efficiency. Design Engineers have identified $10$ vchanges that could be

made in the car to make it lighter. The weight saved by each design

change and the estimated costs of implementing each change are

summarized in the following table:

Changes $4$ and $7$ represent alternate ways of modifying the engine block

and, therefore, only one of these options could be selected. The

company wants to determine which changes to make in order to reduce

the total weight of the car by at least $400$ pounds in the least costly

manner.

a$.$ Create an LP model to solve this problem.

b$.$ What is the optimal solution using Solver.

c$.$ What if the company needs to save exactly $400$ pounds. How does that change the answer?