Rules 1 2 3 4 5 6 7 8 9 Grades

Assignment 6 Cost and Profit of Making Drinks
For this assignment, you need to calculate the cost of our four most popular drinks (a 16 oz. vanilla latte, a 16 oz. hot chocolate, a 12 oz hot chocolate, and a 16 oz. americano). After you determine the cost, you must determine the profit. Remember to use Microsoft Excel to do all your calculations! You should have a detailed spreadsheet in Microsoft Excel to email me when you are done. Label this one lastname_6.xls and email it to my gaggle account. The subject line should be "Assignment 6." Make sure that I can easily understand what your answers are and where they came from.
This is a list of the prices to help you.
Item Price Price per serving 12 oz drink 16 oz drink
Milk $4.00/gallon $0.03 $0.30 $0.48
Coffee $7.70/pound $0.24/2 oz shot $0.24 $0.24
Lid $35.00/1000 $0.035 $0.04 $0.04
Cup $75.00/1000 $.075 $0.08 $0.08
Brewed Coffee $1.04/67oz $0.02/ounce $0.24 $0.32
Soy Milk $2.75/32oz $0.09/ounce $0.90 $1.26
Syrup $4.75/bottle $0.19/ounce $0.19 $0.29
Whip Cream $3.00/32ooz $0.09/ounce $0.09 $0.09
Chocolate $48.00/30lb $0.10/ounce $0.10 $0.14
Chai $3.60/32oz $.11/oz $1.10 $1.54
Club Soda 1.25/64 oz $0.01/ounce N/A $.14
Half and Half $2.00/32oz $0.06/ounce $0.60 $0.84

For example, for a 16 oz. steamer, it would look something like this:
Item Cost
milk $0.48
syrup $0.29
lid $0.04
cup $0.08
Price $2.00 (taken from the price list)
Cost $0.89 (all the costs added up)
Profit $1.11 (the price minus the cost)