Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. excel: calculate the discount rate. a.combine the

Excel: Calculate the discount rate. a.Combine the VLOOKUP function with a multiplication formula. Hint ...

80.2K

Verified Solution

Question

Accounting

Excel: Calculate the discount rate. a.Combine the VLOOKUP function with a multiplication formula. Hint for theVLOOKUP you will need to add the breakpoints to the data in rows 21-25 b.Show as a negative amount. c.Round to two decimals using the ROUND function.

Excel spreadsheet

2
3
4
5
6 A B C D E
7)Quantity Needed Part # Unit price Cost before discount or handling fee Discount Rate %
8) 12 2152 $ 49.99 599.88
9) 55 4167 $ 15.85 871.75
10) 101 8321 $ 77.99 7,876.99
11) 4 12345 $ 17.50 70.00
12) 18 188875 $ 3.10 55.80
13 9,474.42
14
15
16 Average unit price
17 Highest unit price
18 Lowest unit price
19 Third highest
20 Second lowest
21
22 Quantity Categories Discount Rate
23 0-9 0.0%
24 10-24 1.0%
25 25-99 2.0%
26 100 plus 5.0%

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

Q

#1 A candy company makes chocolates in two flavors, milk and dark. Brenda is a quality control...

Statistics
Q

Consider a world that only consists of the three stocks shown in the following? table: LOADING... . a. Calculate...

Finance
Q

An air bubble is inside the water water Which of the following is correct 1...

Physics
Q

A delivery man carries a 5.0-kg box up a flight of stairs 4.0 m above...

Physics
Q

One way of checking the effect of undercoverage, nonresponse, and other sources of error in...

Basic Math
Q

1 point Relative to the graph of the graphs of the following equations have been...

Calculus
Q

Find the consumer s surplus for the following demand function at the given point 3...

Calculus
Q

Bulele Company wisement with a cost of $362.600 and accurated depreciation of 356,100 t can...

Accounting
Q

You have recently been appointed to the board of directors of SAC (Pty) Ltd and...

Accounting
Q

On November 1, Year 1, a company borrows $42,000 cash from Community Savings and Loan....

Accounting
Q

Considered your self- management accountant make benchmark comparison and explain its role in cost management

Accounting
Q

Muzinda (Pty) Ltd is a company established by female entrepreneurs. The company makes school uniforms...

Accounting