Please upload excel file, not the screenshot the answer must show the formulas u
ID: 3196077 • Letter: P
Question
Please upload excel file, not the screenshot the answer must show the formulas used in excel to calculate.
On MasterChef Junior (an amazing TV show!), Gordon Ramsay wants to determine the best way to allocate food ingredients to four specials: cheeseburger, hamburger, taco, and stew. The ingredients were donated, thus there is no cost associated with them. The table below lists the food inventory and the ingredients required for each special Cheeseburger Hamburger Tostada Ingredient Ground beef Stew 0.4 Available 100 0.25 0.3 0.1 0.1 0.25 0.2 0.3 Cheese (lbs Beans (lbs Lettuce (lbs Tomato (Ibs Buns Tostada shells 0.3 0.2 0..2 0.2 50 50 15 50 80 80 0.1 0.3 0..2 The expected demand and selling price for each special (as estimated by Gordon Ramsay) are shown in the table below Cheeseburger 75 $2.25 Tostada 100 $1.75 Hamburger Stew 60 $2.00 Demand Selling Price $2.50 The money made from the specials will be donated to a local charity. Given the information in the tables above, please answer the following questions (a) What is the optimal mix of specials to maximize the amount of the donation? (b) If a friend offers to sell Gordon additional hamburger buns at a cost of $1.00 per bun, should he order more buns? If so, how many should he order?Explanation / Answer
Selling price Demand Total Price Stew 2.5 55 137.5 Tostada 1.75 100 175 Cheeseburger 2.25 75 168.5 Hamburger 2 60 120