S7.6. Robin Dillon has recently accepted a new job in the Washing-ton, DC, area and has been hunting for a condominium to purchase.From friends and coworkers she has compiled a list of five possiblecondominium complexes that she might move into. The followingtable indicates the weighted criteria that Robin intends to use in herdecision-making process and a grade indicating how well each com-plex satisfies each criterion:on coneie OLCondominium ComplexesTysons Alexandria ManassasTerrace CommonsFairfaxDupontGardensLocation CriteriaWeights ForestFarmsPurchase price.30928575627980Neighborhoodlocation.1876639590Proximity to.127875768560Metro trainShopping.106580989275Security.107578909583Recreational.059690828193facilitiesDistance to job.058567957565Condo floor.058078869290planComplex size.056560928970

Answered: S7.6. Robin Dillon has recently…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

3. Consolidated Refineries, headquartered in Houston, must decide among three sites for the construction of a new oil-processing center. The firm has selected the six factors listed below as a basis for evaluation and has assigned rating weights from 1 to 5 on each factor: Factor 1 2 3 4 5 6 Factor Name Proximity to port facilities Power source availability and cost Workforce attitude and cost Distance from Houston Community desirability Equipment suppliers in area Rating Weight 5 3 4 2 2 3 Management has rated each location for each factor on a 1- to 100-point basis. Factor Location A Location B Location C 1 100 80 80 2 80 70 100 3 30 60 70 4 10 80 60 5 90 60 80 6 50 60 90 a. Which site will be recommended based on total weighted scores? b. If location B's score for Proximity to port facilities was reset at 90, how would the result change? c. What score would location B need on Proximity to port facilities to change its ranking?
Metro has initiated discussions on attracting rail service. A depot would need to be constructed, which would require $2.5million in land and $7.5 million in construction costs. Annual operating and maintenance costs (O&M) for the facility would be $150,000, and personnel costs would be an additional $110,000. Other assorted costs would be born by the railroad and federal authorities. Annual benefits (B) of the rail service are estimated as listed: $120,000 for Railroad annual payments, $25,000 for Rail tax charged to passengers, $20,000 for Convenience benefits to local residents, and $12,000 for Additional tourism dollars for Metro. Apply the B-C ratio method, with a MARR of 8% per year and 20 year study period, to determine if the rail service should be established. a. BC ratio=2.12, good project b. BC ratio=-1.76, good project c. BC ratio=1.69, good project d. BC ratio=0.14, not good project
A plastic manufacturing company is considering 2 alternative locations for a new facility. The management considered 2 alternatives: Sta. Rosa and Sta. Rita. The fixed costs for Sta. Rosa is Php1M and variable cost is Php25 per unit. On the other hand, the fixed costs for Sta. Rita is Php1.5M and variable cost is Php23 per unit. 1. If the company plans on producing 50,000 units which location would be more attractive? 2. At what volume the two alternatives equal in cost?
The Skulls, a student social organization, has two different locations underconsideration for constructing a new chapter house. Skull's president, a POM student, estimates that due to differing land costs, utility rates, etc., both fixed and variable costs would be different for each of the proposed sites, as follows: Location Annual Fixed Variable Alpha Ave $5000 $200 per person Beta Blvd $8000 $150 per person If it is estimated that thirty persons will be living in this new chapter house, which location should the Skulls select?
Develop a network showing the origin nodes, destinations, arcs, cost per arc, supply, and demand. Match the correct answer to each question. Warehouse A B C D City E City F City G City H Warehouse Supply. 0.51 0.21 0.52 0.41 4000 Question 1 0.31 Question 2 0.56 0.43 0.35 0.41 0.28 City Demand 4,400 3,000 6,500 4,700 Match the correct answer to the following questions: 1. What is the supply constraint for Warehouse D? 2. What demand constraint for City H? 0.32 0.54 0.33 4000 0.54 0.34 0.52 6300 6000 [Choose ] [Choose ] > >
b. A food manufacturer wants to locate a warehouse to serve its major customers. The customers, annual volume and the X and Y coordinates are shown in the table below. Customer Annual Volume X-Coordinate Y-Coordinate Judy inc 25 3 7 Zac Supermarket 13 5 2 Harry Inc. 6 8 4 Sky Productions 4 1 5 i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products
The Giant Farmer Company processes food for sale in discount food stores. It has two plants: one in Chicago and one in Houston. The company also operates warehouses in Miami, Florida; Denver, Colorado; Lincoln, Nebraska; and Jackson, Mississippi. Forecasts indicate that demand soon will exceed supply and that a new plant with a capacity of 8,000 cases per week is needed. The question is where to locate the new plant. Three potential sites are Buffalo, Atlanta, and Memphis. The two tables below give data on capacities, forecasted demand, and shipping costs that have been gathered. Plant Chicago Houston Capacity (cases per week) New plant Warehouse Plant Chicago Houston Buffalo (alternative 1) Atlanta (alternative 2) Memphis (alternative 3) For each alternative new plant location, determine the total cost of the shipping pattern that will minimize total transportation costs. Where should the new plant be located? If the new plant is located in Buffalo, the optimal cost is $ (Enter your…
K Subway, with more than 27,000 outlets in the U.S., is planning for a new restaurant in Buffalo, New York. Three locations are being considered. The following table gives the factors for each site. Factor Space Costs Traffic density Neighborhood income Zoning laws a) Based on the given information, the best location in Buffalo for Subway to open the new restaurant is Weight 0.25 0.25 0.20 0.15 0.15 Maitland 65 40 55 45 85 Baptist Church 75 85 85 70 20 Northside Mall 80 25 55 35 85 with a
Problem 8-10 Factor Initial cost Traffic Maintenance Dock space Neighborhood Location East #1 East #2 West Weight East #1 100 60 20 24 15 0 00 00 N West East #1 East #2 8 8 4 4 2 East #2 110 35 25 24 9 a. Using the above factor ratings, calculate the composite score for each location. West 110 35 Composite Score 25 13 11 b. Determine which location has the highest composite score:
Problem 8-4 (Algo) A company that produces pleasure boats has decided to expand one of its lines. Current facilities are insufficient to handle the increased workload, so the company is considering three alternatives, A (new location), B (subcontract), and C (expand existing facilities). Alternative A would involve substantial fixed costs but relatively low variable costs: fixed costs would be $285,000 per year, and variable costs would be $570 per boat. Subcontracting would involve a cost per boat of $2,570, and expansion would require an annual fixed cost of $59,000 and a variable cost of $1,040 per boat. a. Find the range of output for each alternative that would yield the lowest total cost. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to the nearest whole number.) A B с Answer is not complete. or to to more b. Which alternative would yield the lowest total cost for an expected annual volume of 70 boats? C. What other factors might be…
Marilyn Helm Retailers is attempting to decide on a location for a new retail outlet. At the moment, the firm has three alternatives: stay where it is but enlarge the facility; locate along the main street in nearby Newbury; or locate in a new shopping mall in Hyde Park. The company has selected the four factors listed in the following table as the basis for evaluation and has assigned weights as shown: Factor Description Hyde Park Factor Weight Present Newbury Location 1 Average community 0.30 40 60 50 income Community growth potential 2 0.15 20 20 80 Availability of public transportation 0.20 30 60 50 Labor availability, attitude, and cost 4 0.35 80 50 50 a) Based on the given information, the best location for Marilyn Helm Retailers is to open the new retail outlet in with a total weighted score of 3.
Subway, with more than 27,000 outlets in the U.S., is planning for a new restaurant in Buffalo, New York. Three locations are being considered. The following table gives the factors for each site. Factor Space Costs Traffic density Neighborhood income Zoning laws Weight 0.30 0.25 0.20 0.15 0.10 Maitland 60 40 55 50 75 Baptist Church 70 85 85 75 20 Northside Mall 75 25 60 45 90 a) Based on the given information, the best location in Buffalo for Subway to open the new restaurant is , with a total weighted score of (Enter your response rounded to two decimal places.) b) If the weights for Space and Traffic density are reversed, the best location in Buffalo for Subway to open the new restaurant will be weighted score of (Enter your response rounded to two decimal places.) with a total

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS