1 answer

QUESTION 1 Use the table below to answer the following question(s). Shirley Templeton is a real...

Question:

QUESTION 1 Use the table below to answer the following question(s). Shirley Templeton is a real estate agent for Paralol Real

QUESTION 1 Use the table below to answer the following question(s). Shirley Templeton is a real estate agent for Paralol Realty. Shirley is given the responsibility to manage potential customers for 5 of the Realty's bungalows. These 5 bungalows are situated in close proximity. In order to make traveling easier, Shirley decides to move to a location closer to the 5 bungalows. The table below gives the location (X and Y coordinates) of the 5 bungalows along with the number of trips she would have to make to each bungalow. Create a nonlinear model based on the data given in the table below noting that the objective is to reduce the weighted distance between Shirley's accommodation and the 5 bungalows. Bungalow Location X-coordinate | Y-coordinate Data Location Bungalow 1 Bungalow 2 Bungalow 3 Bungalow 4 Bungalow 5 125 20 90 60 100 75 80 100 Trips/Month 16 10 15 18 10 According to the model, what is the weighted distance between Shirley's new accommodation and Bungalow 5? O 206.58 O 250.78 O 435.89 O 589.25

Answers

Set up Excel model as follows:

A B с D E F | xl Location X Y Trips/Month 1 2 Bungalow 1 0 0 6 3 Bungalow 2 25 110 10 4 Bungalow 3 20 75 15 5 Bungalow 4 90 8

Note that we need any non zero values for coordinates for Shirley's new accommodation, in order to initialize the model

Set up Solver Parameters as follows:

Solver Parameters Set Objective: $F$111 To: Max Min O Value of: 0 By Changing Variable Cells: $B$9:$C$9 Subject to the Constr

It;s a nonlinear model, so Select a Solve Method: GRG Nonlinear

А B C D G Trips/Month 6 10 15 18 Location X Y 1 2 Bungalow 1 0 0 3 Bungalow 2 25 110 4. Bungalow 3 20 75 5 Bungalow 4 90 80 6

Solver Results Х Solver found a solution. All Constraints and optimality conditions are satisfied. Reports Answer Sensitivity

Click OK

The Weighted distance (or Load distance) between Shirley's new accommodation and Bungalow 5 is 162.62 .

Note that this answer is better than all of the given options. the closest is 206.58

Therefore, answer would be 206.58

.

Similar Solved Questions

1 answer
13. Show that the set of all polynomials P is a first category set in C[a,...
13. Show that the set of all polynomials P is a first category set in C[a, b]....
1 answer
Show how exceptions are thrown and caught in Java. When does the finally block get executed?...
Show how exceptions are thrown and caught in Java. When does the finally block get executed? Show with a sample code if the finally block is executed if we have a return statement in the try block.write code in java...
1 answer
The figure below shows the graph of a rational functionſ. It has vertical asymptotes x-1 and...
The figure below shows the graph of a rational functionſ. It has vertical asymptotes x-1 and x-5, and horizontal asymptote y 0. The graph does not have an x-intercept, and it passes through the point (-4,-2). The equation for f(x) has one of the five forms shown below. Choose the appropriate fo...
1 answer
Sed on the following energy values, determine the AH- for sodium chlo Na (s) + 12...
sed on the following energy values, determine the AH- for sodium chlo Na (s) + 12 Cl2 (g) → NaCl (s) AHsub for Na: Bond Energy of Cl2: Lattice energy of NaCl: Ionization energy for Na: Electron Affinity of Cl: Na (s) → Na (g) Cl2 (g) → 2C1 (g) NaCl (s) → Na" (g) + C (g) Na (g...
1 answer
3. The following information is peuvided for AHC CA Cast 200.000 300.CO 10,000 Retail 500.000 6OXICO...
3. The following information is peuvided for AHC CA Cast 200.000 300.CO 10,000 Retail 500.000 6OXICO Beginning inventory Purchase Purchase discount Sales Sales retum Markup Markup cancellation Markdown Markdown cancellation 850,000 20,000 18,000 3.000 8.000 2.XX 2 Required: Compute the cost of endin...
1 answer
Question 2 1 pts In this situation, the image forms: Draw the dashed lines behind the...
Question 2 1 pts In this situation, the image forms: Draw the dashed lines behind the (A) To the left of C mirror (which indicate where it would look like the rays originate from if (B) Between C and the object viewed from the left side). Do this REGARDLESS of whether or not they (C) Between the obj...
1 answer
Can you combine #\log ( 2+ \frac { 3y } { x } + \frac { 4y ^ { 2} } { x ^ { 2} } ) - 2\log x#?
Can you combine #\log ( 2+ \frac { 3y } { x } + \frac { 4y ^ { 2} } { x ^ { 2} } ) - 2\log x#?...
1 answer
1. (20 points) A hollow sphere of radius r and mass m starts from rest and...
1. (20 points) A hollow sphere of radius r and mass m starts from rest and rolls down the mountainside and then up the opposite side, as shown in Figure 1. The initial height is Ho. The rough part prevents slipping while the smooth part has no friction. The horizontal surface is smooth. How high, in...
1 answer
Given is a decision payoff table and a Sub Decision Payoff Table. Use Minimax Regret as...
Given is a decision payoff table and a Sub Decision Payoff Table. Use Minimax Regret as an evaluation criterion to evaluate alternatives. Future Demands Alternatives Low Moderate High Small Facility 170 180 200 Medium Facility 160 200 220 Large Facility -40 210 310 Alternatives Wors...
1 answer
Small spheres of diameter 1.02 mm fall through 20°C water with a terminal speed of 1.00...
Small spheres of diameter 1.02 mm fall through 20°C water with a terminal speed of 1.00 cm/s. Calculate the density of the spheres. (Enter your answer to at least the nearest kg/m3.)...
1 answer
How much work must be done to bring three electrons from a great distance apart to...
How much work must be done to bring three electrons from a great distance apart to within 1.3x10^-10 m from one another (at the corners of an equilateral triangle)?...
2 answers
8. Find the instantaneous velocity of the particle described in Figure P2.1 at the following times:...
8. Find the instantaneous velocity of the particle described in Figure P2.1 at the following times: (a) t = 1.0 s, (b) t = 3.0 s, (c) t = 4.5 s, and (d) t = 7.5 s. x (m) 10 - 6 il -2 -4 -6 Figure P2.1 Problems 1 and 8....
1 answer
Submit a nursing care plan for the following, Patient admitted after falling in a grocery store...
Submit a nursing care plan for the following, Patient admitted after falling in a grocery store parking lot. His main concerns were that he would become very dizzy when changing positions because of post concussion syndrome and he needed assistance getting out of bed. He was fairly independent prior...
1 answer
This solenoid produces a uniform magnetic field as shown by the blue arrows in the figure....
This solenoid produces a uniform magnetic field as shown by the blue arrows in the figure. What direction does the current need to flow in order to create this field? Select one: a. It enters on the left and leaves on the right. b. It enters on the right and leaves on the left. c. Either A or B woul...
1 answer
For the reaction 2CH4(g)⇌C2H2(g)+3H2(g) K = 0.170 at 1633 ∘C . What is Kp for the...
For the reaction 2CH4(g)⇌C2H2(g)+3H2(g) K = 0.170 at 1633 ∘C . What is Kp for the reaction at this temperature? Express your answer numerically....
1 answer
You are the manager of a restaurant for a​ fast-food franchise. Last​ month, the mean waiting...
You are the manager of a restaurant for a​ fast-food franchise. Last​ month, the mean waiting time at the​ drive-through window for branches in your geographical​ region, as measured from the time a customer places an order until the time the customer receives the​ orde...
1 answer
How do you solve the following linear system: #x=6-4y , 2x-3y=1 #?
How do you solve the following linear system: #x=6-4y , 2x-3y=1 #?...
1 answer
5. Types of Economic Data For each of the following e whether the data are cross-section,...
5. Types of Economic Data For each of the following e whether the data are cross-section, time series or panel data. (a) Quarterly data on the level of U.S. new housing construction from 2000 to 2018. (b) Data on number of doctor visits in 2018 for a sample of 192 individuals. (c) Data on annual hea...