The data is for a subset of dealerships and was collected for the second week of August 2016. Number of Dealership sales New Car Identifier people Brand A1 13 VW A2 5 VW A3 6 VW A4 7 VW A5 6 Dodge A6 6 VW A7 10 Toyota A8 13 Honda A9 15 VW A10 13 Dodge A11 15 Toyota A12 14 Ford A13 13 Ford A14 20 Ford A15 15 Honda A16 11 Toyota A17 9 VW A18 14 Dodge A19 8 Honda A20 13 Honda A21 13 Dodge A22 6 Ford A23 19 Ford A24 16 Toyota A25 10 Dodge A26 18 Dodge A27 13 VW A28 18 Dodge A29 18 Toyota A30 5 VW A31 20 Toyota A32 5 Ford A33 14 VW A34 17 Dodge A35 10 VW A36 15 Dodge A37 17 VW A38 12 Dodge A39 13 Ford A40 10 Ford Number of Number of Better New cars Used Cars Business Profit from sold each sold each Bureau New Car week week Rating Sales 11 6 AAA $42,207.00 4 4 AAA $14,296.00 8 6 A $25,336.00 5 7 AAA $16,975.00 6 5 A $24,150.00 10 4 AA+ $36,830.00 3 5 AAA $12,486.00 8 2 AA $31,352.00 15 3 AAA $43,875.00 15 7 AA+ $46,215.00 8 7 AAA $29,792.00 7 8 AA+ $27,202.00 5 6 A $14,995.00 5 2 AAA $15,265.00 15 8 A $47,595.00 14 3 AAA $52,248.00 5 7 AAA $15,675.00 4 3 AA+ $12,448.00 11 4 AA+ $38,522.00 5 8 AAA $14,670.00 4 6 AAA $14,016.00 5 5 AA $17,225.00 11 4 AA $37,532.00 4 5 AA $16,292.00 15 8 AA $61,800.00 12 7 AA+ $40,440.00 7 8 AAA $28,105.00 11 5 A $44,638.00 5 5 AAA $15,455.00 6 6 AAA $20,460.00 13 3 A $46,436.00 5 4 A $14,160.00 13 3 AAA $49,439.00 3 4 AA+ $10,308.00 14 8 AA $48,440.00 15 4 A $58,590.00 4 6 AAA $14,316.00 12 5 AAA $46,056.00 13 3 AA $38,844.00 10 8 A $41,320.00 Profit from Used Car Sales $17,334.00 $16,176.00 $6,158.00 $18,951.00 $2,765.00 $11,260.00 $19,410.00 $1,426.00 $15,492.00 $17,989.00 $23,865.00 $17,216.00 $6,098.00 $14,986.00 $6,672.00 $15,183.00 $22,241.00 $11,600.00 $13,000.00 $25,488.00 $21,804.00 $3,435.00 $2,212.00 $3,220.00 $4,856.00 $17,310.00 $19,576.00 $2,620.00 $16,205.00 $17,700.00 $92.00 -$548.00 $15,480.00 $13,732.00 $9,072.00 -$228.00 $20,046.00 $20,630.00 $2,710.00 $6,936.00 Total Profit $59,541.00 $30,472.00 $31,494.00 $35,926.00 $26,915.00 $48,090.00 $31,896.00 $32,778.00 $59,367.00 $64,204.00 $53,657.00 $44,418.00 $21,093.00 $30,251.00 $54,267.00 $67,431.00 $37,916.00 $24,048.00 $51,522.00 $40,158.00 $35,820.00 $20,660.00 $39,744.00 $19,512.00 $66,656.00 $57,750.00 $47,681.00 $47,258.00 $31,660.00 $38,160.00 $46,528.00 $13,612.00 $64,919.00 $24,040.00 $57,512.00 $58,362.00 $34,362.00 $66,686.00 $41,554.00 $48,256.00 Bicycle Car Metro Minutes Late to Work <5 5 to 10>10 3 6 3 4 12 15 2 3 1 Day 1 2 3 4 5 6 7 # Orders # Not Correct 40 10 40 10 40 16 40 8 40 11 40 10 40 15 Windshields 1 2 3 4 5 6 Flaws in Windshields 4 4 6 3 3 5 Day 1 2 3 4 5 6 7 8 9 10 Supbroup size Subgroup Mean 5 2.4 5 2.94 5 3.68 5 2.78 5 3.99 5 3.6 5 2.89 5 1.86 5 3.43 5 2.34 Subgroup Range 3.35 4.98 3.46 4.27 4.32 4.84 3.97 3.81 3.48 3.24 Fund Accessor Internatl Equity "Adv" Aetna "I" International Amer Century Intl Discovery "Inv" Columbia International Stock Concert Inv "A" Internatl Equity Dreyfus Founders Intl Equity "F" Driehaus International Growth Excelsior "Inst" Internatl Equity Julius Baer International Equity Marshall International Stock "Y" MassMutual Internatl Equity "S" Morgan Grenfell Intl Sm Cap "Inst" New England "A" Internatl Equity Pilgrim Internatl Small Cap "A" Republic International Equity Sit International Growth Smith Barney "A" Internatl Equity State St Research "S" Intl Equity Strong International Stock Vontobel International Equity Annual Expense Ratio (%) Return (%) 1.59 49 1.35 52 1.68 89 1.56 58 2.16 131 1.8 59 1.88 99 0.9 53 1.79 77 1.49 54 1.05 57 1.25 61 1.83 88 1.94 122 1.09 71 1.5 51 1.28 60 1.65 50 1.61 93 1.5 47 Time Period (Week) 1 2 3 4 5 6 7 8 9 10 Ice Cream Average Sales Temperature hundreds Fahrenheit of gallons 73 110 65 95 81 135 90 160 75 97 77 105 82 120 93 175 86 140 79 121 Month Demand January 149 February 154 March 150 April 152 May 158 June 162 July 161 August 173 September 165 October 176 November 180 December 178 #N/A 149 134 86 -112 -922 -4174 -17179 -69235 -277435 -1110268 -4441612 149 149 149 149 149 149 149 149 149 149 149 #N/A 165 174.9 179.49 Weeks Monday Tuesday Wednesday Thursday 1 219 274 673 351 2 245 306 712 344 3 265 312 693 375 729 892 2078 1070 Friday Saturday Sunday 303 326 1053 324 319 1145 346 360 1138 973 1005 3336 0.0723 0.088466 0.20608946 0.106119 0.096499 0.099673 0.330854 3199 3395 3489 10083 #NAME? 113.5476