Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. suppose that a company offers quantity discounts.

Suppose that a company offers quantity discounts. If up to 1,000 units are purchased, the...

60.1K

Verified Solution

Question

Accounting

Suppose that a company offers quantity discounts. If up to 1,000 units are purchased, the unit price is

$11;

if more than 1,000 and up to 5,000 units are purchased, the unit price is

$9.00;

and if more than 5,000 units are purchased, the unit price is

$7.50.

Develop an Excel template using the VLOOKUP function to find the unit price associated with any order quantity and compute the total cost of the order.

Question content area bottom

Part 1

Complete the formulas in the spreadsheet below. Select the correct VLOOKUP function in cell C8 to find the unit price for the order quantity.

(Type integers or decimals rounded to two decimal places as needed.)

A B C D
1 Purchase Quantity Unit Price
2 1 to 1000 $enter your response here
3 1001 to 5000 $enter your response here
4 5001 or more $enter your response here
5
6 Quantity Ordered 2100
7
8 Unit Price

=VLOOKUP(B6,$A$2:$D4,4,1)

=VLOOKUP(B6,$A$2:$D4,1,0)

=VLOOKUP(B6,$A$2:$A4,1,0)

=VLOOKUP(B6,$A$2:$A4,4,1)
9 Total Cost

=B8+B6

=B8*B6

=B8*MAX(D2:D4)

=B8*A4
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

Basic Math
1.2K views

Appraise what new statistical methods are used in the evaluation of conceptual theories outlining specific advantages...

Electrical Engineering
1.2K views

Design a circuit using Op amp that will combine four voltages according to the following ratio....

Biology
1.2K views

How many people were expected by the organizers of Woodstock How many actually attended O...

Algebra
1.2K views

Solve the following system by Gauss-Jordan elimination.2x? + 9x? + 17x?= 276x?+28X? +53x? = 83x?...

Accounting
1.2K views

The unadjusted trial balance as of December 31, 2013, for the...

Accounting
1.2K views

Video Magic, Inc. has the following information available for...

Accounting
1.2K views

Jims Wholesale Foods had temporary differences related to the following future (deductible) or taxable amounts...

Accounting
1.2K views

[The following information applies to the questions displayed below.] Allied Merchandisers was organized...

Accounting
1.2K views

Analysis and Interpretation of Profitability Balance sheets and income statements for Costco Wholesale Corportation follow....

Accounting
1.2K views

22 A business uses the first in first out (FIFO) inventory system. The following information...

Accounting
1.2K views

Assume that TDW Corporation (calendar year-end) has 2022 taxable income of $700,000 for purposes of...

Accounting
1.2K views

TB MC Qu. 12-27 How has the SEC exercised its power with... How has the...