DV#1 DV#2 Decision Variables Objective Function Coefficient Constraints: LHS Sign RHS Constraint #1 Constraint #2 Constraint #3 Constraint #4 FORMULATION ANSWERS TO QUESTIONS (do not just put numbers - answers should be complete sentences) Decision Variables: a ) Objective Function: b) Constraints: C)M7.2. Cullowhee Food Services Company delivers fresh sandwiches each morning to vending machines throughout the county. The company makes three kinds of sandwiches roast beef, turkey, and tuna salad. A roast beef sandwich requires a worker 0.49 minutes to assemble, a turkey sandwich requires 0.45 minutes, and a tuna salad requires 0.52 minutes to make. The company has 960 available minutes each night for sandwich assembly. Vending machine capacity is available for a total of 2000 sandwiches (all three types combined) each day. The profit for roast beef sandwich is $0.87, the profit for a turkey sandwich is $0.64, and the profit for a tuna salad sandwich is $0.74. The company knows from past sales records that its customers buy as many roast beef sandwiches as the other two sandwiches combined. Also bases on past sales, Cullowhee must make at least 350 roast beef, 500 turkey, and 200 tuna sandwiches. Cullowhee management wants to know how many of each sandwich it should make to maximize plofit. Formulate and solve in Excel. SOLUTION: The optimal solution, the value of the profit, should be $1,588.34. Formulation: Formulate this problem by defining decision variables, objective function, and constraints in standard format as specified/demonstrated in videos. Questions: (Be sure to answer questions using full sentences and quantitative values) 1. a) How many roast beef, turkey, and tuna sandwiches should be made based on your optimal solution? 2. b) What is the total number of assembly minutes used based on your optimal solution? Use the LP Template.xlsx provided to you in the Module 7 Resource page. Solve the problem using Excel Solver, place the formulation and answers to the questions in the appropriate text boxes. I will delete your decision variables in your Excel submission and re-solve your problem. There is no credit for the problem if your Excel submission doesn't solve. If necessary, remove problem constraints so that your Excel file solves. It is better to get partial credit than no credit. Your Excel Solver solution must result in the follow dialog box for full credit for the solution. Note the highlighted text. Solver Results X Solver found a solution, All Constraints and optimality conditions are satised. RE'EOI'IS Answer @ :Eeep'olver Solu't'lcn' Sensitivity .. .. .. . Limits 0 esmre original values I: Rgtum to Solver Parameters Dialog D Outline Reports 9K I Qancel gave Scenario