A B C D E F G H Region Midwest Question 4: Use VLOOKUP to find...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A B C D E F G H Region Midwest Question 4: Use VLOOKUP to find price in column H and use XLOOKUP to find per unit discount in column I. Calculate net revenue in column J. Use VLOOKUP or XLOOKUP to find region in column K Sales Rep Anderson, Robin Date Units Sales Rep Product Price Per Unit Disco Net Region 12/17/2017 5 Nichols, Claudia Quad B Bryan, Viola West 6/24/2016 6 Bryan, Viola Quad B Gonzalez, Danny East 1/25/2016 35 Rodgers, Bob Sunbell Miles, Josefina Southwest 3/21/2017 3 Rodgers, Bob Sunshine 5 Ply 1 Nguyen, Sheldon East 5/31/2017 2 Nichols, Claudia Northwest 8/13/2017 3 Pittman, Otis West 5/2/2016 67 Rodgers, Bob 4 Richardson, Kristin, Northwest 1/9/2016 15 Rodgers, Bob Midwest 10/31/2017 16 Stokes, Taylor 17 Boomerangs 18 Available 19 Quad 20 Bellen 21 Carlota Southwest 8/27/2016 51 Anderson, Robin 11/23/2017 10 Stokes, Taylor2 Price 9/9/2017 $34.48 5/13/2017 $27.78 9/6/2016 $19.76 4/21/2016 22 Carlota Doublers $58.18 2/27/2016 5 Gonzalez, Danny 43 Gonzalez, Danny 5 Rodgers, Bob 70 Gonzalez, Danny 57 Pittman, Otis 23 Majestic Beaut $22.04 2/11/2016 24 Sunshine 5 Ply $15.40 8/11/2016 5 Stokes, Taylor 39 Stokes, Taylor 5 Richardson, Kristina Quad 3 Gonzalez, Danny Sunset 3 Richardson, Kristina Carlota Doublers 2 Richardson, Kristina Sunbell Quad Sunset Bellen Dancer Carlota Doublers Bellen Wind Dance Sunbell Majestic Beaut Sunbell Quad Flattop 25 Sunshine 10 Ply $20.50 7/19/2016 26 Sunset $23.50 11/21/2016 27 Sunbell $29.10 9/23/2016 121 Miles, Josefina 5 Rodgers, Bob 62 Gonzalez, Danny Sunbell Sunshine 10 Ply 28 Flattop $24.72 7/7/2016 29 Bellen Dancer $28.16 5/16/2017 30 Bellen Wind Dancer $30.32 6/13/2017 31 GelFast $25.80 3/29/2017 9 Gonzalez, Danny 2 Gonzalez, Danny 64 Anderson, Robin 4 Rodgers, Bob Quad Quad Sunbell Majestic Beaut Quad 32 Phenolic Sunshine $31.24 4/2/2016 33 Icarus MTA $37.36 3/9/2016 34 2/3/2017 35 Units Price Per Unit Discount 9/25/2017 36 0 $0.00 7/4/2016 37 10 $0.02 12/5/2017 10 Bryan, Viola 38 15 $0.10 6/21/2016 39 25 $0.35 7/3/2017 40 44 $0.45 9/24/2016 41 75 $0.50 1/9/2016 42 100 $0.55 2/23/2017 10 Nichols, Claudia 37 Gonzalez, Danny 58 Bryan, Viola 8 Richardson, Kristina Quad 5 Gonzalez, Danny Quad 3 Gonzalez, Danny 56 Gonzalez, Danny 1 Nguyen, Sheldon 51 Gonzalez, Danny 37 Miles, Josefina Carlota Doublers Sunbell Carlota Quad Bellen Wind Dance Quad Sunbell Sunbell Quad 43 8/20/2016 5 Anderson, Robin Quad 44 5/16/2016 1 Gonzalez, Danny Quad 10/2/2016 4 Richardson, Kristin Sunset A B C D E F G H Region Midwest Question 4: Use VLOOKUP to find price in column H and use XLOOKUP to find per unit discount in column I. Calculate net revenue in column J. Use VLOOKUP or XLOOKUP to find region in column K Sales Rep Anderson, Robin Date Units Sales Rep Product Price Per Unit Disco Net Region 12/17/2017 5 Nichols, Claudia Quad B Bryan, Viola West 6/24/2016 6 Bryan, Viola Quad B Gonzalez, Danny East 1/25/2016 35 Rodgers, Bob Sunbell Miles, Josefina Southwest 3/21/2017 3 Rodgers, Bob Sunshine 5 Ply 1 Nguyen, Sheldon East 5/31/2017 2 Nichols, Claudia Northwest 8/13/2017 3 Pittman, Otis West 5/2/2016 67 Rodgers, Bob 4 Richardson, Kristin, Northwest 1/9/2016 15 Rodgers, Bob Midwest 10/31/2017 16 Stokes, Taylor 17 Boomerangs 18 Available 19 Quad 20 Bellen 21 Carlota Southwest 8/27/2016 51 Anderson, Robin 11/23/2017 10 Stokes, Taylor2 Price 9/9/2017 $34.48 5/13/2017 $27.78 9/6/2016 $19.76 4/21/2016 22 Carlota Doublers $58.18 2/27/2016 5 Gonzalez, Danny 43 Gonzalez, Danny 5 Rodgers, Bob 70 Gonzalez, Danny 57 Pittman, Otis 23 Majestic Beaut $22.04 2/11/2016 24 Sunshine 5 Ply $15.40 8/11/2016 5 Stokes, Taylor 39 Stokes, Taylor 5 Richardson, Kristina Quad 3 Gonzalez, Danny Sunset 3 Richardson, Kristina Carlota Doublers 2 Richardson, Kristina Sunbell Quad Sunset Bellen Dancer Carlota Doublers Bellen Wind Dance Sunbell Majestic Beaut Sunbell Quad Flattop 25 Sunshine 10 Ply $20.50 7/19/2016 26 Sunset $23.50 11/21/2016 27 Sunbell $29.10 9/23/2016 121 Miles, Josefina 5 Rodgers, Bob 62 Gonzalez, Danny Sunbell Sunshine 10 Ply 28 Flattop $24.72 7/7/2016 29 Bellen Dancer $28.16 5/16/2017 30 Bellen Wind Dancer $30.32 6/13/2017 31 GelFast $25.80 3/29/2017 9 Gonzalez, Danny 2 Gonzalez, Danny 64 Anderson, Robin 4 Rodgers, Bob Quad Quad Sunbell Majestic Beaut Quad 32 Phenolic Sunshine $31.24 4/2/2016 33 Icarus MTA $37.36 3/9/2016 34 2/3/2017 35 Units Price Per Unit Discount 9/25/2017 36 0 $0.00 7/4/2016 37 10 $0.02 12/5/2017 10 Bryan, Viola 38 15 $0.10 6/21/2016 39 25 $0.35 7/3/2017 40 44 $0.45 9/24/2016 41 75 $0.50 1/9/2016 42 100 $0.55 2/23/2017 10 Nichols, Claudia 37 Gonzalez, Danny 58 Bryan, Viola 8 Richardson, Kristina Quad 5 Gonzalez, Danny Quad 3 Gonzalez, Danny 56 Gonzalez, Danny 1 Nguyen, Sheldon 51 Gonzalez, Danny 37 Miles, Josefina Carlota Doublers Sunbell Carlota Quad Bellen Wind Dance Quad Sunbell Sunbell Quad 43 8/20/2016 5 Anderson, Robin Quad 44 5/16/2016 1 Gonzalez, Danny Quad 10/2/2016 4 Richardson, Kristin Sunset
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
What steps have been taken in the EU to provide lighter accounting regulation for micro-entities?
-
A bicyclist travels in a circle of radius 25.0 m at a constant speed of 9.00 m/s. The bicycle-rider mass is 85.0 kg. Calculate the magnitudes of (a) The force of friction on the bicycle from the road...
-
If sales are 20,000 and the gross profit margin is 20 percent, what is the cost of goods sold?
-
How could one tell whether the metrics used for performance evaluations were KPIs?
-
The Budgetary Comparison Schedule for the City of Vienna appears below. Several items of information are missing (denoted**). Required: a. Determine the missing amounts. b. During the year, the City...
-
Classify the statements as "true" or "false" based on the graph of f () shown below. 3 2 -4 -3 -2 2 3 True False No Answers Chosen No Answers Chosen Possible answers The limit as x approaches 3 does...
-
With the strategic goal and objective for the two insurance companies, the main thing in advertising will be Google ads and mobile marketing display advertising. Provide two examples.
-
A full absorption costing system would involve the assignment of both variable and fixed overhead costs to products. A traditional full absorption costing system typically uses a single volume...
-
discuss the evolution of Open Banking frameworks and their implications for competition, innovation, and consumer data privacy within the financial services industry?
-
Completion Complete each statement. 1. ____________________ is used when you want to shut down a cluster server for maintenance or upgrades, such as adding memory or replacing a failing component....
-
Land worth $800,000 is purchased by a down payment of $120,000 and the balance in equal monthly installments for 15 years. If interest is atj12= 4%, determine the buyer's and seller's equity in the...
-
I'm confused by no mention of depreciation and then when to apply the MARR and tax rate. Please help clear this up for me. An asset has the following data. If the MARR is 10%, determine the asset...
-
1 (100 points) Rem Select two market sectors from the 11 sectors identified on this reference o https://www.bloomberg.com/markets/sectors Select two stocks from each sector (stocks) Add one of these...
-
Design an experiment to demonstrate that RNA transcripts are synthesized in the nucleus of eukaryotes and are subsequently transported to the cytoplasm.
-
Examine the cash flow measures in requirement 2 of the review problem in this chapter. Discuss the meaning of these ratios. Computing Cash Flows from Operating Activities: Indirect Method
-
During 20x7, Arizona Company issued $500,000 in long-term bonds at 96, repaid $75,000 of bonds at face value, paid interest of $40,000, and paid dividends of $25,000. Prepare the cash flows from the...
-
Lower of Cost and Net Realizable Value} Meredith's Appliance Store has the following data for the items in its inventory at the end of the accounting period: \section*{Required:} 1. Compute the...
Study smarter with the SolutionInn App