1. ABC Electric Supplies offer quantity discount for large amount volume purchas
ID: 347037 • Letter: 1
Question
1. ABC Electric Supplies offer quantity discount for large amount volume purchases of energy saving light bulb. If the quantity purchased is 500 units or more you get 10% discount. No discount if the quantity ordered is less than 500. Price per unit is $2 Complete the following table. Use the Logical If function. Enter only one formula in the first row, copy the formula to the rest of the rows below. Submit two printouts, one with numbers and one with formula. Include the row and column headings and grid lines. Use relative and/or absolute references to refer to the values in the assumption area for unit price, the threshold and the percent discount. Assumption Area Unit Price Volume $2 Percent Discount 500 500 12% 0% Unit Purchased Regular price Percent Final Price without discount Discount 600 1200 500 400 Note: Both answers should be on the same worksheet.Explanation / Answer
Answer :
Pls find theupdated sheet with logical IF function.
The IF function can be used to suit the conditions in the calculation.
For the given problem, the logical IF function as = IF(C17>=1000,(C17*$E$8),0)
The table is calculated as below with 10% discount as
Assumption area Unit price $2 Volume Percent Discount >,= 500 10% < 500 0% Unit Purchased Regular price withoutr discount Percent Discount Final Price 600 $1,200 $120 $1,080 1200 $2,400 $240 $2,160 500 $1,000 $100 $900 400 $800 $0 $800Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.