Question: 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

Problem Renova's problem is to develop a

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). The notations are presented in Table 1. However, you need to define new variables if required. Table 1: Notations Parameter/Variable j Dj 1 P; Pt Indices of set of SKUs, j e{w,b,r,g.p} Demand of SKU; Inventory on hand of SKU; Available manhours for producing SKU; Total available manhours in cycle T Cycle length T Note: The unit of measurement for D,1,and P is manhours. Part A (8 marks) Demand and inventory on hand for five SKUs are presented in Table 2: Table 2: SKU's demand and inventory on hand for Part.A. White Blue Red Green Pink D 300 900 600 700 500 1 200 500 500 300 100 Given that the demands are deterministic and in manhours, and the available manhours (P) for a cycle is 3000, i. determine the sequence of producing the SKUs and show it in a simple graph. ii. develop a linear programming model (in MS Word) and then solve it in Excel. iii. explain the findings in details (MS Word)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!