Math Problem Solver

Forecasting Sales Abstract

By first completing the attached worksheet, you will answer the following question

Forecasted

Menu Item

Forecasted

Number of Sales

Food Cost Sales Price Food Cost Percent Total Cost Total Sales

Actual

Number of Sales

Food Cost Sales Price Food Cost Percent Total Cost

Total Sales

Navarin 18 $7.95 $25.25 $143.10 20 $7.95 $25.25 31.49% $159.00 $505.00Ratatouille 24 $2.98 $11.25 $71.52 25 $2.98 $11.25 26.49% $281.25Classic Pot au Feu 17 $9.35 $29.95 $158.95 22 $9.35 $29.95 31.22% $658.90Oysters Rockefeller 35 $5.58 $17.45 $195.30 29 $5.58 $17.45 31.98% $506.05French Onion Soup 19 $2.35 $10.25 $44.65 18 $2.35 $10.25 22.93% $184.50Cassoulet 19 $7.85 $23.55 $149.15 21 $7.85 $23.55 33.33% $494.55Boeuf Bourguignon 34 $7.75 $23.55 $263.50 30 $7.75 $23.55 32.91% $706.50Totals Average Food Cost % $1,026.17 Average Food Cost % $3,336.75Total Covers 166 165 Based on forecasted portion sales of Navarin 18 what is its food cost percent ?Question 11 options:31.09%31.49%30.57%33.25%Question 12 (Mandatory) (5 points) SavedForecasting Sales AbstractBy first completing the attached worksheet, you will answer the following question Actual Sales: What was the average food cost percentageQuestion 12 options:32.22%31.19%31.52%30.91%Question 13 (Mandatory) (5 points) SavedForecasting Sales AbstractBy first completing the attached worksheet, you will answer the following question What was the forecasted food cost percent for CassouletQuestion 13 options:31.45%33.33%33.99%32.85%Question 14 (Mandatory) (5 points) SavedForecasting Sales AbstractBy first completing the attached worksheet, you will answer the following question What were the actual total sales?Question 14 options:$3,686.75

$3,336.75$3,256.75

$3,396.75Question 15 (Mandatory) (5 points) SavedForecasting Sales AbstractBy first completing the attached worksheet, you will answer the following question What was the actual total costs?Question 15 options:$1,063.40

$1,040.67$1,0536.49

$1,102.34Question 16 (Mandatory) (5 points) SavedForecasting Sales AbstractBy first completing the attached worksheet, you will answer the following question What was the forecasted total sales?Question 16 options:$3,314.39

$3,287.30$3,105.24

$3,294.33Question 17 (Mandatory) (5 points) SavedForecasting Sales AbstractBy first completing the attached worksheet, you will answer the following question Classic Pot au Feu , Based on portions soldwhat was the actual total costQuestion 17 options:$205.70

$201.35$207.50