The problem may requires the solver function in Excel. Thank you for your help.

Submit a word document with your responses as well as the spreadsheet model that you worked with. Remember I will also be grading how well your spreadsheet adheres to the design principles we covered in class. Remember you should write your responses individually. If you brainstormed or worked together with someone else, please mention their names in the document you hand in, but you should still hand in your own individual les. 1.- Write the algebraic representation of an infeasible linear programming problem with two variables. How do you know it is infeasible? You can add a drawing of the "feasible set\" if it is helpful [2pts] 2.- Solve problem 2.2 of Becker's Optimization book [image attached below) 0 What mix of pizzas should be made? [Assume that fractions can be sold) What is the maximum sales revenue? Which ingredients are economically scarce? [which ones limit profits?) (Zpt) Submit your Excel le [2pts) Give an example of an assumption made in the model you used. Is it realistic? (1pt) 2.2 Allocating Ingredients: The Pizza Man is a local shop that plans to make all of its sales this Saturday from its sidewalk tables during the town's holiday parade. On this occasion, the shop's owners know that customers will buy by the slice and any kind of pizza offered will sell. The Pizza Man offers plain, meat, vegetable, and supreme pizzas. Each variety has its own requirement for sauce, cheese, dough, and toppings (in ounces, as shown in the table), and each has its own selling price. Plain Meat Vegetable Supreme Available Dough 200 Sauce A WU 90 Cheese WOW WU OOAWU ow ww u 120 Meat 75 N Vegetables 40 Price $8 $10 $12 $15 The Pizza Man expects to use its entire stock of ingredients and wishes to maximize revenue from its sales