Reference no: EM133616071
Problem
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.
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
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.
I. Penny Chairs wants to determine how much of each chair they should produce at their Bruderheim factory to maximize profit.
II. Penny Chairs has utilized AI to reduce all the above times by 10% but the AI program license will cost $300 per month. Should they implement the AI program?