Reference no: EM132230102

Bangs Leisure Chairs produces three types of hand-crafted outdoor chairs that are popular for beach, pool, and patios: sling chairs, Adirondack chairs, and hammocks. The unit profit for these products is $35, $75, and $100, respectively. Each type of chair re-quires cutting, assembling, and finishing. The owner is retired and is willing to work 6 hours/day for 5 days/week, so has 120 hours available each month. He does not want to spend more than 50 hours each month on any one activity (i.e., cutting, assembling, and finishing). The retailer he works with is certain that all products he makes can easily be sold. Sling chairs are made up of 10 wood pieces for the frame, and one piece of cloth. The actual cutting of the wood takes 30 minutes. Assembling includes sewing of the fabric, and the attachment of rivets, screws, fabric, and dowel rod and takes 45 minutes. The finishing stage involves sanding, staining, and varnishing of the various parts and takes 1 hour. Adirondack chairs take 2 hours for both the cutting and assembling phases, and finishing takes 1 hour. For hammocks, cutting takes 0.4 hours; assembly takes 3 hours; and finishing also takes 1 hour. How many of each type of chair should he produce each month to maximize profit? a. Develop and implement a linear optimization model and clearly explain the sensitivity report. b. Suppose that Mr. Bangs wants to limit the number of sling chairs to at most 25. How will the solution from part (a) change? c. Suppose that Mr. Bangs does not want to spend more than 40 hours each month on any one activity. How will the solution from part (a) change? HOW TO SOLVE THIS IN EXCEL USING SOLVER STEP BY STEP?