Homework Help is Here – Start Your Trial Now!
Business
Accounting
Employee Product Quantity Bob Banana Jill Orange Bob Apple 23 Sale Date Unit Price Monday 45 Thursday 65 Wednesday George Apple George Banana 58 Monday 79 Tuesday Bob Grape 132 Wednesday Jill Grape 56 Monday Mike KumQuat 12 Friday Totals: Extension/Sales Sales Discount Amount Date Discount Amount Amount (in Dollar) (in Dollar) 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. Sales/Extension Discount Unit Price Vlookup Vlookup Date Discount Vlookup Format cells in columns G, H, and I in this table to currency. Name: Banks-EdmondsonDanielle ||||||||||| Instructions: 1. 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 Bob Banana Jill Orange Bob Apple 23 Sale Date Unit Price Monday 45 Thursday 65 Wednesday George Apple George Banana 58 Monday 79 Tuesday Bob Grape 132 Wednesday Jill Grape 56 Monday Mike KumQuat 12 Friday Totals: Extension/Sales Sales Discount Amount Date Discount Amount Amount (in Dollar) (in Dollar) 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. Sales/Extension Discount Unit Price Vlookup Vlookup Date Discount Vlookup Format cells in columns G, H, and I in this table to currency. Name: Banks-EdmondsonDanielle ||||||||||| Instructions: 1. 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

Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Chapter8: Inventories: Special Valuation Issues
Section: Chapter Questions
Problem 9MC: Estimates of price-level changes for specific inventories are required for which of the following...
See similar textbooks
icon
Related questions
Question
Employee Product Quantity Bob Banana Jill Orange Bob Apple 23 Sale Date Unit Price Monday 45 Thursday 65 Wednesday George Apple George Banana 58 Monday 79 Tuesday Bob Grape 132 Wednesday Jill Grape 56 Monday Mike KumQuat 12 Friday Totals: Extension/Sales Sales Discount Amount Date Discount Amount Amount (in Dollar) (in Dollar) 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. Sales/Extension Discount Unit Price Vlookup Vlookup Date Discount Vlookup Format cells in columns G, H, and I in this table to currency. Name: Banks-EdmondsonDanielle ||||||||||| Instructions: 1. 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
Transcribed Image Text:Employee Product Quantity Bob Banana Jill Orange Bob Apple 23 Sale Date Unit Price Monday 45 Thursday 65 Wednesday George Apple George Banana 58 Monday 79 Tuesday Bob Grape 132 Wednesday Jill Grape 56 Monday Mike KumQuat 12 Friday Totals: Extension/Sales Sales Discount Amount Date Discount Amount Amount (in Dollar) (in Dollar) 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. Sales/Extension Discount Unit Price Vlookup Vlookup Date Discount Vlookup Format cells in columns G, H, and I in this table to currency. Name: Banks-EdmondsonDanielle ||||||||||| Instructions: 1. 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
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS