Stickley Furniture is a manufacturer of fine hand-crafted furniture. During the next production period, management is considering producing dining room tables, dining room chairs, and/or bookcases. The time required for each item to go through the two stages of production (assembly and finishing), the amount of wood required (fine cherry wood), and the corresponding unit profits are given in the following table, along with the amount of each resource available in the upcoming production period. Tables Chairs Bookcases Available Assembly (minutes) Finishing (minutes) Wood (pounds) Unit Profit $360 $125 80 40 50 8100 30 20 30 4500 80 10 50 9000 $300 Formulate a linear programming model to detemine the production levels that would maximize profit the solved model and the corresponding sensitivity report. a. Suppose the profit per table increases by $100. Will this change the optimal production quantities? What can be said about the change in total profit? b. Suppose the profit per chair increases by $100. Will this change the optimal production quantities? What can be said about the change in total profit? c. Suppose the profit per table increases by $90 and the profit per bookcase decreases by $50. Will this change the optimal production quantities? What can be said about the change in total profit? d. Suppose a worker in the assembly department calls in sick, so eight fewer hours now are available in the assembly department. How much would this affect total profit? Would it change the optimal production quantities? e. Explain why the shadow price for the wood constraint is zero. f. Anew worker has been hired who is trained to do both assembly and finishing. She will split her time between the two areas, so there now are four additional hours available in both assembly and finishing. How much would this affect total profit? Would this change the optimal production quantities? g. Based on the sensitivity report, is it wise to have the new worker in part f split her time equally between assembly and finishing, or would some other plan be better? Stickley Furniture is a manufacturer of fine hand-crafted furniture. During the next production period, management is considering producing dining room tables, dining room chairs, and/or bookcases. The time required for each item to go through the two stages of production (assembly and finishing), the amount of wood required (fine cherry wood), and the corresponding unit profits are given in the following table, along with the amount of each resource available in the upcoming production period. Tables Chairs Bookcases Available Assembly (minutes) Finishing (minutes) Wood (pounds) Unit Profit $360 $125 80 40 50 8100 30 20 30 4500 80 10 50 9000 $300 Formulate a linear programming model to detemine the production levels that would maximize profit the solved model and the corresponding sensitivity report. a. Suppose the profit per table increases by $100. Will this change the optimal production quantities? What can be said about the change in total profit? b. Suppose the profit per chair increases by $100. Will this change the optimal production quantities? What can be said about the change in total profit? c. Suppose the profit per table increases by $90 and the profit per bookcase decreases by $50. Will this change the optimal production quantities? What can be said about the change in total profit? d. Suppose a worker in the assembly department calls in sick, so eight fewer hours now are available in the assembly department. How much would this affect total profit? Would it change the optimal production quantities? e. Explain why the shadow price for the wood constraint is zero. f. Anew worker has been hired who is trained to do both assembly and finishing. She will split her time between the two areas, so there now are four additional hours available in both assembly and finishing. How much would this affect total profit? Would this change the optimal production quantities? g. Based on the sensitivity report, is it wise to have the new worker in part f split her time equally between assembly and finishing, or would some other plan be better
