Using the grid technique, determine the least-cost location for the following problem: Using the grid technique, determine the least-cost location for the following problem:S1S2M1M2M3M4Tons2003200100100100100Rate0.400.7021121Grid Coordinates (H, V)2, 146, 102,210, 1414, 1814, 6Deliverables for this assignment:• Submit your work in an Excel spreadsheet, following the layout of Table 4-2, pg. 115• Type your name, course number, and title of assignment at the top of the spreadsheet• Clearly indicate the final solution: State the location of the optimal manufacturing plant location (in grid coordinates) within a full sentence below the calculation table.• Save your document as Ch4Assn_LASTNAMEObjective Alignment: C. Obj. 1

6 locations are given below: TonsRateGrid Coordinates(H)Grid…

Using the grid technique, determine the least-cost location for the following problem: S1 S2 M1 M2 M3 M4 Tons 200 3200 100 100 100 100 Rate 0.40 0.70 2 1 2 1 Grid Coordinates (H, V) 2, 14 6, 10 2,2 10, 14 14, 18 14, 6

Using the grid technique, determine the least-cost location for the following problem: S1 S2 M1 M2 M3 M4 Tons 200 3200 100 100 100 100 Rate 0.40 0.70 2 1 2 1 Grid Coordinates (H, V) 2, 14 6, 10 2,2 10, 14 14, 18 14, 6

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

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 Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.
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?
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?
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 ] > >
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…
Describe Strategic Importance of Location Decisions?
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.
For each of the location problems described, discuss which of the seven assumptions listed in this section are likely to be violated:b. Locating an international network of telecommunications facilities.