Question: Can you please help me with this statistics question:? Stuck need help! Thank you. Mason Leisure Chairs (a onewoman operation) produces three types of handcrafted
Can you please help me with this statistics question:? Stuck need help! Thank you.

Mason Leisure Chairs (a onewoman operation) produces three types of handcrafted outdoor chairs that are popular for beach, pool, and patios: The classic Adirondack, a Sling chair, and a deluxe Hammock. The unit prot for these products is $95, $40, and 590, respectively. Each type of chair requires cutting, assembling, and nishing. Details ofthe specic requirements in each activity for each type of chair are given below. The owner is retired and is willing to work only 125 hours available each month. He does not want to spend more than 30 hours each month on cutting but can spend 50 on either of the other two activities (assembling, and nishing}. The retailer he works with is certain that all products he makes can easily be sold and for our purposes he can produce part chairs as any leftover will go forward to next month's production. 1} Identify the decision variables, objective function, and constraints in the usual Model Formulation structure and use Excel to help you solve the optimization problem. 2) How many of each type of chair should he produce each month to maximize profit? What is the optimal solution? A neighbor with nishing skills has offered to help out for six hours each week but is only willing to do finishing. She would need to be paid $25 I hour. Should she be hired? ClassicA Sling D Hamm Cutting 2 hour 1;? hour 6110 hour Assembly 2 hour 31% hour 2 hour Finishing 1 hour 1 hour 1 hour
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
