Optimization Models

There are 4 questions. For each question, please present the mathematical formulation and the final solution in this word document; submit it together with your complete Excel file, containing the solver setup and solution.