In Project Management, we essentially manage Time, control Cost without compromising Quality of the work. In today’s blog entry I present a worksheet which I made recently to manage time and cost of a Project.
Below you see the snapshot of Summary of the Report. The first two columns tells you about the number and name of ongoing Projects. Next 5 columns tells you about the financial status of the Project. Like Budget Amount vs Budget Consumed etc. The remaining columns tells you the status the different activities whether they are completed, ongoing or not yet started.
However the activity status columns do not give us the detailed picture, the management may need. For that we need to refer next Project worksheets.
Below you see the snapshot of Project worksheet. For different activities Planned vs Actual dates are given. Based on dates the excel Gantt chart gets mapped, blue for planned and orange for actual. The dates are on weekly basis, can be put on daily basis. Filters are provided to view only planned or actual activities. % Done column is provided for the Manager to fill the % activity completed as on date.
I have used conditional formatting for making the excel Gantt chart. The dates and values assumed are approx. User need to correct it as per his/her need. Hope you find it useful. Link to file:-
Other related entry :-