WORKPLANNINGANDFINANCIALSPREADSHEET(work_fin.xls)HELPFILEThistoolworkswellforsimpleprojectsbutisnotintendedtoreplaceprojectmanagementpackagedsoftwareformorecomplexprojects.Itwascreatedtofacilitatetheprocessofworkplanning,estimating,andtrackingtosavetheconsultantadministrativetimeandeffort.Thisworkbookperformsthefollowingfunctions:·Workplanning,resourceassignment,estimating,andtrackingprogress(WorkplanSheet)·DrawingaGanttChartbasedontheworkplan(GanttSheet)·TrackingprojectfeesandexpensesandreconcilingwiththeFS90JobSummaryreport(BillingSheet)·Trackingdetailedexpensesbycategory(ExpenseSheet)·PrintinganActivityTurnaroundDocumenttotrackactualprogressagainsttheprojectplan(ATDSheet)Thefollowinggraphicdisplayshowtousethisworkbook.Createworkplan&projectbudget1Beginproject3CreateGanttChart2TrackactualsandETCs5UpdateBillingSheetw/hoursandexpenses7WeeklyoreachpayperiodEachpayperiodReconcileJobSummary8EachpayperiodReviewbudgetvariance6Modifyworkplanasnecessary4WeeklyoreachpayperiodPage1OverallDirectionsforUse·Copythisworkbookorsaveitasanewnamebeforeyoubeginusingit,sothatyoucanretainacleanoriginal.·Thisworkbookisdesignedforusewithoneproject.TheprojectmaycorrespondtomorethanoneJobSummary.·Theseworksheetscontaincellswhichareprotectedtopreventyoufromaccidentallyoverwritingformulas.Thisalsopreventsyoufromadding/deletingrowsandcolumns.Ifyouwishtounprotectaworksheet,selectTools/Protection/UnprotectSheetfromthetoolbar.Afteryoumakethechangesyouwish,itisrecommendedthatyoureprotectthesheetbeforecontinuing.·ColumnandrowheadinglikeTotalCharges,PeriodHours,Cumulative,BillRt1,etc.areusedaslabelsfortheworkbookmacrostolocatecorrectrowsandcolumns.Changingrowandcolumnheadingsisnotrecommendedasthiswillcausethemacrobuttonsnottowork.SHEETSWorkplanSheetThissheetisusedforworkplanning,resourceassignment,estimating,andtrackingprogress(WorkplanSheet).Whenthisinformationisinput,thesheetcalculatesGrossFees,PlannedFeeAdjustment,andNetFees.Asyoutrackactualprogressandestimatestocomplete,thesheetcomputesEstimateatComplete(EAC)andBudgetVarianceinbothhoursanddollars.Whenusingthissheet,youshouldonlybudgetortracktimeatthelowestindentedlevelofactivity,otherwise,youwilldouble-counttime.Forexample:Thisiscorrect:BudgetPhaseSegTaskStepDescriptionStartEndTotSJCJSAMJI1000TechnologyImplementation1/1/965/30/961100MobilizeProject1/1/961/15/961110FinalizeWorkplan24hr2041120Getworkfacilitiessetup16hr881130ConductKick-offMeeting18hr6661200ConductDetailedDesign1/16/965/30/96100206020TOTAL158467834Page2Thisisnotcorrect:BudgetPhaseSegTaskStepDescriptionStartEndTotSJCJSAMJI1000TechnologyImplementation1/1/965/30/962167296481100MobilizeProject1/1/961/15/96582618141110FinalizeWorkplan24hr2041120Getworkfacilitiessetup16hr881130ConductKick-offMeeting18hr6661200ConductDetailedDesign1/16/965/30/96100206020TOTAL43214419296Thesecellsshouldbeblankbecausethereisalowerlevelofactivity,namelythetask.**************************TocorrectlycreatetheGanttChart,youmustspecifyStartandEnddatesatthePhaseand/orSegmentlevel.TheGanttChartdoesnotchartactivitiesbelowthesegmentlevel.Sincethissheethasmanyformulas,itissuggestednottoinsertrowsorcolumnsusingthetoolbar,oryouwillhavetomanuallyupdateallofyourformulas.Toinsertanewrowinordertoaddaworkactivity,placethecursoronthatrowandpressthe“InsertatCursor”button.Toaddapersonor“resource”tothissheetforbudgetin...
