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}. PartA Demand {Djl Inventory [If] Months {til Blue 900 500 0.556 Red 600 500 0.833 Green 700 300 0.429 Pink 500 100 0.2 Given that the demands are deterministic and in manhours. and the available manhours {2? ) '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 supplyr 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. \"3: {14213 t3 = 0.555 tw= 0.66? ii. develop a linear programming model {in MS Word) and then solve it in Excel. [Excel solution under Part A sheet)