Ok, new spreadsheet. Includes additional budget for brakes, more realistic estimate for tires, a very small budget for spare parts, and 1,000 for the
roll cage (DOM). If you know of a cheaper way to get a roll cage than back it up with a link.
The team commitment for each driver will be $645+/- a few hundred. That is on top of paying $100 to enter, $50 for a license, and as much as $415 for a suit and helmet. We might save money on some things here, but we'll just end up spending it on spare parts. if we get a cage for $500 and come across tires on the cheap, we're still looking at $500 team commitment per driver.
<table x:str="" style="border-collapse: collapse; width: 249pt;" width="331" border="0" cellpadding="0" cellspacing="0"><col style="width: 98pt;" width="131"> <col style="width: 48pt;" width="64"> <col style="width: 53pt;" width="70"> <col style="width: 50pt;" width="66"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 98pt;" width="131" height="17">TEAM EXPENSES</td> <td style="width: 48pt;" width="64">
</td> <td style="width: 53pt;" width="70">
</td> <td style="width: 50pt;" width="66">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Vehicle</td> <td class="xl22" x:num="" align="right">500.00</td> <td x:num="" align="right">1</td> <td class="xl22" x:num="" x:fmla="=PRODUCT(B2:C2)" align="right">500.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Vehicle Sales Tax</td> <td class="xl22" x:num="" align="right">25.00</td> <td x:num="" align="right">1</td> <td class="xl22" x:num="" x:fmla="=PRODUCT(B3:C3)" align="right">25.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Team Entry Fee</td> <td class="xl22" x:num="" u1:num="" align="right">500.00</td> <td x:num="" u1:num="" align="right">1</td> <td class="xl22" x:num="" x:fmla="=PRODUCT(B4:C4)" u1:num="" u1:fmla="=PRODUCT(B2:C2)" align="right">500.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" u1:num="" height="17">Tires</td> <td class="xl22" x:num="" u1:num="3205" u1:fmla="=SUM(D2<img src=" http:="" static.mazdas247.com="" smilies="" biggrin.gif="" border="0" alt="" align="right">100.00</td> <td x:num="" align="right">8</td> <td class="xl22" x:num="" x:fmla="=PRODUCT(B5:C5)" align="right">800.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Wheels</td> <td class="xl22" x:num="" align="right">50.00</td> <td x:num="" align="right">4</td> <td class="xl22" x:num="" x:fmla="=PRODUCT(B6:C6)" align="right">200.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Brakes</td> <td class="xl22" x:num="" align="right">200.00</td> <td x:num="" align="right">1</td> <td class="xl22" x:num="" x:fmla="=PRODUCT(B7:C7)" align="right">200.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Rollcage</td> <td class="xl22" x:num="1000" align="right">1,000.00</td> <td x:num="" align="right">1</td> <td class="xl22" x:num="1000" x:fmla="=PRODUCT(B8:C8)" align="right">1,000.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Racing Seat</td> <td class="xl22" x:num="" align="right">200.00</td> <td x:num="" align="right">1</td> <td class="xl22" x:num="" x:fmla="=PRODUCT(B9:C9)" align="right">200.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">5-point harness</td> <td class="xl22" x:num="" align="right">75.00</td> <td x:num="" align="right">1</td> <td class="xl22" x:num="" x:fmla="=PRODUCT(B10:C10)" align="right">75.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Fire Extinguisher</td> <td class="xl22" x:num="" align="right">20.00</td> <td x:num="" align="right">1</td> <td class="xl22" x:num="" x:fmla="=PRODUCT(B11:C11)" align="right">20.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Neck Brace</td> <td class="xl22" x:num="" align="right">45.00</td> <td x:num="" align="right">2</td> <td class="xl22" x:num="" x:fmla="=PRODUCT(B12:C12)" align="right">90.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Exhaust Parts</td> <td class="xl22" x:num="" align="right">0.00</td> <td x:num="" align="right">0</td> <td class="xl22" x:num="" x:fmla="=PRODUCT(B13:C13)" align="right">0.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Kill Switch</td> <td class="xl22" x:num="" align="right">15.00</td> <td x:num="" align="right">1</td> <td class="xl22" x:num="" x:fmla="=PRODUCT(B14:C14)" align="right">15.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Spare Parts</td> <td class="xl22" x:num="" align="right">100.00</td> <td x:num="" align="right">1</td> <td class="xl22" x:num="" x:fmla="=PRODUCT(B15:C15)" align="right">100.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Fluids</td> <td class="xl22" x:num="" align="right">150.00</td> <td x:num="" align="right">1</td> <td class="xl22" x:num="" x:fmla="=PRODUCT(B16:C16)" align="right">150.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td class="xl22">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td u1:num="534.16666666666663" u1:fmla="=D18/6">
</td> <td u1:num="">Total:</td> <td class="xl22" x:num="3875" x:fmla="=SUM(D2
16)" u1:num="534.16666666666663" u1:fmla="=PRODUCT(B22:C22)" align="right">3,875.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" u1:num="" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td># of Drivers:</td> <td x:num="" u1:num="999.16666666666663" u1:fmla="=SUM(D22<img src=" http:="" static.mazdas247.com="" smilies="" biggrin.gif="" border="0" alt="" align="right">6</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">DRIVER EXPENSES</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Team Commitment</td> <td>
</td> <td>
</td> <td x:num="645.83333333333337" x:fmla="=D18/D20" align="right">645.8333</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Driver Entry Fee</td> <td>
</td> <td>
</td> <td x:num="" align="right">100</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Lemon License</td> <td>
</td> <td>
</td> <td x:num="" align="right">50</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Helmet & Race suit</td> <td>
</td> <td>
</td> <td x:num="" align="right">415</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>Total:</td> <td x:num="1060.8333333333335" x:fmla="=SUM(D23,D26)" align="right">1060.833</td> </tr> </tbody></table>