For one of the three product families involved in the aggregate production plan of the year 2022, determine production quantities of at least three products included in the family. For the disaggregation of the aggregated production amount among the products of the family, use the predefined proportions. By allocating the monthly production amounts of each three product to the weeks of the month evenly, Master Production Schedule (MPS) for the first three months of 2022 will be created.(proportions are weights of the types)

Table 1. Proportional distribution according to product type and Lot sizes (MPS quantities).
Product types	Proportions	Lot size
Y3	0,1	3000
Y5	0,35	3000
Y7	0,55	2500

Table 2. MPS data.
Y3
Orders	600	700	600	700	500	600	600	640	580	620	560	700
On hand	100
Safety stocks (weekly)	120
Y5
Orders	860	960	860	960	760	860	860	900	840	880	820	960
On hand	90
Safety stocks (weekly)	110
Y7
Orders	880	780	830	780	880	830	730	730	830	780	780	770
On hand	50
Safety stocks (weekly)	40

Answer rating: 100% (QA)

Table Master Production Schedule MPS for the first three months of 2022 Month 1 Month 2 Month ... View the full answer