Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City Fort Worth San Diego Minneapolis 55,000 71,000 75,000 75,000 Bindley has three plants that can produce the motors. The plants and production capacities are Boulder Macon Gary 110,000 80,000 165,000 Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000.) SHIPPED TO PRODUCED AT NEW YORK CITY FORT WORTH SAN DIEGO Boulder 6 14 Macon 25 17 Gary 9 21 1026 9 MINNEAPOLIS 13 10 14

Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City Fort Worth San Diego Minneapolis 55,000 71,000 75,000 75,000 Bindley has three plants that can produce the motors. The plants and production capacities are Boulder Macon Gary 110,000 80,000 165,000 Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000.) SHIPPED TO PRODUCED AT NEW YORK CITY FORT WORTH SAN DIEGO Boulder 6 14 Macon 25 17 Gary 9 21 1026 9 MINNEAPOLIS 13 10 14

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

During a major expansion in 2004, Douwalla’s Import Company developed a new processing line for which the delivered equipment cost was $1.75 million. This year, the board of directors decided to expand into new markets and expects to build the current version of the same line. Estimate the cost if the following factors are applicable: construction cost factor is 0.20, installation cost factor is 0.50, indirect cost factor applied against equipment is 0.25, and the total plant cost index has risen from 2509 to 3713 over the years.
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 ] > >
b. 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 i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products
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 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…
#4. The Pelican Company has four distribution centers (A, B, C, and D) that require 50,000, 40,000, 60,000 and 40,000 liters of diesel fuel, respectively, per month for their long-haul trucks. Three fuel wholesalers (1, 2 and 3) have indicated their willingness to supply as many as 60,000, 80,000, and 50,000 liters of fuel, respectively. The total cost (shipping and price) of delivering 1000 liters of fuel from each wholesaler to each distribution center is shown in the following table. Distribution center Wholesaler A B C D • 1 1700 1600 1600 1600 2 1500 1800 1600 1700 3 1800 1500 1800 1600 I. Determine the optimal solution. Check if all capacities have been exhausted and that all demands can be met with this solution. II. What is the total cost of the solution?
Problem 8-10 Factor Initial cost Traffic Maintenance Dock space Neighborhood Location East #1 East #2 West Weight East #1 100 60 20 24 15 0 00 00 N West East #1 East #2 8 8 4 4 2 East #2 110 35 25 24 9 a. Using the above factor ratings, calculate the composite score for each location. West 110 35 Composite Score 25 13 11 b. Determine which location has the highest composite score:
Problem 8-4 (Algo) A company that produces pleasure boats has decided to expand one of its lines. Current facilities are insufficient to handle the increased workload, so the company is considering three alternatives, A (new location), B (subcontract), and C (expand existing facilities). Alternative A would involve substantial fixed costs but relatively low variable costs: fixed costs would be $285,000 per year, and variable costs would be $570 per boat. Subcontracting would involve a cost per boat of $2,570, and expansion would require an annual fixed cost of $59,000 and a variable cost of $1,040 per boat. a. Find the range of output for each alternative that would yield the lowest total cost. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to the nearest whole number.) A B с Answer is not complete. or to to more b. Which alternative would yield the lowest total cost for an expected annual volume of 70 boats? C. What other factors might be…
Problem 1: A large pharmaceutical chain aims to build a new store to be able to deliver from it to the rest of the mid-west area. By now, three different locations have been selected. Some data about factors, weights and location are provided to make the selection. Locations Factor Weight Peoria Des Moines Chicago Closeness to markets 20 4 7 Labor costs 8 4 Taxes 15 9 7 Closeness to providers 10 10 10
Problem 8-9 (Static) Location Score Factor (100 points each) Weight A B Convenience 0.15 80 70 Parking facilities 0.20 72 76 Display area 0.18 88 90 90 Shopper traffic 0.27 94 86 Operating costs 0.10 98 90 Neighborhood 0.10 96 85 182820 C 60 92 80 82 75 1.00 Click here for the Excel Data File a. Using the above factor ratings, calculate the composite score for each location. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Location Composite Score A B 0
An auto company currently maintains plants in Cincinnati and Tulsa to supply two distributioncenters in Boston and Phoenix. The production and distribution costs, distribution demands aswell as facility capacities are given in the table attached. b) Using the intuitive lowest cost method, determines which of the candidate locations, inaddition to existing locations, gives the initial solution with a lower cost? c) Using the solutions obtained in b), identify which distribution center still faces a shortage. d) Suppose the company has chosen Houston as their third plant and would like to know the optimaltransportation strategy that minimizes overall costs by solving a minimum-cost flow problem.Terry has defined decision variables, represented as xij, to denote the number of items shippedfrom plant i to distribution center j wherei= C(Cincinnati), T(Tulsa), and H(Houston)j= B(Boston) and P(Phoenix)
Silky Industries is looking for a location for its second telephone remanufacturing facility. Two cities are under consideration. The two most important location factors are: Factor A “availability of resources” and Factor B “availability of customers.” However, the company is having great difficulty assigning relative weights to these factors. Location Factor Factor Weight Factor Scorefor Each City Blake Irmo A. Availability of resources 5 6 B. Availability of customers 10 7 Total 100 Assuming that the factor weights must sum to 100, what range of weights would make Blake the superior location?