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

Explain who do the following two methods of facility location differ in their purpose, scope, and application? Can these be used together on a problem? If yes, how: Factor rating method: Centroid method:
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.
What kind of location measure technique will be appropriate for you to keep track of continuous location information?
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.
What kinds of location decisions are appropriate for the use of locational cost-volume analysis?
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?
What major issues should be considered when determining a retail site location?
Discuss some of the consideration and factors that causes location decisions?
Problem 4
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?