Par's production is constrained by a limited number of hours available in each department. The director of manufacturing estimates that 630 hours for cutting and dyeing, 300 hours for sewing, 708 hours for finishing, and 270 hours for inspection and packaging will be available for the production of golf bags during the next 3 months. The accounting department arrived at prices for both bags that will result in a profit contribution of $20 for every standard bag and $39 for every deluxe bag produced. After you have run the solver again with the new numbers answer these question from your Answer and Sensitivity report. Questions to be answer. (Write down the answers on the Excel sheet) 1) Will your finding hold if the profit per deluxe bag decreases $8? 2) Will your finding hold if the profit per standard bag increases $8? 3) Is cutting and dyeing a binding constraint? 4) How much you can increase the profit if you can increase Sewing time an hour? (Hint: Shadow Price) 5) If you can increase the available finalizing hours to 800 hours, do you need to change your production plan? Par's production is constrained by a limited number of hours available in each department. The director of manufacturing estimates that 630 hours for cutting and dyeing, 300 hours for sewing, 708 hours for finishing, and 270 hours for inspection and packaging will be available for the production of golf bags during the next 3 months. The accounting department arrived at prices for both bags that will result in a profit contribution of $20 for every standard bag and $39 for every deluxe bag produced. After you have run the solver again with the new numbers answer these question from your Answer and Sensitivity report. Questions to be answer. (Write down the answers on the Excel sheet) 1) Will your finding hold if the profit per deluxe bag decreases $8? 2) Will your finding hold if the profit per standard bag increases $8? 3) Is cutting and dyeing a binding constraint? 4) How much you can increase the profit if you can increase Sewing time an hour? (Hint: Shadow Price) 5) If you can increase the available finalizing hours to 800 hours, do you need to change your production plan