EX-D Quarterly Tour Expenses ASF

Document Sample
EX-D Quarterly Tour Expenses ASF Powered By Docstoc
					Your Name



                                            Quest Specialty Travel                                                                        Total Expenses, by Country
Cell A12 reads “United                       2013 Quarterly Tour
                                          FY Cell D11 contains 4568.92 Expenses
                                                                                                                           Australia   Britain   Canada   France   Germany     India    Japan   United States
                Quarter 1      Quarter 2       Quarter 3     Quarter 4                           Total
Australia            5,367.40         5,860.49      6,583.12      6,133.14                        $    23,944.15
Britain              3,510.99         3,921.46      4,337.40      4,558.11                        $    16,327.96
                                                                                                                                                           19%      17%
Canada               4,287.76
                  “Quarterly Tour 4,371.98          4,570.21      4,100.06                        $    17,330.01
                                                                                                                                                   11%                       11%
France            Expenses” title is offset
                     4,032.10         4,489.74      4,579.06      4,653.92                        $    17,754.82                                                          Pie chart title is “Total Expenses, by
Germany           diagonally, with drop
                     5,082.77         2,994.56      3,561.12      3,712.50                        $    15,350.95                                                           12%
                                                                                                                                                                          Country”
                                                                                                                                                          11%      12%
India             shadow, Times New
                     1,468.25         2,510.30      2,665.04      2,890.95                        $     9,534.54
Japan             Roman, 8 pt, blue 3,556.14
                     3,271.50                       4,568.92      3,721.69                        $    15,118.25                        7%
United States        7,195.06         6,542.76      6,107.09      7,018.91                        $    26,863.82
          Total $ 34,215.83 $ 34,247.43 $ 36,971.96 $ 36,789.28                                   $ 142,224.50

                                                                                                                                        India data point is exploded from pie

                    Great improvement               Quarterly Tour ExpensesCell D12 contains 6107.09Chart widened to extend to column G
                   8,000.00                                                                                          Quarter 1
                   7,000.00                                                                                                            Chart gridlines are off
                                                                                                                     Quarter 2                                                         Embedded pie chart
   Expenss (in$)




                   6,000.00
                   5,000.00                                                                                                                                                            included based on
                                                                                                                     Quarter 3
                   4,000.00                                                                                                                                                            range A5:A11 and
                   3,000.00                                                                                          Quarter 4   Data series color fill matches Figure D-17            F5:F12
                   2,000.00
                   1,000.00
                         -
                              Australia   Britain    Canada   France   Germany     India     Japan   United States
                                                              Tour Countries
                                                                                   Chart includes annotation “Great
                                                                                   Improvement” with arrow
Vertical axis title is “Expenses (in $)”


                                                                Title “Tour Countries” is primary axis
                                                                title
    Embedded chart included based
    on range A4:E12: quarters are on
    x-axis, expense amounts per
    country on y-axis, chart title is                           Print orientation is landscape, No
    Quarterly Tour Expenses                                     scaling, Fit on one page

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:20
posted:11/22/2012
language:English
pages:1