1) Input the Restaurant menu problem into a generic linear programming spreadsheet and confirm (or prove it wrong) the solution given in the attached images below.

2) If the restaurant wanted to sell the same number of each type of special, how many of each could they make and stay under their budget?

NB: Please explain all steps and reasoning.

ences Manings Review 21 1 ABCcode AaRbCeDdle AaBbccde A AaBbCcD Heading 1 Normal No Spacing Heading 2 A Linear algebra helps restaurants cam a profit. Restaurants use linear programming for menu planning. It uses basic algebra to optimize meal production and thereby increase restaurant profits. Linear algebra reflects a direct relationship between an increase or decrease in food resources, and an increase or decrease in meal production. For example, if the kitchen has only half its needed supply of cream base, then it can only prepare half its normal amount of cream soups. Additionally, management can determine the cost of preparing different menu items to decide how many of each menu item to prepare for optimal profit. Weekly Meal Planner Step 1 Choose the decision variables that apply. In this example, a restaurant needs to produce 250 of its dinner specials per day, one with meat and the other vegetarian. The decision variables are the number of meals and the different menu names (1.e., porterhouse steak and spinach lasagna). Step 2 Choose the objective for the restaurant. Normally, the objective is to determine how many of each menu item to prepare that meets the required number of meals yet stays within budget, so this is the objective for the example shown. However, the objective will be the quantity of physical supplies on hand, if there is a shortage of a particular ingredient that several menu items use, such as tomato sauce. Then management can determine how to get the largest number of meals with the quantity of tomato sauce on hand. I Focus MacBook Air erences Mailings Review View Tell me A E 21 AaBbCeDdEe AaBbCcDdEe AaBbCcDdE A AaBbCcD Heading 1 Normal No Spacing Heading 2 Step 3 Choose the constraints on menu production, which is the day's monetary budget to produce a specified number of meals. For example, a restaurant has a $1,000 budget for that day's two dinner specials, and it must prepare 250 meals that cost different amounts to prepare. It cannot spend more than $1,000 and still carn a profit. Step 4 Choose the two dinner specials, such as porterhouse steak and spinach lasagna. For this example, the porterhouse steak costs $7 to prepare and the lasagna dinner costs $3. The steak is designated as "S" and the lasagna as "L." Step 5 Calculate how many steak dinners the restaurant can prepare for $1,000: S+L = 250 meals. 7S