There are two [2) questions in this seeon Formulate and solve the following linear programming problem: The Meetmg Point restaurant is busiest on a weekend and being located in a busy intersection, the executive chef: Salli;r Doe and sons chef Alexa Zoni, have agreed that the}r should use the materials in stock= to create Melting Point's four (-l} Saturday night specials. The items are Cheese Burger= Chili Bowl= Gyro and Veggie Burger. Chefs Doe and Zoni having looked at their records, have projected the estimated demand and selling price as shown in Table 1.1 (below). Table 1.1 Meeting Point estimated demand and selling E Special Mg; Chili Bowl Gyro Veggie Burger Demand T5 3U 11:") 51] Selling Price $35.13!) $. $451)!) $413.13!) The food in inventory and the amounts required for each item is shown in Table 1.2 (below). Table 1.2 - Meeting Point food supplies for Saturday Night Specials Food/Special Cheese Burger Chili Bowl Gyro Veggie Burger Inventory (kg/tsp/units) Veggie Patty (kg) 13 18 11 11 4500 Cheese (kg) 5 9 14 0 2500 Beans (kg) 14 9 O 2050 Lettuce (kg) O O 1500 OUVO Tomato (kg) LO 13 3000 Cajun seasoning (tsp)- O O 80 Buns (units) O O 270 Pita Bread (units) O 200 Zucchini, carrot rot and broccoli 2 top - teaspoon1. \"'hat is the best IlliI of the Saturday night specials to maximize Meeting Point's revenue? a. Indicate the Objective Function. (4 marks} b. Identify and state the constraints in this problem. [15 marks} c. Use Microsoft Excel Solver to determine the optimal allocation of your ingredients. (13 marks} :1. Report the maximum value of the Objective Function. (1 mark] 2. If a supplier offered to provide a rush order of pita bread at 31.00 a loaf= is it worth the money? (Hint: Use the Sensitivity Report} (I5 marks} QM II Quantitative Methods Formula Sheet h a +4m +b - a ET = = 6 6 Z =- D - IE C. +, TC = DC + D 2DS S+ -H Qopt = 1 H 2 R = dL R = dL+ :, SS = =6, OR SS = =OF+I q = d(T+ L)+ =07+1-I 2DS Q = . Vic\f\f