Question

ROTECTED VIEW Be cavefulles from the Internet can contain viuses. Unless you need to ndit, its safler to stay in Prodected View.Enable Editing A clothing retailer gives you 10 points for every $1 spent, and you can trade in 2,350 points for a $15 gft certificate. Eddie Bauer Shopping Spree Iteres Cost Total Cost Points L Polo Shirt a) The spreadsheet lists purchases and their prices. Create formulas which compute the cost of each item and the points you get from each item. 5 135.00 5219.00 19.99 s 75.00 4 Merrell Shoes Snowline Jacket 7 Cloud Layer Fleece b.) Compute the total cost of the order and the total number of points from the order Full Dip Hoodie 0 Wrinkle Free Oxfor $ 70.00 55.00 Totals: c-) Compute how many $15 gft certificates you will get from this order and the total value of these gift certificates. Note: you cannot get a fractional gift certificate so use the INT function which gives the integer part of a number (effectively it rounds down). Format with er decimal places Gift Certificates: Value of Gift Certificates: Money SpenValue of Gift cestificates d) What is the ratio of money spent to the value of the gift certificates? Enter a formula in cell 121 for this ratio with the second quantity scaled to one. 82 EddieB
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a) Formula

Total Cost for polo shirt - =c4*d4

Total points - =E4*10

b) Calculation of total cost and total points

Items Quantity Cost Total cost Total points
Polo shirt 3 $50 $150 $1500
Dress shirt 4 $75 $300 $3000
Khakis 2 $59.99 $119.98 $1199.8
Merell shirt 1 $135 $135 $1350
Snowline Jacket 1 $219 $219 $2190
Belt 1 $19.99 $19.99 $199.9
Cloud layer fleece 2 $75 $150 $1500
Sweater 3 $80 $240 $2400
Full zip hoodie 1 $70 $70 $700
Wrinkle Free oxford 5 $55 $275 $2750
Total $1678.97 $16789.7

c) Calculation of gift certificates and its value

One gift certificate of $15 for 2550 points

Formula for number of gift certificates - =INT(F15/2550)

Gift certificate = 6 Certificate

Formula for Value of gift certificates - =F17*$15

Value of gift certificates = 6*$15 = $90

d) Ratio of money spent to value of gift certificates

Formula for ratio = E15:F18

Ratio = $1678.97:$90

Add a comment
Know the answer?
Add Answer to:
ROTECTED VIEW Be cavefulles from the Internet can contain viuses. Unless you need to ndit, it's...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View...

    Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View -ut interruption, please reactivate now. Reactivate Enable Editing MERIWELL COMPANY I Finished goods inventory, beginning Finished goods inventory, ending Depreciation, factory Administrative expenses Utilities, factory Maintenance, factory Supplies, factory Insurance, factory Purchases of raw materials Raw materials inventory, beginning Raw materials inventory, ending Direct labour Indirect labour Work in process inventory, beginning Work in process inventory, ending Sales Selling expenses $20,000 40,000 27,000 110,000...

  • Enable Editing (0) PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need...

    Enable Editing (0) PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected view K19 DK 1 CD5 - EXCEL Tutorial 3 CURRENT DESIGNS 4 Bill Johnson, sales manager, and Diane Buswell, controller at Current Designs are beginning to analyze the cost 5 considerations for one of the composite models of the kayak division. They have provided the following production 6 and operational costs necessary to produce one composite...

  • ROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit Recerding...

    ROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit Recerding sapplies and ideatifing their dfect on finenciel stetemeats Exercise 13-108 LO 13-1, 13-3, 13-4 Laurs Moss started and operated a small family consuking firm in Year L The firm was aflected by two events (1) Moss provided $36,000 of services on acount, and (2) she purchased $10,000 of supplies on account. There were $1800 of supplies on hand as of December 31, Year L...

  • met can contain viruses. Unless you need to edit, it's safer to stay in Protected View...

    met can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Alex quit his job at State University where he earmed $45,000 a year to start extreme gaming software business To start the business, he cashed in $100,000 in bonds that was earning him 10 percent interest anmually to buy equipment. His forgone entrepreneurial income was $5,000 a year. In the first year, the fim sold 11,000 units of software at $75 for...

  • Home Insert Page Layout Formulas Dats Reve ROTECTED VIEW Be careful fFiles from the Internet can contain vinuses. Unless you need to edit, it's saler to stay in Protected View C D...

    Home Insert Page Layout Formulas Dats Reve ROTECTED VIEW Be careful fFiles from the Internet can contain vinuses. Unless you need to edit, it's saler to stay in Protected View C D Strength 48.5 52.3 53.5 50.5 50.3 49.6 The CEO of Durable Bags Inc. is planning to introduce a new, improved version of the company's trash bag. The new trash bag utilizes a new formula that is being touted as the strongest bag on the market Previously, one of...

  • et can contain viruses. Unless you need to edit, it's safer to stay in Protected View...

    et can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Case: Cost Structures for Global Shippers Inc. Management from Global Shippers Inc, an interational shipping business, is in the process of assessing the choice between two different cost structures for the business. Option A has relatively higher variable costs per unit shipped but lower annual fixed costs, while Option B has the opposite relatively lower variable costs in its cost structure but...

  • References Mailings Review View Help nternet can contain viruses. Unless you need to edit, it's safer...

    References Mailings Review View Help nternet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Q6. Dollarama Inc, completed the following transactions during November 2019, its first month of operations: Nov. 1 Received $25,000, and issued common shares. Nov.5 Purchased $800 of office supplies on account. Nov. 6 Paid $20,000 cash for land to use as a building site. Nov. 10 Performed service for customers, and received cash of $5,000. Nov. 15...

  • i just need 10 and 12 answered!!! Thank you! Are you reading from a computer or...

    i just need 10 and 12 answered!!! Thank you! Are you reading from a computer or a cellphone? They are clear on my computer just need 10 and 12 answered pls The Business Situation When Shelley Jones became president-elect of the Circular Club of Auburn, Kansas, she was asked to suggest a new fundraising activity for the club. After a consider- able amount of research, Shelley proposed that the Circular Club sponsor a pro- fessional rodeo. In her presentation to...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT