Question: NEED to know HOW to solve for blanks using excel spreadsheet. NEED question: Why is it important to consider both food cost % and contribution

NEED to know HOW to solve for blanks using excel spreadsheet.

NEED question: "Why is it important to consider both food cost % and contribution margin of a food item?" explained and answered.

NEED to know HOW to solve for blanks using excel spreadsheet. NEED

question: "Why is it important to consider both food cost % and

Please show HOW, EXPLAIN, and ANSWER.

Calculate the food cost % and contribution margin for the following menu 2 items at Ron Swanson's House of Meat Food Cost Contribution Item Sales Price Food Cost Margin 3 4 Chicken 5 Lamb 6 Pork tenderloin 7 Baked Potato 8 Soup, bow 9 Steak 10 Side salad 11 Chocolate cake 12 13 Why is it important to consider both food cost % and contribution margin of a food 14 item? $3.00 $12.00 $12.00 $32.00 $17.00 $3.00 $5.00 $8.00 0.50 $1.10 $19.00 $7.50 $3.00 $7.00 $1.00 $1.50 16 Ron is thinking of adding a beef brisket dinner to the menu. Help him 17 calculate the plate cost 18 Ingredients Units Quantity Unit Cost Recipe Cost 19 Beef brisket 20 BBQ sauce 21 Baked potato each 22 Sour cream 23 Butter 24 Cheddar cheese oz 25 Biscuits 26 S0.47 S0.19 S0.50 $0.11 S0.25 S0.23 S0.12 Oz oz 2 oz Oz each Plate Cost

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!