





Ŀ
  
  D U R H A M     
  
  G R O U P         ______________________________________________________
    
                    P. O. Box 7484                        Voice/FAX
                   Roanoke  VA  24019                    (703) Lne-8192


____________________________________________________________________________


           Micro Technology    Contract Lotus/Paradox Programming  
                     Quantitative and Statistical Analysis


Durham Group has enhanced eight of its Lotus 1-2-3 .Wk1 worksheets for general
use.  These are the worksheets that find the most frequent application in our
in-house consulting work, so we've nicknamed them the "Big 8."  


DGCapex .Wk1	Supports investment decisions via calculation of the NPV of
                  a CapEx with a life of up to ten years.  The worksheet
                  facilitates entry of fixed asset purchases, working capital
                  requirements, and the continuing benefits and costs of the
                  CapEx.  DGCapEx.Wk1 supports all depreciation methods, and
                  provides on-screen guidelines and examples regarding the most
                  common questions and errors encountered when evaluating a
                  capital project.
 
			(The worksheet DGCapex.Wk1, and the associated Allways file,
                  DGCapex.All are made available at no charge via the BBS channel
                  as bannerware, in .ZIP format.  DGCapEx.Wk1 is an example of
                  the quality to be found in our products, and we encourage you
                  to review it.)

DGLseVal.Wk1	Supports financing decisions via present valuation of a leases
                  versus a loan based on the equivalent cash flows.  The
                  worksheet facilitates entry of any non-financing value
                  contained in the lease and provides for a subjective management
                  valuation of the legal and tax benefits of leasing.

DGLotSQC.Wk1	Supports quality decisions via calculation of the quality level
                  of a lot from a sample qualitative batch up to size 30, based
                  on standard SPC techniques; normal curve and range-to-standard
                  deviation tables are embedded in the worksheet.  

			A novice 1-2-3 user can enter, on a single screen, the
                  qualitative batch measurements and the qualitative batch
                  target, then immediately view the quality level, mean, and the
                  estimated sample and population standard deviations.  A single
                  keystroke sends the scaled "bell curve" representation of the
                  batch to the screen or to print.  

			










			For direct labor applications where access to 1-2-3 is not
                  practical, a single page form can be printed out of
                  DGLotSQC.Wk1 that instructs the sampler how to calculate the
                  quality level quickly, using only addition and division.

DGEOQ   .Wk1	Supports purchasing/scheduling decisions via calculation of
                  the economic order quantity (or optimal lot/batch quantity)
                  employing the classical method of comparison of inventory
                  carry costs to onetime/setup costs.  A range over which the
                  cost difference is negligible is also provided.  Graphical
                  representation to support subjective decisions is available
                  for view or print.

DGRatios.Wk1	Supports financing decisions via ratio analysis of financial
                  position.  The user enters, on a single screen, nine balance
                  sheet line items, eight income statement line items, and any
                  stock parameters, and receives a report with:


					Gross Profit Margin
					Operating Profit Margin
					Net Profit Margin 
					Return on Assets 
					ROA including interest
					Return on Stockholder's Equity 
					Return on Common Equity
					Earnings per share
					Current Ratio
					Quick (Acid Test) Ratio
					Inventory to Net Working Capital
					Debt to Assets
					Current Debt to Assets
					Debt to Equity
					Long Term Debt to Equity
					Times Interest Earned
 					Fixed Charge Coverage
 					Inventory Turnover
 					Fixed Assets Turnover
 					Total Asset Turnover
					Average Collection Period
					Dividend Yield on Common Stock
					Price-Earnings (P-E) Ratio
 					Dividend Payout Ratio
					Cash Flow per Share

 
 			The report includes a brief explanation of each ratio to the
                  right of each result.

DGSeason.Wk1	Supports forecasting decisions via calculation of normalized
                  seasonal indexes based on the ratio-to-moving-average method. 
                  The worksheet supports weekly, monthly, or quarterly indexes,
                  and provides for entry of subjective adjustments for outliers. 
                  Graphical representation of the indexes is available for view
                  or print.











DGMhrEst.Wk1	Supports project management via placement of confidence limits
                  on direct labor completion estimates, empirically based.

			The worksheet takes as input an original ESTIMATE by direct
                  labor of manhours to complete (for 100% direct labor activities
                  such as drafting, programming, etc.) then provides "best" and
                  "worst" values for ACTUAL manhours to completion.  A historical
                  analysis by Durham Group of such tasks indicates that the
                  optimism/pessimism of direct labor's estimates is highly
                  predictable in the long run.  Included in the worksheet is a
                  random sample of 200 data points used in the development of
                  the mathematical model, so users can graphically observe the
                  actual relationship.   The report provides "best" and "worst"
                  projections at the 80%, 90%, 95%, and 98% confidence levels.

DGRegres.Wk1	Supports a spectrum of analytical decisions. Performs of a more
                  detailed regression analysis, and allows two more independent
                  variables, than / Data Regression; based on a Gauss-Jordan
                  matrix reduction model.

			The summary report, designed for non-statisticians, provides
			a straightforward explanation of how to calculate a prediction,
			indicates the "strength" of the model, states which variables
			should be considered as "related" or "not related" with each
			other, and whether a variable should be removed from the model.

			The detail report, for statisticians, provides means and
                  standard deviations; summations; the variable correlation
                  coefficient matrix and  T-values; R Squared and adjusted R
                  Squared; SSR ,SSE, and SST; T-tests for acceptance and for
                  variable retention at 80%, 90%, 95%, and 98%.


All DG worksheets


				Contain print macros that provide Allways formatted
                        reports and graphs when Allways is attached

				Are not compiled, and contain no hidden formats, in
                        order to facilitate enduser modification

				Contain descriptive macro names to facilitate the
                        enduser's tracing of the worksheet logic

				Contains all documentation and examples on-screen, where
                        it supports the user


Payback with The Durham Group Big 8 worksheet set occurs


				The first time a user doesn't have to write a worksheet

				The first time you use a worksheet to make a cost-
                        effective decision

				The first time you don't have to outsource a decision








To purchase a copy of the Durham Group Big 8 .Wk1 worksheet set:


				Send check or money order to Durham Group for $65.00 with
                        a cover letter indicating delivery details

				Allow 4 weeks for delivery (Durham Group duplicates on
                        a make-to-order basis.)

______________________________________________________________________________


[	DG-Big8.Txt		8,575 bytes		4-9-90	9:56 	am  ]