Create 3 lookup tables based on the following information: Unit Price: Apple, $45; Banana, $34; Grape,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create 3 lookup tables based on the following information: Unit Price: Apple, $45; Banana, $34; Grape, $89; Kumquat, $150; Orange, $20 Sales Amount Discount: For the sales amount up to less than 1,000, the discount is 0%; for the sales amount from 1,000 up to less than 5,000, the discount is 2%; For the sales amount from 5,000 up to less than 10,000, the discount is 5%; for the sales amount 10,000 and up, the discount is 8%. Date Discount: Mon, 10%; Tue, 5%; Wed, 0%; Thu, 2%; Fri, 20% 2. Calculate Unit Price using VLOOKUP function 3. Calculate Extension/Sales Amount, which is equal to Unit Price X Quantity 4. Calculate Sales Amount Discount Amount using VLOOKUP function ((format cell to Currency) 5. Calculate Date Discount Amount using VLOOKUP function (format cell to Currency) 6. Calculate Discounted Price, which is equal to the Extension - (Sales Amount Discount)-(Date Discount Amount) 7. Calculate Total in cells F11 to 111 8. DO NOT change the order of the data from A1 to 112 ------- ------ Employee Product Quantity Sale Date Bob 23 Monday 45 Thursday Banana Jill Orange Bob Apple George Apple 65 Wednesday 58 Monday 79 Tuesday George Banana Bob Grape 132 Wednesday Jill Grape KumQuat 56 Monday 12 Friday Mike Unit Price Vlookup Name: TrchalekDaniel || | ||| ||| |||| Unit Price Totals: Sales/Extension Discount Vlookup Extension/Sales Sales Discount Amount (in Date Discount Amount (in Amount Dollar) Dollar) Date Discount Vlookup Discounted Price DO NOT change the order of the data in this area (i.e., A1:111). Doing so will cause a mis-match in grading. Format cells in columns G, H, and I in this table to currency. Create 3 lookup tables based on the following information: Unit Price: Apple, $45; Banana, $34; Grape, $89; Kumquat, $150; Orange, $20 Sales Amount Discount: For the sales amount up to less than 1,000, the discount is 0%; for the sales amount from 1,000 up to less than 5,000, the discount is 2%; For the sales amount from 5,000 up to less than 10,000, the discount is 5%; for the sales amount 10,000 and up, the discount is 8%. Date Discount: Mon, 10%; Tue, 5%; Wed, 0%; Thu, 2%; Fri, 20% 2. Calculate Unit Price using VLOOKUP function 3. Calculate Extension/Sales Amount, which is equal to Unit Price X Quantity 4. Calculate Sales Amount Discount Amount using VLOOKUP function ((format cell to Currency) 5. Calculate Date Discount Amount using VLOOKUP function (format cell to Currency) 6. Calculate Discounted Price, which is equal to the Extension - (Sales Amount Discount)-(Date Discount Amount) 7. Calculate Total in cells F11 to 111 8. DO NOT change the order of the data from A1 to 112 ------- ------ Employee Product Quantity Sale Date Bob 23 Monday 45 Thursday Banana Jill Orange Bob Apple George Apple 65 Wednesday 58 Monday 79 Tuesday George Banana Bob Grape 132 Wednesday Jill Grape KumQuat 56 Monday 12 Friday Mike Unit Price Vlookup Name: TrchalekDaniel || | ||| ||| |||| Unit Price Totals: Sales/Extension Discount Vlookup Extension/Sales Sales Discount Amount (in Date Discount Amount (in Amount Dollar) Dollar) Date Discount Vlookup Discounted Price DO NOT change the order of the data in this area (i.e., A1:111). Doing so will cause a mis-match in grading. Format cells in columns G, H, and I in this table to currency.
Expert Answer:
Answer rating: 100% (QA)
93 answers STEPS 1 CREATE TABLE OF DATA FOR UNIT PRICE SALE... View the full answer
Related Book For
Fundamental Managerial Accounting Concepts
ISBN: 978-1259569197
8th edition
Authors: Thomas Edmonds, Christopher Edmonds, Bor Yi Tsay, Philip Olds
Posted Date:
Students also viewed these general management questions
-
Create two tables based on the E-R model shown in Figure 4-41 and the business rules in the following list for a work order tracking database. Include all the constraints in the CREATE TABLE...
-
Calculate the magnetic declination in 1870 based on the following data from an old survey record. Present Magnetic Bearing S15 50" E S52-35" E Present Magnetic Declination 1 15 W 8 30'E 1870 Magnetic...
-
Create a stakeholder assessment matrix based on the following scenario. Be sure to build a list of all stakeholders . Use the format shown in Figure 4-8.
-
The following information was taken from the annual manufacturing overhead cost budget of Granada Company. Variable manufacturing overhead costs .....$33,000 Fixed manufacturing overhead costs...
-
Why might members of an organization disagree about the nature of hostile work environment sexual harassment?
-
Determine whether the yield to maturity of a 6.5% 20-year bond that pays interest semi annually and is selling for $90.68 is 7.2%, 7.4%, or 7.8%.
-
Which of the following is the cornerstone (or most critical element) of the master budget? a. the sales budget b. the inventory budget c. the purchases and cost of goods sold budget d. the operating...
-
The client, Mrs. Tatum, purchased a new microwave oven from Inki Appliances Company. No written or oral warranty was given when the sale was made. The microwave stopped working one week after Mrs....
-
A cash budget, by quarters, is given below for a retail company ( 0 0 0 omitted ) . The company requires a minimum cash balance of at least $ 3 , 0 0 0 to start each quarter. \ table [ [ , \ table [...
-
In Part III (Appendix 11B) of the audit case, the audit staff of Adams, Barnes & Co. identified specific revenue risks on working paper RA-12 (page 494). However, the Summary of Audit Approach...
-
Assume your client Peace and Love, Inc. has purchased the following assets listed below, when they moved into their new office space in 2020. The office building was purchased in 2017 and placed into...
-
What is an example of a product innovation opportunity presented by Bluetooth, and NFC, Smart Bluetooth, or Beacons?
-
Which LPWA or LPWAN technology would you use if you frequently took travelers on remote tours and relied on IoT devices to improve the traveler experience?
-
Which type of LPWA or LPWAN is likely to be the most widely accepted and why?
-
How might the three categories of management assertions provide a powerful tool for the financial statement auditor?
-
What is an example of a business model innovation opportunity presented by GPS III or LEO satellites?
-
An Analyst has times a metal-cutting task for 50 cycles. The average time per cycle was 10.40 minutes and the standard deviation was 1.20 minutes for a worker with performance rating of 125 percent. A
-
Les has collected stamps in his spare time for years. He purchased many of his stamps at a price much lower than the current market value. Les recently lost his job as a carpenter. Since his wife...
-
Shawn Corder needs extra money quickly to help cover some unexpected school expenses. Mr. Corder has learned fortune-telling skills through his long friendship with Fred Molloy, who tells fortunes...
-
Supply the missing information in the following table for Greenwood Company: Sales.................................................................................... ?...
-
Logan Oil Change operates two divisions. The following pertains to each division for 2018: Concord Kinston Sales................................................. $900,000.........................
-
List three unused (solid) edges from Graph \(O\) that cannot be used to complete the spanning tree. A student has been asked to construct a spanning tree for Graph \(O\), as shown in the figure. The...
-
Determine whether Graph \(Q_{3}\) is a spanning tree of Graph \(Q\). If not, explain how you know. m n
-
How many more edges must be included with the dashed edges to create a spanning tree? A student has been asked to construct a spanning tree for Graph \(O\), as shown in the figure. The dashed lines...
Study smarter with the SolutionInn App