De. Chiand belped XYZ company optimine its production deciuion to maxamize the firm't profit. His solver reports are provided belowi Please ase these feports to answer the following queitions Variable Cells (Sensitivity report) Allowable Allowable Cell Name SBS1 X1 Ham and cheese sandwiches (HECC) SB52 X2 Bologna sandwiches (B) SB53 X3 Chicken Salad Sandwiches (CS) Constraints (Seasitivity report) SBS11Cl(storagesize,units)Cell SB\$12 C2 (Production mix, units) SBS7 C3 (labor time, minutes) \$BS8: C4 (H\&C production, units) 5B59 C5 (B productioti, units) \$\$B510 C6 (CS production, units) Q1: How many chicken salad sandwichs should company XYZ produce? Q2. What is company XYZ maximized profit? (No \$ needed and no comma) Q3. How many constraints are the binding constraints? (Provide your answer as one of the following choice: 1, 2, 3, 4, 5, 6) Q4. How many labor minutes have been used for production to get the optimal solution? Q5. What is the upper boundary value of the range of the optimality of the Chicken salad sandwiches? (Provide your answer in two decimal places in a format of . Q6. What is the reduced cost of Bologna sandwiches? Q7. When the storage size decrease by 1 unit, how much profit is changed? (use a positive number to show an increase and a negative number to show a decrease. Provide your answer in two decimal places in the format of =. ) Q8. If all other information stays the same, when the profit rate of H\&C sandwiches (coefficient of X1 ) reduces by 0.05 , what is the optimal number of bologna sandwiches company XYZ should produce to maximize the profit? De. Chiand belped XYZ company optimine its production deciuion to maxamize the firm't profit. His solver reports are provided belowi Please ase these feports to answer the following queitions Variable Cells (Sensitivity report) Allowable Allowable Cell Name SBS1 X1 Ham and cheese sandwiches (HECC) SB52 X2 Bologna sandwiches (B) SB53 X3 Chicken Salad Sandwiches (CS) Constraints (Seasitivity report) SBS11Cl(storagesize,units)Cell SB\$12 C2 (Production mix, units) SBS7 C3 (labor time, minutes) \$BS8: C4 (H\&C production, units) 5B59 C5 (B productioti, units) \$\$B510 C6 (CS production, units) Q1: How many chicken salad sandwichs should company XYZ produce? Q2. What is company XYZ maximized profit? (No \$ needed and no comma) Q3. How many constraints are the binding constraints? (Provide your answer as one of the following choice: 1, 2, 3, 4, 5, 6) Q4. How many labor minutes have been used for production to get the optimal solution? Q5. What is the upper boundary value of the range of the optimality of the Chicken salad sandwiches? (Provide your answer in two decimal places in a format of . Q6. What is the reduced cost of Bologna sandwiches? Q7. When the storage size decrease by 1 unit, how much profit is changed? (use a positive number to show an increase and a negative number to show a decrease. Provide your answer in two decimal places in the format of =. ) Q8. If all other information stays the same, when the profit rate of H\&C sandwiches (coefficient of X1 ) reduces by 0.05 , what is the optimal number of bologna sandwiches company XYZ should produce to maximize the profit
