Items
PriceQuantityUnit PriceUnits
Flour
10 pounds for $3.39 $ 3.39 10 $ 0.34 $ per lb
15 pounds for $4.31 $ 4.31 15 $ 0.29 $ per lb
25 pounds for $7.49 $ 7.49 25 $ 0.30 $ per lb
Bite-sized candy bars
20 oz for $8.49 $ 8.49 20 $ 0.42 $ per oz
26 oz for $10.58 $ 10.58 26 $ 0.41 $ per oz
4 lb for $19.50 $ 19.50 64 $ 0.30 $ per oz
Potato Sticks
7 oz for $1.99 $ 1.99 7 $ 0.28 $ per oz
4 oz for $1.25 $ 1.25 4 $ 0.31 $ per oz
1.5 oz for $0.50 $ 0.50 1.5 $ 0.33 $ per oz
Cookies
8 oz for $3.29 $ 3.29 8 $ 0.41 $ per oz
13.5 oz for $5.49 $ 5.49 13.5 $ 0.41 $ per oz
22 oz for $9.99 $ 9.99 22 $ 0.45 $ per oz
Coffee
11.5 oz for $2.75 $ 2.75 11.5 $ 0.24 $ per oz
34.5 oz for $7.49 $ 7.49 34.5 $ 0.22 $ per oz
5 lb for $19.95 $ 19.95 80 $ 0.25 $ per oz
Milk
16 oz for $1.29 $ 1.29 16 $ 0.08 $ per oz
32 oz for $2.09 $ 2.09 32 $ 0.07 $ per oz
1 gallon for $3.89 $ 3.89 128 $ 0.03 $ per oz
2.5 gal for $7.50 $ 7.50 320 $ 0.02 $ per ozFor each item, record the price in column B and record the quantity of the item in column C. You will want to record all of the quantities for each item you are comparing using the same units (lbs, oz, gal ). It may be necessary to convert the units on some quantities before recording them in column C. Then write a formula to calculate the unit price in column D. With a little creativity, you should not have to type the formula every time. Finally write the units for each unit price in column E (Hint: in cell E5 the units should be $ per lb.)
Finally, highlight the cells that contain the item that would be "best deal" based on the unit price.
Use the $ under the "Number" dropdown to format the dollar amounts.
PriceQuantityUnit PriceUnits
Flour
10 pounds for $3.39 $ 3.39 10 $ 0.34 $ per lb
15 pounds for $4.31 $ 4.31 15 $ 0.29 $ per lb
25 pounds for $7.49 $ 7.49 25 $ 0.30 $ per lb
Bite-sized candy bars
20 oz for $8.49 $ 8.49 20 $ 0.42 $ per oz
26 oz for $10.58 $ 10.58 26 $ 0.41 $ per oz
4 lb for $19.50 $ 19.50 64 $ 0.30 $ per oz
Potato Sticks
7 oz for $1.99 $ 1.99 7 $ 0.28 $ per oz
4 oz for $1.25 $ 1.25 4 $ 0.31 $ per oz
1.5 oz for $0.50 $ 0.50 1.5 $ 0.33 $ per oz
Cookies
8 oz for $3.29 $ 3.29 8 $ 0.41 $ per oz
13.5 oz for $5.49 $ 5.49 13.5 $ 0.41 $ per oz
22 oz for $9.99 $ 9.99 22 $ 0.45 $ per oz
Coffee
11.5 oz for $2.75 $ 2.75 11.5 $ 0.24 $ per oz
34.5 oz for $7.49 $ 7.49 34.5 $ 0.22 $ per oz
5 lb for $19.95 $ 19.95 80 $ 0.25 $ per oz
Milk
16 oz for $1.29 $ 1.29 16 $ 0.08 $ per oz
32 oz for $2.09 $ 2.09 32 $ 0.07 $ per oz
1 gallon for $3.89 $ 3.89 128 $ 0.03 $ per oz
2.5 gal for $7.50 $ 7.50 320 $ 0.02 $ per ozFor each item, record the price in column B and record the quantity of the item in column C. You will want to record all of the quantities for each item you are comparing using the same units (lbs, oz, gal ). It may be necessary to convert the units on some quantities before recording them in column C. Then write a formula to calculate the unit price in column D. With a little creativity, you should not have to type the formula every time. Finally write the units for each unit price in column E (Hint: in cell E5 the units should be $ per lb.)
Finally, highlight the cells that contain the item that would be "best deal" based on the unit price.
Use the $ under the "Number" dropdown to format the dollar amounts.
