MENU COSTING ACTIVITY
1. Complete the following costing sheet using the information already included in the form.
Step-by-step explanation:
To complete the costing sheet, we need to calculate the missing values for the "Converted AP Cost," "Converted EP Cost," and "Total EP Cost" columns.
Let's calculate these values for each ingredient:
1. Chicken breast, skinless, boneless, trimmed, 6 oz each;
• Recipe (EP) = 18002 • Yield % = 95%
• APCost = P73.5/6.0Z
To find the "Converted AP Cost," we need to convert the APCost per 6 oz to the cost per 1 oz.
Converted AP Cost = APCost
To find the "Converted EP Cost," we need to calculate the cost per portion using the "Converted AP Cost" and the yield percentage.
Converted EP Cost = Convert
To find the "Total EP Cost," we need to multiply the "Converted EP Cost" by the number of portions.
Total EP Cost = Converted E!
2. Mango, fresh, diced:
• Recipe (EP) = 2 cups • Yield % = 61%
• APCost = P500.00/8 cups
Using the same calculations as above, we can find the "Converted AP Cost," "Converted EP Cost," and "Total EP Cost" for mango.
3. Red onion, diced:
• Recipe (EP) = 1/2 cup • Yield % = 77%
• APCost = P11.00/cup
Again, using the same calculations, we can find the missing values for red onion.
4. Cilantro, fresh chopped:
• Recipe (EP) = 4 Tbsp • Yield % = 100%
• APCost = P39.5/bun (1 bun = 5 Tbsp chopped)
Apply the calculations to find the missing values for cilantro.
5. Lime juice, fresh:
• Recipe (EP) = 20 oz • Yield % = 100%
• APCost = P19.5 per lime (1 lime = 1 oz juice)
Use the calculations to find the missing values for lime juice.
6. Salt:
• Recipe (EP) = 1 Tbsp
• Yield % = 100% • APCost = P610.00 for 36/3
case
Since the "Converted AP Cost" and "Converted EP Cost" for salt are not given, we need to use the "Spice Factor" (SF) and "QFactor" to calculate them. However, the values for SF and QFactor are not provided in the table, so we cannot calculate the missing values for salt.
7. Black Pepper:
• Recipe (EP) = 1/2 tsp • Yield % = 100%
• APCost = $324.00/kilo
Similar to salt, we cannot calculate the missing values for black pepper
without the SF and QFactor.
To find the "Total" and "Total with
SF Adjustment," we need to sum up the "Total EP Cost" column.
Once the missing values are calculated, the costing sheet will be
complete.