Question: AON Network Model in Excel: With the attached project data table (with monetary values in MGA), how can I create an AON network model in

AON Network Model in Excel: With the attached project data table (with monetary values in MGA), how can I create an AON network model in Excel? Please provide specific Excel formulas for calculating the Earliest Start Time, Earliest Finish Time, Latest Start Time, Latest Finish Time, Slack, and Critical Path for each activity. Also, include the method to calculate the Ki values for each activity, considering the monetary values are in MGA. Focus on practical Excel formulas and steps.

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!

Q:

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?...

Q:

Need help with this assignment.I've attached the excel workbook that should be used to record answers and the case scenario. The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy...

Q:

The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy generating firm, who needs to present his recommendation to the company Board regarding a proposed investment in a new...

Q:

Please help with this. Text below BCS 101 - Programming Concepts and Problem Solving This course will provide an introduction to programming logic and problem solving techniques using different...

Q:

Can someone please help me make this run? I don't understand why it is not //AssignReadString public class AssignReadString { } import java.awt.image.BufferedImageFilter; import...

Q:

Can someone help make this java file run? The code is probable the main issue I am having //AssignReadString public class AssignReadString { } import java.awt.image.BufferedImageFilter; import...

Q:

Consolidate all excel spreadsheets from part1 in a single Excel file.ONLY an EXCEL FILE will be accepted. You have write up with your own words. Do not copy from others work. In the last page, you...

Q:

can i get a solution to this question please. Value: Document (include your file name) 15% of final grade How to complete: 1. Read the following Anniversary Party scheduling problem: As the project...

Q:

Hi Ruchi, I need help with the attached assignment. It's due in about a week. Thanks 1) The paper should be written in APA style Research Paper format. This is the link that explains the research...

Q:

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

Q:

(1 point) Book Problem 15 Consider the indefinite integral I + 4x + 8 (x + 5) Using the partial fraction method, the integrand decomposes into the form A B where A = and B = x+5 (x + 5) +C...

Q:

A number plate has 6 single digit numbers. If a plate is made by selecting digits from 0 to 9 randomly, what is the probability that there will be exactly two 9s and two 0s?

Q:

Exercise 1 0 - 1 9 ( Algorithmic ) ( LO . 5 ) Miller owns a personal residence with a fair market value of $ 2 1 6 , 2 0 0 and an outstanding first mortgage of $ 1 7 2 , 9 6 0 , which was used...

Q:

Question 2 \ based on the following information in the table below: State of economy Probability of of economy Rate of return if state occurs Stock A STOCK B Recession 0.15 0.09 - 0.30 Normal 0.70...