Please provide detailed steps on how to complete using Solver in Excel. Thanks.

Problem 3: Using Solver to solve production problems A company manufactures two types of trucks. Each truck must go through the painting shop and the assembly shop. If the painting shop were completely devoted to painting type 1 trucks, 800 per day could be painted, whereas if the painting shop were completely devoted to painting type 2 trucks, 700 per day could be painted. If the assembly shop were completely devoted to assembling truck 1 engines, 1500 per day could be assembled, whereas if the assembly shop were completely devoted to assembling truck 2engines, 1200 per day could be assembled. It is possible, however, to paint both types of trucks in the painting shop. Similarly, it is possible to assemble both types in the assembly shop. Each type 1 truck contributes $1000 to profit; each type 2 truck contributes $1500. a) Use Solver to maximize the company's profit. (Hint: One approach, but not the only approach, is to try a graphical procedure first and then deduce the constraints from the graph.) b) Generate a sensitivity report and explain the report in relation to objective coefficients and constraints coefficients