Please complete the steps in Excel using Solver.

Bright Photos Inc. produces color printers for both the professional and consumer markets. The company$$s consumer division recently introduced two new color printers. The KX$-210$ model can produce $4"$ x $6$ borderless color prints, and the more sophisticated and faster KX$-250$ model can even produce $13$ x $19$ borderless color prints. Financial projections show profit contributions of $$42$ for each KX$-210$ printer and $$87$ for each KX$-250$ printer. This highly automated plant uses two manufacturing lines to produce the printers. Line $1$ performs the assembly operation with times of $3$ minutes per KX$-210$ printer and $6$ minutes per KX$-250$ printer. Line $2$ performs testing and packaging operations with $4$ minutes per KX$-210$ printer and $2$ minutes per KX$-250$ printer. Both manufacturing lines are in operation one $8-$hour shift per day.

a$.$ Formulate the algebraic linear programming model for this problem

b$.$ Using Excel Solver, determine the optimal solution for the problem

c$.$ What is the value of the total profit at the optimal solution?

d$.$ Which constraints are binding? What is your interpretation of these constraints,

given the context of the problem?

e$.$ If management must produce both models to remain competitive in the market,

should the optimal solution that you obtained be implemented? Why or why not?

Please complete the steps in Excel using Solver.