I'm not sure how to go about finding the optimal solution for part a and b ( please see the attached file it includes my partial solution to the question)
Please refer attached files detailed response to your posting. The word ...
The word document contains explanation . The Excel file contains optimal solution using Solver tool. The Solver tool is shown for ease in understanding. Also, attached is help file on Solver tool.