Please explain, step by step, how to resolve the problem with linear programming including the variables, the min. or max formula as well as any and all constraints so that I can, thereafter, input said information into Scientific Management Software. In providing your response, please do not use Lindo. Word and/or Excel are fine.
Word file contains conceptual understanding of the problem and excel file contains computations, final answer and formulas.