Scribd
Upload
19 views5 pages

Project Schedule Optimization Guide

The document outlines a project schedule with activities, durations, and costs, including critical path calculations. It details steps for adjusting the schedule to keep labor under a specified limit while ensuring project completion. Additionally, it provides financial metrics for two companies, including EBIT and debt service ratios.

Uploaded by

Krishna Dravid2020
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
19 views5 pages

Project Schedule Optimization Guide

The document outlines a project schedule with activities, durations, and costs, including critical path calculations. It details steps for adjusting the schedule to keep labor under a specified limit while ensuring project completion. Additionally, it provides financial metrics for two companies, including EBIT and debt service ratios.

Uploaded by

Krishna Dravid2020
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Activity PredecessoNormal TimCrash TimeExpediting Cost/Week

A - 9 6 3000
B A 5 3 3500
C A 15 10 4000
D B, C 7 3 2000
E C 10 6 2500
F D, E 2 1 5000

Critical Path Calculation


Path Duration ( Duration (Crashed)
A→B→D 23 13
A→C→D 33 20
A→C→E 36 23
Path Duration (Normal)
A→B→D 0
A→C→D 0
A→C→E 0

Critical Pat 0
Activity Duration ( PredecessoLaborers
A 2- 3
B 4A 2
C 6A 4
D 9A 3
E 5B 4
F 7 B, C 2
G 3 D, E, F 4

Adjusted Schedule to Keep Labor ≤ 9


Day Activities Total Laborers
Step Description
Step 1 Create a table for project activities with duration, predecessors, and laborers.
Step 2 Create a resource usage table with columns for each project day.
Step 3 Fill in labor usage per day based on each activity’s start and duration.
Step 4 Identify days where total laborers exceed 9 using Conditional Formatting.
Step 5 Adjust schedule by delaying non-critical activities to balance workload.
Step 6 Ensure no day exceeds 9 laborers while maintaining project duration.
Step 7 Verify that all tasks are completed within the timeline without overload.
Company EBIT Annual Int Annual Pri ICR (EBIT/I DSCR (EBIT/Total Debt Service)
BG 5000000 1600000 2000000 3.125 1.388889
NC Utility 1E+08 45000000 35000000 2.222222 1.25

You might also like