Case Studies

KanTech Corporation is a global distributor of electrical pans and components. Its customers are electronics companies in the United States, including computer manufacturers and audio/ visual product manufacturers. The company contracts to purchase components and parts from manufacturers in Russia. Eastern and Western Europe, and the Mediterranean, and it has them delivered to warehouses in three European posts. Gdansk. Hamburg, and Lisbon. The various components and parts are loaded into containers based on demand from U.S. customers. Each port has a limited fixed number of containers available each month. The containers are then shipped overseas by container ships to the ports of Norfolk. Jacksonville, New Orleans, and Galveston. From these seaports, the containers are typically coupled with Wicks and hauled to inland polls in Front Royal (Virginia). Kansas City, and Dallas. There are a fixed number of freight haulers available at each port each month. These inland ports are sometimes called "freight villages." or intermodal junctions, where the containers are collected and transferred from one transport mode to another (i.e.. from truck to mil or vice versa). From the inland ports, the containers are transported to KanTech's distribution centers in Tucson. Pittsburgh, Denver, Nashville, and Cleveland. Following are the handling and shipping costs ($/container) between each of the embarkation and destination points along this overseas supply chain and the available containers at each port:

Formulate and solve a linear programming model to determine the optimal shipment from each point of embarkation to each destination along this supply chain that will result in the minimum total shipping cost.

Case Study Group Assignments with Excel QM -

The Question:

Dr. Maureen Becker, the head administrator at Jefferson County Regional Hospital, must determine a schedule for nurses to make sure there are enough nurses on duty throughout the day.  During the day, the demand for nurses varies.  Maureen has broken the day into 12 two-hour periods.  The slowest time of the day encompasses the three periods from 12:00 A.M. to 6:00 A.M., which, beginning at midnight, require a minimum of 30, 20, and 40 nurses, respectively.  The demand for nurses steadily increases during the next four daytime periods.  Beginning with the 6:00 A.M. - 8:00 A.M. period, a minimum of 50, 60, 80, and 80 nurses are required for these four periods, respectively.  After 2:00 P.M. the demand for nurses decreases during the afternoon and evening hours.  For the five two-hour periods beginning at 2:00 P.M. and ending at midnight, 70, 70, 60, 50, and 50 nurses are required, respectively.  A nurse reports for duty at the beginning of one of the two-hour periods and works eight consecutive hours (which is required in the nurses' contract).  Dr. Becker wants to determine a nursing schedule that will meet the hospital's minimum requirements throughout the day while using the minimum number of nurses.

Problem Description

The problem is summarized by a need from an administrator of a hospital to prepare a nursing schedule in order to make sure that there are enough nurses available during the day.

Dr. Maureen Becker analysis showed that the day can be divided into a 12 (2) hours periods to determine the demand for nurses. The analysis showed the following findings:

• From 12:00 A.M. to 6:00 A.M. required a minimum of 30, 20, and 40 nurses, respectively.
• From 6:00 A.M. - 8:00 A.M. required a minimum of 50, 60, 80, and 80 nurses.
• From 2:00 P.M. and ending at midnight required 70, 70, 60, 50, and 50 nurses.

Taking into consideration that the each nurse work for an eight consecutive hours.

Attachment:- Assignment Files.rar