Question: Linear Model for Project Acceleration: Given the attached project data table (with monetary values in MGA), how can I formulate a linear model in algebraic
Linear Model for Project Acceleration: Given the attached project data table (with monetary values in MGA), how can I formulate a linear model in algebraic form to accelerate the project to week 28? Please provide a clear definition of variables, the objective function with all necessary linear combinations, and all model constraints. Demonstrate how to implement this model in Excel, focusing on mathematical formulation and step-by-step Excel implementation.
| Activity | Description | Predecessors | Duration (Weeks) | Accelerated (Weeks) | Resources (MGA) | Accelerated Cost (MGA) |
| A | Selection of Microcredit Office Location | None | 4 | 2 | 200000000 | 400000000 |
| B | Development of Organizational and Budgetary Plan | None | 6 | 3 | 150000000 | 300000000 |
| C | Human Resources Staffing Requirements | B | 4 | 2 | 70000000 | 140000000 |
| D | Physical Resources Office Design | A,C | 5 | 3 | 12000000 | 24000000 |
| E | Physical Resources Interior Construction | D | 9 | 4 | 25000000 | 50000000 |
| F | Human Resources Select Staff to Transfer | C | 3 | 2 | 12000000 | 24000000 |
| G | Human Resources Hire New Employees | F | 5 | 3 | 15000000 | 30000000 |
| H | Systems Assign Passwords/Codes | F | 3 | 2 | 3000000 | 6000000 |
| I | Tesoreria Apartar los recursos de acuerdo al presupuesto | B | 6 | 3 | 12000000 | 24000000 |
| J | Human Resources Train New Staff | E,G | 4 | 2 | 8000000 | 16000000 |
| K | Physical Resources Development of Advertising | I | 2 | 1 | 25000000 | 50000000 |
| L | Physical Resources Distribute Advertising to Media | K | 3 | 2 | 12000000 | 24000000 |
| M | Assignment of Responsibilities | J | 2 | 1 | 2000000 | 4000000 |
| N | Opening of New Office | M, H, I | 1 | 1 | 16000000 | 32000000 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
