Easy way to get 15 free YouTube views, likes and subscribers
Get Free YouTube Subscribers, Views and Likes

How to make a MPS (master production schedule): DETAILED example in excel + DOWNLOAD 📦

Follow
Ingenio Empresa

http://ingenioempresa.com/planmaestr...

In this video you will learn how to make a master production schedule step by step through an example involving decisions associated with capacity, disaggregation of aggregate planning, two sources of demand and two product references.

What to produce, how much to produce, and when to produce it, are the types of decisions you make when making a master production schedule.

The master plan determines which are the concrete references to plan from what was previously defined in the aggregate planning, so it is a great example to understand concepts mentioned in previous videos and in the Ingenio Empresa website.


Some adjustments to the explanation in the video:
At minute 12:18 I mention that there are 24 hours left to achieve the production of 600 units which is the required capacity. The mail would be to say that there are 24 hours to achieve the production of 2000 units which is equivalent to 600 hours (the required capacity).

At minute 14:08 when applying a rule of 3 I mention that one unit of reference A is produced in 0.3 hours, when in reality it should be one unit of reference B is produced in 0.3 hours. Note that this in no way affects the calculation or final result of the exercise.


Content:
00:21 Example data
02:25 Design of the master production plan MPS
09:09 Review of the MPS
19:25 Conclusion and download of the mps excel example
20:15 Ingenio Enterprise Networking

Ingenio Company in networks
Facebook: https://goo.gl/HDLFyn
Twitter:   / ingenioempresa  

posted by Insembeskvd