Write an Excel formula in cell Models!H3 to determine the base price for the Classic European...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Write an Excel formula in cell Models!H3 to determine the base price for the Classic 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. ($/SF for all combinations of stories) Square footage can be found in the Base worksheet. Model Classic European New American CSE Favorite Country Charmer Contemporary Model Square # Letter Footage Levels A B C Standard Features Basement Type Crawlspace D E 1,750 2 2,370 2 1,220- 1 1,860 1 3,150 2 Full Full Crawlspace Partial # # Bedrm Bathrm Base Price 3 2 3 4 3 3 4 2 1.5 3.5 # Levels 0 85.00 $ 1 $ 2 $ 105.00 $ 1,500 83.00 $ 102.00 $ Square Footage 2,000 82.00 $ 99.00 $ 2,500 78.00 $ 94.00 $ 3,000 75.00 $ 90.00 $ 3,500 72.00 90.00 Unit Conversion and Plot Details Total development area in square meters Feet/meter Square Meters/acre Square Yards/acre #plots/acre Lake Center Road Location Details Location Surcharge % 50% 25% 0% Percent Allocation of land 15% 66% 19% 750,000 3.3 4047 48.4 4 # Plots Available 111 489 141 Customers Cline White Walters Flint Jones Phillips 1 Stevens 2 Thomas 3 Jacuzzi Tub Walkout Larger Bay Options Base Model Location (Master) Basement. Plot Window Total Price E Road A с C B A D 10 D Center Center Lake Road Lake Center Road $4,500 TRUE TRUE TRUE FALSE TRUE FALSE FALSE TRUE $7,999 $11,000 TRUE TRUE FALSE TRUE FALSE FALSE FALSE TRUE TRUE FALSE TRUE FALSE TRUE FALSE FALSE TRUE $3,900 TRUE FALSE FALSE $ 4,500 FALSE $ 11,000. TRUE $ 27,399 FALSE $ TRUE $ 11,899 TRUE $19,400 $ 27,399 $ 15,500 Location Charges Total Price after Options Reduction 3. Write an Excel formula in cell Customers!H5 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 Customers!15 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!J5 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.) Write an Excel formula in cell Models!H3 to determine the base price for the Classic 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. ($/SF for all combinations of stories) Square footage can be found in the Base worksheet. Model Classic European New American CSE Favorite Country Charmer Contemporary Model Square # Letter Footage Levels A B C Standard Features Basement Type Crawlspace D E 1,750 2 2,370 2 1,220- 1 1,860 1 3,150 2 Full Full Crawlspace Partial # # Bedrm Bathrm Base Price 3 2 3 4 3 3 4 2 1.5 3.5 # Levels 0 85.00 $ 1 $ 2 $ 105.00 $ 1,500 83.00 $ 102.00 $ Square Footage 2,000 82.00 $ 99.00 $ 2,500 78.00 $ 94.00 $ 3,000 75.00 $ 90.00 $ 3,500 72.00 90.00 Unit Conversion and Plot Details Total development area in square meters Feet/meter Square Meters/acre Square Yards/acre #plots/acre Lake Center Road Location Details Location Surcharge % 50% 25% 0% Percent Allocation of land 15% 66% 19% 750,000 3.3 4047 48.4 4 # Plots Available 111 489 141 Customers Cline White Walters Flint Jones Phillips 1 Stevens 2 Thomas 3 Jacuzzi Tub Walkout Larger Bay Options Base Model Location (Master) Basement. Plot Window Total Price E Road A с C B A D 10 D Center Center Lake Road Lake Center Road $4,500 TRUE TRUE TRUE FALSE TRUE FALSE FALSE TRUE $7,999 $11,000 TRUE TRUE FALSE TRUE FALSE FALSE FALSE TRUE TRUE FALSE TRUE FALSE TRUE FALSE FALSE TRUE $3,900 TRUE FALSE FALSE $ 4,500 FALSE $ 11,000. TRUE $ 27,399 FALSE $ TRUE $ 11,899 TRUE $19,400 $ 27,399 $ 15,500 Location Charges Total Price after Options Reduction 3. Write an Excel formula in cell Customers!H5 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 Customers!15 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!J5 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.)
Expert Answer:
Answer rating: 100% (QA)
According to question it is a conditional type of question so we have to write conditiona... View the full answer
Related Book For
Essential Statistics in Business and Economics
ISBN: 978-1260239508
3rd edition
Authors: David Doane, Lori Seward
Posted Date:
Students also viewed these computer engineering questions
-
Write an Excel formula to generate a random normal deviate from N(4000, 200) and copy the formula into 100 cells.
-
The number of repairs produced by a computer repair shop depends on the number of workers as follows: NUMBER OF WORKERS NUMBER OF REPAIRS (PER WEEK) 0 0 1 8 2 20 3 35 4 45 5 52 6 57 7 60 Assume that...
-
Body-heat loss due to convection depends on a number of factors. If Hc is body-heat loss due to convection, Ac is the exposed surface area of the body, Ts - Ta is skin temperature minus air...
-
A beverage wholesale outlet sells beverages by the case. On April 13, a customer purchased 18 cases of wine at $42 per case, 20 cases of soda at $29 per case, and 45 cases of water at $17 per case....
-
What is a top- down approach to evaluation of internal controls?
-
On August 3, 2010, the date of incorporation, the Quinn Company accepts separate subscriptions for 1,000 shares of $100 par preferred stock at $104 per share and 9,000 shares of no-par,...
-
What is the formula for calculating equity per share?
-
Outline the possible disadvantages of using a parallel translation technique? As an overseas student, Zaid Kilani chose to research downsizing in his home country in the Middle East. He was...
-
! Required information [The following information applies to the questions displayed below.] BatCo makes baseball bats. Each bat requires 2 pounds of wood at $18 per pound and 0.25 direct labor hour...
-
Define the terms management science and operations research.
-
The asking price for an apartment building is $1,000,000; rents are estimated at $200,000 during the first year and are expected to grow at 5 percent per year. Vacancies and collection losses are...
-
3. Techron I costs $290,000, has a 3 year life and operating cash flows of -$50,000 per year. If the discount rate is 10%, what is the Equivalent Annual Cost? Capital Investment In-Class Exercise...
-
A boy exerts a horizontal force of 137 N on a crate with a mass of 36.2 kg. HINT (a) If the crate doesn't move, what's the magnitude of the static friction force (in N)? N (b) What is the minimum...
-
Assume that the base address 0x003c of the array A is stored in $50. The following table gives the memory addresses of A[0],...,A [3] along with the values stored in the corresponding memory...
-
3.8. A driver going too fast for the icy conditions sees a truck stopped ahead and slams on the brakes. Their car (mass = 1000 kg) skids along the icy road and collides with the truck (mass - 3000...
-
The audit team sets tolerable misstatement at $3,000,000, expected misstatement at $1,750,000, and risk of incorrect acceptance at 37%. Independent of part a, you use a sample size of 73...
-
watch the movie Twelve Angry Men (you can find it on YouTube, iTunes, Google play, Vudu and Amazon Prime). Please note there is a 1957 version and a more current version (you can watch either o
-
Show that every group G with identity e and such that x * x = e for all x G is abelian.
-
A car dealership offers a prepaid maintenance plan for their new vehicles that covers all scheduled maintenance for the first three years. The cost of the plan is $499. Jennifer has just purchased a...
-
Jills resting heart rate (bpm) is a uniformly distributed random variable ranging between 74 and 77 bpm. (a) What is her average resting heart rate? (b) The standard deviation? (c) What is the...
-
Can people really identify their favorite brand of cola? Volunteers tasted Coke, Pepsi, Diet Coke, and Diet Pepsi, with the results shown below. Research question: At ? = .05, is the correctness of...
-
If 1.0 -in. metal Pall rings are used instead of 2.0 -in. rings in Example \(16-2\) : a. Recalculate flooding velocity and required diameter. b. Recalculate \(\mathrm{H}_{\mathrm{G}}\) and...
-
A distillation column with \(8.01 \mathrm{~m}\) of packing operating at total reflux separates methanol from ethanol at \(101.3 \mathrm{kPa}\). Average relative volatility is 1.69 . Methanol mole...
-
A distillation column with \(6.0 \mathrm{ft}\) of packing can be operated as a stripper with liquid feed, as an enricher with vapor feed, or at total reflux. We are separating methanol from...
Study smarter with the SolutionInn App