This project must be completed in groups of at maximum of 4 students. Please list all group members’ names in the report that is submitted. If one or more of the group members do not participate, leave their names off the report and they will receive a zero for the project. All four questions must be completed, regardless of how many group members there are. Note: 24% of the mark is for working in groups. If, for some reason, a student decides to work on their own, they will forfeit the 24%. Projects should be submitted in Meskanis ( Linear Programming Group Assignment link). You will submit two files per group: 1. One Word Document with a report outlining your recommendations for the issues listed in the case. The document should also include an appendix for each of the issues showing your algebraic equations and decisions, and a readable screen clip of your Excel output, including the Solver dialogue box (see parts a & b below). This is especially important to show how you used solver. 2. One Excel Spreadsheet with clearly labelled worksheets (one worksheet for each of the issues in theassignment). Theworkintheworksheetsneedstobewellorganizedandclearlylabelled, with formulas used appropriately. Examples of potential formats can be found in chapter 16 in the text. The general approach for solving each of the issues should be: a. Formulate the linear programming model for the issue algebraically. Group this in three sections: 1) Definition of Decision Variables, 2) Objective Function Equation, 3) Constraints Equations. This should go in the appendix to your memo. (8 marks each issue) b. Set up and solve this problem using Excel. Include screenshots of this in the appendix to the memo or report. (5 marks each issue) c. Provide your answers and recommendations to the Manager of the company (include your recommendations for all issues in single report). (2 marks each issue). See basic structure of the report and memo on pages 5 & 6. d. General organization and formatting (16marks) e. Working in groups (24 marks) f. The rubric includes the correct answers for each decision. Make sure that your answers are correct before submitting the report.