Final answer:
Excel Solver can be used to minimize P1+P2+P3+P4+P5+P6 with the given constraints. Input the objective and constraints into Excel, use Solver to set the objective to 'Min', set variable cells, and solve for the minimal value.
Step-by-step explanation:
The objective of minimizing P1+P2+P3+P4+P5+P6 given the stated constraints can be approached using Excel Solver, which is a tool within Microsoft Excel that allows for optimization of various scenarios through linear and nonlinear models.
The constraints provided describe relationships between pairs of variables that should be input into Solver as limitations on the solution.
Excel Solver would use these constraints to find the set of values for P1 through P6 that result in the minimum possible sum.
To use Solver, input the objective function and constraints into Excel, then open Solver through the Data tab.
Set the objective as the cell containing the sum of P1 through P6, choose 'Min' for the objective, and enter the constraints as described.
After setting the variable cells as those containing P1 through P6, click 'Solve' to find the optimal solution.