Find the initial basic feasible solution by (i) north west corner rule (ii) lowest cost entrymethod (iii) Vogel's approximation method of the following transportation problem:RIOTITIONSR1R2R3R4Requirement3RZ1536421Z21847341257-85-25-Z3354417Z4343217Capacity3415121980

The transportation problem deals with finding the most cost-effective way to distribute a product…

Answered: Find the initial basic feasible…

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

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.
#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…
2 For a destination region with which you are familiar, conduct a critical analysis of VIC provision. . Consider the location (s) involved, the appropriateness of the buildings, the level of staffing, the services available and the hours of operation. What improvements would you suggest?
1. A company would like to develop an aggregate plan and evaluate its cost using the transportation method. Develop the aggregate for them. Solve using Excel Related data are shown in the tables below Demand forecast Period Demand (Unit) 1 Period 1 2 3 2 3 80 90 40 Supply Capacity available (units) Regular time 40 65 30 Other Data Beginning Inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost Overtime 20 12 10 30 R 100 R 150 R 200 R 5 Subcontract 10 5 5
Rauschenberg Manufacturing is investigating which locations would best position its new plant relative to three important customers (located in cities A, B, and C). As shown in the table below, all three customers require multiple daily deliveries. Management limited the search for this plant to those three locations and compiled the following information: Location Coordinates (miles) Deliveries per day (200,100) (300,100) (300,300) A 9 B 5 7 a. Which of these three locations yields the smallest load-distance score, based on Euclidean distances? Location V yields the smallest load-distance score of : (Enter your response rounded to one decimal place.)
Determine the suitable location of a distribution centre with the below data, minimizing the transportation dollars spent on managing inbound and outbound shipments. Plot the location of the Vendors, Customers and the location of the new DC in a chart Vendor V1 V2 V3 V4 Customer C1 C2 C3 C4 Rate $ per Ton Mile $ $ $ $ 4.75 3.75 3.15 4.75 Rate $ per Ton Mile $ $ $ $ 3.50 3.75 4.25 5.00 Volume in Tons 1000 1000 1600 1400 Volume in Tons 760 640 800 500 Vendor Location Coordinates (miles) Horizontal 525 600 412.5 300 Vertical 300 750 750 630 Customer Location Coordinates(miles) Vertical 450 900 1050 975 Horizontal 900 900 825 1050
Q3b) Ghana Post has established various truck and air routes around the country over which it ships parcels. The holiday season is approaching, which means a dramatic increase in the number of packages that will be sent. The service wants to know the maximum flow of packages it can accommodate (in tons) from station 1 to station 6. The network of routes and the flow capacities (in tons of packages per day) along each route are shown in the following network: 1 ∞ 10 5 2 3 3 6 4 4 5 0 9 nter 0 5 0 6 6 You are to determine the maximum tonnage of packages that can be transported per day from station 1 to station 6 and indicate the flow along each branch + 00 0
A valve manufacturer is considering three alternative locations for a new plant for manufacturing ball valves for oil and gas industry. Since the plant ships nationwide, revenue is assumed the same regardless of plant location. The estimated annual fixed and variable costs for each site is shown in TABLE Location Costs A B C Fixed (RM) 700,000 1,000,000 $1,500,000 Variable (RM) $28 $18 $12 Identify the range of output for which each location provides the lowest total cost. Show necessary graph and calculation used in the analysis. Discuss on the finding(s).
(C) to four distribution centres. The following table shows the cost per (in RM), capacity, and demand for the company. To Distribution Centre Сарacity From F G H 8. 7 11 10 150 11 8. 9. 11 100 Demand 70 60 90 30 (a) Find an initial solution. (b) Determine an optimal solution and the minimum transportation cost. (c) Is there an alternative optimal solution? 5. Man Yee Company manufactures printers in two factories and ships them to three distribution centres. The following table shows the cost (RM) per um capacity, and demand for the company.

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

Find the initial basic feasible solution by (i) north west corner rule (ii) lowest cost entry method (iii) Vogel's approximation method of the following transportation problem: RIOTYVAS ap R1 R2 R3 R4 Requirement Z1 5 3 6 4 21 Z2 1 3 4 1 25 Z3 3 5 4 4 17 Z4 3 4 3 2 17 Capacity 34 15 12 19 80