Question: Problem 2: (10 pts) A manufacturing company, receiving orders for a special product, want to elaborate a production plan for the next four months to

Problem 2: (10 pts) A manufacturing company, receiving orders for a special product, want to elaborate a production plan for the next four months to minimize the total cost. Using the following data: - Demand in each month is 4 units (must be satisfied in each month) - Unit production cost ci (month 1:2, month 2:3, month 3: 5, Month 4: 6) - Stock level in the month beginning (S1) and in the end (S5) equal to 0 - Can keep at most 3 units in inventory (m=3) - Unit holding cost hi (month 2=2, month 2=1, month 2=2 ), note that the unit holding cost of the first month will be not used because S1=0 ) Complete the Excel file (worksheet 2) and apply Excel Solver to determine the optimal planne roduction quantity of each month and the total cost
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
