Reference no: EM132229230

Hetfield Leisure Chairs produces three types of hand-crafted outdoor chairs (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 requires cutting, assembling, and finishing. Mr. James Hetfield, 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? (Hint: time units should be standardized) (a) Develop and implement a linear optimization model and clearly explain the report you get. (b) Suppose that Mr. Hetfield wants to limit the number of sling chairs to at most 25. How will the solution from part (a) change? (c) Suppose that Mr. Hetfield 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 with solver?