Susan Helms Manufacturing Co. has hired you to analyze its shipping costs from the existing three factories to five warehouses. These factories have produced 1900, 1420 and 2050 units, respectively, and these units will be all shipped out to the warehouses. There are five warehouses, each located in a different region. According to the sales in the retail stores in these five regions, the minimum demands each warehouse is expected to meet are 900, 1500, 600, 800, and 1100 units, respectively, for next month. The table below shows the information of the above-mentioned demands and produced units, and freight costs (per unit) between each factory and each warehouse. Due to the recent active markets, the management indicated that the warehouse should plan its orders to the factories to receive at least 20% more than the minimum demand it has to meet. If it is not possible for all warehouses to meet this expectation, you should have as many warehouses as possible that meet such expectation. With the above management’s expectation, what is the most shipping cost-effective shipping schedule (showing the shipping quantities on each shipping lane, i.e., the cells below in cream color) for next month? What is the resulting shipping cost from this optimal solution? (Solver is required)
| TABLE | ||||||
| Warehouse 1 | Warehouse 2 | Warehouse 3 | Warehouse 4 | Warehouse 5 | Units to ship out | |
| Factory 1 | $7 | $10 | $8 | $12 | $14 | 1900 |
| Factory 2 | $9 | $8 | $11 | $8 | $10 | 1420 |
| Factory 3 | $10 | $9 | $9 | $8 | $11 | 2050 |
| Min. demand | 900 | 1500 | 600 | 800 | 1100 |
| Warehouse 1 | Warehouse 2 | Warehouse 3 | Warehouse 4 | Warehouse 5 | |
| Factory 1 | |||||
| Factory 2 | |||||
| Factory 3 |
In today’s fast-paced business environment, efficient supply chain management is crucial for companies looking to maintain a competitive edge. One significant aspect of this management is minimizing shipping costs while meeting the demands of retail stores in various regions. For Susan Helms Manufacturing Co., this means finding the most cost-effective shipping schedule that also aligns with the management’s expectations.
To tackle this challenge, we’ll employ mathematical optimization techniques and a linear programming solver to create an optimal shipping schedule. This schedule should ensure that each of the company’s five warehouses receives at least 20% more units than its minimum demand, and all while minimizing shipping costs.
The essential data for this task is laid out in a table, which includes the costs of shipping per unit between each factory and each warehouse, the production quantities from each factory, and the minimum demand for each warehouse. Our goal is to optimize the transportation of goods in a way that not only satisfies the increased demand but also does so in the most cost-effective manner.
To achieve this, we will introduce decision variables representing the quantities to be shipped from each factory to each warehouse. For instance, Xij represents the quantity shipped from Factory i to Warehouse j. The objective function is designed to minimize the total shipping cost, which is calculated as the sum of the product of Xij and the corresponding shipping cost.
The constraints for this optimization problem include ensuring that each factory ships all of its produced units, that each warehouse receives 20% more than its minimum demand, and that all shipment quantities are non-negative. These constraints create a balanced and efficient allocation of resources.
By utilizing a linear programming solver, we can quickly and accurately find the optimal solution. The solver will provide the exact shipping quantities for each shipping lane and the resulting minimum shipping cost. This approach not only ensures that all warehouses meet their increased demand but also does so while minimizing transportation costs.
In conclusion, this mathematical optimization approach empowers Susan Helms Manufacturing Co. to make informed decisions about its shipping schedule. By doing so, the company can save on costs, allocate resources efficiently, and meet the expectations of the management. It’s a win-win situation, allowing the company to thrive in a competitive market.
In today’s competitive business landscape, efficient supply chain management is vital. By optimizing shipping costs and adhering to the management’s expectations, Susan Helms Manufacturing Co. can stay ahead of the curve and continue to provide for its retail stores in different regions.
As a renowned provider of the best writing services, we have selected unique features which we offer to our customers as their guarantees that will make your user experience stress-free.
Unlike other companies, our money-back guarantee ensures the safety of our customers' money. For whatever reason, the customer may request a refund; our support team assesses the ground on which the refund is requested and processes it instantly. However, our customers are lucky as they have the least chances to experience this as we are always prepared to serve you with the best.
Plagiarism is the worst academic offense that is highly punishable by all educational institutions. It's for this reason that Peachy Tutors does not condone any plagiarism. We use advanced plagiarism detection software that ensures there are no chances of similarity on your papers.
Sometimes your professor may be a little bit stubborn and needs some changes made on your paper, or you might need some customization done. All at your service, we will work on your revision till you are satisfied with the quality of work. All for Free!
We take our client's confidentiality as our highest priority; thus, we never share our client's information with third parties. Our company uses the standard encryption technology to store data and only uses trusted payment gateways.
Anytime you order your paper with us, be assured of the paper quality. Our tutors are highly skilled in researching and writing quality content that is relevant to the paper instructions and presented professionally. This makes us the best in the industry as our tutors can handle any type of paper despite its complexity.
Recent Comments