Problem Renova's problem is to develop a disaggregate production plan (Economic Lot Schedule) for five SKUs (white, blue, red, green, and pink} of a product to determine the optimal cycle length in order to minimize the total cost (or equivalent objective). Part A Demand (DJ) E 900 600 700 500 300 100 Inventory (lj) Months (tj) 0.667 0.556 0.833 0.429 0.2 Given that the demands are deterministic and in manhours, and the available manhours l? ) '3 for a cycle is 3000, i. determine the sequence of producing the SKUs and show it in a simple graph R] is represented as the number of months of the inventory. This means that the inventory is capable to supply to the demand before running out. From the table, Pink has the smallest value which means it is going to exhaust first so we have start production before 0.2 months. Therefore, the sequence for producing the SKUs will be Pink, Green, Blue, White and Red. tG= 0.429 tB=0.556 tW= 0.667 tR=0.833 i i i I l - ii. develop a linear programming model (in MS Word} and then solve it in Excel. {Excel solution under Part A sheet)