Can you please an excel spreadsheet

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 Nocument 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 labeled worksheets (one worksheet for each of the issues in the assignment). The work in the worksheets needs to be well organized and clearly labeled, with formulas used appropriately. Examples of potential formats can be found in the course materials for linear programming. The general approach for solving each of the issues should be: a. Formulate the linear programming model for the issue algebraically. Group this into three sections: 1) Definition of Decision Variables, 2) Objective Function Equation, and 3) Constraints Equations. This should go in the appendix of your report or memo. (6 marks for each issue) b. Set up and solve this problem using Excel. Include screenshots of this in the appendix to the memo or report. (6 marks for each issue) C. Provide your answers and recommendations to the Manager of the company (include your recommendations for all issues in a single report). (2 marks for each issue). See the basic structure of the report and memo on pages 5 & 6. d. General organization and formatting - 4 marks. Decision 1. Penny Chairs received financing from Funance Inc. to produce three types of outdoor chairs that are ideally suited to the beach, pool, and patios: sling chairs, Adirondack chairs, and hammocks. At its Bruderheim factory, the unit profit for these chairs is $40, $100, and $90 respectively. Additionally, each type of chair requires cutting, assembly, and finishing. Workers are available to produce these chairs have 120 hours available per month however they cannot spend more than 50 hours per month on any one activity (i.e. cutting, assembly, and finishing). Sling chairs are made up of ten wood pieces for the frame and one piece of cloth. The cutting of the wood takes 30 minutes. Assembling includes sewing the cloth and the attachment of rivets, screws, and fabric. This takes 45 minutes per chair. The finishing step involves sanding, staining, and varnishing chair parts and takes one hour per chair. Adirondack chairs take two hours for the cutting phase as well as the assembly phase whereas the finishing stage takes one hour. For a hammock, cutting takes 0.4 hours, assembly takes three hours, and finishing takes one hour. A. Penny Chairs wants to determine how much of each chair they should produce at their Bruderheim factory to maximize profit. B. Penny Chairs has utilized Al to reduce all the above times by 10% but the Al program license will cost $300 per month. Should they implement the Al program