MAT 144 Topic 1 DQ 2
Technology Assignment 5-1
Complete Technology Assignment 1 in Lesson 5-1 in the textbook. Use the template that is provided in the online resources this lesson. The hint is provided in the video called “Tech Hints QR 5-1.” Fill out the template and upload it with your r...
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.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller KnowledgeBase. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $18.48. You're not tied to anything after your purchase.
