Question

Jobs A B C

Release Time 9 3 2
Duration 5 7 15
Due Date 16 13 20
Suppose that for each working day until all projects are done, you need to pay $10/day.

Also, for each day each project is delayed (past due), you pay $3 penaltyFormulate the LP to minimize the total cost. Upload your Excel file. Individual work. No discussion. Note that you need to have all correct setting and correct answers shown in the solver.

Answer 1

The question involves creating an LP model to minimize costs of project completion, factoring in daily operation costs and delay penalties, using variables for the project start times and constraints based on project duration and release times.

Step-by-step explanation:

The subject question involves formulating a linear programming (LP) model to minimize the total cost of completing projects with daily operation costs and deadline penalties. In the LP model, variables would represent the start times for each project (A, B, and C). The objective function would include both the daily operation costs ($10/day) and the penalty costs for project delays ($3/day past due). Constraints would include the project duration, earliest start times following release times, and precedence if any project needs to be completed before starting another. The Excel solver tool would be utilized to find the optimal start times to minimize the overall cost.