Looking for the correct way to calculate each item on a menu.

Please show all the work for each of the cells

Appetizer CPP is $.34

Soup CPP is $.29

Salad CPP is $.55

Entree CPP is $2.76

Starch CPP is $.23

Veg CPP is $.18

Dessert CPP is $.62

Need to find TCPD (sp 4%)

Factor Method/Food cost method?

Mark Up Method?

Gross Mark Up Method?

Sales to Date

Desired Food Cost per Category for Factor/FC Method Food

App, Salad: 18%

Soup: 25%

Entre: 38%

Starch, Veg: 20%

Dessert: 45%

Total Cost of Sales: 971019

30.58%

Gross Profit: 2203982

Annual Guest Count: 275274

Cost per guest: ?

Total Sales: 3175000