阳光灿烂队木兰围场财务明细

阳光灿烂了

<p>感谢本活动&quot;CFO&quot;森林同学的辛苦！！！</p>
<p>下述财务明细是&quot;CFO&quot;发给我的，请各位同学审阅。</p>
<p>
<table style="WIDTH: 346pt; BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" width="460" border="0" x:str="">
    <colgroup><col style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1280" width="40"></col><col style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 2880" span="2" width="90"></col><col style="WIDTH: 54pt" span="2" width="72"></col><col style="WIDTH: 72pt; mso-width-source: userset; mso-width-alt: 3072" width="96"></col></colgroup>
    <tbody>
        <tr style="HEIGHT: 14.25pt" height="19">
            <td class="xl75" style="WIDTH: 346pt; HEIGHT: 14.25pt" width="460" colspan="6" height="19">7.25-7.27塞罕坝财务明细</td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl65" style="HEIGHT: 12pt" height="16">&nbsp;</td>
            <td class="xl63">&nbsp;</td>
            <td class="xl63">&nbsp;</td>
            <td class="xl63">&nbsp;</td>
            <td class="xl63">&nbsp;</td>
            <td class="xl64">&nbsp;</td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl66" style="HEIGHT: 12pt" height="16">日期</td>
            <td class="xl66" style="BORDER-LEFT: medium none" colspan="2">项目</td>
            <td class="xl66" style="BORDER-LEFT: medium none">金额（元）</td>
            <td class="xl66" style="BORDER-LEFT: medium none">人数</td>
            <td class="xl67" style="BORDER-LEFT: medium none">人均</td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl66" style="BORDER-TOP: medium none; HEIGHT: 120pt" height="160" rowspan="10" x:num="">7.25</td>
            <td class="xl73" style="BORDER-LEFT: medium none" colspan="2">预支车费</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">1000</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="76.92307692307692" x:fmla="=D4/E4">76.92 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl73" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">零食</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">21.5</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="1.6538461538461537" x:fmla="=D5/E5">1.65 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl73" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">矿泉水（1箱）</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">20</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="1.5384615384615385" x:fmla="=D6/E6">1.54 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl73" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">西瓜</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">17.5</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="1.3461538461538463" x:fmla="=D7/E7">1.35 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl73" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">门票（75*14）</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">1050</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="80.769230769230774" x:fmla="=D8/E8">80.77 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl73" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">保险（5*14)</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">70</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="5.384615384615385" x:fmla="=D9/E9">5.38 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl73" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">地图</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">10</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="0.76923076923076927" x:fmla="=D10/E10">0.77 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl73" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">晚餐</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">620</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="47.692307692307693" x:fmla="=D11/E11">47.69 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl73" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">住宿（30*14）</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">420</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="32.307692307692307" x:fmla="=D12/E12">32.31 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl72" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">小计</td>
            <td class="xl70" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="" x:fmla="=SUM(D4:D12)">3229</td>
            <td class="xl70" style="BORDER-TOP: medium none; BORDER-LEFT: medium none">　</td>
            <td class="xl71" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="248.38461538461542" x:fmla="=SUM(F4:F12)">248.38 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl66" style="BORDER-TOP: medium none; HEIGHT: 168pt" height="224" rowspan="14" x:num="">7.26</td>
            <td class="xl73" style="BORDER-LEFT: medium none" colspan="2">早餐（10*14）</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">140</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="10.76923076923077" x:fmla="=D14/E14">10.77 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl73" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">矿泉水（2箱）</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">44</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="3.3846153846153846" x:fmla="=D15/E15">3.38 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl73" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">西瓜</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">25</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="1.9230769230769231" x:fmla="=D16/E16">1.92 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl73" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">中餐</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">267</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="20.53846153846154" x:fmla="=D17/E17">20.54 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl73" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">晚餐</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">480</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="36.92307692307692" x:fmla="=D18/E18">36.92 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl73" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">住宿（30*14）</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">420</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="32.307692307692307" x:fmla="=D19/E19">32.31 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl72" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">小计</td>
            <td class="xl70" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="" x:fmla="=SUM(D14:D19)">1376</td>
            <td class="xl70" style="BORDER-TOP: medium none; BORDER-LEFT: medium none">　</td>
            <td class="xl71" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="105.84615384615384" x:fmla="=SUM(F14:F19)">105.85 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl66" style="BORDER-TOP: medium none; HEIGHT: 60pt" height="80" rowspan="5">骑马</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none">手套</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">15</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">10</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="1.5" x:fmla="=D21/E21">1.50 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none; HEIGHT: 12pt" height="16">护腿</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">200</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">10</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="20" x:fmla="=D22/E22">20.00 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none; HEIGHT: 12pt" height="16">7人整天马费</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">1260</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">7</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="180" x:fmla="=D23/E23">180.00 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none; HEIGHT: 12pt" height="16">3人半天马费</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">270</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">3</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="90" x:fmla="=D24/E24">90.00 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none; HEIGHT: 12pt" height="16">分摊马倌费用</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">270</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">10</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="27" x:fmla="=D25/E25">27.00 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl72" style="BORDER-TOP: medium none; HEIGHT: 24pt" height="32" rowspan="2">小计</td>
            <td class="xl70" style="BORDER-TOP: medium none; BORDER-LEFT: medium none">7人整天</td>
            <td class="xl72" style="BORDER-TOP: medium none" rowspan="2" x:num="" x:fmla="=SUM(D21:D25)">2015</td>
            <td class="xl70" style="BORDER-TOP: medium none; BORDER-LEFT: medium none">　</td>
            <td class="xl71" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="228.5" x:fmla="=F21+F22+F23+F25">228.50 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl70" style="BORDER-TOP: medium none; BORDER-LEFT: medium none; HEIGHT: 12pt" height="16">3人半天</td>
            <td class="xl70" style="BORDER-TOP: medium none; BORDER-LEFT: medium none">　</td>
            <td class="xl71" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="138.5" x:fmla="=F21+F22+F24+F25">138.50 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl66" style="BORDER-TOP: medium none; HEIGHT: 48pt" height="64" rowspan="4" x:num="">7.27</td>
            <td class="xl66" style="BORDER-LEFT: medium none" colspan="2">早餐（5*14）</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">70</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="5.384615384615385" x:fmla="=D28/E28">5.38 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl66" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">中餐</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">215</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="16.53846153846154" x:fmla="=D29/E29">16.54 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl66" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">补齐车费</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">1900</td>
            <td class="xl68" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="">13</td>
            <td class="xl69" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="146.15384615384616" x:fmla="=D30/E30">146.15 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl72" style="BORDER-LEFT: medium none; HEIGHT: 12pt" colspan="2" height="16">小计</td>
            <td class="xl70" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="" x:fmla="=SUM(D28:D30)">2185</td>
            <td class="xl70" style="BORDER-TOP: medium none; BORDER-LEFT: medium none">　</td>
            <td class="xl71" style="BORDER-TOP: medium none; BORDER-LEFT: medium none" align="right" x:num="168.07692307692309" x:fmla="=SUM(F28:F30)">168.08 </td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl74" style="WIDTH: 346pt; HEIGHT: 24pt" width="460" colspan="6" height="32" rowspan="2">note 1: 住宿、餐饮、门票等包含司机张师傅的费用，由大家分摊</td>
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl74" style="WIDTH: 346pt; HEIGHT: 57pt" width="460" colspan="6" height="76" rowspan="2">note 2: 不骑马的3人（蜈蚣、梅花鹿、BeMe）人均总费用为522.31；骑马全天的7人（阳光、Sarah、森林、dingqi323、firefly、羔狼、goldfishy)人均总消费750.81；骑马半天的3人（紫苔、haitao、jaunty)人均总消费660.81。小数点后省略。</td>
        </tr>
        <tr style="HEIGHT: 45pt; mso-height-source: userset" height="60">
        </tr>
        <tr style="HEIGHT: 12pt" height="16">
            <td class="xl74" style="WIDTH: 346pt; HEIGHT: 33pt" width="460" colspan="6" height="44" rowspan="2">Note 3：塞罕坝的门票有的队伍是70/人，可能是团体票，cfo买票时询问过，卖票处说没有，没给卖，所以是75/人。</td>
        </tr>
        <tr style="HEIGHT: 21pt; mso-height-source: userset" height="28">
        </tr>
    </tbody>
</table>
</p>

阳光灿烂了