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

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!