For this question, we have to develop a model in Excel which lists all the constraints, decision variables, and objective variable. Following is the developed model:
Here, the decision variables are highlighted in yellow, constraints in red, and objective function in green.
Decision variables are the units of each type