Please follow the instructions. ONLY PROVIDE AN ANSWER FOR QUESTION 1 (PART A an

Please follow the instructions.
ONLY PROVIDE AN ANSWER FOR QUESTION 1 (PART A an

Please follow the instructions.
ONLY PROVIDE AN ANSWER FOR QUESTION 1 (PART A and PART B)
I have attached the instructions, case study, and data file you will use!
For Question 1, the following is needed:
One Excel file coded with formulas (no hard-coded numbers) containing the following 2 (or 3) models
a. Initial optimization model (#1 Part A)
b. Outsourcing model (#1 Part B)
c. Advertising tradeoff (optional)
PLEASE ONLY USE THE DATA FILE (EXCEL FILE) THAT I HAVE ATTACHED.
ALSO PLEASE PROVIDE AN EXPLANATION FOR EACH MODEL