From: CBS%UK.AC.RUTHERFORD.MAIL::EARN.UICVM::TEISTEER 4-MAY-1989 21:14:20.38 To: LOU,SUSAN CC: Subj: Details of American Budget Analysis (TEI B7) Via: UK.AC.RUTHERFORD.MAIL; Thu, 4 May 89 21:14 BST Received: from UKACRL by UK.AC.RL.IB (Mailer X1.25) with BSMTP id 2320; Thu, 04 May 89 21:12:19 BS Received: from UICVM by UKACRL.BITNET (Mailer X1.25) with BSMTP id 1994; Thu, 04 May 89 21:12:19 B Received: by UICVM (Mailer R2.02) id 6874; Thu, 04 May 89 15:12:04 CDT Date: 4 May 1989 14:54:25 CDT Reply-To: Text Encoding Initiative Steering Committee List , Michael Sperberg-McQueen 312 996-2477 -2981 Sender: Text Encoding Initiative Steering Committee List Comments: "ACH / ACL / ALLC Text Encoding Initiative" From: Michael Sperberg-McQueen 312 996-2477 -2981 Subject: Details of American Budget Analysis (TEI B7) To: Lou Burnard , Susan Hockey I append the calculations which led me to the conclusions I sent you the other day: first a summary of the budget categories with compensible North American expenses, and then a recapitulation of our calculations in Oxford, with a comparison of the original figures. The summary is budget document 7 (TEI B7). Its columns show the budget line, the original amount allocated to that in the revised NEH budget of July 1988, the amount spent so far (this is the amount for which vouchers have passed through my hands, except for some Advisory Board travel receipts still outstanding), my current best estimate of the amount of money spent or committed in 1988-89 (through 31 May 89), our current best estimate of costs in 1989-90, the total currently estimated, and the difference vis-a-vis the revised NEH budget of July 1988. (Positive numbers are in our favor, negative mean we are over the original budget.) The key figure in the first part is at the lower right; it shows us $625.81 over our original estimate of $198,779.54 (of which we have raised about $184,000). The second part shows where we went wrong in estimating the American funds in Oxford: we calculated direct costs only, not overhead. Respectfully, Michael ----- TEI B7 ----- TEI B7 - American Budget summary (NEH funds only) 2 May 89 (under time pressure) Line NEH 7/88 Spent Est 88 tot Est 89 Total Balance Salaries editor $ 31,262.50 $ 4,050.00 $11,437.50 $ 16,012.00 $ 27,449.50 $ 3,813.00 clerical $ 5,125.00 $ 260.00 $ 1,000.00 $ 2,625.00 $ 3,625.00 $ 1,500.00 TD $ 0.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00 AI $ 14,531.25 $ 0.00 $ 6,510.42 $ 16,250.00 $ 22,760.42 $ -8,229.17 ML $ 14,531.25 $ 0.00 $ 8,576.00 $ 16,767.00 $ 25,343.00 $-10,811.75 Tot Sal $ 65,450.00 $ 4,310.00 $27,523.92 $ 51,654.00 $ 79,177.92 $-13,727.92 Fringe ed $ 4,103.52 $ 509.28 $ 1,501.50 $ 2,102.00 $ 3,603.50 $ 500.02 cler $ 13.32 $ 0.63 $ 6.00 $ 7.00 $ 13.00 $ 0.32 TD $ 0.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00 AI $ 3,632.81 $ 0.00 $ 1,041.67 $ 2,600.00 $ 3,641.67 $ -8.86 ML $ 3,632.81 $ 0.00 $ 1,492.00 $ 2,736.00 $ 4,228.00 $ -595.19 Tot Frin $ 11,382.46 $ 509.91 $ 4,041.17 $ 7,445.00 $ 11,486.17 $ -103.71 Travel SC Eurtrip $ 4,756.00 $ 615.45 $ 615.45 $ 3,000.00 $ 3,615.45 $ 1,140.55 NA trip $ 11,000.00 $ 3,770.67 $ 3,771.67 $ 1,800.00 $ 5,571.67 $ 5,428.33 SC tot $ 15,756.00 $ 4,386.12 $ 4,387.12 $ 4,800.00 $ 9,187.12 $ 6,568.88 CH EurTrip $ 0.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00 $ 0.00 NA trip $ 3,224.00 $ 2,320.69 $ 2,320.69 $ 1,400.00 $ 3,720.69 $ -496.69 CH tot $ 3,224.00 $ 2,320.69 $ 2,320.69 $ 1,400.00 $ 3,720.69 $ -496.69 AB NAtrip $ 7,852.00 $ 9,231.99 $ 9,231.99 $ 0.00 $ 9,231.99 $ -1,379.99 AB Tot $ 7,852.00 $ 9,231.99 $ 9,231.99 $ 0.00 $ 9,231.99 $ -1,379.99 Ed trav NAtrips $ 8,080.00 $ 6,140.36 $ 6,140.36 $ 4,000.00 $ 10,140.36 $ -2,060.36 Eurtrip $ 10,800.00 $ 0.00 $ 0.00 $ 5,400.00 $ 5,400.00 $ 5,400.00 Ed tot $ 18,880.00 $ 6,140.36 $ 6,140.36 $ 9,400.00 $ 15,540.36 $ 3,339.64 WorkCom Eurtrip $ 45,000.00 $ 0.00 $ 0.00 $ 48,100.00 $ 48,100.00 $ -3,100.00 NA trip $ 38,688.00 $ 0.00 $ 0.00 $ 21,000.00 $ 21,000.00 $ 17,688.00 WkC HALF $ 41,844.00 $ 0.00 $ 0.00 $ 34,550.00 $ 34,550.00 $ 7,294.00 Tot Trav $ 87,556.00 $22,079.16 $22,080.16 $ 50,150.00 $ 72,230.16 $ 15,325.84 Supplies Doc $ 1,500.00 $ 52.00 $ 750.00 $ 750.00 $ 1,500.00 $ 0.00 Sup Tot $ 1,500.00 $ 52.00 $ 750.00 $ 750.00 $ 1,500.00 $ 0.00 Tot Dir $165,888.46 $26,951.07 $54,395.25 $109,999.00 $164,394.25 $ 1,494.21 Indir uic 10 $ 8,755.60 $ 2,207.92 $ 2,208.02 $ 5,015.00 $ 7,223.02 $ 1,532.58 uic 38 $ 15,961.65 $ 1,851.33 $ 5,584.10 $ 8,168.48 $ 13,752.58 $ 2,209.07 Ariz $ 4,086.91 $ 0.00 $ 378.00 $ 942.50 $ 1,320.50 $ 2,766.41 OSU $ 4,086.91 $ 0.00 $ 4,329.00 $ 8,386.00 $ 12,715.00 $ -8,628.09 other Ind Tot $ 32,891.08 $ 4,059.24 $12,499.12 $ 22,511.98 $ 35,011.10 $ -2,120.02 Tot Cost $198,779.54 $31,010.31 $66,894.37 $132,510.98 $199,405.35 $ -625.81 Alternate Calculation: Cash on Hand, Commitments made Estimate Oxford est. Orig NEH $148,895.00 $148,895.00 Matching $ 36,366.00 $25,000.00 i.e. 33000 ECU * 1.1020 Total $185,261.00 $173,895.00 Item Estimate Oxford est. Commentary / Discrepancy Spent $ 31,010.31 $21,889.00 Salaries $ 74,867.92 $90,744.00 Fringe Ben. $ 10,976.26 $13,072.00 Indirect $ 30,951.86 $ 0.00 !!! Total $147,806.35 $125,705.00 Remaining $ 37,454.65 $48,190.00 for Travel Oxford estimate roughly correct for direct costs, but omitted overhead, leading to overoptimistic result. -----