Please fill in the table and show solver screenshots

H M M N P D o 1 Question 2 A fast food chain plans to expand by opening several new restaurants. The chain operates three types of restaurants, drive-through, truck-stop, and full-service. 3 A drive-through restaurant costs $100,000 to construct and funish, requires 5 employees, and has an expected annual revenue of $200,000 4 A truck-stop restaurant costs $20,000 to funish (no construction costs), requires 3 employees, and has an expected annual revenue of $120,000. 5 A full-service restaurant costs $150,000 to construct and funish, requires 18 employees, and has an expected annual revenue of $600,000. 6 The chain has $2,200,000 in capital available for expansion. 7 Labor contracts require that they hire no more than 210 employees, and licensing restrictions require that they open no more than 20 new restaurants. 8 Use integer constraints on the number of restaurants built. What is the maximum expected revenue? You will also complete a sensitivity analysis and make suggestions to the company. 9 10 11 a) List the constaints in the table to the left. You may also list them 12 Constraints Usage Constraint Available Left over below if that's helpful for you. 13 14 15 16 17 18 19 20 21 22 23 b) First run Solver without integer contraints to obtain a sensitivity analysis. (Until you have completed Step c) the Instruction sheet won't show any points for the problem.) 24 c) Next use integer constraints with Excel's Solver to find the maximum revenue. 25 26 d) Looking at the surplus above and the sensitivity analysis, interpret the sensitivity analysis and make some suggestions for the company. Again, you can type your answer below or in a 27 separate file. (The separate file must be a Word document or a PDF file.) 28 29 30 31 32 33 34 H M M N P D o 1 Question 2 A fast food chain plans to expand by opening several new restaurants. The chain operates three types of restaurants, drive-through, truck-stop, and full-service. 3 A drive-through restaurant costs $100,000 to construct and funish, requires 5 employees, and has an expected annual revenue of $200,000 4 A truck-stop restaurant costs $20,000 to funish (no construction costs), requires 3 employees, and has an expected annual revenue of $120,000. 5 A full-service restaurant costs $150,000 to construct and funish, requires 18 employees, and has an expected annual revenue of $600,000. 6 The chain has $2,200,000 in capital available for expansion. 7 Labor contracts require that they hire no more than 210 employees, and licensing restrictions require that they open no more than 20 new restaurants. 8 Use integer constraints on the number of restaurants built. What is the maximum expected revenue? You will also complete a sensitivity analysis and make suggestions to the company. 9 10 11 a) List the constaints in the table to the left. You may also list them 12 Constraints Usage Constraint Available Left over below if that's helpful for you. 13 14 15 16 17 18 19 20 21 22 23 b) First run Solver without integer contraints to obtain a sensitivity analysis. (Until you have completed Step c) the Instruction sheet won't show any points for the problem.) 24 c) Next use integer constraints with Excel's Solver to find the maximum revenue. 25 26 d) Looking at the surplus above and the sensitivity analysis, interpret the sensitivity analysis and make some suggestions for the company. Again, you can type your answer below or in a 27 separate file. (The separate file must be a Word document or a PDF file.) 28 29 30 31 32 33 34