In order to increase the number of customers who are purchasing the various options (Jacuzzi, basement walkout, larger plot, bay window in dining room), you have decided to offer an options package special for a limited time- Customers who purchase all of the options listed will get the highest priced option for free. Currently the larger plot is the most expensive option at $11,000 but keep in mind that prices are always subject to change. Write an Excel formula for cell Customers!L5, which can be copied down the column, to calculate the new total price of each home, taking into consideration any discounts for the options package, if applicable. E M 1 Customers 2 Options Total Base Price Location Charges Price after Options Reduction 3 Model Total E Jacuzzi Tub Walkout Location (Master) Basement $4,500 $7,999 Road TRUE TRUE Center TRUE FALSE Center TRUE FALSE Lake FALSE FALSE Road TRUE TRUE Lake FALSE FALSE Center FALSE TRUE Road TRUE FALSE Bay Window $3,900 TRUE FALSE FALSE FALSE 4 5 Cline 6 White 7 Walters 8 Flint 9 Jones 10 Phillips 11 Stevens 12 Thomas 13 Larger Plot $11,000 TRUE TRUE FALSE TRUE TRUE FALSE FALSE TRUE B $27,399.00 $ 283,500 $15,500.00 $ 178,500 $4,500.00 $ 103,700 $11,000.00 $ 103,700 $27,399.00 $ 234,630 $0.00 $ 178,500 $11,899.00 $ 154,380 $19,400.00 $ 154,380 $0.00 $ 310,899 $3,875.00 $ 197,875 $ $1,125.00 $ 109,325 $ $5,500.00 $ 120,200 $ $0.00 $ 262,029 $ $0.00 $ 178,500 $ $2,974.75 $ 169,254 $ $0.00 $ 173,780 $ TRUE D FALSE TRUE TRUE D 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Models Base Units Customers Edit Average: 0 Cou