Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If I order up to 500 units of a product, I pay $3.00 per unit. If I order from 501 through 1200 units, I pay
If I order up to 500 units of a product, I pay $3.00 per unit. | |||
If I order from 501 through 1200 units, I pay $2.70 per unit. | |||
If I order from 1201 through 2000 units, I pay $2.30 per unit. | |||
If I order more than 2000 units, I pay $2.00 per unit. | |||
Write a formula that expresses the purchase cost as a function of the number of units purchased. (The formula you write in C15 and D15 should work for all the rest of the tables) | |||
1. Name the cells, by using keywords like cutoffX & priceX, in the following lookup table. | |||
cutoff | price | ||
1 | $ 3.00 | ||
cutoff1 | 500 | $ 2.70 | |
cutoff2 | 1200 | $ 2.30 | |
cutoff3 | 2000 | $ 2.00 | |
2. Write an IF formula and a VLOOKUP formula that express the purchase cost as a function of the number of units purchased. (The formula you write in C16 and D16 should work for all the rest of the tables) | |||
Order quantity | Total Cost (IF) | Total Cost (Lookup) | |
450 | |||
900 | |||
1450 | |||
2100 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started