Question: 0 Write an Excel formula in cell CustomerleS to be copied down to determine the total price of the home that the rst person will

0 Write an Excel formula in cell CustomerleS to be copied down to determine the total price of the home that the rst person will purchase. Write the formula so that it can be copied down the column to determine the total home price for each corresponding customer. This should include options total, the base price and location charges. 0 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 Customersll5, 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
