A retailer has to decide how many bottles of still and sparkling water have to be available to maximize profit. The parameters are: x1 = demand for still water; x2 = demand for sparkling water;

profit for still water A = 50 - 0.1x1; profit for sparkling water B = 50 - 0.15x2; labor is the same for both; maximum labor = 400 hours. Based on Exhibit 10.4 and using Excel Solver, determine the maximum profit the retailer can generate for both water types. Profit values are in pence.

 LO.1