Four hospitals (1, 2, 3, 4) have their requirements for blood met through a central blood distribution office that coordinates deliveries from three blood banks (A, B, and C) on a weekly basis. The costs to ship a standard pouch of blood from each blood bank to each hospital are reported in the table below. The table also provides, for an upcoming week, the weekly number of pouches available at each blood bank and the number of pouches required, i.e. the demand, at each hospital. Blood Bank A B с Demand Hospital 1 2 3 $4 $6.5 $4.9 $6.9 $5.1 $4.5 4 $5.5 $2 $2.5 $3.4 $6 $5.5 80 240 100 190 Pouches Available 150 200 320 Develop the optimization model that obtains an optimal shipment plan that ensures that capacities at warehouses are not violated and demands are met exactly. Compute the optimal shipment cost by solving the model using an optimizer such as EXCEL's Solver. (Specify as a whole number)

Four hospitals (1, 2, 3, 4) have their requirements for blood met through a central blood distribution office that coordinates deliveries from three blood banks (A, B, and C) on a weekly basis. The costs to ship a standard pouch of blood from each blood bank to each hospital are reported in the table below. The table also provides, for an upcoming week, the weekly number of pouches available at each blood bank and the number of pouches required, i.e. the demand, at each hospital. Blood Bank A B с Demand Hospital 1 2 3 $4 $6.5 $4.9 $6.9 $5.1 $4.5 4 $5.5 $2 $2.5 $3.4 $6 $5.5 80 240 100 190 Pouches Available 150 200 320 Develop the optimization model that obtains an optimal shipment plan that ensures that capacities at warehouses are not violated and demands are met exactly. Compute the optimal shipment cost by solving the model using an optimizer such as EXCEL's Solver. (Specify as a whole number)

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. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
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?
The new software organization requires a new point of sale and stock control system for their many stores throughout Pakistan to replace their aging mini-based systems. A sales assistant will be able to process an order by entering product numbers and required quantities into the system. The system will display a description, price, and available stock. In-stock products will normally be collected immediately by the customer from the store but may be selected for delivery to the customer's home address for which there will be a charge. If stock is not available, the sales assistant will be able to create a backorder for the product from a regional warehouse. The products will then either be delivered directly from the regional warehouse to the customer's home address, or the store for collection by the customer. The system will allow products to be paid for by cash or credit card. Credit card transactions will be validated via an online card transaction system. The system will produce…
Suppliers A, B, and C supply components to three plants -- F, G, and H via two transshipment facilities -- T1 and T2. It costs $4 to ship from T1 regardless of final destination and $3 to ship to T2 regardless of supplier. Shipping to T1 from A, B, and C costs $3, $4, and $5, respectively, and shipping from T2 to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. The Logistics Manager has come to you for help. Answer the following question: Which of these is not an element of the objective function? Group of answer choices 4D-T1 600T1 9T2-G 3C-T2 Plz do fast asap
draw a Business Process Modeling Notation (BPMN) for each process with a brief explanation of the process flow.Major components of Logistics Management:1. Production Management2. Sales and Distribution
XYZ pharmaceutical company has the following situation involving the processing of purchases transaction, were the outside entities are suppliers (who receive purchase orders and ship ordered goods with packing slip), the inventory control department (which prepares requisition related to the needed goods), the store room( which accepts received goods from the receiving department together with receiving reports), and the cash disbursements department ( which receives approved suppliers invoices, together with supporting purchase orders and receiving reports), and management (which receives purchase analysis reports from purchasing ) Required: Draw a context diagram (data flow diagram) for the situation
CASE:Reducing New Product Stockouts at ColesYou have been employed in the supply chain management organization of Coles for the past two years.You are very excited when you are asked to join a team being formed to address serious inventory management problems often associated with the introduction of new products. Too often, customers who make a trip to Coles to purchase a highly advertised new product are disappointed to find the store is out of stock of that particular item. Such stockouts result in lost sales for both Coles and the product supplier and the potential loss of customers as shoppers look elsewhere to find the new product. The resulting loss of customer goodwill can have a long-term effect on sales. Solving this problem will require a balancing act; the company needs to carry sufficient inventory of new products to meet customer demand while avoiding excessive inventory levels that increase costs. The team you have joined consists of nine people representing the finance,…
Adelie Enterprises is exploring a new service to provide weekly delivery of grocery items to homes in the greater Greenwood area. The company’s customers place Web-based orders and Adelie’s team assembles and delivers the orders in specially designed cardboard boxes. Management, interested in locating a supplier that can provide boxes cheaply and efficiently, has discovered that each potential supplier’s ability to satisfy the company’s requirements is influenced by the level of demand. The following table provides Adelie’s vendor selection criteria, criterion weights, and rankings (1–10 with 10 being the highest) under the assumption that low, moderate,or high demand is generated for their service.a. Which supplier should be selected if there is low demand for Adelie’s new service? Which supplier should be selected under moderate demand assumptions? Under high demand assumptions?b. Which supplier is selected if Adelie evaluates each alternative using a Maximin decision criterion (see…
For this assignment, you will be required to identify a research topic that is relevant to Logistics and supply chain management.You will not be able to start the assignment until you understand what we mean by “research” in Introduction to Research, as you have probably understood the concept differently in previous modules and assignments. You will create a short, catchy title for the proposed research and describe the background and context in which the research would take place. You will need to formulate and present the research problem in such a way that the reader understands why this research is worth doing and why it is a manageable, specific problem that has not been researched before. This will require additional study and extensive reading. Once you have a well-developed research problem, you will describe the relevance of the research and formulate research question/s, explaining what outcomes you expect if you were to conduct the research. A relevant theory will need to…
Describe the types of data that are commonly used in conventional logistics measurement systems.
Valles Galactic Industries (VGI) owns a small company (VGI-Durango Sur) that manufactures various electronic products for original equipment manufacturers. Customer companies provide engineering designs, materials lists, and some unique materials. VGI-DS provides labor and space for the manufacturing and assembly operations and stocking a variety of inventory items for production, such as wire, cables, some electronic components, etc. Thus, VGI-DS orders a variety of components and raw materials by contract. The labor pool is primarily composed of about 100 retirees picking up extra cash by working four to six-hour shifts. Thus, the assembly operations must be simple and easy to teach. Skilled employees must do several raw material conversions for packaging—there are currently three such employees. VGI-DS receives forecasts from VGI headquarters for planned production for two years on a rolling quarterly basis. Staff at VGI-DS develop schedules and inventory plans based on this…
eCabs is a newly created taxi service company that provides online booking for clients in the Lusaka province. eCabs has considered developing a simple website for an online booking System with the capability to enable clients access from their mobile devices and to book for a trip. At the time of their first booking, clients should be able to enter their details into an online form, along with their credit card details. However, clients can also have an account with eCabs and for any subsequent bookings, they can log in to their own account and make a booking for a taxi. They need to be able to enter their trip origin and destination. The system will give them an estimate of cost according to their trip description. Assuming you have been assigned to design and develop the system for eCabs. You are given three weeks to come up with a blueprint of the system design and present the design to a team of consultants. The online booking System should be able to perform a number of…