Please help me solve this question. I am not sure which concept I should use. Thank you so much. Task 2: A manager has received an analysis of several cities being considered for a new office complex. The locationscores (out of 100) against these factors are:Location (Score)FactorABCCommunity services606080Business services606040Construction cost708060Cost of livingPersonal taxes906050806070Commuting ease607050Both 'community services' and 'personal taxes' have a weigh of 50 each. Construction costť's weight is 70. Each ofthe remaining factors has a weight of 100. How would the locations compare? Which location should be selected?

FACTOR A B C WEIGHT community services 60 60 80 50 business services 60 60 40 100…

Task 2: A manager has received an analysis of several cities being considered for a new office complex. The location scores (out of 100) against these factors are: Location (Score) Factor A В C Community services Business services 60 60 80 60 60 40 Construction cost 70 80 60 Cost of living 90 60 50 Personal taxes 80 60 70 Commuting ease 60 70 50 Both 'community services' and 'personal taxes' have a weigh of 50 each. Construction cost's weight is 70. Each of the remaining factors has a weight of 100. How would the locations compare? Which location should be selected?

Task 2: A manager has received an analysis of several cities being considered for a new office complex. The location scores (out of 100) against these factors are: Location (Score) Factor A В C Community services Business services 60 60 80 60 60 40 Construction cost 70 80 60 Cost of living 90 60 50 Personal taxes 80 60 70 Commuting ease 60 70 50 Both 'community services' and 'personal taxes' have a weigh of 50 each. Construction cost's weight is 70. Each of the remaining factors has a weight of 100. How would the locations compare? Which location should be selected?

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

objectives of location for tax planning for new business ?? please give more than 10 objectives please answer ASAP
Problem 8-11 A manager has received an analysis of several cities being considered for a new office complex. The data (10 points maximum) are as follows: Location Score Factor A B C Business services 8 6 6 Community services 7 6 7 Real estate cost 3 8 7 Construction costs 5 8 7 Cost of living 3 7 8 Taxes 5 5 4 Transportation 6 7 8 a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores? A / 7 B / 7 C / 7 Thus, (Click to select) A B C B and C A and B is the best. b. If business services and construction costs are given weights that are double the weights of the other factors, how would the locations stack up? A / 9 B / 9 C / 9 Thus, (Click to select) A B C A and B B and C is best and (Click to select) A B C A and B B and C…
The Office Place”. This start-up organization has done well and they are now planning to expand their business into a new area of the country. HR is being asked how soon they might be able to have the new site fully staffed. Currently, headquarters has: 100 customer service representatives and 10 managers and has been operational for 5 years. The new site will have 50 customer service representatives and 5 managers. The HR Manager continues to work on a strategic plan to fill positions in the new location. Part of the process is to analyze current sources for recruitment for the headquarters location. Determine the yield ratios for each source by reviewing the “Data” Based on the results, which of the resources would you recommend? Which sources should be eliminated? 1. Indeed 2. Zip Recruiter 3. LinkedIn 4. Facebook 5. Twitter 6. Colleges 7. Private Employment Agencies 8.…
A new medical facility, Health-Watch, is to be located in Erie, Pennsylvania. The following table shows the location factors, weights, and scores (1 = poor, 5 = excellent) for one potential site. The weights in this case add up to 100 percent. A weighted score (WS) will be calculated for each site. What is the WS for this site? Location Factor Weight Score Total patient miles per month Facility utilization Average time per emergency trip Expressway accessibility Land and construction costs Employee preferences 25 20 20 15 10 10 4 3 3 4 1 5
Can you explain the following question in full details. Please provide detail so I can understand the detail of the assignment. 4.8 We Rescue, Inc., a firm providing nationwide ambulance services, intends to expand its service range through a new branch in the suburbs of the mid-Atlantic region. The data were gathered to evaluate three different possible sites, Suburb A, Suburb B, and Suburb C, for the new location. The data include factor ratings, minimum satisfactory level, and importance rankings of each factor (attribute), as shown in Table EX 4.8. Attribute (factor) Weight Suburb A Suburb B Suburb C Satisfaction level Importance Ranking Contracting and Land Cost 0.1 65* 76 45 70 3 Labor Availability and cost 0.15 50 65 60 65 5 Transportation and road network 0.15 60 70 75 80 4 Supplier/ Support Service companies 0.13 75 60 65 85 6 Average time per Emergency trip 0.22 95 75 70 95 2…
A company desires to locate a new facility. Based on preliminary analysis, thechoice has been reduced to four locations: A, B, C, and D. These four locationswere rated on a scale from 1 worst to 10 best on each of four criteria. Eachcriterion was also weighted to indicate its importance (i.e., the higher theweight, the more important). The list of ratings and weights follows THE TABLE ATTACHED b- If the wights of weather and regulation be divided that the weatherwould be double of the regulations, what would be the best location. Please can you give me an answer with explanation.
Questions i. Calculate the weighted score for each alternative location. ii. Which location should be chosen?
A location analysis has been narrowed down to three locations. The management needs to select the best location. The critical success factors, their weights, and the ratings for each location are shown below: Location Location Location Factor Wt. A B C Labor Cost 0.3 80 85 75 Transportation Cost 0.2 85 85 60 Market Access 0.2 90 70 90 Raw Materials Cost 0.1 80 90 90 Utility Cost 0.2 75 90 75 a) The composite score for location A is ( )b) The best location is ( )
For the following scores 6, 1, 4, 2, 3, 4, 6, 6 find the: (d) What is the concern to use mean as measure of central location?
ABC Wants to choose the best location for its new aluminium plant. The manager of productions and operations has three possible locations to choose from. His assistant recommends that he use break-even analysis location technique to help determine which location is best based on costs. Design a numerical example in order to demonstrate to the Productions and Operations Manager how break-even analysis can be used in this Demonstrate to the OM manager how to go about choosing the best location using the numerical example you designed
Explain the a ssumptions behind the center-of-gravity method. How can the model be used in a service facility location?
Analyze Boeing strategy in the location selection and layout of the venue where the airplanesare manufactured