it is time to complete your analysis. 1. Based on the Total development area given in the Units worksheet, write an Excel formula in cell UnitsiD9 to calculate the number of take plots you will buld per the allocation described in the Units worksheet. This formula should alwo work when you copy it down to determine the number of Center plots you will have and finally, the number of Road plots. (Use the ROUND function to round the number to the nearest whole number.) 2. Write an Excel formula in cell ModelsiH3 to determine the base price for the Ciassic European home. This formula should also work when you copy it down to determine the base price for the New American Home, CSE Favorite, etc. Recall that the base price for each model depends on the number of levels and total square footage of the home. IS/SF for all combinations of stories) Square footage can be found in the Base worksheet. 3. Write an Excel formula in cell CustomersiHs to be copied down to determine the total value of the options purchased for the first customer's sale. When copied down, the formula will determine the total value of options for each corresponding customer. 4. Write an Excel formula in cell Customersils to be copied down to determine the Base price for the specific model home the first customer has purchased. When copied down, the formula will determine the total value of each home for the corresponding customer. (Do not use an if function for this formula.) 5. Write an Excel formula in cell Customers!/S to determine the location surcharge (not total cost). if applicable, for the home purchased by the first customer. Remember that the surcharge percentage is applied to the home price including options. Write the formula so that it can be copied down the column to determine the surcharge for each corresponding customer. (Do not use an IF function for this formula.)