VIDEO
HIGHLIGHT
Log InSign up
Cómo hacer un MPS (programa maestro de producción): Ejemplo DETALLADO en excel + DESCARGA 📦
SummaryTranscriptChat

Cómo hacer un MPS (programa maestro de producción): Ejemplo DETALLADO en excel + DESCARGA 📦

New Section

In this section, the speaker introduces the topic of developing a production master plan (MPS) and explains that the example will be more complex than real-life scenarios. The speaker also mentions the forecasted units for a product family and the sales distribution within the family.

Developing a Production Master Plan

  • The speaker explains that they will develop a more complex example of a production master plan (MPS).
  • The forecasted units for the product family in October and November are 13,900.
  • There are two references or products within the family, with one reference accounting for 60% of sales and the other reference accounting for 40%.
  • Sales distribution within the product family is determined by observing previous months' sales data.
  • The objective is to create a more specific forecast for the master production plan (MPS) rather than an aggregate production plan.

New Section

In this section, the speaker discusses how to distribute forecasted units evenly among weeks and mentions an average plant capacity. They also explain how to calculate ending inventory based on demand.

Distributing Forecasted Units and Calculating Ending Inventory

  • The forecasted units for each reference in October are distributed evenly among four weeks.
  • An average plant capacity of 2,000 units is considered in this example.
  • To calculate ending inventory, sum up MPS units with initial inventory and subtract either forecasted units or customer orders (whichever is higher).
  • The objective is to respond 100% to customer requirements without having negative final inventory.

New Section

In this section, the speaker demonstrates how to assign production capacity based on demand requirements. They go through each week of October as an example.

Assigning Production Capacity for October

  • The initial inventory for the reference is 1,000 units.
  • For week 1, 2,000 units are assigned to meet the demand, resulting in a final inventory of 1,680 units.
  • Week 2 starts with the final inventory of week 1 as the initial inventory.
  • The same procedure is followed for both references to assign production capacity and calculate final inventory for each week.

New Section

In this section, the speaker continues assigning production capacity for November. They consider forecasted units and compare them between references to determine which one requires more production.

Assigning Production Capacity for November

  • Forecasted units differ between October and November.
  • The speaker compares forecasted units and current inventory levels to determine which reference requires more production.
  • Production capacity is assigned based on demand requirements and balancing final inventories.
  • The process is repeated for each week of November.

New Section

In this section, the speaker emphasizes comparing imbalances between references and considering future weeks' demands when assigning production capacity.

Comparing Imbalances and Future Demands

  • It's important to consider which reference has a greater imbalance in terms of demand requirements.
  • Future weeks' demands should also be taken into account when assigning production capacity.
  • The process of comparing imbalances and assigning production capacity continues throughout November.

Due to repeated words that don't make sense in this section, no summary was provided.

Distribution of MPS in Parallel

The speaker discusses the distribution of Master Production Schedule (MPS) in parallel and assigns units to different periods.

Assigning Units to Different Periods

  • The speaker mentions that they will distribute the MPS in parallel by assigning a thousand units to one period and another thousand units to another period.
  • They state that there are 459 units that need to be satisfied and reference 405 units. They repeat the procedure of assigning a thousand units for referenced and a thousand units for reference. A similar situation occurs with 779 units offset in the reference and 285 units.

Analysis of Predicted Units

The speaker analyzes the predicted units for different periods.

Discrepancy in Predicted Units

  • The speaker points out that there is a difference between the predicted units for one period, which is 1320, and the predicted units for the next period, which is only s of 880p.
  • As a result, they decide to assign one thousand units for one period and I unit for another period. For week 8 of November, they determine that it will be necessary to produce 1100 thousand 100 units.

Consideration of Capacity Limitations

The speaker discusses considering capacity limitations while reviewing the Master Production Plan (MPP).

Reviewing MPP with Capacity Constraints

  • After designing the MPP, they now review it considering limitations due to capacity and standard time.
  • They mention that an installed capacity has been determined by allocating 12 workers to an area responsible for production.
  • One restriction is not exceeding 80% of production capacity.
  • They calculate the installed capacity, which is 576 hours per week to produce 16,000 units.
  • The required capacity is determined by the number of units to be produced multiplied by the time it takes to produce each unit.
  • They analyze the deficit between installed capacity and required capacity.

Modifying MPS Based on Capacity Constraints

The speaker discusses modifying the MPS based on capacity constraints.

Adjusting MPS for Insufficient Capacity

  • The speaker identifies weeks 1 and 3 of October as having insufficient capacity to meet the designed MPS.
  • They consider modifying the MPS to allocate all available installed capacity for a particular week.
  • Using a rule of three calculation, they determine how many units can be produced in the available hours.
  • They find that they can produce 1920 units in 576 hours, which matches their installed capacity.
  • They address concerns about negative inventory balances and ensure that modifications do not result in negative balances.

Conclusion

The transcript covers topics such as distributing MPS in parallel, analyzing predicted units, considering capacity limitations, and modifying the MPS based on those limitations. It emphasizes the importance of reviewing and adjusting the Master Production Plan (MPP) to ensure it aligns with company policies and resource constraints.

New Section

In this section, the speaker discusses the procedure for week 3 of October and the required capacity to produce 2,000 units.

Week 3 Procedure

  • The same procedure as previous weeks is followed for week 3 of October.
  • The required capacity to produce 2,000 units in the ave reference is determined to be 600 hours.
  • The speaker suggests decreasing the required capacity by removing 80 units from the total.
  • With a production target of 1,920 units, there are still 576 hours available.
  • The remaining 80 units can be assigned to the next period as there is enough capacity to meet the demand for two thousand units.

New Section

This section focuses on adjusting the production plan for week 3.

Adjusting Production Plan

  • To take advantage of full capacity utilization, it is necessary to produce a total of 1,920 units.
  • The production plan for week 3 involves reducing the number of units by removing 80 units.
  • After adjustment, all values remain positive and there is no deficit in production.

New Section

This section discusses analyzing the proposed MPS and its viability.

Analyzing Viability

  • After analyzing all values, it is confirmed that there are no negative values in the proposal.
  • Sufficient capacity exists to produce the desired number of units.
  • While other methods like linear programming or heuristics may provide better results, they are beyond the scope of this exercise.

New Section

This section concludes with a summary and mentions additional resources available for understanding production master plans (MPS).

Conclusion and Additional Resources

  • The presented approach demonstrates one way to design and review an MPS.
  • Different forms of MPS exist depending on various factors, such as the number of command sources.
  • The template used in the exercise is available for download from the company's website.
  • The template provides information about production planning and experience with the added plan.

The transcript is already in English, so there is no need to translate it.

Video description

http://ingenioempresa.com/plan-maestro-produccion-mps/ En este vídeo vas a conocer cómo se hace un plan maestro de producción paso a paso a través de un ejemplo que involucra decisiones asociadas a la capacidad, desagregación de la planeación agregada, dos fuentes de demanda y dos referencias de producto. Qué producir, cuánto producir y en qué momento hacerlo, es el tipo de decisiones que tomas al elaborar un programa maestro de producción El plan maestro determina cuáles son las referencias concretas a planear a partir de lo antes definido en la planificación agregada, por lo que es un estupendo ejemplo para comprender conceptos mencionados en vídeos anteriores y en el sitio web de Ingenio Empresa. Algunos ajustes a la explicación en el vídeo: - En el minuto 12:18 menciono que faltan 24 horas para lograr la producción de 600 unidades que es la capacidad requerida. Lo correo sería decir que faltan 24 horas para lograr la producción de las 2000 unidades que equivalen a 600 horas (la capacidad requerida). - En el minuto 14:08 al aplicar una regla de 3 menciono que una unidad de la referencia A se produce en 0.3 horas, cuando en realidad debe ser una unidad de la referencia B se produce en 0.3 horas. Nota que esto de ninguna forma afecta el cálculo o resultado final del ejercicio. El contenido: 00:21 - Datos del ejemplo 02:25 - Diseño del plan maestro de producción MPS 09:09 - Revisión del MPS 19:25 - Conclusión y descarga del ejemplo de mps en excel 20:15 - Ingenio Empresa en redes Ingenio Empresa en redes Facebook: https://goo.gl/HDLFyn Twitter: https://twitter.com/ingenioempresa