Scribd
Upload
47 views1 page

Lemonade Cost & Conversion Table

The document provides instructions for completing a conversion table for lemonade recipes, requiring the calculation of ingredient costs per cup and total costs for regular and fancy lemonade. It includes specific data on ingredient quantities, purchase prices, and conversion factors. The assignment emphasizes formatting monetary values correctly in U.S. dollars.

Uploaded by

María Eva González
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
47 views1 page

Lemonade Cost & Conversion Table

The document provides instructions for completing a conversion table for lemonade recipes, requiring the calculation of ingredient costs per cup and total costs for regular and fancy lemonade. It includes specific data on ingredient quantities, purchase prices, and conversion factors. The assignment emphasizes formatting monetary values correctly in U.S. dollars.

Uploaded by

María Eva González
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

W07 - Conversion Table Names:

Instructions
Using the data below, fill in the yellow cells. Watch the video at W07 Prepare: Semester Project. It will help you. This
assignment asks you to convert the raw materials you purchase into individual unit quantities and costs. Make sure you do
the following:
Each ingredient must be converted from the purchase quantity to the quantity you use per cup of lemonade to how many
servings you could make per purchase.
You must calculate the cost per cup of each ingredient.
Once you have the cost per cup for each ingredient (row), add up how much it costs to make one cup of regular lemonade
and one cup of fancy lemonade.
Please display the 'Purchase Price' and 'Price per Cup' data (each cell in that column) in United States dollars. The data in the
cells should look something like this: “$0.01” not this: “0.00810141”. Do the same thing for the total cost per cup.

Helpful Links:
[Article] How to format numbers as currency
[Video] How to Save and Close a Workbook in Excel (01:33 mins) Transcript
[Video] How to Adjust Column Width in Excel (02:11 mins) Transcript

Regular Lemonade Recipe Fancy Lemonade Recipe Material Costs Unit Conversions
(Per Cup) (Per Cup) Sugar (10 lbs(pounds)) $5.88 108.87 tsp = 1 pound of sugar
1 Cup Water 1 Cup Water Lemons (1 box) $3.98 120 ice cubes = 1 bag
Lemon Lemon
0.5 (Squeezed) 0.5 Ice Cubes (1 bag) $2.50 12 lemons = 1 box of lemons
(Squeezed)
1.5 tsp Sugar 1.5 tsp Sugar Paper Cup (1 case) $10.48 6 tsp = 1 ounce
4 Ice Cubes 4 Ice Cubes Fruit (12 ounces) $4.98 768 tsp = 1 gallon syrup
2 tsp Flavor
1 Paper Cup Syrup Flavor Syrup (3 gallons) $38.68 240 fancy cups = 1 case
3 tsp Fruit Fancy Cup (1 case) $21.47 264 paper cups = 1 case
1 Fancy Cup

Regular Lemonade Recipe (1 Cup)


Item Quantity Purchase Purchase Quantity Ingredient Conversion Factor: Individual Cost Per Cup
Purchased Units Price Needed Per Units Purchase Units to Quantities
Lemonade Ingredient Units Available

Sugar
Lemons
Ice Cubes
Paper Cups
Total Cost Per Cup

Fancy Lemonade Recipe (1 Cup)


Item Quantity Purchase Purchase Quantity Ingredient Conversion Factor: Individual Cost Per Cup
Purchased Units Price Needed Per Units Purchase Units to Quantities
Lemonade Ingredient Units Available

Sugar
Lemons
Ice Cubes
Fruit
Flavor Syrup
Fancy Cups
Total Cost Per Cup

You might also like