Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. i need a, b, c, and d on this question all for #1

I need a, b, c, and d on this question all for #1 ...

60.1K

Verified Solution

Question

Accounting

image

image

I need a, b, c, and d on this question all for #1

1 2 Bins 3 $0-$99.99 4 $100-$249.99 5 $250-$499.99 6 $500-$999.99 7 $1000- B C Zip Shipping Cutoffs Output % $ 10.00% $100.00 5.00% $250.00 4.00% $500.00 2.50% $1,000.00 0.00% 8 9 Input Order Total 10 Shipping Percentage: 11 Shipping costs: $874.00 2.50% $21.85 12 In the table above, we have 5 possibilities for the %. We represent the possibilities in a table in cells, B3:07. This table consists of two columns, #1 and #2. Basically we will LOOKUP the value for the order total B9, in the table, and then output the appropriate % from column #2. The following VLOOKUP function is entered in cell B10 which gives an output of 2.50%: =VLOOKUP(B9, B3:07,2) 1. What are the outputs for the following? (Hint: one strategy is to create the table in an Excel spreadsheet and then enter the following VLOOKUP commands.) a. =VLOOKUP( 165, B3:C7, 2) b. =VLOOKUP( 650, B3:07, 1) c. =VLOOKUP( 650, B3:C7, 2) d. =VLOOKUP( 6500, B3:C6, 2)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Finance
1.2K views

Monica Dubois, an ABC investment advisor, has a new client, Mr. Jack Klein. Mr. Klein is...

Biology
1.2K views

Here you will be plotting results and commenting in written form. Hence, you must show your...

Physics
1.2K views

You MUST show all the diagrams, formulas, substitutions, calculations, results, and unit to receive the whole credit...

Economics
1.2K views

You have just started up a new company in Nova Scotia. Your company produces software for...

Basic Math
1.2K views

. Assume that the lifetimes (measured from the beginning of use) of lightbulbs are i.i.d. random...

Basic Math
1.2K views

Find all angles 0 x 360 that satisfy the equation below to the nearest 10th...

Statistics
1.2K views

Maybe you have considered buying a term life insurance policy The expected value of any...

Algebra
1.2K views

Use the graphs to write the formula for the function 18 8 2 a f...

Accounting
1.2K views

Materiality in Auditing: Materiality is a fundamental concept in auditing that refers to the...

Accounting
1.2K views

17. Project Y requires a $342,000 investment for new machinery with a five-year life and...

Accounting
1.2K views

Question 15 1 points SAVE ANSWER Peter operates a tyre retail business as a sole...

Accounting
1.2K views

Oliver Company uses the percentage of accounts receivable ending balance method to estimate its bad...