help Wefixit Co. has just signed a contract to handle copy machine repairs for a large printing company in Chicago. The contract coverscopy machines at four locations: in the Loop (downtown), on the North side, on the West side, and on the South side. Wefixit hasidentified two potential sites for housing their equipment, spare parts, and employees. One site is Northwest of the Loop, and theother on is south of the Loop. The x, y coordinates for the printing company locations and potential sites for Wefixit are as follows:TypeLocationx coordinatey coordinatePrinting Co.Loop2418Printing Co.North side1927Printing Co.West side1119Printing Co.South side2711WefixitNorthwest of Loop1823WefixitSouth of Loop2416The estimated number of trips per year to each Printing Co. location is: 400 to Loop, 200 to North side, 200 to West side and 100 toSouth side.(a)Calculate the total load-distance value from each potential Wefixit location.Total load-distance value for Northwest of LoopTotal load-distance value for South of Loop

Answered: Calculate the total load-distance value…

Calculate the total load-distance value from each potential Wefixit location. Total load-distance value for Northwest of Loop Total load-distance value for South of Loop

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

Katie Reynolds owns two exclusive women's clothingstores in Miami. In her plan to expand to a third location,she has narrowed her decision to three sites- one in a downtownoffice building, one in a shopping mall, and one in anold Victorian house in the suburban area of Coral Gables. Shefeels that rent is absol utely the most importa nt factor to beconsidered, although walk-in traffic is 90% as important asrent. Further, the more distant the new store is from her twoexisting stores, the better. She weights this factor to be 80%as important as walk-in traffic. Katie developed the followingtable, in which she graded each site from A to D, with A beingbest. Which site is preferable?
Don Levine Corporation is considering adding an additional plant to its three existing facilities in Decatur, Minneapolis, and Carbondale. Both St. Louis and East St. Louis are being considered. Evaluating only the transportation costs per unit as shown in the tables below, which site is best? FROM EXISTING PLANTS TO DECATUR MINNEAPOLIS CARBONDALE DEMAND Blue Earth $20 $17 $21 250 Ciro 25 27 20 200 Des Moines 22 25 22 350 Capacity 300 200 150 FROM PROPOSED PLANTS TO EAST ST. LOUIS ST. LOUIS Blue Earth $29 $27 Ciro 30 28 Des Moines 30 31 Capacity 150 150
Peggy Lane Corp., a producer of machine tools, wants to move to a larger site. Two alternative locations have been identified: Bonham and McKinney Bonham would have fixed costs of $780,000 per year and variable costs of $15,000 per standard unit produced McKinney would have annual fixed costs of $920,000 and variable costs of $13,800 per standard unit. The finished items sell for $30,000 each. a) The volume of output at which both the locations have the same profit = standard units (round your response to the nearest whole number). b) Based on the analysis of the volume, after rounding the numbers to the nearest whole number, Bonham is superior below c) Based on the analysis of the volume, after rounding the numbers to the nearest whole number, McKinney is superior above d) The break-even point for Bonham is The break-even point for McKinney is units. (Enter your response rounded to the nearest whole number) units. (Enter your response rounded to the nearest whole number) standard…
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.
Describe fixed and random systems for assigning locations to SKUs.
William Green, vice president of manufacturing for computer products (CPC), and his staff are studying three midwestern alternative locations for a new production facility for producing high-resolution scanners. His staff analysts predict that the scanners will be a growing market over the next ten years, and the analyst's group shares marketing's enthusiasm for planning facilities for producing this new product line. The analysts have developed these estimates for the three locations; In what range of production volume would each of the locations be preferred (at the minimum cost)? Variable cost locations Annual Fixed costs per scanner Cleveland, Ohio $390,000 $34 South Bend, Indiana $360,000 $37 Grand Rapids, Michigan $310,000 $40
PetSmart and PetCo are two major competitors offering pet supplies and pet food. Given the location decisions of PetSmart and PetCo in this city, you conclude that: a. PetSmart focuses on raising its quantity sold rather than raising its profit margin on each unit. b. PetSmart and Petco engage in intense price undercutting. c. PetSmart and PetCo differentiate themselves by location. d. PetCo chose its location primarily using demand side considerations.
The owner of Genuine Subs, Inc., hopes to expand the present operation by adding one new outlet.She has studied three locations. Each would have the same labor and materials costs (food, servingcontainers, napkins, etc.) of $1.78 cents per sandwich. Sandwiches sell for $2.43 each in all locations.Rent and equipment costs would be $5,000 per month for location A, $6,500 per month forlocation B, and $5,800 per month for location C.a. Determine the volume necessary at each location to realize a monthly profit of $10,000.b. If expected sales at A, B, and C are 22,000 per month, 21,000 per month, and 20,000 per month,respectively, which location would yield the greatest profits?
Mick Karra is the manager of MCZ Drilling products which produces a variety of especially valves for oil field equipment. Recent activity in the oil fields has cause demand to increase drastically, and a decision has been made to open a new manufacturing facility. Three locations are being considered, and the size of the facility would not be the same in each location Thus, overtime might be necessary at times. The folowing table gives the total monthly cost (in 1000s) for each possible location under each demand posibility. The probabilities for the demand levels have been determined to be 20% for low demand, 30% for medium demand, and 50% for high demand Demand is Low Demand is medium Demand is High Ardmore, OK 85 110 150 Sweetwater, TX 90 100 120 Lake Charles, LA 110 120 130 (a) Which location would be selected based on the optimistic criterion? (b) which location would be selected based on the pessimistic criterion? (c) which location would be selected based on the…
Problem 8-2 The owner of Genuine Subs, Inc., hopes to expand the present operation by adding one new outlet. She has studied three locations. Each would have the same labor and materials costs (food, serving containers, napkins, etc.) of $1.70 per sandwich. Sandwiches sell for $2.50 each in all locations. Rent and equipment costs would be $5,050 per month for location A, $5,570 per month for location B, and $5,740 per month for location C. a. Determine the volume necessary at each location to realize a monthly profit of $9,500. (Do not round intermediate calculations. Round your answer to the nearest whole number.) Location Monthly Volume A B C b-1. If expected sales at A, B, and C are 20,800 per month, 22,100 per month, and 23,300 per month, respectively, calculate the profit of the each locations? (Omit the "$" sign in your response.) Location Monthly Profits A $ B $ C $ b-2. Which…
Amazon had planned to open a second headquarters in Brooklyn that would have allegedly added 25,000 jobs to the region, increased property values, generated more business for local store owners, and generated additional sales and income tax revenue for the government. Some people were concerned, however, that increased home prices could lead to higher rent for people who rented apartments in Brooklyn. Which of the following statements are true? O Allowing Amazon to locate its second headquarters in Brooklyn is a Pareto improvement (i.e., makes one or more persons better off without making anyone worse off) even if some renters will have to pay higher rent. O Allowing Amazon to locate its second headquarters in Brooklyn would not be Kaldor-Hicks efficient if some renters will have to pay higher rent. O Allowing Amazon to locate its second headquarters in Brooklyn is a Kaldor-Hicks improvement if the gain in jobs and tax revenue more than offsets any losses experienced by renters. O…
Problem 3: Regional Office Coordiantes (x,y) N Tampa Post Office must be relocated by other in a new location, much bigger and modern, to be able to absorb the huge mail flow. Ybor City -10,5 3 Davis Island -3,8 Dale-Mabry Given received and delivered mailing, is transported from regional offices to the central office, the new location can produce significant differences about the deliverance efficiency, as in terms of cost as time. Using the data represented in the attached table, calculate the location for the new facilities as the center of -4,7 Palma Cela -15,1 Bayshore -13,3 Temple Terrace -1,12 Hyde Park N = Number of delivery trucks per day -5,5 10 gravity.