1. This is an individual assignment. As stated in the syllabus you must do your own work or you will fail the class. 2. You can use any software you wish to perform the analysis, but the assignment was designed under the assumption that you would be using the LINDO software used for LP in BA555. 3. The project is due at the beginning of class in week four (February 1).
The Darby Company manufactures and distributes meters used to measure electric power consumption. The company started with a small production plant in El Paso, Texas and gradually built a customer base throughout Texas. A distribution center (DC) was established in Ft. Worth, Texas and later as business expanded to the North, a second distribution center was established in Santa Fe, New Mexico.
The El Paso plant was expanded when the company began marketing its meters in Arizona, California, Nevada and Utah. With the growth of the West Coast business, the Darby Company opened a third distribution center in Las Vegas, Nevada and just two years ago opened a second manufacturing plant in San Bernardino, California.
Manufacturing costs differ between the company’s two production facilities. The cost of each meter produced at the El Paso plant is $10.50. The San Bernardino plant is more efficient and produces meters at $10.00 a unit.
Due to the company’s rapid growth, not much attention has been paid to the efficiency of the distribution system, but Darby’s management has decided that it is time to address this issue. The costs of shipping a meter from each of the plants to each of the three distribution centers is shown in Table 1.
Yearly production capacity is 30,000 units at the El Paso plant and 20,000 units at the San Bernardino plant. Note that no shipments are allowed from the San Bernardino plant to the Ft. Worth distribution center.
The company serves nine customer zones from the three distribution centers. The forecast of the number of meters needed in each customer zone for the following year is given in Table 2.
The Unit costs of shipping from each distribution center to each customer zone is given in Table 3. Note that some of the distribution centers can not serve certain customer zones.
In the current distribution strategy demand at the Dallas, San Antonio, Wichita and Kansas City customer zones is satisfied by shipments from the Ft. Worth DC. In a similar manner the Denver, Salt Lake City and Phoenix customer zones are served by the Santa Fe DC. And the Los Angles and San Diego customer zones are satisfied by the Las Vegas DC. To determine how many units to make at each plant, the customer demand forecasts are aggregated at the distribution centers and a transportation model is used to minimize the costs of shipping from the production plants to the distribution centers.
Issues the company wants you to address
1. If the company does not change its distribution strategy what will its manufacturing and distribution costs be for the following quarter? 2. Suppose the company is willing to change its distribution strategy so that customer zones could be served from any distribution center for which costs are available. Would this reduce total costs? If so by how much? Would you make this change? Please be sure to examine all supply chain implications beyond just direct dollars saved. 3. The company wants to explore the potential of direct shipping from the plants to certain customer zones. Specifically the shipping cost is $.30 per unit from San Bernardino to Los Angeles and $.70 from San Bernardino to San Diego. The cost for direct shipments from El Paso to San Antonio is $3.50 per unit. Should the company do direct shipping? If so on which routes? 4. In 3 years demand is expected to have increased 30% on average across all customers. At that time the company expects to have saturated the markets they presently serve (in other words additional growth will have...