PLEASE SHOW THE EXCEL FILE SCREENSHOT EXPLANATION FOR EQUATIONS USED (IF ANY USED IN EXCEL)

3. Sticky 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 fine cherry wood required, and the corresponding unit profits are presented below along with the current amount of resources available Tables Chairs Bookcases Available Finishing (min) 80 40 50 8100 Assembly (min) 30 20 30 4500 80 10 50 9000 Wood (pounds) Unit Profit ($) $360 $125 $300 a. What is the optimal mix of products? b. Suppose the profit per table could be increased by $100, would that change the optimal production quantities? What can be said about the change in profit? c. Suppose the profit per chair could be increased by $100, would that change the optimal production quantities? What can be said about the change in profit? d. Suppose the profit per table could be increased by $90 and the profit per bookcase decreases by $50, would that change the optimal production quantities? What can be said about the change in profit? e. Suppose a worker in the assembly department calls in sick and so 8 hours fewer are available for assembly. How would this affect the total profit? Would it change the optimal production quantities? f. What is the value of an additional pound of wood? Why? g. Suppose an additional worker is hired and she can add 4 additional hours of assembly and 4 additional hours of finishing. How much would this affect the total profit? Would this change the optimal production quantities? h. Is it wise to have the new employee split her time equally between finishing and assembly or would another assignment be better? 3. Sticky 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 fine cherry wood required, and the corresponding unit profits are presented below along with the current amount of resources available Tables Chairs Bookcases Available Finishing (min) 80 40 50 8100 Assembly (min) 30 20 30 4500 80 10 50 9000 Wood (pounds) Unit Profit ($) $360 $125 $300 a. What is the optimal mix of products? b. Suppose the profit per table could be increased by $100, would that change the optimal production quantities? What can be said about the change in profit? c. Suppose the profit per chair could be increased by $100, would that change the optimal production quantities? What can be said about the change in profit? d. Suppose the profit per table could be increased by $90 and the profit per bookcase decreases by $50, would that change the optimal production quantities? What can be said about the change in profit? e. Suppose a worker in the assembly department calls in sick and so 8 hours fewer are available for assembly. How would this affect the total profit? Would it change the optimal production quantities? f. What is the value of an additional pound of wood? Why? g. Suppose an additional worker is hired and she can add 4 additional hours of assembly and 4 additional hours of finishing. How much would this affect the total profit? Would this change the optimal production quantities? h. Is it wise to have the new employee split her time equally between finishing and assembly or would another assignment be better