Udemyalles

Cadena de suministro: Diseño de una red logística con Solver

Optimize your supply chain with Excel Solver! Learn to solve real-world problems and interpret formulas for better decision-making.

4.9(33)
3,548students
2h 12m
Certificate
Jacobo Licon
Jacobo LiconIng Industrial, Master en Ingenieria Financiera

Course Content

Cadena de suministro: Diseño de una red logística con Solver is an all-levels Udemy course taught by Jacobo Licon. It runs 2h 12m, is taught in Spanish, and includes a certificate of completion. Learners rate it 4.9 out of 5 from 33 reviews, with 3,548 students enrolled. It is a paid course, first published April 2024.

Optimizing your supply chain network is crucial for profitability. The decisions you make regarding facility placement (warehouses, factories, stores, etc.) and supply allocation directly impact your company's success. This course will equip you with the knowledge to make informed choices.

Learn how to effectively manage supply and demand constraints, and production capacity using Solver in Excel. This powerful tool allows you to solve both basic and complex network design problems.

In this course, you will:

  • Identify supply and demand constraints to optimize your distribution network.
  • Determine the minimum cost for routes and movements within your distribution network.
  • Pinpoint the optimal location for a new warehouse, considering factors like demand, latitude, and longitude.

Course Outline:

Chapter 1: Introduction to Supply Chain Network Design

  • Core Concepts & Formulas: Understand the fundamental principles and formulas driving effective network design.
  • Key Variables: Explore factors influencing network design, including product availability, response times, traceability, and returns management.
  • Network Design Alternatives: Discover various distribution network models: direct shipping, shipments via intermediate warehouses, cross-docking, home delivery, parcel delivery, and customer pickup options.

Chapter 2: Practical Applications with Excel Solver

  • Solver in Excel – A Hands-on Approach: Review formulas and problem setup using real-world scenarios.
  • Cost Minimization Exercises: Determine optimal shipment quantities from two production plants to three customers – explore three different approaches to minimize costs.
  • Multi-Tier Network Optimization: Calculate optimal shipment quantities from two production plants to two transshipment centers and three customers – explore two different solution methods.
  • Warehouse Location Optimization: Determine the best location for a distribution center, factoring in demand, latitude, and longitude.

Chapter 3: Network Design Comparison & Strategic Factors

  • Distribution Network Alternatives – A Comparative Analysis: A detailed comparison of distribution network options discussed in Chapter 1, evaluating costs and customer service levels.
  • Influencing Factors in Network Design: Understand the strategic, macroeconomic, political, competitive, technological, response time, and total logistics cost factors that shape network design decisions.

This is just a glimpse of what you'll learn! Join the course to unlock the potential of optimized supply chain networks.

$ whoami — the devs behind tutorialsearch.io

Need a SaaS MVP shipped fast? Hire the TutorialSearch.io team

Auth, billing, dashboards and AI features — a launch-ready product built by the devs behind this site.

4.7(38)
2h 53m
all
4.6(92)
5h 10m
intermediate

Cadena de Suministros: Administración, Diseño y Riesgos

by Carlos Martínez, PhD • Instructor with 15+ Best-Selling Courses

4.6(410)
9h 40m
all
4.6(913)
4h 4m
all
4.6(5,930)
2h 46m
beginner