Solver Dialogue Box

First, we multiply equation 1 by 5 and equation 2 by 4 to get:

and

Then subtract the resulting equation 2 from the resulting equation 1 to get.

Solving for x yields,

Substituting the value of x obtained in equation 1 and solving for y

The maximum Profit  

Therefore,  and  have to be produced in order to maximize the daily profit to

Graphical Representation

Part b: Solver Print Outs

Figure 3: Print Out of Solver Cell Values

Figure 4: Print Out of Solver Cell Formulae

Figure 5: Print Out of Solver Dialogue Box