旼컴컴컴컴컴컴컴컴커 � 컴컴컴컴컴컴컴컴 � � 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 lease 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 best 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 9,171 bytes 4-9-90 9:56 am ]