a. Which location, A or B, should be chosen on the basis of the total weighted score?b. If the factors were weighted equally, would the choice change? Accel Express, Inc., collected the following information on where to locate a warehouse (1 poor, 10 = excellent):Location ScoreLocation FactorFactor Weight3.Construction costsUtilities availableBusiness servicesReal estate cost1010101010301010Quality of lifeTransportation3010a. Which location, A or B, should be chosen on the basis of the total weighted score?integers)The total weighted score for location A is and the total weighted score for location Bis so location B should be chosen on the basis of the total weighted score. (Enter your responsesb. If the factors were weighted equally, would the choice change?O A. Yes, location B would be the best choice.O B. Yes, because the two locations would be tiedO C. No, location B would still be the best choice.O D. No, location A would still be the best choiceO E. Yes, location A would be the best choice.

Accel Express, Inc, collected the following information on where to locate a warehouse (1 poor, 10 excellent) Location Score Location Factor Factor Weight 10 Construction costs Usilities avalable Business services 10 10 10 10 10 10 Real estate cost Quality of life Transportation 30 30 10 7. a. Which location, A or B, should be chosen on the basis of the total weighted score? The total weighted score for location Aisand the total weighted score for location B is so location B should be chosen on the basis of the total weighted score. (Enter your responses as integers) b. If the factors were weighted equally, would the choice change? OA. Yes, location B would be the best choice OB. Yes, because the two locations would be tied OC. No, location B would stil be the best choice O D. No, location A would still be the best choice O E. Yes, location A would be the best choice.

Accel Express, Inc, collected the following information on where to locate a warehouse (1 poor, 10 excellent) Location Score Location Factor Factor Weight 10 Construction costs Usilities avalable Business services 10 10 10 10 10 10 Real estate cost Quality of life Transportation 30 30 10 7. a. Which location, A or B, should be chosen on the basis of the total weighted score? The total weighted score for location Aisand the total weighted score for location B is so location B should be chosen on the basis of the total weighted score. (Enter your responses as integers) b. If the factors were weighted equally, would the choice change? OA. Yes, location B would be the best choice OB. Yes, because the two locations would be tied OC. No, location B would stil be the best choice O D. No, location A would still be the best choice O E. Yes, location A would be the best choice.

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

An operations manager has narrowed down the search for a new King Kola plant to three locations. Fixed and variable costs follow. Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 Plot the total cost curves in a line chart and identify the range over which each location would be best.
Brian Trump has obtained fixed- and variable-cost information for four potential sites for his professional wrestling school and summarized it in tabular form below. All values are in dollars. Site Fixed Cost Variable Cost A 10,000 24 B 12,000 20 C 14,000 18 D 16,000 17 Brian plans to charge the same amount for tuition regardless of where he decides to establish his school. If he believes that 700 students will matriculate each year, which site will result in the lowest total cost?
Identify and clarify seven key factors affecting decision on the location?
In deciding on where to locate their next grocery store, Publix narrowed it down to 3 locations (St. Augustine, the Airport area, or the Westside). They are using 2 criteria to make their decisions costs (with a weight of 70%) and customer base (with a weight of 30%). Each item was scored on a 10-point scale with 10 being the highest. St. Augustine rated a score of 4 for cost and 10 for customer base; the Airport area rated a score of 6 for cost and 5 for the customer base, and the Westside rated a score of 8 for cost and 2 for the customer base. __________ 2a. What is the computed mean score for each of the 3 locations? __________ 2b. Which location should be chosen based on the highest score?
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?
The following table shows the fixed cost and variable cost for 3 locations. Construct cost curves for these 3 locations for production from 0 to 200 units at 20 units intervals. What would be the range of production units that would give Location A a competitive advantage? What would be the range for Location B and Location C, respectively?
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:
Describe Strategic Importance of Location Decisions?
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
2. Garysburg Fire Rescue (GFR) is considering three different locations for a new fire station. Using factor rating, GFR has created the following table. When rating these locations, GFR used a 5- point scale, where 1 means unfavorable and 5 means excellent. (Noteshaper Scenario #26) Factor Weight Location 1 Location 2 Location 3 Cost of land 0.5 4 1 Accessibility 0.3 2 2 4 Size of Land 0.2 1 3 3 a. Which of the following statements are true and which are false? I. The cost of the available land parcel is of the greatest importance in this analysis. I. Location 2 has better accessibility than location 3. GFR considers the size of the available land parcel to be the least important III. factor.