Excel Formulation: The main formulas used are highlighted through comments. You can easily extend the remaining formulas. Solver Formation: Final Results after clicking SOLVE: