Linear programming models

Based on the brief provided, please build out two linear programming models and prepare a report to present the findings. There are questions that need to be answered for each model. Make sure that you address each question fully. If you choose to report the answers in text boxes in Excel, make sure it's very clear what you are answering. If you choose to write up the report in Word, please also submit your Excel spreadsheets with the solved models.