Read the information below carefully to answer the subsequent questions (Use of MS Excel Solver Permitted)- A company has 4 plants and 4 distribution centers (DCs). The production and transportation costs per shipment (in thousands of Rupees) from each plant to each distribution center is given in the below- Demand Source Production and Transportation cost per 1000 units Supply Source Delhi Pune Hyderabad Kolkata Fixed Cost Capacity Delhi 211 232 238 299 7650 18 Pune 232 212 217 225 3500 Hyderabad 240 230 215 305 5000 Kolkata 300 280 270 255 2200 Demand 10 8 14 6 What would be the minimum total cost for the given problem? 24 24 27 22 22 22

Read the information below carefully to answer the subsequent questions (Use of MS Excel Solver Permitted)- A company has 4 plants and 4 distribution centers (DCs). The production and transportation costs per shipment (in thousands of Rupees) from each plant to each distribution center is given in the below- Demand Source Production and Transportation cost per 1000 units Supply Source Delhi Pune Hyderabad Kolkata Fixed Cost Capacity Delhi 211 232 238 299 7650 18 Pune 232 212 217 225 3500 Hyderabad 240 230 215 305 5000 Kolkata 300 280 270 255 2200 Demand 10 8 14 6 What would be the minimum total cost for the given problem? 24 24 27 22 22 22

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

ChapterC: Cases

Section: Chapter Questions

Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
13.2 A company manufactures component parts for machine tools in North America and ships them to Southeast Asia for assembly and sale in the local market. The components are shipped by sea, transit time averages 6 weeks, and the shipping costs $2700 per shipment. The company is considering moving the parts by air at an estimated cost of $7500; the shipment taking 2 days to get there. If inventory in transit for the shipment costs $125 per day, should they ship by air?
After applying the NWC Rule for the initial tableau of the given transportation model, evaluate the vacant cells. What is the cell which has the most negative evaluation value and what is the cell evaluation value? DESTINATION SOURCE DEMAND X Y N OX-R; 1 OY-S; -1 OX-S; -1 OY-S; -2 P 75 8 12 EI 11 Q 80 5 8 11 R 120 7 10 10 S 50 11 13 14 SUPPLY 100 125 100 325
4. In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,100 radials each year. In the past 2 years, 220 and 250, respectively were sold in fall, 360 and 300 in winter, 150 and 160 in spring, and 320 and 440 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,300 radials. Part 2 Based on next year's projected sales, the demand for each season is going to be (enter your responses as whole numbers): Season Demand Fall __________
What is the 3-month simple moving average for February 2017, given that demand was 100 during October 2016, 200 in November 2016, 300 in December 2016 and 400 in January 2017? a. 350 b. 300 c. 250 d. 400
d-Term Exam)_BUS 384 (page 15 of 20) 2316036-SUPPLY CHAIN AND LOGISTICS MANAG Soru 15 Logistics firms or divisions deliver goods from places of lower value to the customer to places where they Cevap are of higher value, which of the following does it provide? kaydedildi 5,00 üzerinden içaretlenmiş Lütfen birini seçin O a Ownership benefit P Soruyu igaretle Ob Structure benefit Oc Space benefit Od Shape benefit O e Time benefit Seçimimi Temızle Onceki sayfa Sonraki sayfa O O ||>
1. A company would like to develop an aggregate plan and evaluate its cost using the transportation method. Solve using Excel of the QM software. Note: do not do this manually Related data are shown in the tables below Demand forecast Period Demand (Unit) 1 80 2 90 3 40 Supply Capacity available (units) Regular time 40 65 30 Period 1 2 3 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
I would like you to help me with this question. please include the steps that you are dong Supply and Demand, inequality, feasible Region, Graphical LP
Weighted factor methodUse the table to calculate the most ideal X coordinate for supermarket Point Quantity offered/requested Transportation costs Coordinate X Coordinate Y Supermarket 1 3,000 0.04 4 8 Supermarket 2 3,500 0.04 7 2 Supermarket 3 2,000 0.07 3 5 Supermarket 4 1,500 0.07 7 4 Supermarket 5 1,200 0.07 6 8
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
Q2. Pharmaceutical company producing asingle product sold it through five agencies situated in different cities. All of sudden there rouse a demand for the product in another five cities that didn't agency of the company. The company is now facing the problem of deciding on how to assign the existing agencies in order to dispatch the product to needy cities in such a waythat the travelling distance is minimized. The distance between the surplus and deficit cities in kilometer is given the following table. Surplus city Deficit cities Deficit cites A1 160 130 115 190 200 B1 135 120 130 160 175 C1 140 110 125 170 185 D1 50 50 80 80 110 E1 55 35 80 80 105 Determine the optimum assignment schedule.
2) Using the cost table of the transportation problem shown below, do the following: a) Develop the appropriate LP model of the problem. WAREHOUSE PLANT A B C D DEMAND 1 5 10 7 20 200 2 3 12 5 25 400 3 8 10 10 18 600 4 7 8 12 30 1000 SUPPLY 200 500 300 1000