Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Brue Lee is the Vice President of Purchasing for the consumer electronics division of the Major Electric Corporation ( MEC ) . The company recently
Brue Lee is the Vice President of Purchasing for the consumer electronics division of the Major Electric Corporation MEC The company recently introduced a new type of video camcorder that has taken the market by storm. Although Brue is pleased with the strong demand for this product in the market place, it has been a challenge to keep up with MECs distributors orders of this camcorder. His current challenge is how to meet requests from MECs major distributors in Pittsburgh, Denver, Baltimore, and Houston who have placed orders of and units, respectively, for delivery in months there is a month manufacturing and month shipping lead time for this product
MEC has contracts with companies in Hong Kong, Korea, and Singapore who manufacture camcorders for the company under the MEC label. These contracts require MEC to order a specified minimum number of units each month at a guaranteed per unit cost. The contracts also specify the maximum number of units that may be ordered at this price. The following table summarizes these contracts:
Monthly Purchasing Contract Provisions
Supplier
Unit Cost
Minimum Required
Maximum Allowed
Hong Kong
$
Korea
$
Singapore
$
MEC also has a standing contract with a shipping company to transport product from each of these suppliers to ports in San Francisco and San Diego. The cost of shipping from each supplier to each port is given in the following table along with the minimum required and maximum allowable number of shipping containers each month:
Monthly Shipping Contract Provisions
San Francisco Shipping Requirements
San Diego Shipping Requirements
Supplier
Cost per Container
Minimum Containers
Maximum Containers
Cost per Container
Minimum Containers
Maximum Containers
Hong Kong
$
$
Korea
$
$
Singapore
$
$
Under the terms of this contract, MEC guarantees it will send at least but no more than shipping containers to San Francisco each month, and at least but no more than shipping containers to San Diego each month.
Each shipping container can hold video cameras and will ultimately be trucked from the seaports on to the distributors. Again, MEC has a standing contract with a trucking company to provide trucking services each month. The cost of trucking a shipping container from each port to each distributor is summarized in the following table:
Unit Shipping Cost per Container
Pittsburgh
Denver
Baltimore
Houston
San Francisco
$
$
$
$
San Diego
$
$
$
$
As with the other contracts, to obtain the prices just given, MEC is required to use a certain minimum amount of trucking capacity on each route each month and may not exceed certain maximum shipping amounts without incurring cost penalties. These minimum and maximum shipping restrictions are summarized in the following table:
Minimum Required and Maximum Allowable Number of Shipping Containers per Month
Pittsburgh
Denver
Baltimore
Houston
Min
Max
Min
Max
Min
Max
Min
Max
San Francisco
San Diego
Brue is left with the task of sorting through all this information to determine the least cost purchasing and distribution plan to fill the distributors requests. But because he and his wife have tickets to the symphony for this evening, he has asked you to take a look at this problem and give him your recommendations at : tomorrow morning.
Create a network flow model for this problem. Hint: Consider inserting intermediate nodes in your network to assist in meeting the minimum monthly purchase restrictions for each supplier and the minimum monthly shipping requirements for each port.
Implement a spreadsheet model for this problem and solve it
What is the optimal solution?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started