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