b$.$ Create range names based on the values in the range $C15$:$C16.$

c$.$ Apply the Total$\_$Profit and Total$\_$Building$\_$Expense range names to the worksheet.

d$.$ Load the Solver add$-$in if it is not available.

e$.$ Set the objective cell to Max Net Profit $($cell C$17).$

f$.$ Assign Total Contracts $($range C$8$:E$8)$ as the Changing Variables Cells.

g$.$ Set a constraint to ensure contracts are whole numbers.

h$.$ Set a constraint to ensure the raw materials used in the range E$11$:E$13$ do not exceed the inventory in the range D$11$:$113.$

i$.$ Set a constraint to ensure that the Total Contracts in the range $C8$:$E8$ are greater or equal to the existing contracts in the range $C7$:$E7.$

j$.$ Create an Answer Report to outline your findings.

k$.$ Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side.

I. Save and close the file. Based on your instructor's directions, submite $06m2$ DeckBuilders$\_$LastFirst.