Accel Express, Inc., collected the following information on where to locate a warehouse (1= poor, 10 = excellent):%3DLocation ScoreLocation FactorFactor WeightAВConstruction costs10Utilities available1012Business services20810Real estate cost201Quality of lifeTransportation206.2206.a. Which location, A or B, should be chosen on the basis of the total weighted score?The total weighted score for location A isand the total weighted score for location B isso locationshould be chosen on the basis of the total weighted score. (Enter your responses as integers.)

The factor weight and the location score are provided, for each element. The location weighted…

Answered: Which location, A or B, should be…

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

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?
On the cost- volume analysis chart where the costs of two or more location alternatives have been plotted, the quantity at which two cost curves cross is the quantity at which:a) fixed costs arc equal for two alternative locations.b) variable costs are equal for two alternative locations.c) total costs are equal for all alternative locations.d) fixed costs equal variable costs for one location.c) total costs are equal for two alternative locations.
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?
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?
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.
The fixed and variable costs for three potential manufacturing plant sites for a rattan chair weaver are shown: Site Fixed Cost Per Year Variable Cost per Unit 1 $800 $12.00 2 $1,200 $5.00 3 $2,000 $3.00 a) After rounding to the nearest whole number, site 1 is best below units. After rounding to the nearest whole number, site 2 is best between and units. After rounding to the nearest whole number, site 3 is best above units. b) If the demand is 47 units, then the best location for the potential manufacturing plant is

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