need help figuring out how to solve for the blanks using Excel

Determining Menu Prices CMAPTER4 APPLICATION EXERCISE You are the general manager of Burrito Biggies, a popalar quick service restaurant, and have been given this 1. Calculate the missing information and complete the 2. What is the composite (potential) food cost percentage for Burrito Biggie's menu? menu product mix spreadsheet that follows Food Cost Percentage MENU PRODUCT MIX SPREADSHEET Total Sales S 792.10 1.255.50 Selling Total Cost Number item 50.89 $325.50 232.00 208.00 26 $042 0.29 775 0.79 1.49 0.89 800 774.80 694.20 27 Chili con quesa/chips 780 0.26 18 264.00 Beverages Total 1,650 3. You have just found out that the cost of cheddar and Refigure the menu product mix information using Monterey Jack cheese will be going up substantially due to a major strike by your dary distributor's delivery personnel. You have refigured the recipe cost cards for the items using these ingredients and the revised costs and determine what you will do to offset these increases. Note: You are not limited to changing the selling price of those items that have an ingredient cost increase. have come up with new costs tacos at 50,35, buritos You can change the selling price of anything on the at $0.46, and chili con queso at $0.46. Butch Biggs the owner of Burrito Biggies, will not stand for any increase in the standard food cost percentage, nor will he let you change the recipes or portion sizes IEHH Fill in the following worksheet to reflect changes in the oduct mix: You are therefore limited to price increases. WORKSHEET TO REFLECT CHANGES IN THE PRODUCT MIX: MENU PRODUCT MIX SPREADSHEET Number Sold 890 775 Selling Price Food Cost Percentage Item Cost 50.35 0.46 0.29 046 0.26 Taco Total Cost Total Sales Tamale Chill con queso/chips Salsa/chips Beverages Total $232.00 520 780 1,650 202.80 264.00