From Casetext: Smarter Legal Research

Auto Industries Supplier Esop v. Snapp Systems, Inc.

United States District Court, E.D. Michigan, Southern Division
Dec 23, 2008
Case No. 03-74357 (E.D. Mich. Dec. 23, 2008)

Opinion

Case No. 03-74357.

December 23, 2008


ORDER GRANTING FORD'S MOTION TO STRIKE SNAPP'S DAMAGE ANALYSIS AND RELATED TESTIMONY


I. Introduction

This is a breach of contract case. Three contracts are at issue: (1) the 1995 Framework Agreement, as amended in 1996, (2) the Master Lease Agreement, and (3) the 1999 Transition Agreement. SNAPP seeks approximately 1.3 billion dollars in damages.

Before the Court is Ford's motion to strike SNAPP's damages analysis and related testimony. For the reasons that follow, the motion will be granted.

Ford also moved for partial summary judgment with respect to specific components of SNAPP's damages, arguing they lacked evidentiary support, and also sought partial summary judgment on the grounds of the statute of limitations. This memorandum deals solely with SNAPP's damages expert, Thomas Frazee, and whether his report and testimony and the related testimony of the other witnesses is admissible.

II. Background

As the Court has commented earlier in this case, ascertaining SNAPP's damages has been elusive at best. Rather than repeat the long history of discovery requests, orders from the special master and the Court, and the parties' various responses, the focus now is on SNAPP's expert report and related testimony.

On September 10, 2007, SNAPP filed an Expert Report Prepared By Thomas A. Frazee (Frazee Report) on damages (Dkt. 513). The Frazee Report calculated SNAPP's damages to be approximately 3.9 billion dollars, broken down into several categories. See Exhibit 1 — Exhibit B to Frazee Report. On October 5, 2007, Ford's filed a Motion to Strike SNAPP's Final Damages Report. Ford argued that the expert report falls short in several respects in properly identifying and supporting SNAPP's claimed damages. On October 19, 2007, the Court entered an order styled:

Previously, on July 29, 2005, Frazee prepared a report entitled Expert Report Prepared by Thomas A. Frazee. This report was incomplete as to many of the categories of damages and was never filed with the Court.

Order Staying Proceedings on Snapp's Motion to Supplement the Joint Final Pretrial Order and Directing Snapp to File a Response to Ford's Motion to Strike Snapp's Final Damage Report and Setting a Hearing on Ford's Motion to Strike

On December 5, 2007, the Court held a hearing on Ford's Motion to Strike. At the hearing, the Court noted that "whether Frazee is competent to express an opinion as to each of [the claimed items of damages] based upon his report is problematic." 12/2/07 Tr. at p. 2. To that end, the Court ordered an evidentiary hearing in which Frazee could be examined regarding his report; in essence, a Daubert hearing. The hearing, in which Frazee, Douglas Vetter and Bhagwan Thacker testified, extended over five days. At the conclusion, the Court stated:

Daubert v. Merrell Dow Pharm., Inc., 509 U.S. 579 (1993).

I think that's the crucial question here, whether there is a factual predicate for the opinions expressed by Mr. Frazee or whether — and that can be supported by Mr. Vetter or [Mr. Thacker]'s testimony. I have a considerable concern that there is an inadequate factual predicate for much of the opinions expressed by Mr. Frazee even as supplemented by the data from Mr. Vetter, and I think . . . that's the crucial issue the Court has to decide.

5/5/2008 Tr. at p. 204. The Court also afforded SNAPP the opportunity to decide whether to file an amended damages report in light of the testimony at the hearing. On May 6, 2008, the Court entered an order setting forth time limits pertaining to whether or not SNAPP elected to file an amended report. In either instance, Ford was directed to file an amended motion to strike. SNAPP chose to submit an amended report. A Supplemental Expert Report Prepared by Thomas A. Frazee (Supplemental Report) was filed on July 3, 2008 (Dkt. 542). In the Supplemental Report, SNAPP omitted some of the items of damages. Frazee now calculates SNAPP's damages to be approximately $1.3 billion dollars. See Exhibit 2 — Exhibit B of Supplemental Report.

The parties agree that the Supplemental Report is largely duplicative of the September 2007 report. The only substantive differences being the elimination of damages relating to MRO items and reduced damages for I-RaMMP. Thus, Frazee's testimony from the hearings is applicable to the Supplemental Report.

Ford then filed the instant motion.

III. Analysis A. Frazee as an Expert Witness 1.

The law regarding expert testimony is well-known. Rule 702 of the Federal Rules of Evidence, as discussed and interpreted by the Supreme Court in Daubert v. Merrell Dow Pharm., Inc., 509 U.S. 579 (1993) and Kumho Tire Co. v. Carmichael, 526 U.S. 137 (1999), controls the admissibility of expert testimony. Rule 702 provides:

If scientific, technical, or other specialized knowledge will assist the trier of fact to understand the evidence or to determine a fact in issue, a witness qualified as an expert by knowledge, skill, experience, training, or education, may testify thereto in the form of an opinion or otherwise, if (1) the testimony is based on sufficient facts or data, (2) the testimony is the product of reliable principles and methods, and (3) the witness has applied the principles and methods reliably to the facts of the case.

Fed.R.Evid. 702. Thus, expert testimony may only be admitted into evidence if: (1) the witness qualifies as an expert; (2) the methodology by which the expert reaches his or her conclusions is sufficiently reliable; and (3) the expert's testimony will assist the trier of fact to understand the evidence or determine a fact in issue. Id.; Daubert, 509 U.S. at 589-91.

In Daubert, the Supreme Court held that Rule 702 imposes a "gatekeeping" obligation on the trial court to ensure expert testimony "is not only relevant, but reliable." Daubert, 509 U.S. at 589. This "gatekeeping" function applies not only to scientific testimony but also to testimony regarding technical or other specialized knowledge. Kumho, 526 U.S. at 141.

Daubert sets forth five factors the court may consider to determine reliability: (1) whether the expert's technique or theory can be and has been tested, (2) whether the technique or theory has been subjected to peer review and publication, (3) the known or potential rate of error of the technique when applied, (4) the existence and maintenance of standards and controls, and (5) whether the technique or theory is generally accepted in the scientific community. Id. at 593-94. The court's inquiry underDaubert is flexible. Id. at 594. These factors are not a definitive test or checklist but are merely instructive. Id. at 593; Kumho, 526 U.S. at 150.

As one district court has explained:

Essentially, Daubert and Kumho require a two-step inquiry that involves an analysis of the "relevance and the reliability" of an expert's opinion. Greenwell v. Boatwright, 184 F.3d 492, 496 (6th Cir. 1999). The relevance step of the inquiry is designed to ensure that "there is a `fit' between the testimony and the issue to be resolved by the trial." Id. (citing United States v. Bonds, 12 F.3d 540, 555 (6th Cir. 1993)). The reliability step focuses on the "methodology and principles" that form the basis for the testimony. Id. A trial court must inquire as to whether the methodology underlying the proffered expert testimony is valid and whether the methodology may be properly applied to the facts at issue in a particular case. Daubert, 509 U.S. at 592-93.
Ellipsis Inc. v. The Color Works, Inc., 428 F. Supp. 2d 752, 757 (W.D. Tenn. 2006)

2.

Ford argues that SNAPP cannot meet the threshold requirement ofDaubert and Rule 702 with respect to Frazee's opinions and testimony essentially because Frazee's testimony made clear that he had little, if any, personal knowledge of the underlying data used to created the opinions contained in his report. The Court agrees. As was born out at the hearing, Frazee accepted summaries of data supplied to him by Vetter wholesale and simply used that data, often in the same format sometimes reformatting the data, to prepare his report. Frazee had no personal involvement in the preparation of the data. The Court indicated as much at the hearing:

The Court: Mr. McIntyre, I think it's clear that [Frazee] has no personal familiarity with any specific item on H-1 [cost-savings] so I don't know why you continue to examine him. He testified he got this from SNAPP and reformatted it into tabular form from a spreadsheet. . . . The Court: Is anything inaccurate from what I just said? Frazee: I think that's a pretty fair summarization 1/17/08 Hearing Transcript at p. 116. The Court: . . . he's gotten a lot of this data from somebody else and what he's done is simply plugged in the figures in a matrix. 2/27/08 Hearing Transcript at p. 145.

For instance, Frazee testified that he did not prepare Exhibit Q to his Expert Report (attached as Exhibit 5), which is also Exhibit Q to the Supplemental Report. Exhibit Q purports to delineate documents allegedly reviewed and relied upon in formulating SNAPP's cost-savings claim. Frazee testified he did not know who prepared it. 2/27/08 Hearing Transcript at p. 76. At the hearing, counsel for SNAPP said that Exhibit H-1 to the Frazee Report and Supplemental Report (portions of which are attached as Exhibits 3 and 4, respectively) clearly sets forth the parameters of SNAPP's cost savings claim. However, Frazee testified that Exhibit H-1 was derived directly from data supplied by Vetter and mirrors Exhibit 14 at the hearing, which was an e-mail and attachment from Vetter to Frazee with the subject heading "revised cost savings schedule." Thus, with respect to SNAPP's cost savings claim, Frazee performed no independent analysis but rather simply took figures supplied by Vetter.

The exhibits purporting to substantiate SNAPP's cost savings claim, Exhibits H-1, Exhibit Q and Hearing Exhibit 23, are discussed more fully in Part III.C., infra.

Ford further notes that Frazee admitted a similar lack of involvement and/or knowledge with respect to every component of his damage analysis:

• Frazee admitted that he did no analysis to determine whether SNAPP's cost savings claim related to the Midwest settlement was appropriate and that he did not know anything about the Midwest item other than the fact that it was on Vetter's papers that were given to him. 02/27/08 Tr. at 63:12-15; 63:21, 64:3-5.
• Frazee admitted that he accepted SNAPP's calculation of "leaked revenue" without any analysis beyond "talk[ing] to SNAPP about the document." 1/17/08 Tr. at 75:21-77:24.
• Frazee admitted that all of the cost savings information on Exhibit H-1 was provided to him by SNAPP and incorporated into his report with little more than mere formatting changes. Id. at 96:1-12. Frazee had no idea who at SNAPP actually derived the numbers used for Exhibit H-1. Id. at 13-16. Further, Frazee admitted that he had no personal familiarity with any specific item on H-1. Id. at 116:15-25. See also Defendant's Hearing Ex. 14.
• Frazee admitted that he obtained all of the contemporaneous relationship documents used in his Report from SNAPP business people. Ex. 3, 01/17/08 Hr'g Tr. at 117:9-15.
• Frazee admitted that he did not personally prepare Exhibit Q to his Report and did not know who specifically prepared it other than someone at SNAPP. 2/27/08 Tr. at 76:9-24; 78:8-15.
• Frazee admitted that he just incorporated the alleged savings percentage of 38.39 percent in a Nasser memo sent to him by SNAPP into his Report. Id. at 124:3-125:4. Frazee did not undertake any analysis or due diligence to verify this percentage other than just talking to Thacker about Thacker's commodity experience. Id. at 125:6-17.
• Frazee admitted that he incorporated most of the spreadsheet Vetter sent him entitled "Good Faith Renewal Damages" into his Report without doing any analysis of the information other than cross-referencing the numbers for accuracy with other documents provided to him by SNAPP. Id. at 153:16-154:7; see also 01/17/08 Tr. at 158:13-159:9. Compare Defendant's Hearing Ex. 10 with Exhibit O to Supplemental Report, lines 1-3.
• Frazee lifted and accepted the numbers from Vetter's email entitled "Damages Related to Past Due Payments Under the MLA" without further change or analysis to create Exhibit J to the Report. Compare Defendant's Hearing Ex. 15 with Ex. J to Supplemental Report.
• Frazee adopted the total from Vetter's email entitled "Interest benefit under the LPA" without further change or analysis to create Exhibit K to the Report. Compare Defendant's Hearing Ex. 16 with Ex. K to Supplemental Report.
• Frazee admitted that his Exhibit N "summarizes" the contents of Vetter's email entitled "1999 agreement claim — open A/R." 02/27/08 Tr. at 59:22. In fact, other than rounding a few numbers, Exhibit N is identical to the information provided by Vetter, and merely was reformatted. Compare Defendant's Hearing Ex. 17 with Ex. N to Supplemental Report.
• Frazee admitted that the $5.5 million in alleged damages in Exhibit L, pertaining to the Transition Agreement, is based upon Exhibit N, which in turn was created wholesale from an email attachment from Vetter. 02/27/08 Tr. at 120:16-121:7. Frazee also admitted that he did no independent review or analysis of the underlying purchase orders from which the data in Exhibit N allegedly was compiled. Id. at 121:8-14.
• Frazee admitted that Exhibit M was based on data that was forwarded to him by Vetter entitled "Incompleted' Type II Transactions." 02/27/08 Tr. at 135:10-136:6. Frazee did not change any of the substantive data provided by Vetter, nor did he do any independent verification of the numbers by reviewing the underlying purchase orders. Id. at 136:7-15. Frazee only changed the title of the spreadsheet and the title of the last column, and otherwise incorporated the attachment wholesale as Exhibit M to his Report. Compare Defendant's Hearing Ex. 19 with Ex. M to Supplemental Report.

SNAPP, however, says that these alleged deficiencies go to the weight of Frazee report which is a question of fact for the jury, and the weakness of the report should not result in its exclusion. This argument overlooks that:

When determining whether an expert's testimony is reliable, the court may consider the factual basis for the expert's opinion. Indeed, Rule 702 specifically states that an expert may only testify if the testimony is based upon sufficient facts and data and the witness has applied the principles and methods reliably to the facts of the case. Courts may also review the factual basis for an expert's testimony under Rule 703 of the Federal Rules of Evidence. . . . Under Rule 703, courts have held that if the underlying data are so lacking in probative force and reliability that no reasonable expert could base an opinion on them, an opinion which rests entirely upon them must be excluded.
Ellipsis, Inc. v. Color Works, Inc., 428 F. Supp. 2d 752, 760 (W.D. Tenn. 2006) (internal quotations and citations omitted) (emphasis added).

Frazee was, as Ford aptly states, a "mere conduit for information prepared by others." Frazee's acceptance of other's work and incorporating it into a report simply does not meet the reliability component necessary for expert testimony. SNAPP contends that the fact that Frazee had no personal knowledge of the underlying business records is not grounds for exclusion of his report. This argument misses the point. It is not the fact that Frazee did not have personal knowledge of the business records which is important. Rather, it is the fact that Frazee failed to perform any intellectual analysis or review of the underlying source documents (which SNAPP says are its business records) sufficient to qualify him as an expert. As demonstrated above, Frazee testified that he did not perform any such analysis or review. In reality, Frazee had no actual involvement in the calculations of SNAPP's damages components. Instead, he either did no analysis or accepted the analysis supplied by others, particularly Vetter. Although SNAPP points to Frazee's testimony in which he stated he spent some time looking at the calculations in the summaries provided by Vetter to see if they were consistent with SNAPP documents and other summaries, he did not testify that he actually did the analysis for SNAPP's damage calculations, as opposed to merely "double checking" SNAPP's math and sources at some level. Under these circumstances, there is no way to determine whether the data relied upon and methodologies Frazee used, which were given to him by others, are reliable under Rule 702.

B. Summary Witnesses 1. Frazee

SNAPP also argues that Ford is "mixing up issues" by failing to distinguish between Frazee's role as an expert witness and a summary witness under Rule 1006. It would appear that SNAPP, when faced with the deficiences in Frazee's testimony and report, says that Frazee is also to be a summary witness. Frazee himself described this rather amorphous role as "evolved . . . from providing expert testimony and opinions" "to encompassing a role as a summarizer or summarization of some of the facts." 1/17/08 Tr. at p. 10. SNAPP, however, has not identified where Frazee is offered as an expert and where he is offered as a summary witness. Moreover, despite Frazee's testimony mentioning his role as a summary witness, at no point in his Supplemental Report does he refer to himself as such.

Rule 1006 states:

The contents of voluminous writings, recordings or photographs which cannot conveniently be examined in court may be presented in the form of a chart, summary, or calculation. The originals, or duplicates, shall be made available for examination or copying, or both, by other parties at [a] reasonable time and place.

Fed.R.Evid. 1006.

Moreover, Frazee is relying on summaries prepared by Vetter, not himself. Where a summary witness does not personally prepare the summaries testified to, the summary witness must at least have "carefully reviewed the charts and ensured that the refelct[] information contained in documents already in evidence." United States v. Lemire, 720 F.2d 1327, 1349 (D.C. Cir. 1983). The summary witness must also be able to "identify the source of all of the information on the chart" and "explain how all the dollar figures were derived." Id. As noted above, Frazee does not meet these requirements. Indeed, the only witness who purports to have knowledge of the information contained in the summaries and underlying documents is Vetter, not Frazee. Frazee would essentially be a summary witness of a summary witness, a role that is not helpful to the litigation. At most, he would be cumulative of Vetter. Thus, Frazee is not a proper summary witness.

2. Vetter

SNAPP has filed an affidavit of Vetter, its consultant, who testified at the hearing in an effort to bolster Frazee's report. At the hearing, Vetter testified that he was SNAPP's consultant and created almost all of the attachments to the Frazee report. However, he explained that his role at SNAPP was limited to "high-level agreements and projects and new contracts" and that he did not interact with Ford employees. 4/23/08 Tr. at p. 7. Vetter was never a direct employee of SNAPP, only a consultant. Significantly, he testified that he did not review any of the data underlying SNAPP's summaries or any of the 961 boxes of documents SNAPP listed as the underlying basis for the summaries. 4/22/08 Tr. at p. 28.

In his affidavit, however, Vetter confirms that he, not Frazee, performed the damages work for SNAPP. The Vetter affidavit supports that Frazee relied upon documents and data to support his testimony and Report, that document only confirms that it was not "the witness," i.e. Frazee, who applied principles and methodology to create damages calculations as required by Fed.R.Evid. 702(3). As Ford points out, the fact that SNAPP chose to submit an affidavit of Vetter to attempt to prove a factual and intellectual predicate for Frazee's Report, as opposed to an affidavit from Frazee, stating that he performed the work expected of an expert witness pursuant to the Daubert standards it telling. Equally telling is that after Frazee's cross-examination, SNAPP made the "determination" that it would not recall Frazee for redirect examination to rebut his admissions.

Vetter's affidavit purports to highlight his involvement. Vetter first states that "I was substantially involved in all damages submissions to the Court," and lists five of SNAPP's damages submissions in illustration. See 10/03/08 Vetter Affidavit — Ex. 6 to SNAPP's Response at ¶ 7. Only the final two damages submissions listed are the "Frazee Studies," which shows that Vetter performed SNAPP's damage calculations well before Frazee's involvement. Id. Vetter concedes that he not only did all the calculations for the pre-Frazee damages submissions, but also for the Frazee Reports, as he states that "I also adjusted those computations already performed by SNAPP for its previous Damages submissions based on Mr. Frazee's input and advice, particularly as to the application of Ford's historical payments," id. at ¶ 8, and "I performed similar functions in assisting Mr. Frazee in connection with his July 3, 2008, Supplemental Expert Report ("Frazee Study"). Id. at ¶ 9. Vetter also "worked extensively with [Frazee] to bring him up to speed on the previous damage submissions and the events that had occurred since Mr. Frazee had issued his previous report in August 2005." Id. at ¶ 10. Continuing, Vetter states that "Mr. Frazee quickly understood SNAPP's calculations, as they were based in large part on the methodology proposed by Mr. Frazee in his August 2005 report."Id. Ford accurately describes Vetter's affidavit relative to Frazee as follows:

Vetter's statement contains two important admissions. First, that someone other than Frazee performed SNAPP's calculations, and Frazee simply was "brought up to speed" on them. Second, that those calculations were based, in part, on methodology other than that suggested by Frazee. While Vetter now claims that SNAPP's calculations were based "in large part" on a methodology developed by Frazee, Frazee's original 2005 Expert Report contains only one calculation — for the "Estimated Profit Margin of 2% Revenue." See Ex. 2, 07/29/05 Expert Report Prepared by Thomas A. Frazee at 9. To the extent that Frazee describes any "methodologies" in his 2005 Report, such descriptions are broad and general and do not reflect what documents and data would be used to calculate any of SNAPP's now listed categories of damages. Id. at 4. Moreover, the "damages perspectives and methodologies" are limited to (a) Benefit Received by Customer; (b) Seller's Profits; and (c) Cost-Plus Pricing, rather than tailored to the categories of damages now claimed by SNAPP in its current damage Report. Id.
Further, even though Vetter claims in his latest Affidavit that Frazee also determined a new methodology consistent with the Court's orders for the Frazee Reports, he then admits that "I emailed the final calculations to Mr. Frazee." Ex. 6 to Resp., Vetter Aff. at ¶ 10-11. Vetter also admits that Frazee (and his team's) involvement with the damages calculations was limited to applying tests for reasonableness and accuracy to the summaries previously calculated and forwarded by Vetter, which again, amounts to little more than "double checking" Vetter's submissions as opposed to taking an active role in their production as required of an expert. Id. at ¶ 11. Vetter's Affidavit also contains several other admissions showing that Vetter was the primary, if not sole, preparer of the damages calculations that are contained in the Frazee Supplemental Report, including: "I examined the underlying data supporting the calculations that I performed to assist Mr. Frazee," id. at ¶ 13; "the damages calculations that I prepared in my collaboration with Mr. Frazee," id. at ¶ 14; and "I prepared a spreadsheet for Mr. Frazee that summarized the calculations." Id. at ¶ 28 (emphasis added).

Ford's Reply at p. 7-8.

Ford goes on to say:

The fact that the Frazee Supplemental Damages Report purports to explain how various damages components were calculated does not mean that Frazee actually performed the calculations or determined the methodologies for doing so. The bulk of the evidence, including SNAPP's own admissions via the Vetter Affidavit, irrefutably shows that Vetter, and not Frazee, was the individual, if any, who applied any alleged principles or methodology to the facts of the case, as required of an expert witness pursuant to F.R.E. 702 and Daubert. Thus, "the expert witness" proposed by SNAPP, Frazee, has not met the basic requirements expected of an expert pursuant to the Federal Rule governing expert testimony, and his report and any related testimony should be stricken.
Id. at p. 8.

Moreover, to the extent that SNAPP says that Vetter may testify as a summary witness and/or lay the foundation for Frazee's report, SNAPP is misguided. While Vetter may have made the calculations, there is no evidence that he can lay a foundation for the data underlying the analysis because (1) he was not involved in the day-to-day operations of SNAPP, (2) did not create the underlying documents, (3) is not the custodian of the documents, and (4) testified at the hearing that he did not review the underlying documents. Indeed, Vetter's primary role at SNAPP largely did not occur until 1999 and was limited to discrete issues such as the 1999 Agreement, summarizing 1999 audited financial statements, negotiation of the Lease Program Agreement, and the I-RaMPP program. Documents allegedly supporting SNAPP's damage claims date back prior to 1999 and involve issues in which Vetter had no direct involvement, such as cost savings processes and documentation and the parties' understanding of the profit target.

3. Thacker

Thacker's testimony at the hearing was very limited. The only input he testified to as to SNAPP's damage analysis was support for "SNAPP's industry knowledge indicating 19% savings" on claims relating to IMPACT and MRO commodities — claims which have since been dismissed from the case. As the Court noted at the hearing, Thacker was not competent to lay a foundation for SNAPP's damage claims:

The Court: [Thacker] does not know that much about the details of the Frazee Report and the items in it to testify to it completely. He was removed from it. He knows generally, he knows generally, but he doesn't know the details, to justify it, and that's why I stopped you. I'm not saying he's not a believable person. I'm not saying he's not an honest person. I'm not saying he's not a successful person. But a witness who doesn't have knowledge to support the factual predicate or the expert testimony is not credible. 5/5/08 Tr. at p. 211. Thus, Thacker cannot lay the foundation for SNAPP's damages.

4. Other Witnesses

In its response, SNAPP says it will produce additional fact witnesses and damages proofs at trial to "present foundational testimony . . . to Mr. Thacker and Mr. Vetter." SNAPP's Response at p. 29. This statement does not save Frazee's report. Clearly, SNAPP's statement shows that it implicitly concedes that it has failed to provide an adequate foundation for the Frazee report. At no time at the hearing did SNAPP indicate that other witnesses were necessary to fill in the factual predicate and did not take the position that other witnesses must be examined.

C. Identifying the Source Documents

Finally, and not insignificantly, despite its protestations to the contrary, SNAPP has not provided Ford with meaningful access to the documents which SNAPP says underlay the damage calculations, i.e. the source documents. This is important because even if SNAPP was able to use Frazee, Vetter, or Thacker as a summary witness, Rule 1006 requires that the proponent of the documentation made the documents available. This availability requires more than just "passive availability." See Maris Equip. Co., Inc. v. Morganti, Inc., 163 F. Supp. 2d 174, 201-202 (E.D.N.Y. 2001). Likewise, in order for Ford to be able to understand SNAPP's damages in the Rule 702 context, Ford must be given the source documents. Thus, SNAPP's contention that the source documents have been produced to Ford at various points in the litigation, are contained in the 961 boxes of documents in a warehouse, and that many are Ford documents, falls short. As Ford states:

While it is possible that Ford "saw" the documents at some point in the litigation or business relationship among the hundreds of documents exchanged, this is not the functional equivalent of being made specifically aware, by the party proposing the summary, that a particular document or documents will be used in support of a damages analysis. Simply claiming that all documents were always available to Ford is not sufficient, because the "availability" contemplated by F.R.E. 1006 only is meaningful if Ford is able to understand the underlying data in the relevant damage analysis context of the Frazee Report and attached summaries. Thus, Ford's actual objection is to SNAPP's insistence that the documents on which its summaries allegedly are based were "made available," even though SNAPP has never, at any point, identified and segregated precisely which documents support each individual summarization of a damages component.

Reply brief at p. 15-16.

At oral argument, counsel for Ford tracked SNAPP's documentation which purports to support its cost savings claim which illustrates the problematic nature of SNAPP's proofs. As noted above, Frazee testified that the documentation for the in costs savings was derived from Exhibit H-1 to Expert Report which we now know was prepared by Vetter. Exhibit H-1 of the Expert Report (a portion of which is attached here as Exhibit 3) is listing of suppliers and savings numbers. Exhibit H-1 of the Supplemental Report (a portion of which is attached here as Exhibit 4) is also a listing of what appears to be the same suppliers; however, the cost savings are broken down into intervals and the numbers are significantly lower. Frazee testified that the documents supporting H-1 were contained in Exhibit Q (attached here at Exhibit 5) to the report and supplemental report. Exhibit Q consists of seven pages and each page has two columns headed "Description" and "Citation." The description column contains entries like supplier reports, supplier invoices, and various other entries. The citation column contains reference entries such as SNAPP trial exhibit numbers, SNAPP summary judgment exhibit numbers, and notably, SNAPP documents in boxes identified only by box number. According to counsel for Ford, the number of boxes of documents referenced in Exhibit Q totals approximately 720. Exhibit Q does not provide any meaningful insight into how SNAPP derived the cost savings figures; rather, it is simply a listing of a description of a document or documents and where it may be located. During the course of the hearings, SNAPP produced Exhibit 23, asserting that the document provided further support for its cost savings claim. Putting aside that Exhibit 23 was never produced during discovery or designated as a trial exhibit, Exhibit 23 (attached here as Exhibit 6), much like Exhibit H-1, lists thousands of suppliers and numbers with no underlying analytical detail, no underlying information. None of this information is meaningful document information from which the figures supporting SNAPP's cost savings damages of 242 million dollars can be ascertained.

SNAPP initially sought 1.3 billion dollars in cost savings. It now seeks 242 million dollars. The reduced amount is due to the removal of SNAPP's claim for cost savings damages based on MRO commodities.

Exhibit Q to the Expert Report and Supplemental Report are identical.

SNAPP has been directed from the very early stages of this case to articulate and explain its damages. While a lot of paper has been filed, SNAPP has simply failed to provide a coherent explanation of its damages. Frazee's reports and related testimony fall short.

IV. Conclusion

In the end, the Court's observation at the hearing that the Frazee report rests on a "foundation of sand" has held true. Frazee's report, as evidenced by his testimony, does not satisfy Rule 702. Neither Vetter nor Thacker's testimony nor Vetter's affidavit alter this conclusion.

Ford's motion to strike damage analysis and related testimony is GRANTED.

Ford shall within ten (10) days amend its motion for partial summary judgment filed in conjunction with the instant motion.

SO ORDERED. 03-74357 Auto Ind Supplier Industries v. SNAPP Systems, Inc. EXHIBIT LIST

Exhibit 1 Exhibit B to Expert Report (detailing categories and amounts of SNAPP's damages) Exhibit 2 Exhibit B to Supplemental Report (detailing categories and amounts of SNAPP's damages) Exhibit 3 Exhibit H-1 (first page only) to Expert Report (listing cost savings by supplier) Exhibit 4 Exhibit H-1 (first page only) to Supplemental Report (listing cost savings by supplier, also broken down into time intervals) Exhibit 5 Exhibit Q to Expert Report (a multi-page document listing documents and sources for documents supporting cost savings under headings "Description" and "Citation") Exhibit 6 Exhibit 23 from the Hearing (collection of documents including, (1) a multi-page cost savings listing by supplier, (2) a multi-page chart/listing of suppliers entitled "SNAPP's Negotiated Cost Savings 1991-1995, and (3) a document entitled Order statistics"

03-74357 Auto Ind Supplier v. SNAPP — EXHIBIT 1

UHY Advisors MI, Inc. Exhibit B SNAPP v. Ford Motor Company Summary of SNAPP Damages Net Amount Line Description Fn Due SNAPP Breach of Contract — Framework Agreement Amendment 1 1 2 2 3 3 4 4 1,692,951,670 5 MELA and LPA 6 5 7 6 254,796 8 Transition Agreement 9 7 10 7 11 7 12 7 13 7 3,238,041 14 28,714,430 15 Grand Total $3,902,043,022 Footnotes: 1 2 3 4 5 6 7 1.75% Profit Agreement $844,938,008 Savings — SNAPP's 50% Share 1,325,924,956 Interest on Late Payments from Ford 8,379,755 Failure to Negotiate Renewal in Good Faith Subtotal 3,872,194,388 Late Charges on Payments Under Master Equipment Lease Agreement 879,408 Lost Interest Income from Lease Program Agreement Subtotal 1,134,204 Unpaid Accounts Receivable 5,500,000 Lost Mark-Up on Certain Type II Transactions 4,318,537 Operating Costs 8,973,661 Loss of 2% Profit 6,684,191 2% Profit on Type III and Type IV Transactions Subtotal _______________________________________________________________________________ Refer to Exhibit E Refer to Exhibit G Refer to Exhibit I Refer to Exhibit O Refer to Exhibit J Refer to Exhibit K Refer to Exhibit L

03-74357 Auto Ind Supplier v. SNAPP — EXHIBIT 2

UHY Advisors MI, Inc. Exhibit B SNAPP v. Ford Motor Company Summary of SNAPP Damages Net Amount Line Description Fn Due SNAPP Breach of Contract — Framework Agreement Amendment 1A 1 1B 1 2 2 3 3 $489,471,863 4 MELA and LPA 5 4 6 5 254,796 7 Transition Agreement 8 6 9 6 10 6 11 6 12 6 3,238,041 13 28,714,430 14 Grand Total $1,362,101,837 Footnotes: 1 2 3 4 5 6 1.75% Profit Agreement (Excludes MRO/IMPACT and IPAS) $61,433,648 Unreimbursed Expenditures for Ford's Benefit (Excludes MRO/IMPACT and IPAS) $539,141,784 Savings — SNAPP's 50% Share 242,205,907 Failure to Negotiate Renewal in Good Faith (Excludes MRO/IMPACT and IPAS) Subtotal 1,332,253,202 Late Charges on Payments Under Master Equipment Lease Agreement 879,408 Lost Interest Income from Lease Program Agreement Subtotal 1,134,204 Unpaid Accounts Receivable 5,500,000 Lost Mark-Up on Certain Type II Transactions 4,318,537 Operating Costs 8,973,661 Loss of 2% Profit 6,684,191 2% Profit on Type III and Type IV Transactions Subtotal ______________________________________________________________________________________ Refer to Exhibit E Refer to Exhibit G Refer to Exhibit O Refer to Exhibit J Refer to Exhibit K Refer to Exhibit L

Exhibit H-1 03-74357 Auto Ind Supplier v. SNAPP — EXHIBIT 3

Actual Savings by Supplier Supplier Base Price SNAPP's Cost Total Cost Savings ABB ROBOTICS 34,470 28,815 5,655 ABT CORPORATION 1,087,010 948,560 138,450 ACCELR8 TECHNOLOGY 2,154,314 947,154 1,207,160 ACCUSCAN CORP 4,259,714 2,724,911 1,534,803 ACRO SERVICE CORP 83,513 65,087 18,426 ADAPCO 1,412,028 759,456 652,572 ADOBE SYSTEMS 2,104,226 1,783,821 320,405 ADVANCED VISUAL SYS/UNIRAS 265,911 206,252 59,658 AGT INTERNATIONAL 220,118 182,038 38,080 ALIAS/WAVEFRONT 4,145,472 2,969,644 1,175,828 ALTAIR 20,329,562 12,892,775 7,436,788 AMERICAN POWER CONVERSION 10,067 — 10,067 AMERICAN SYSTEMS TECHNOLOGY 969,378 748,737 220,641 AMERIQUEST 1,388,888 1,094,358 294,530 ANALOGY INC 7,433,148 5,021,812 2,411,336 ANALYTICAL SYSTEMS, INC. 38,308 30,205 8,103 ANALYTICAL TECHNOLOGIES 2,632,114 2,063,224 568,890 ANDATACO 420,626 324,315 96,311 ANSOFT CORPORATION 1,900 — 1,900 ANSWERTHINK 448,102 389,000 59,102 AONIX 297,190 187,525 109,665 APEX SMART MODULAR 13,860 9,453 4,407 APRICORN INC 334,955 226,101 108,854 ARBOR SOFTWARE 5,439 4,739 700 ARMAGUARD LTD 460,821 390,653 70,168 ASG RENAISSANCE 111,040 91,820 19,220 ASP COMPUTER PRODUCTS, INC. 18,118 13,171 4,946 AST IMAGING SYSTEMS INC 218,190 134,795 83,395 ATTACHMATE 1,042,846 535,050 507,796 AUTODATA 468,747 349,090 119,657 AUTODESK INC 8,000,328 4,306,147 3,694,181 AUTOFORM ENGINEERING GMBH 102,279 75,268 27,011 AUTOMATED ANALYSIS 1,789,560 971,697 817,863 AUXILIUM 370,482 275,000 95,482 AXIOM SYSTEMS 7,650 — 7,650 AXSYS INC 70,397 53,797 16,601 BAAN USA 8,901,998 4,404,814 4,497,184 BACKWEB TECHNOLOGIES 128,224 91,450 36,774 BAYNEWORKS 34,250 20,608 13,642 BEAME WHITESIDE 14,786 10,030 4,756 BETA CAE 882,831 425,935 456,896 BLACK BOX 186,839 117,844 68,994 BLACKBURN CO 693,502 593,787 99,714 BLUECURVE, INC. 6,172 4,666 1,506 BMC SOFTWARE 23,609,327 17,214,507 6,394,821 BONN COMPANY 1,813,277 1,418,479 394,798 BOOLE BABBAGE 90,516 — 90,516 BOSS AUTOMATED BARCODE SYSTEMS 68,369 58,914 9,455 BOSTON CONSULTING 3,348,873 2,601,800 747,073 BRIGHTWARE 351,868 236,000 115,868

03-74357 Auto Ind Supplier v. SNAPP — EXHIBIT 4

UHY Advisors MI, Inc. Savings on IT Commodity Transactions — Other than Administrative Exhibit H-1 Line Supplier 1991-1995 Total 1996 1997 1998 1999 Total Savings 1 2,985 2 50,556 3 1,119,396 4 1,282,311 5 12,395 6 582,200 7 155,115 8 40,547 9 21,212 10 900,659 11 6,242,137 12 10,067 13 151,263 14 193,126 15 1,946,012 16 5,304 17 377,710 18 66,260 19 1,900 20 23,057 21 92,289 22 3,531 23 87,903 24 261 25 33,970 26 10,712 27 3,726 28 70,905 29 458,218 30 87,310 31 3,295,172 32 20,037 33 727,825 34 70,000 ABB ROBOTICS 2,985 — — — — ABT CORPORATION 24,704 5,779 15,756 667 3,649 ACCELR8 TECHNOLOGY — — 862,746 55,500 201,150 ACCUSCAN CORP — 24,548 429,014 486,176 342,574 ACRO SERVICE CORP — — — 8,241 4,154 ADAPCO 1,938 — — 566,763 13,499 ADOBE SYSTEMS 87,205 38,367 16,478 11,759 1,306 ADVANCED VISUAL SYS/UNIRAS 37,567 534 — 2,447 — AGT INTERNATIONAL — 10,460 — 10,752 — ALIAS/WAVEFRONT 80,442 — 14,306 805,912 — ALTAIR 917,761 175,054 336,800 3,026,574 1,785,947 AMERICAN POWER CONVERSION — 10,067 — — — AMERICAN SYSTEMS TECHNOLOGY — — — 151,263 — AMERIQUEST 126,571 36,933 12,744 11,894 4,984 ANALOGY INC 717,493 292,450 289,072 350,048 296,950 ANALYTICAL SYSTEMS, INC. — — — — 5,304 ANALYTICAL TECHNOLOGIES 135,369 89,496 68,200 81,456 3,189 ANDATACO 66,260 — — — — ANSOFT CORPORATION — — 1,900 — — ANSWERTHINK — — — 23,057 — AONIX 79,812 4,523 — 6,797 1,157 APEX SMART MODULAR — — 3,531 — — APRICORN INC — — 47,203 35,364 5,336 ARBOR SOFTWARE — — — 261 — ARMAGUARD LTD — — — 10,271 23,699 ASG RENAISSANCE — — 7,262 3,450 — ASP COMPUTER PRODUCTS, INC. 3,430 296 — — — AST IMAGING SYSTEMS INC — — — — 70,905 ATTACHMATE 387,450 70,768 — — — AUTODATA — — — 48,202 39,108 AUTODESK INC 1,367,119 913,709 1,014,344 — — AUTOFORM ENGINEERING GMBH — — — 20,037 — AUTOMATED ANALYSIS 12,422 — 152,000 482,241 81,161 AUXILIUM — — — — 70,000

03-74357 Auto Ind Supplier v. SNAPP — EXHIBIT 5

Description Citation nd rd The 1995 Frame Work Agreement Between Ford and SNAPP Project summaries The 1996 First Amendment to Frame Work Agreement "SNAPP Shots" SNAPP Preliminary Trial Exs. 44; 346; 582; 589; 617; 604; 761; 879; 916; 1050; 1071; 1160; 1255. 1991 Supplier Report F/S #00122921-00122925 1992 Supplier Report F/S #00122926-00122984 1993 Supplier Report F/S #00122985-00123601 1994 Supplier Report F/S #00123602-00124214 1995 Supplier Report F/S #00124215-00125714 1996 Supplier Report F/S #00125715-00126364 1997 Supplier Report F/S #00126365-00127076 1997 Full Year Cost Report F/S #00171227-00171241 1997 October YTD Cost Report F/S #00171213-00171226 1998 Cost Reduction Metrics F/S #00171242-00171245 1998 Software Spending Deferral Support SNAPP Trial Exhibit 0667 Documents, 9/26/96 1998 Supplier Report F/S #00127077-00127643 1999 Actuals Accomplishments 2000 F/S #00170314-00170333 Initiatives 1999 Actuals Accomplishments, 2000 Ford Production F/S #00170314-00170333 Initiatives 1999 Supplier Report F/S #00127644-00128207 2000 Supplier Report Ford Production F/S #00128208-00128699 2001 Supplier Report F/S #00128700-00129134 2002 Supplier Report F/S #00129135-00129561 2003 Supplier Report F/S #00129562-00129963 2004 Supplier Report F/S #00129964-00130342 ACD Progress Report for Rapid SNAPP EX # 0876 Asset Management — PC Renewal, 2/12/98 — SNAPP Trial Exhibit 0254 2/23/98 Asset Management-PC Renewal Program, SNAPP Trial Exhibit 0926 3/9/98-3/20/98 Batch Supplier Invoice Ford Ex # 2760 Blanket Order Header F/S #00157585-00157647 Canadian Sourcing F/S #00170937-00170941 Comments on NOR Process DOE#45140-45164 Commodity and Product type reports SNAPP Documents contained in Boxes: 933; 934; 935; 936; 937; 938; 939; 940; 941; 942; 943; 944. Commodity Strategy Sheets DOE #21207-21211 Cost Metrics — 2 Quarter 1997 F/S #00171162-00171192 Cost Reduction Metrics F/S #00157566-00157572 Dollar Volume Reporting F/S #00077559-00077565 E-mail to Schmitt from Ebel re: 1999 1stHalf Ford Preliminary Trial Ex. 69 Negotiated Cost Savings Results Email, D. Schmitt to Carmen Zirles, re Ford Preliminary Trial Ex. 500 Microsoft EA Quote, 11/12/98 Email, L.R. Lewis to Matt Portu, 2/6/97, re SNAPP S.J. Ex. 162 Sample Results Email, Michael Taylor to Chris Pazzi, re SNAPP's Preliminary Trial Ex. 62 SNAPP (Sun Workstations) 5/4/95 Europe Operational SNAPP Shots 1-31-98, 5- SNAPP EX #0604 31-98 and 2-28-99 Europe Process Cost Study SNAPP Production EuroSNAPP Shots SNAPP EX #0543 EuroSNAPP Shots 1995 12-31,12-17,11- SNAPP EX #0617 30,11-19,11-12,11-6,10-31,9-30,8-31,7-31,6- 30,,5-31,4-30,4-12 EuroSNAPP Shots 1996 9-30,4-30, 3-31,2-29, SNAPP EX #1071 1-31 and SNAPP Shots 1996 1-31,2-29,3- 31,4-30,7-31,8-31,9-30, 10-31,11-30,12-31 EuroSNAPP Shots 1997 (5/31, 6/30, 7/31, SNAPP Preliminary Trial Ex. 916 8/31, 10/31, 12/31); 1998 (1/31, 5/31). Expenditures amounts by supplier SNAPP Documents contained in Boxes: 907; 908; 923; 924; 925; 926; 927. Facilities Material and Services Purchasing, Ford EX #1676 Purchase Order Transaction Cost, Appendix Facilities, materials and services purchasing F/S 00096030 cost Fax to Chen from Zirles Ford EX # 2079 Fax to Dickson from Zirles re SNAPP Senior Ford EX #2080 Management FM SP 3 Qtr. YTD QOS F/S #00171193-00171204 Ford SNAPP Global Supplier Council, SNAPP Trial Exhibit 0720 5/30/96 Ford USL Leasing Process Analysis, 3/95 SNAPP Trial Exhibit 0063 to 12/95 Ford Financial Review SNAPP EX #1226 Ford Financial Review 4th Quarter 1997, SNAPP Preliminary Trial Ex. 968 2/24/98 Ford Financial Review Agenda SNAPP Preliminary Trial Ex. 710 Attachments, 7/31/98 Ford Financial Review, 1st Quarter 1999 SNAPP Preliminary Trial Ex. 606 Summary, 5/21/99 Ford Financial Review, 3rd 4th Quarter SNAPP Preliminary Trial Ex. 1226 1998, 2/22/99 Ford Financial Review, 8/27/99 SNAPP Preliminary Trial Ex. 592 Ford leases administered by SNAPP SNAPP Documents contained in Boxes: 126; 128; 149; 150; 405; 465; 545; 648; 652; 725; 726; 738; 753; 766; 767; 770; 805; 810; 811; 812. Ford reports F/S #00158124-00158153 Ford Supplier Value Management DOE1-004745-004750 Ford/SNAPP Program Requirements and SNAPP Documents contained in Boxes: 735; Communications 739; 741; 742; 743; 744; 745; 746; 747; 748; 749; 759. Ford/SNAPP Purchasing records — supplier SNAPP Documents contained in Boxes: 70; files, orders and quotes 71; 72; 88; 108; 109; 113; 114; 115; 117; 132; 139; 140; 141; 144; 148; 176; 178; 179; 180; 181; 182; 183; 184; 185; 186; 187; 188; 189; 190; 191; 192; 193; 194; 195; 196; 197; 198; 199; 200; 201; 202; 203; 204; 205; 206; 207; 208; 209; 210; 211; 212; 213; 214; 215; 216; 217; 218; 219; 220; 221; 222; 223; 224; 224B; 225; 226; 227; 228; 229; 230; 231; 232; 233; 234; 235; 236; 237; 238; 239; 240; 241; 242; 243; 244; 245; 246; 247; 248; 249; 250; 251; 252; 253; 254; 255; 256; 257; 258; 259; 260; 261; 262; 263; 404; 407; 408; 409; 410; 411; 412; 413; 414; 415; 416; 417; 418; 419; 420; 421; 422; 423; 424; 425; 426; 427; 429; 447; 448; 451; 452; 453; 454; 455; 456; 458; 462; 468; 476; 477; 482; 483; 484; 491; 499; 500; 501; 502; 506; 507; 513; 516; 518; 556; 572; 575; 618; 619; 680; 681; 682; 683; 684; 685; 686; 687; 688; 689; 690; 691; 692; 693; 695; 697; 698; 699; 700; 701; 702; 703; 704; 705; 706; 707; 730; 731; 732; 734; 736; 737; 752; 754; 768; 769; 827; 828; 829; 830; 831; 832; 833; 878; 880; 881; 882; 883; 884; 885; 886; 887; 888; 890; 895; 896; 897; 898; 902; 957; 958; 959; 960; 961. Ford/SNAPP Supplier contracts SNAPP Documents contained in Boxes: 361; 362; 363; 364; 365; 366; 471; 472; 473; 474; 475; 489; 490; 492; 493; 494; 495; 615; 728; 729. Ford/SNAPP Accounting — supplier invoices SNAPP Documents contained in Boxes: 001; 002; 003; 004; 005; 006; 007; 008; 009; 010; 011; 012; 013; 014; 015; 016; 017; 018; 019; 020; 021; 022; 023; 024; 025; 026; 027; 028; 029; 030; 031; 032; 033; 034; 035; 036; 037; 038; 039; 040; 041; 042; 043; 044; 045; 046; 047; 048; 049; 050; 051; 052; 053; 054; 055; 056; 057; 058; 059; 060; 061; 062; 063; 064; 065; 066; 067; 068; 069; 070; 071; 072; 073; 074; 075; 076; 077; 078; 079; 080; 081; 082; 083; 084; 085; 086; 087; 091; 092; 093; 094; 095; 096; 097; 098; 099; 100; 101; 102; 103; 104; 107; 123; 124; 125; 127; 129; 133; 134; 135; 136; 137; 138; 142; 143; 264; 265; 266; 267; 268; 269; 270; 271; 272; 273; 274; 275; 276; 277; 278; 279; 280; 281; 282; 283; 284; 285; 286; 287; 288; 289; 290; 291; 292; 293; 294; 295; 296; 297; 298; 299; 300; 301; 302; 303; 304; 305; 306; 307; 308; 309; 310; 311; 312; 313; 314; 315; 316; 317; 318; 319; 320; 321; 322; 323; 324; 325; 326; 327; 328; 329; 330; 331; 332; 333; 334; 335; 336; 337; 338; 339; 340; 341; 342; 343; 344; 345; 346; 347; 348; 349; 350; 351; 352; 353; 354; 355; 356; 357; 358; 359; 360; 357; 368; 369; 370; 371; 372; 373; 374; 375; 376; 377; 378; 379; 380; 381; 382; 383; 384; 386; 387; 388; 389; 390; 391; 392; 393; 394; 395; 396; 397; 398; 399; 400; 401; 402; 403; 573; 576; 577; 578; 579; 580; 582; 583; 584; 585; 586; 587; 588; 589; 591; 593; 595; 596; 597; 600; 605; 606; 665; 666; 667; 668; 714; 727. Ford-Third Party Order Processing/Order Ford EX #2613 Payment ISD Planning and Administration, PC SNAPP Trial Exhibit 0766 Renewal, 3/10/98 Memo from Honecker to Nasser, 4/11/97 SNAPP's S.J. Ex. 102 Memo from Kaplan, Myers, Honecker, SNAPP S.J. Ex. 118 Commitments with Suppliers for Purchased Services, 6/20/97 Memo from Susan Lee to Roy re: write-up of Ford EX #2534 RAPID Workshop concerning the Lease Order Process held March 5-7, 1996 North America Pre-Commitment Metrics F/S #00171278-00171302 Notes from Next Day PC Town meeting with Ford EX #1401 Szuluk Payment History Database F/S #00118300-00118355 PC Asset Management PC Renewal Program, SNAPP Trial Exhibit 0276 1/30/98 — 3/5/98 PC Moratorium, 9/97 SNAPP Trial Exhibit 0709 PC Renewal Financial Process, Asset SNAPP Trial Exhibit 0015 Management, 7/23/98 PC Renewal Order and Fulfillment Visteon- SNAPP Trial Exhibit 0300 DSSI-Dell, 6/1/98 PC Renewal Payments, Europe, Canada, US, SNAPP Trial Exhibit 1000 11/3/99 PC Renewal Personnel, 12/98 SNAPP Trial Exhibit 0727 PC Renewal Plans, 9/30/99 SNAPP Trial Exhibit 1007 PC Renewal Program, Internal Billing, SNAPP Trial Exhibit 0827 3/27/98 PC Renewal/PC Thaw, 1/98 to 3/98 SNAPP Trial Exhibit 0422 Pre-commitment Detail Report F/S #00171303-00171387 Pre-commitments purchase orders Ford EX #1343 administrative sourcing strategy (international procurement administrative services — "IPAS") PROFS, Carmen Zirles, Dennis Buckley, SNAPP Preliminary Trial Ex. 1131 Janice Lutes, others re Microsoft EA Quote, 11/12/98-11/16/98 RAPID Recommendation Action Plan 1997 SNAPP EX # 0332 RAPID Recommendation Action Plan Ford EX # 2525 forms/RAPID Workshop name: EURO- SNAPP PAYMENT Sales Invoices SNAPP Documents contained in Boxes 909; 910; 911; 912; 913; 914; 915; 916; 917; 918; 919; 920. SDRC Audit 7/2/99 SNAPP Trial Exhibit 0841 SNAPP Financial Project Summary, 1991- SNAPP Preliminary Trial Ex. 1187 1992 SNAPP Financial Project Summary, 1993 SNAPP Preliminary Trial Ex. 1176 SNAPP Financial Project Summary, 1994 SNAPP Preliminary Trial Ex. 314 SNAPP Financial Project Summary, 1995 SNAPP Preliminary Trial Ex. 551 SNAPP Financial Project Summary, 3rd SNAPP Preliminary Trial Ex. 133 Quarter, 9/30/99 SNAPP Payment Process RAPID, Updates to SNAPP Trial Exhibit 1011 Open Issues, 4/23/96 SNAPP Process Cost Study Agenda Sept 19, SNAPP EX #0545 1997 SNAPP Shots 12-31-1993 to 12-31-1994 SNAPP EX # 1050 SNAPP Shots 1997 5-31,6-30,7-31,8-31,10- SNAPP EX # 0916 31, 12-31, 1998 1-31,5-31 SNAPP's "Quarterly Financial Reviews" for SNAPP Preliminary Trial Exs. 282, 376, each quarter from December 1996 through 384, 411, 506, 596, 606, 656, 775, 895, December, 1999 1206, 1210, 1212, 1272, 1278, 1282, 1371 SNAPP's Financial Project Summary for each SNAPP Preliminary Trial Ex. 411 month from November 1991 through September 1996 Status Report, PC Renewal Program, SNAPP Trial Exhibit 0176 Installation Cascade Process, 4/9/98 Supplier Listing by Department F/S #00161172-00161178 Town Meeting Agenda and handouts Ford EX # 2095 Where are we Today? F/S # 00086613-00086620 Workplan Summary F/S #00086536-00086549 Worldwide Volume of Payment F/S #00172280-00172295 Exhibit Order Statistics Ford Related hold code Total Qty of Total Qty of % of total % of Orders on Orders Orders on orders on Qty of Orders Hold — Ford's Rec'd based Hold based Hold per on Hold-Ford's Responsibility of on Monthly on Monthly Monthly Responsibility monthly Metric Metric Metric statistics Year/Mo 1997/01 2071 1247 60.2% 892 43.1% 1997/02 2338 1357 58.0% 1039 44.4% 1997/03 2360 1468 62.2% 1085 46.0% 1997/04 2411 1426 59.1% 1058 43.9% 1997/05 2484 1348 54.3% 1000 40.3% 1997/06 2492 1349 54.1% 959 38.5% 1997/07 2269 1104 48.7% 748 33.0% 1997/08 2339 1209 51.7% 803 34.3% 1997/09 2218 1238 55.8% 864 39.0% 1997/10 2368 1174 49.6% 835 35.3% 1997/11 1963 1067 54.4% 707 36.0% 1997/12 1976 1036 52.4% 751 38.0% 1998/01 1756 871 49.6% 645 36.7% 1998/02 2015 1022 50.7% 767 38.1% 1998/03 2158 959 44.5% 724 33.6% 1998/04 1743 852 48.9% 595 34.1% 1998/05 1798 839 46.7% 604 33.6% 1998/06 2069 1073 51.9% 815 39.4% 1998/07 1829 1042 57.0% 822 44.9% 1998/08 2189 1238 56.6% 1034 47.2% 1998/09 2488 1592 64.0% 1358 54.5% 1998/10 2489 1579 63.4% 1345 54.0% 1998/11 1731 936 54.1% 742 42.9% 1998/12 1909 1132 59.3% 909 47.6% 1999/01 1776 1056 59.5% 730 41.1% 1999/02 1823 818 44.9% 545 29.9% 1999/03 2699 1580 58.5% 1200 44.5% 1999/04 2135 1169 54.8% 881 41.3% 1999/05 2123 1241 58.5% 933 43.9% 1999/06 2102 1124 53.5% 852 40.5% 1999/07 1853 941 50.8% 737 39.8% 1999/08 1868 822 44.0% 569 30.5% 1999/09 2024 931 46.0% 716 35.4% 1999/10 2044 1047 51.2% 848 41.5% 1999/11 1861 984 52.9% 838 45.0% 1999/12 1431 705 49.3% 550 38.4% total 75198 40576 54.0% 30498 40.6% averages 2089 1127 54.0% 847 40.3%


Summaries of

Auto Industries Supplier Esop v. Snapp Systems, Inc.

United States District Court, E.D. Michigan, Southern Division
Dec 23, 2008
Case No. 03-74357 (E.D. Mich. Dec. 23, 2008)
Case details for

Auto Industries Supplier Esop v. Snapp Systems, Inc.

Case Details

Full title:AUTO INDUSTRIES SUPPLIER EMPLOYEE STOCK OWNERSHIP PLAN (ESOP), Plaintiff…

Court:United States District Court, E.D. Michigan, Southern Division

Date published: Dec 23, 2008

Citations

Case No. 03-74357 (E.D. Mich. Dec. 23, 2008)

Citing Cases

Saginaw Chippewa Indian Tribe of Mich. v. Blue Cross Blue Shield of Mich.

would simply regurgitate Myrick's calculations and conclusions. See Auto Indus. Supplier Emp. Stock Ownership…

Guy v. Absopure Water Co.

See Auto Indus. Supplier Emp. Stock Ownership Plan (ESOP) v. Snapp Sys., Inc., No. 03-74357, 2008 WL…