Prior Year’s Data

←Previous                              Up↑                                                    Next→

Tab-15 Prior Year’s Data: Pages 18-21.  The data rows in Tab-15 Prior Year’s Data are the same as the Current Year’s Data in workbook Tab-14 for the Current Year’s Data.  Enter actual historical data for the available prior years for Time Analysis, Standard Hours, Overtime, Condensed Income Statement and Cash, Accounts Receivable and Unbilled Services.  Enter the most recent prior year data in Column L. Hide any unused columns to the left of Column L so the Graphic Charts appear correctly.  Column M year-to-date actual data is from formulas in those cells that are linked to the actual values from Tab-14.  The Current Year’s Plan values in Column N are linked to Tab-14 Column Q.

←Previous                              Up↑                                                    Next→