I need help with the rest of the homework. Please do not add or delete columns or rows. Please do not change font, or color unless instructed.

Assignm Please do not (otherwise you will jeopardize the grading proce -rename this workbook -rename any sheets -insert/delete any columns in a sheet -insert/delete any rows in a sheet Read the Multiple Choice and Excel assignment(s) carefully an You have to complete every cell colored yellow For every cell colored yellow, you have to decide: Dropdown -> Every cell with a dropdown, choose the Value -> enter the appropriate numeric, date/time or Formula -> enter the appropriate formula e.g. '=A1+B Array Formula -> enter the appropriate array formula The initial due date/time for this assignment is Friday, May 06 The retake due date/time for this assignment is Friday, May 06 Cell comments: every cell you must complete has a cell comment. The cell comment has spe When you rest the pointer on the cell, the comment appears. Four items of information will 1. 2. cell value - whether the cell value will be date, logical value, number, text cell formula - simple or array the formula tokens will be provided and sorted e.g. 0 (3), 1 (2), 12 (4), H the formula operators */+-^() are not provided if a formula token is used more than once in the formula, the token cou 3. cell formatting - Excel lets you change many of the ways it displays data in a cell. Fo to the cell. You can access and modify the majority of these settings in the Format characteristics. 4. cell name - any required cell name will be indicated Excel instructions: column AA will contain any Excel instructions for a chart, conditional form Assignment Instructions Exam: 2 he grading process): nt(s) carefully and do the following: o decide: own, choose the appropriate response from the dropdown ric, date/time or text value mula e.g. '=A1+B1' press Enter te array formula e.g. '=LINEST(A1:A12, B1:B12, True, True)' press Ctrl+Shift+Enter s Friday, May 06, 2016 --- 6:00:00 PM is Friday, May 06, 2016 --- 6:00:00 PM he cell comment has specific information for the student. When a cell has a comment, a red indicator appears in the corner ems of information will be provided to the student in the cell comment. , number, text e.g. 0 (3), 1 (2), 12 (4), H18 (4), H20 (2), H36 (2), I29 (2), I33 (2), IF, ROUNDUP formula, the token count will appear in parentheses e.g. 0 (3), H18 (4) displays data in a cell. For example, you can specify the number of digits to the right of a decimal point, or you can add a patt settings in the Format Cells dialog box (on the Format menu, click Cells). The student is required to only set 12 commonly u chart, conditional formatting, tables, data tables, range names, pivot tables, etc. trl+Shift+Enter r appears in the corner of the cell. nt, or you can add a pattern and border only set 12 commonly used formatting Megan, Inc. uses the following standard costs per unit for one of its products: Direct labor (2.00 $2.50/hr.) = $5.00. The flexible budget for overhead is $120,000 plus $1.00 per direct labor hou costs of $227,000, total fixed overhead of $124,200, 84,100 hours worked, and 39,000 units pro MC-001 The overhead production volume variance for Megan, Inc. for the month is: Answer: A. B. C. D. E. $4,200 unfavorable $3,000 unfavorable $18,700 unfavorable $32,000 unfavorable $6,100 unfavorable B. Zero Company's standard factory overhead rate is $3.69 per direct labor hour (DLH), calculated the company operated at 79.00% of capacity, or 790 standard DLHs. Budgeted factory overhead fixed overhead. For December, the actual factory overhead cost was $3,740 for 842 actual DLHs MC-002 Assuming the use of a four-way breakdown (decomposition) of the total overhead variance, wh for Zero Company in December? Answer: MC-003 A. B. C. D. E. $139 unfavorable $116 unfavorable $755 unfavorable $587 unfavorable $87 favorable B. Examine this algebra. Answer: A. B. C. D. E. A. MC-004 Answer: MC-005 What does this algebraic model represent? Variable cost planning Total contribution margin Contribution margin per unit Profit planning Revenue planning Examine this diagram. A. B. C. D. E. What does this diagram represent - choose the best answer. The CVP Graph The Profit- Volume Graph Illustrates how the levels of revenues and total fixed costs change over different levels of sales volume e Illustrates how the levels of revenues and total costs change over different levels of sales volume expres None of the above D. Armer Company is accumulating data to use in preparing its annual profit plan for the coming year. The determined. The accounting staff has suggested the use of linear regression to derive an equation for m maintenance hours and costs for the last year and the results of the regression analysis follow: Month January Maintenance Cost $4,200 Machine Hours 490 February March April May June July August September October November December Sum Average $3,000 $3,540 $2,805 $4,281 $2,898 $2,990 $4,409 $4,226 $4,000 $3,250 $3,132 $42,731 $3,561 Average cost per hour a (intercept) b (coefficient) Standard error of the estimate R-squared t-value for b 317 390 300 500 307 315 511 490 463 356 338 4,777 398 $8.95 $693.97 $7.20 28.2915 .9981 72.4888 If Armer Company uses the high-low method of analysis, the equation for the relationship between hou Answer: MC-006 A. B. C. D. E. y = $693.97 + $7.20x y = $524.43 + $7.20x y = $693.97 + $7.60x y = $524.43 + $7.60x None of the above D. Machine Builders Inc. adopted a standard cost system several years ago that it uses in conjuncti costs for direct materials and direct labor for its single product are as follows: Materials: (4.00 kilograms $9.90 per kilogram) $39.60 Labor: (4.00 hours $18.60 per hour) $74.40 All materials are issued at the beginning of processing. The operating data shown below were ta In-process beginning inventory In-process ending inventory - 90.00% complete as to labor Units completed Budgeted output Purchases of materials in kilograms (AQ) Total actual labor costs incurred Direct labor hours worked (AQ) Materials purchase-price variance Increase in materials inventory in July Beginning inventory of materials The direct labor flexible-budget variance for July was: Answer: A. B. C. D. E. $3,000 unfavorable $2,847 unfavorable $10,200 unfavorable $81,684 favorable $91,884 favorable C. Ally Mfg. uses a standard cost system and its July production of 1,770 units involved actual direc budget for July called for production of 2,000 units with 5,900 direct labor hours at $39.00 per h MC-007 Ally's flexible budget variance for July is: Answer: A. B. C. D. E. $37,862 unfavorable $29,170 unfavorable $10,692 unfavorable $9,692 unfavorable $28,170 unfavorable A. MC-008 The Merchant Manufacturing Company has two service departments purchasing and maintenance, a assembly. The distribution of each service department's efforts to the other departments is shown belo FROM TO Purchasing Maintenance Purchasing Maintenance 0% 20% 60% 0% The direct operating costs of the departments (including both variable and fixed costs) were as Purchasing Maintenance Fabrication Assembly A. B. $93,800 $18,100 $71,700 $47,600 The total cost accumulated in the fabrication department using the step method is (assume the purchas $108,973 $122,228 Answer: C. D. E. $129,263 $115,600 $101,938 A. Talamoto Co. manufactures a single product that goes through two processes mixing and coo Department for September. MC-009 Work-in-process inventory, September 1 Conversion - 70% completed Work-in-process inventory, September 30 Conversion - 50% completed Units started into production Units completed and transferred out Costs: Work-in-process inventory, September 1 Material P Material Q Conversion Cost added during September Material P Material Q Conversion Material P is added at the beginning of work in the Mixing Department. Material Q is also adde product are forty percent completed with regard to conversion. Conversion costs are incurred u Answer: MC-010 A. B. C. D. E. Cost per equivalent unit for conversion under the weighted-average method is calculated to be: $5.06 $2.32 $2.50 $5.34 $2.61 D. Crown Co. can produce two types of lamps, the Enlightner and Foglighter. The data on the two lamp mo Enlightner Sales volume in units Unit sales price Unit variable cost Unit contribution margin 500 $300.00 $200.00 $100.00 It takes one machine hour to produce each product. Total fixed costs for the manufacture of both produ to keep the plant operating at maximum capacity. Assuming that sales mix remains constant in dollars, what is the breakeven point in dollars? (Round inte up to the nearest whole number) Answer: A. B. C. D. E. $248,625 $273,488 $236,194 $223,763 $261,056 A. Everlast Co. manufactures a variety of drill bits. The company's plant is partially automated. The 4,650 direct labor-hours. Listed below is cost driver information used in the product-costing sys MC-011 Overhead Cost Pool Machine setup Material handling Quality inspections Other overhead cost Total overhead Budgeted Overhead Cost Driver $116,170 $103,340 $257,780 $142,610 # setups # batches # of inspections # of machine hours $619,900 A current product order has the following requirements: Machine setup Material handling Quality inspections Machine hours Direct labor hour Answer: A. B. C. D. E. E. 7 setups 616 barrels 80 inspections 810 machine hours 320 hours Using ABC, how much other overhead is assigned to the order? $7,393 $43,942 $19,273 $7,642 $9,634 Luanna Inc. manufactures game consoles. Some of the company's data was misplaced. Use the MC-012 Actual Results Units Revenues Variable costs Fixed costs Operating income Answer: A. B. C. D. E. MC-014 $1,741 U C $20,800 $44,269 The amount A is: $66,760 $103,531 $26,307 $100,481 $36,721 B. MC-013 Answer: 1,731 $101,790 Flexible Budget Variance A range around the regression line within which the management accountant can rely that the actual va A. B. C. D. E. A t-value A goodness of fit A p-value A relevant range A confidence interval E. Norio Manufacturing uses powdered plastics (PPS) to manufacture a high-pressure board used its operation in June is as follows: Budgeted units of Flex 10 for June Budgeted usage of FPS Number of units of Flex 10 manufactured PFS purchased PFS used Total actual cost of FPS used Direct materials usage variance - unfavorable The cost of PPS in the flexible budget for the number of units manufactured this period is: Answer: A. B. C. D. E. $277,500 $326,320 $305,030 $227,228 $251,422 C. Universal Automotive Group is a maker of engines for high performance cars and uses a proces the final department of manufacturing for Universal's most popular engine, the "Atomic 8". MC-015 Beginning work-in-process (40% completed) Transferred-in Normal spoilage Abnormal spoilage Good units transferred out Ending work-in-process (25% completed) Conversion costs in beginning inventory Current conversion cost Universal Automotive Group calculates separate costs of spoilage by computing both normal and abnorm good units and abnormal spoilage costs are charged as a loss. The units of the Atomic 8 that are spoiled of finished units. Using the weighted-average method, answer the following question: Answer: A. B. C. D. C. MC-016 Answer: What are the total conversion costs transferred to finished goods? $797,893 $753,581 $798,893 $708,270 A. B. C. D. B. The p-value is a measure of: The linearity in the data The accuracy of the regression predictions The precision of the regression The reliability of the independent variable MC-017 In September, Larson Inc. sold 39,000 units of its only product for $234,000 and incurred a total cost of $ budget for September showed total sales of $300,000. Among variances of the period were: total variab budget variance, $63,100U; and, sales volume variance, in terms of contribution margin, $26,700U. The sales volume variance, in terms of operating income, is: Answer: MC-018 A. B. C. D. E. $36,700 unfavorable $21,700 unfavorable $31,700 unfavorable $26,700 unfavorable $16,700 unfavorable D. Badour Inc. is a job-order manufacturer. The company uses a predetermined overhead rate bas individual jobs. For the current year, estimated direct labor hours were 114,700 and estimated f information was for September. Job X was completed during September, while Job Y was started September 1, inventories: Materials Work-in-process (All Job X) Finished goods Materials purchases Direct materials requisitioned: Job X Job Y Direct labor hours: Job X Job Y Labor cost incurred: Direct labor Indirect labor Factory supervisory salaries Rental costs Factory Administrative offices $6.10 per hour Total equipment depreciation costs: Factory Administrative offices Indirect materials used Answer: MC-019 A. B. C. D. E. The total cost of Job X is: $111,180 $148,712 $148,980 $110,912 $119,090 B. National Inc. manufactures two models of CMD that can be used as cell phones, MPX, and digit Model Annual Sales in Units High F Great P 9,600 15,970 National uses a volume-based costing system to apply factory overhead based on direct labor d follows: High F Direct materials Direct labor Great P $37.15 $17.92 $24.66 $12.97 Budgeted Factory Overhead Engineering and Design Quality Control Machinery Miscellaneous Overhead Total 2,356 engineering hours 12,790 inspection hours 33,071 machine hours 26,040 direct labor hours National's controller had been researching activity-based costing and decided to switch to it. A the following budgeted activities: High F Engineering and design hours Quality control inspection hours Machine hours Labor hours 930 5,427 19,546 11,600 Answer: MC-020 Answer: MC-021 A. B. C. D. E. What is the overhead application rate using the firm's volume-based costing system (rounded to the nea 446.19% percent of direct labor cost $4.46 per direct labor-hour 346.19% percent of direct labor cost 546.19% percent of direct labor cost $5.46 per direct labor-dollar C. A. B. C. D. E. A company using a volume-based overhead assignment (allocation) method will tend to: Overstate the cost of low volume products Understate the cost of all products Either understate or overstate the cost of high volume products depending on the specific manufacturin Understate the cost of high volume products Understate the cost of low volume products E. Burmer Co. has accumulated data to use in preparing its annual profit plan for the upcoming ye must be determined. Data regarding the machine hours and maintenance costs for the last year follows: Month January February March April May June July August September October November December Sum Average Maintenance Cost $5,030 $3,560 $4,267 $3,376 $5,155 $3,403 $3,552 $5,309 $5,039 $4,882 $3,864 $3,736 $51,173 $4,264 Machine Hours 617 417 515 403 636 400 430 667 624 606 452 436 6,203 517 A staff assistant has run regression analyses on the data (you still need to do this) and obtained REGRESSION ANALYSIS Y (Dependent) Variable: Maintenance Cost X (Independent) Variable: Maintenance Hours Answer: A. B. C. D. The t statistic for the independent variable: At 11.46, is statistically significant At 52.78, is too large to be statistically significant Is statistically significant at less than 5% risk Lies somewhere between 6.49 and 7.063 D. MC-022 Marshall Co. produced a pilot run of fifty units of a recently developed piston used in one of its product annually. The pilot run required an average of 0.55 direct labor hours per piston for 50 pistons. Marshall direct labor hours needed to produce new pistons. Past experience indicated that learning tends to ceas Marshall's manufacturing costs for pistons are presented below. Direct labor Variable overhe Fixed overhead Materials $14.00 per direct labor hour $11.00 per direct labor hour $20.00 per direct labor hour $4.00 per unit Marshall received a quote of $8.00 per unit from Kytel Machine Co. for the additional 1,840 nee type of work and has always been satisfied with the quality of the units produced by Kytel. If the pistons are manufactured by Marshall Co, the average direct labor hours per unit for the first 800 p (use five decimal places in calculating the average time): Answer: MC-023 A. B. C. D. E. 0.27117 0.34326 0.16924 0.43450 0.21423 D. Bradford Company derived the following cost relationship from a regression analysis of its monthly man C = $80,000 + $12M where: C = monthly manufacturing overhead cost, and M = machine hours The standard error of estimate of the regression is $6,000 The standard time required to manufacture o hours Bradford applies manufacturing overhead to production on the basis of machine hours, and its no Bradford's estimated variable manufacturing overhead cost for a month in which scheduled production Answer: A. B. C. D. E. $120,000 $200,000 $140,000 $80,000 Some amount other than those given above A. Barstow Manufacturing Company has two service departments product design and engineer assembly and finishing. The distribution of each service department's efforts to the other depar MC-024 FROM TO Design Design Support Support 0% 20% Assembly 10% 0% 30% 45% The direct operating costs of the departments (including both variable and fixed costs) were as Design Engineering Support Assembly Finishing Answer: MC-025 A. B. C. D. E. $137,480 $137,890 $544,000 $830,000 The total cost accumulated in the finishing department using the step method is: $55,019 $667,390 $586,470 $110,039 $981,980 E. A. B. C. D. E. The degree of operating leverage (DOL) at any given sales volume, X, is useful as: An alternative measure of the breakeven volume A way to estimate fixed costs for an upcoming period A measure of risk in conjunction with a CVP model An easy way to perform a Monte Carlo Simulation (MCS) analysis A measure of targeted profit, expressed on a pre-tax basis Answer: E. ucts: Direct labor (2.00 hrs. @ $4.90/hr.) = $9.80; overhead (2.00 hrs. @ 00 per direct labor hour (DLH). Actual data for the month show total overhead d, and 39,000 units produced. hour (DLH), calculated at 88.00% capacity = 880 standard DLHs. In December, geted factory overhead at 79.00% of capacity is $3,124, of which $1,357 is 40 for 842 actual DLHs, of which $1,270 was for fixed factory overhead. overhead variance, what is the variable factory overhead efficiency variance levels of sales volume expressed in units. s of sales volume expressed in units. or the coming year. The cost behavior pattern of the maintenance costs must be derive an equation for maintenance hours and costs. Data regarding the analysis follow: elationship between hours of activity and maintenance cost follows: hat it uses in conjunction with its process cost system. The per-unit standard ows: a shown below were taken from the records for July: none 1,000 units 7,210 units 7,900 units 29,000 $521,700 27,500 hours $3,000 unfavorable 1,480 kilograms none ts involved actual direct labor costs of $241,500 for 5,470 hours worked. The r hours at $39.00 per hour. sing and maintenance, and two production departments fabrication and partments is shown below: Fabrication 10% 30% Assembly 30% 50% d fixed costs) were as follows: d is (assume the purchasing department goes first): sses mixing and cooking. The following data pertains to the Mixing 31,800 units 20,000 units 70,800 units ? $78,000 $103,200 $138,721 $179,000 $164,600 $355,980 Material Q is also added in the Mixing Department, but not until units of on costs are incurred uniformly during the process. calculated to be: ata on the two lamp models are as follows: Foglighter 400 $390.00 $235.00 $155.00 nufacture of both products are $91,000. Demand is high enough for either product t in dollars? (Round intermediate calculations to 4 decimal places and final answer artially automated. The budget for the year includes $433,870 payroll for he product-costing system: inspections machine hours Estimated Cost Driver Level 110 setups 8,330 barrels 1,070 inspections 11,990 machien hours as misplaced. Use the following information to replace the lost data. Flexible Budget Sales Volume variance Master Budget 1,680 A B $47,540 D $24,700 an rely that the actual value of the predicted cost will fall is referred to as: -pressure board used in digital equipment, Flex 10. Information concerning 4,900 44,200 pounds 4,000 42,710 pounds 38,600 pounds $227,228 $21,290 red this period is: cars and uses a process costing system. The following information pertains to ne, the "Atomic 8". 400 units 1,550 units 100 units 100 units 1,360 units 390 units $180,500 $726,462 both normal and abnormal spoiled units. Normal spoilage costs are reallocated to tomic 8 that are spoiled are the result of defects not discovered before inspection estion: incurred a total cost of $221,000, of which $25,000 is fixed costs. The flexible period were: total variable cost flexible-budget variance, $7,800U; total flexiblen margin, $26,700U. ned overhead rate based on direct labor hours to apply overhead to 14,700 and estimated factory overhead was $693,400. The following while Job Y was started but not finished. $9,100 $37,800 $78,200 $118,600 $51,400 $40,200 4,900 4,400 $56,730 $15,500 $7,200 $8,000 $2,100 $8,700 $1,800 $13,900 hones, MPX, and digital camcorders. ased on direct labor dollars. The unit prime costs of each product were as $387,631 $264,979 $521,669 $138,351 $1,312,630 ided to switch to it. A special study determined National's two products have Great P 1,400 7,010 13,250 13,860 tem (rounded to the nearest percent or cents)? he specific manufacturing factors involved an for the upcoming year. The cost behavior pattern of the maintenance costs e costs for the last year and the results of the regression analysis are as do this) and obtained the following output using Excel: sed in one of its products. Marshall expected to produce and sell 1,915 units for 50 pistons. Marshall experienced an seventy nine percent learning curve on the at learning tends to cease by the time 800 pistons are produced. he additional 1,840 needed pistons. Marshall frequently subcontracts this roduced by Kytel. per unit for the first 800 pistons (including the pilot run) produced is calculated to be alysis of its monthly manufacturing overhead cost: quired to manufacture one six-unit case of Bradford's single product is two machine machine hours, and its normal annual production is 50,000 cases h scheduled production is 5,000 cases would be: ct design and engineering support, and two production departments orts to the other departments is shown below: Finishing 60% 35% d fixed costs) were as follows: Ryan uses a job costing system for its production costs. It uses a predetermined factory overhead rate based on d the month of July, the firm processed three jobs: Al2, C46, and M23. A small fire in the administration office duri company's factory ledger: Inventories, July 1 Materials inventory (all direct) Work-in-process inventory (job A12) Finished goods inventory Inventories, July 31 Materials inventory (all direct) Work-in-process inventory (job C46 and M23) Finished goods inventory Cost of goods sold, July Direct materials purchased, July Direct materials issued to production Job A12 Job C46 Job M23 Factory labor-hours used ($3.97/hour) Job A12 Job C46 Job M23 Indirect labor Other factory overhead costs incurred Rent Utilities Repairs and Maintenance Depreciation Other $28,561 $37,500 $53,630 ? ? ? ? $20,610 $42,487 $13,127 $18,900 $10,460 1,970 2,517 1,351 708 $19,685 $6,370 $3,348 $17,817 $4,912 Job A12 is the only job completed during the month and delivered to the customer; cost of goods m Solution Manufacturing Statement Raw materials, beginning $28,561 Purchases $20,610 Available $49,171 Raw materials, ending $6,684 Raw materials used Direct labor $3.97 per hour Overhead Applied Total manufacturing costs Work in Process, beginning Total cost to account for $42,487 $23,177 $30,678 Work in Process, ending Total Cost of Goods Manufactured Cost of Goods Sold overhead rate based on direct labor costs to apply factory overhead to jobs. During administration office during the early hours of August left only these fragments of the customer; cost of goods manufactured totaled $68,800 Jobs Opening balance Direct materials Direct labor hours rate Overhead Total cost Overhead rate Prorate overhead variance Adjusted total cost $3.97 76% A12 $37,500 $13,127 1,970 $7,821 $10,352 $68,800 C46 $18,900 2,517 $9,992 $13,227 $42,119 M23 $10,460 1,351 $5,363 $7,099 $22,923 Total $37,500 $42,487 $23,177 $30,678 $133,842 Actual Overhead Depreciation Indirect labor Other Rent Repairs and Maintenance Utilities Total Applied Overhead Difference Under/Over applied $17,817 $2,811 $4,912 $19,685 $3,348 $6,370 $54,943 $30,678 $24,265 Excel Instructions No additional Excel instructions No pivot tables, no tables/lists, no range names, no charts. les/lists, no range names, no charts. The Air Force Museum Foundation has commissioned the purchase of 15 Four F Sixes, pre-World War II aircraft. the exact specifications used for the originals. As further authentication, the aircraft will be made using the techn when the originals were built. Each of the 16 will be flown to Air Force and aviation museums throughout the co also visit the production facility to see exactly how such aircraft were built in 1938. Soren Industries wants to bid on the aircraft contract and asked for and received certain cost information about t information includes some of the old cost data from the builders of the original aircraft. The available information eighth, and thirty-second aircraft, respectively, were completed. Output Total Hours 1 9 37 72 Required 1. Graphically determine the learning curve. 2. What are the following learning curve parameters: Y=aX^b a b R square Learning curve percentage 245 1,574 4,950 8,582 Hours Per Unit 245.00 174.89 133.78 119.19 3. If Soren Industries expects that the manufacturing time will be the same as it was in 1938, how many hours wi Force Museum Foundation? Units Hours to make xes, pre-World War II aircraft. They will be built completely from scratch to ft will be made using the technology and manufacturing processes available n museums throughout the country for exhibition. Aviation enthusiasts can . ertain cost information about the Four F Sixes from the Air Force. The craft. The available information is for the total accumulated time as the first, as in 1938, how many hours will it take to build the 15 aircraft for the Air Excel Instructions Chart(s) - charts have many properties, you will set only the following properties. Name ChartType Location ChartWidth ChartHeight Series Name XValues Values PlotOrder Format.Line/Border.ForeColor: Format.Fill.ForeColor: ChartTitle Caption Font.Name Font.Size Font.Bold ChartLegend Position Font.Name Font.Size Font.Bold Axis - Horizontal AxisTitle AxisTickLabelsFormat Axis - Vertical AxisTitle AxisTickLabelsFormat ChartAreaColor PlotAreaColor Chart # 1 Chart 1 Scatter $B$12 4.25 4 Series 1 Series1 $C$6:$C$9 $G$6:$G$9 Not this semester Red 255, Green 255, Blue 255 N/A Learning Curve Calibri 14 True No chart legend Output #,##0;[Red]#,##0 Hours Per Unit #,##0.00;[Red]#,##0.00 Red 235, Green 241, Blue 222 Red 217, Green 217, Blue 217 Below starting at row 100 you will find three ranges of data: Product Categories: range B100:C118 Products: range B125:E170 Production Data: range G100:K3100 Use this data to answer all questions. 1. The five most profitable categories were in decreasing order of profitability: Category Description Most profitable Least profitable Use an array formula to sort by Category Description Category Description 2. The five most profitable products were in decreasing order of profitability: Product Description Most profitable Least profitable 3. For the following five products determine the product BreakEven point i.e. Product total fixed co Product Code TA5187 SK2625 SQ3548 QM1483 QQ5463 Product Description When you submit for grading, leave the Pivottable as question 3 and the last product in question Category Code SS58 SK85 KQ58 QK82 KQ23 QC36 CE65 EN52 NK24 KC42 CH26 HC63 CN35 NF55 FJ56 JK63 KM31 MF17 Category Air Care Blenders Brooms Circular Saws Classic Irons Coffee + Tea Cooking Drills Dusters Edgers Food Processors Hedge Trimmers Juicers Ladders Movers Toasters + Ovens Vacuums Woodcutting Category Code Product Code SS58 SS58 SK85 SK85 KQ58 KQ58 CE65 SK2625 SQ3548 KK6222 QQ5463 KC2236 QE4655 CN2352 Product Description Table Top HEPAFr 8-Hour Tabletop 10-Speed Blende 8 Cup Food Proc Angle Broom Large Corn Broo 12-Cup Rice Coo Selling Price $46.64 $34.97 $33.29 $26.18 $15.99 $14.99 $29.98 CE65 CE65 KQ23 QK82 QK82 QK82 QK82 QC36 QC36 NK24 EN52 EN52 KC42 CH26 CH26 CH26 HC63 HC63 CN35 CN35 NF55 NF55 NF55 FJ56 FJ56 FJ56 FJ56 JK63 JK63 JK63 JK63 KM31 KM31 KM31 KM31 KM31 MF17 MF17 EK6564 NC3532 KH5616 CC5373 HN6165 CF3755 NJ1636 FK7523 JM6371 KF5217 MA3766 FP2155 AL7693 PJ1522 LG6917 JD5221 GO9176 DB2245 OL1759 BJ2442 LT7511 JD4442 TA5187 DD4444 AP1865 DG4464 PJ8631 GH4624 JA6318 HI6264 AQ3146 II2656 QM1483 IM6512 MG4841 MD5166 GA8424 DL1665 12" by 15" Electri Family Size Elect The Classic Iron 5 Amp Jigsaw wi 15 Amp 7-1/4 in. 20V MAX* Lithiu 4.5 Amp Variable 8-Cup Thermal P 12-Cup Programm 12V DUSTBUSTER MATRIX 20V MAX 6 Amp 1/2 in. Ha 12 Amp EdgeHog Ergo 3-Cup Chop Glass Bowl Chop One Touch Chop 17 in. Hedge Tr 24 in. Hedge Tri Citrus Juicer Fruit and Vegetab 2 Step Aluminum 16' Aluminum Ext 24' Aluminum Ext 0V MAX* Lithium 12 Amp 17 in. El 20V MAX* Lithiu 40V MAX* Lithiu 2-Slice Toaster Countertop Toas 4-Slice Toaster Countertop Conv 24V MAX* Lithiu 20V MAX* Lithiu 16V MAX* Lithiu 7.2V DUSTBUSTE 12V Auto Pivot V 20V MAX* Lithi 20V MAX* Lithium $44.21 $29.99 $35.99 $43.99 $60.35 $49.99 $24.99 $41.86 $59.92 $43.78 $69.97 $58.76 $89.00 $21.99 $33.30 $13.99 $33.24 $74.99 $16.12 $44.99 $43.96 $99.00 $291.02 $399.99 $169.00 $149.00 $329.00 $27.52 $48.99 $29.99 $44.09 $239.99 $73.99 $80.74 $21.99 $34.99 $119.00 $76.99 er of profitability: Average Profit Batches sort by Category Description Average Profit Batches $0 $0 $0 $0 $0 of profitability: Average Profit Batches Product Description eakEven point i.e. Product total fixed cost / Product contribution margin per unit t Description Per Unit Selling Price Variable Cost Contribution Margin Fixed Cost estion 3 and the last product in question 3. Entry Product Code Batch Size Production Date 1 MD5166 2 MG4841 3 GO9176 4 HI6264 5 GO9176 6 HI6264 7 CN2352 8 CC5373 9 TA5187 10 JD5221 11 CN2352 12 MA3766 13 QE4655 14 TA5187 15 CF3755 16 JD5221 17 JD5221 18 JD4442 19 HN6165 20 SQ3548 21 GH4624 22 BJ2442 23 LG6917 24 FK7523 14,450 14,200 10,250 13,200 10,300 13,200 6,450 7,450 11,550 10,050 6,400 8,850 6,250 11,550 7,700 10,000 10,000 11,350 7,500 5,300 12,550 10,850 9,850 8,200 12/29/2016 12/28/2016 7/16/2016 10/25/2016 7/16/2016 10/25/2016 2/4/2016 3/7/2016 8/20/2016 7/15/2016 2/4/2016 5/11/2016 2/3/2016 8/20/2016 4/8/2016 6/15/2016 7/15/2016 8/19/2016 4/7/2016 12/31/2015 10/23/2016 8/18/2016 6/15/2016 4/9/2016 25 EK6564 26 PJ8631 27 KC2236 28 OL1759 29 PJ1522 30 DL1665 31 EK6564 32 SQ3548 6,700 12,350 5,900 10,650 9,650 14,900 6,800 5,250 3/5/2016 9/22/2016 2/2/2016 7/17/2016 6/14/2016 12/30/2016 3/5/2016 12/31/2015 33 NC3532 34 PJ8631 35 JM6371 36 PJ1522 37 KF5217 38 SK2625 39 AL7693 40 AQ3146 41 FP2155 42 JD4442 43 JD4442 44 NJ1636 45 NC3532 46 SK2625 47 BJ2442 48 KF5217 49 JD5221 50 II2656 51 KK6222 52 JM6371 53 TA5187 54 KH5616 55 BJ2442 56 QE4655 57 PJ1522 58 IM6512 59 JD4442 60 GA8424 61 NC3532 62 DL1665 63 DD4444 64 GA8424 65 QE4655 66 GH4624 67 QM1483 68 NC3532 69 EK6564 70 BJ2442 71 PJ8631 72 DD4444 73 DD4444 74 LG6917 75 KH5616 76 NC3532 77 JD4442 78 PJ1522 6,900 12,500 8,400 9,600 8,750 5,000 9,450 13,400 9,050 11,300 11,300 8,100 6,800 5,150 10,800 8,700 9,950 13,500 5,450 8,550 11,650 7,050 10,900 6,100 9,550 13,900 11,300 14,750 6,850 15,000 11,750 14,550 6,250 12,600 13,700 7,000 6,650 10,950 12,400 11,850 11,700 9,750 7,200 6,850 11,300 9,600 3/5/2016 10/23/2016 5/10/2016 6/14/2016 5/11/2016 12/31/2015 6/13/2016 11/26/2016 5/12/2016 8/19/2016 8/19/2016 4/9/2016 3/5/2016 12/31/2015 7/18/2016 5/11/2016 6/15/2016 11/26/2016 1/1/2016 5/10/2016 8/20/2016 3/6/2016 8/18/2016 2/3/2016 6/14/2016 11/27/2016 8/19/2016 12/30/2016 3/5/2016 12/30/2016 9/20/2016 12/29/2016 2/3/2016 10/23/2016 11/26/2016 3/6/2016 2/5/2016 8/18/2016 9/22/2016 9/21/2016 9/20/2016 6/14/2016 3/6/2016 3/5/2016 8/19/2016 6/14/2016 79 IM6512 80 PJ1522 81 KK6222 82 OL1759 83 OL1759 84 PJ8631 85 TA5187 86 HI6264 87 GA8424 88 KF5217 89 JD4442 90 BJ2442 91 JA6318 92 JA6318 93 MG4841 94 EK6564 95 MD5166 96 HI6264 97 DB2245 98 LT7511 99 CN2352 100 MD5166 101 NC3532 102 GH4624 103 OL1759 104 NC3532 105 KH5616 106 AP1865 107 MD5166 108 MG4841 109 PJ8631 110 CN2352 111 GH4624 112 NC3532 113 SK2625 114 PJ1522 115 II2656 116 QQ5463 117 SK2625 118 BJ2442 119 CN2352 120 PJ1522 121 JD5221 122 LG6917 123 OL1759 124 MG4841 14,000 9,650 5,650 10,650 10,700 12,350 11,600 13,200 14,650 8,550 11,400 10,900 12,800 12,950 14,300 6,650 14,450 13,150 10,350 11,000 6,500 14,450 6,850 12,650 10,700 6,800 7,200 11,900 14,400 14,200 12,450 6,400 12,600 6,850 5,000 9,500 13,600 5,750 5,200 10,850 6,350 9,550 10,100 9,850 10,750 14,200 11/27/2016 6/14/2016 1/2/2016 7/17/2016 7/17/2016 9/22/2016 8/20/2016 10/25/2016 12/29/2016 5/11/2016 8/19/2016 8/18/2016 10/24/2016 10/24/2016 12/28/2016 3/5/2016 12/29/2016 10/25/2016 7/16/2016 8/18/2016 2/4/2016 12/29/2016 3/5/2016 10/23/2016 7/17/2016 3/5/2016 3/6/2016 9/21/2016 12/29/2016 12/28/2016 9/23/2016 2/4/2016 10/23/2016 3/5/2016 12/31/2015 6/13/2016 11/26/2016 1/2/2016 12/31/2015 7/18/2016 2/4/2016 6/14/2016 7/15/2016 6/15/2016 7/17/2016 12/28/2016 125 DL1665 126 TA5187 127 GO9176 128 SK2625 129 NC3532 130 MD5166 131 KH5616 132 LT7511 133 AP1865 134 TA5187 135 PJ1522 136 PJ8631 137 II2656 138 MD5166 139 HI6264 140 FP2155 141 HI6264 142 KH5616 143 AP1865 144 MD5166 145 QQ5463 146 CN2352 147 MD5166 148 CF3755 149 SQ3548 150 TA5187 151 JD4442 152 HI6264 153 AQ3146 154 CC5373 155 KK6222 156 CF3755 157 JD4442 158 LT7511 159 MD5166 160 MG4841 161 IM6512 162 FP2155 163 QQ5463 164 KC2236 165 SK2625 166 PJ1522 167 MD5166 168 PJ8631 169 FK7523 170 QM1483 14,900 11,500 10,250 5,050 6,950 14,350 7,050 11,100 12,050 11,650 9,650 12,350 13,500 14,350 13,200 9,200 13,150 7,150 11,900 14,450 5,800 6,500 14,400 7,850 5,300 11,550 11,350 13,150 13,400 7,450 5,450 7,700 11,400 11,050 14,400 14,300 13,900 9,150 5,700 5,900 5,200 9,450 14,550 12,550 8,300 13,700 12/30/2016 8/20/2016 7/16/2016 12/31/2015 3/6/2016 12/29/2016 3/6/2016 8/18/2016 9/21/2016 8/20/2016 6/14/2016 9/22/2016 11/26/2016 12/29/2016 10/25/2016 6/12/2016 10/25/2016 3/6/2016 9/21/2016 12/29/2016 1/2/2016 2/4/2016 12/29/2016 4/8/2016 12/31/2015 8/20/2016 8/19/2016 10/25/2016 11/26/2016 3/7/2016 1/1/2016 4/8/2016 8/19/2016 8/18/2016 12/29/2016 12/28/2016 11/27/2016 5/12/2016 1/2/2016 2/2/2016 12/31/2015 6/13/2016 12/29/2016 10/23/2016 4/10/2016 11/26/2016 171 IM6512 172 BJ2442 173 QE4655 174 AQ3146 175 KH5616 176 CN2352 177 QQ5463 178 FK7523 179 II2656 180 HN6165 181 GA8424 182 NC3532 183 DL1665 184 II2656 185 FP2155 186 GO9176 187 CC5373 188 PJ8631 189 EK6564 190 NC3532 191 DG4464 192 SK2625 193 MA3766 194 AP1865 195 GH4624 196 NJ1636 197 FP2155 198 CF3755 199 OL1759 200 TA5187 201 PJ1522 202 CN2352 203 NC3532 204 JM6371 205 MD5166 206 EK6564 207 IM6512 208 NC3532 209 JA6318 210 JD4442 211 LT7511 212 MG4841 213 QE4655 214 JM6371 215 PJ8631 216 MD5166 13,900 10,900 6,200 13,350 7,200 6,450 5,850 8,250 13,500 7,650 14,650 6,900 14,950 13,450 9,150 10,150 7,300 12,450 6,650 6,850 12,250 5,050 9,000 12,000 12,750 8,000 9,000 7,700 10,700 11,450 9,450 6,400 6,900 8,450 14,400 6,650 13,900 6,900 13,000 11,300 11,100 14,300 6,150 8,400 12,450 14,500 11/27/2016 8/18/2016 2/3/2016 11/25/2016 3/6/2016 2/4/2016 2/2/2016 4/9/2016 11/26/2016 4/8/2016 12/29/2016 3/5/2016 12/30/2016 11/26/2016 5/12/2016 7/15/2016 3/7/2016 9/23/2016 2/5/2016 3/5/2016 9/22/2016 12/31/2015 5/12/2016 9/21/2016 10/24/2016 4/9/2016 5/12/2016 4/8/2016 7/17/2016 8/19/2016 6/13/2016 2/4/2016 3/5/2016 5/10/2016 12/29/2016 2/5/2016 11/27/2016 3/5/2016 10/24/2016 8/19/2016 8/18/2016 12/28/2016 2/3/2016 5/10/2016 9/23/2016 12/29/2016 217 SK2625 218 GA8424 219 CN2352 220 HN6165 221 II2656 222 DB2245 223 FP2155 224 JD4442 225 JD5221 226 AL7693 227 KF5217 228 CN2352 229 CN2352 230 NJ1636 231 AQ3146 232 HI6264 233 DL1665 234 FP2155 235 PJ8631 236 BJ2442 237 DB2245 238 JM6371 239 KH5616 240 JD5221 241 DL1665 242 DG4464 243 HN6165 244 EK6564 245 PJ8631 246 CF3755 247 FP2155 248 DB2245 249 AL7693 250 CC5373 251 AQ3146 252 AP1865 253 GA8424 254 II2656 255 GO9176 256 KH5616 257 DL1665 258 NJ1636 259 AQ3146 260 GO9176 261 JD5221 262 DD4444 5,200 14,550 6,500 7,500 13,450 10,500 9,100 11,300 10,050 9,400 8,550 6,400 6,350 7,950 13,400 13,150 14,800 9,150 12,400 10,800 10,550 8,550 7,200 9,900 14,950 12,200 7,650 6,750 12,500 7,700 9,200 10,350 9,300 7,250 13,400 11,950 14,650 13,500 10,200 7,100 14,900 8,000 13,400 10,250 10,000 11,700 12/31/2015 12/29/2016 2/4/2016 4/7/2016 11/26/2016 7/16/2016 5/12/2016 8/19/2016 7/15/2016 6/13/2016 5/11/2016 2/4/2016 2/4/2016 4/9/2016 11/26/2016 10/25/2016 12/30/2016 5/12/2016 9/22/2016 7/17/2016 7/17/2016 5/10/2016 3/6/2016 6/15/2016 12/30/2016 9/22/2016 4/8/2016 3/5/2016 10/23/2016 4/8/2016 6/13/2016 7/16/2016 6/13/2016 3/6/2016 11/26/2016 9/21/2016 12/29/2016 11/26/2016 7/16/2016 3/6/2016 12/30/2016 4/9/2016 11/26/2016 7/16/2016 7/15/2016 9/20/2016 263 NJ1636 264 TA5187 265 DG4464 266 JM6371 267 BJ2442 268 KH5616 269 HN6165 270 OL1759 271 PJ8631 272 PJ1522 273 PJ1522 274 HN6165 275 AQ3146 276 MG4841 277 EK6564 278 QE4655 279 DB2245 280 SK2625 281 AL7693 282 GA8424 283 JM6371 284 DL1665 285 HI6264 286 HN6165 287 BJ2442 288 CN2352 289 JD4442 290 MG4841 291 HN6165 292 JM6371 293 JA6318 294 DB2245 295 LG6917 296 LT7511 297 AL7693 298 BJ2442 299 PJ8631 300 QE4655 301 NJ1636 302 MD5166 303 SK2625 304 LG6917 305 DL1665 306 IM6512 307 KF5217 308 KK6222 8,050 11,650 12,150 8,400 10,800 7,050 7,450 10,600 12,500 9,550 9,650 7,600 13,350 14,200 6,650 6,300 10,500 5,050 9,300 14,750 8,350 14,800 13,000 7,500 11,000 6,550 11,350 14,300 7,550 8,500 12,800 10,550 9,850 11,100 9,300 10,800 12,350 6,300 7,950 14,400 5,050 9,800 14,800 13,950 8,550 5,600 4/9/2016 8/20/2016 9/22/2016 5/10/2016 7/17/2016 3/6/2016 3/7/2016 7/17/2016 10/23/2016 6/14/2016 6/14/2016 4/8/2016 11/25/2016 12/28/2016 2/5/2016 2/4/2016 7/17/2016 12/31/2015 6/13/2016 12/30/2016 5/10/2016 12/30/2016 10/24/2016 4/7/2016 8/18/2016 2/4/2016 8/19/2016 12/28/2016 4/7/2016 5/10/2016 10/24/2016 7/17/2016 6/15/2016 8/18/2016 6/13/2016 7/17/2016 9/22/2016 2/4/2016 4/9/2016 12/29/2016 12/31/2015 6/14/2016 12/30/2016 11/27/2016 5/11/2016 1/1/2016 309 JD4442 310 QQ5463 311 DD4444 312 GH4624 313 HI6264 314 II2656 315 TA5187 316 SK2625 317 JD4442 318 IM6512 319 EK6564 320 QM1483 321 CC5373 322 DL1665 323 JD4442 324 GO9176 325 HN6165 326 KC2236 327 MG4841 328 KK6222 329 IM6512 330 JA6318 331 CC5373 332 HN6165 333 DL1665 334 TA5187 335 GO9176 336 DL1665 337 FK7523 338 CF3755 339 II2656 340 JD5221 341 AL7693 342 CF3755 343 NJ1636 344 CC5373 345 FK7523 346 DB2245 347 II2656 348 DG4464 349 PJ8631 350 GA8424 351 GH4624 352 GH4624 353 GO9176 354 QE4655 11,300 5,800 11,650 12,700 13,050 13,650 11,600 5,150 11,350 14,050 6,700 13,650 7,250 14,850 11,400 10,300 7,500 6,050 14,150 5,500 14,050 12,850 7,400 7,550 14,850 11,550 10,250 14,850 8,300 7,900 13,600 10,050 9,300 7,750 8,000 7,350 8,250 10,500 13,550 12,100 12,550 14,650 12,650 12,600 10,300 6,300 8/19/2016 1/2/2016 9/20/2016 10/23/2016 10/24/2016 11/26/2016 8/20/2016 12/31/2015 8/19/2016 11/27/2016 3/5/2016 11/26/2016 3/6/2016 12/30/2016 8/19/2016 7/16/2016 4/7/2016 2/3/2016 12/28/2016 1/1/2016 11/27/2016 10/24/2016 3/7/2016 4/7/2016 12/30/2016 8/20/2016 7/16/2016 12/30/2016 4/10/2016 4/8/2016 11/26/2016 7/15/2016 6/13/2016 4/8/2016 4/9/2016 3/7/2016 4/10/2016 7/16/2016 11/26/2016 9/22/2016 10/23/2016 12/29/2016 10/23/2016 10/23/2016 7/16/2016 2/3/2016 355 SK2625 356 GA8424 357 KH5616 358 LG6917 359 QE4655 360 MA3766 361 MG4841 362 LT7511 363 QE4655 364 JD5221 365 BJ2442 366 II2656 367 AQ3146 368 KF5217 369 NJ1636 370 KC2236 371 KF5217 372 EK6564 373 II2656 374 QM1483 375 DL1665 376 HI6264 377 JA6318 378 DD4444 379 MD5166 380 GA8424 381 AL7693 382 BJ2442 383 MG4841 384 CC5373 385 JM6371 386 SK2625 387 AL7693 388 OL1759 389 IM6512 390 AQ3146 391 TA5187 392 SQ3548 393 HN6165 394 DG4464 395 AL7693 396 PJ8631 397 FP2155 398 AP1865 399 PJ1522 400 SQ3548 5,200 14,650 7,000 9,800 6,300 8,900 14,200 11,100 6,250 9,950 11,000 13,500 13,300 8,650 7,950 5,950 8,750 6,600 13,450 13,700 14,800 13,050 12,800 11,850 14,400 14,700 9,300 10,900 14,150 7,300 8,400 5,100 9,300 10,700 14,050 13,350 11,600 5,400 7,600 12,200 9,250 12,450 9,100 11,950 9,550 5,300 12/31/2015 12/29/2016 3/6/2016 6/14/2016 2/4/2016 5/12/2016 12/28/2016 8/18/2016 2/3/2016 6/15/2016 8/18/2016 11/26/2016 10/25/2016 5/11/2016 4/9/2016 2/2/2016 5/11/2016 2/4/2016 11/26/2016 11/26/2016 12/30/2016 10/25/2016 10/24/2016 9/21/2016 12/29/2016 12/29/2016 6/13/2016 8/18/2016 11/28/2016 3/7/2016 5/10/2016 12/31/2015 6/13/2016 7/17/2016 11/28/2016 11/25/2016 8/20/2016 1/1/2016 4/8/2016 9/22/2016 6/13/2016 9/23/2016 5/12/2016 9/21/2016 6/14/2016 12/31/2015 401 TA5187 402 GA8424 403 MD5166 404 MG4841 405 EK6564 406 SK2625 407 CC5373 408 IM6512 409 MD5166 410 MG4841 411 MD5166 412 AP1865 413 MD5166 414 MD5166 415 CN2352 416 AP1865 417 AL7693 418 NJ1636 419 IM6512 420 CC5373 421 TA5187 422 FK7523 423 SQ3548 424 FP2155 425 AP1865 426 GH4624 427 EK6564 428 MG4841 429 AP1865 430 FK7523 431 MD5166 432 MA3766 433 NC3532 434 OL1759 435 OL1759 436 DG4464 437 TA5187 438 QM1483 439 LT7511 440 IM6512 441 LT7511 442 MD5166 443 MG4841 444 JA6318 445 BJ2442 446 EK6564 11,500 14,650 14,400 14,300 6,600 5,200 7,400 13,900 14,500 14,250 14,550 11,950 14,500 14,350 6,500 11,900 9,350 7,900 14,000 7,400 11,500 8,200 5,350 9,050 12,050 12,650 6,600 14,200 12,100 8,350 14,350 8,900 6,800 10,650 10,750 12,300 11,550 13,850 11,100 13,900 11,150 14,350 14,250 12,950 10,950 6,550 8/20/2016 12/29/2016 12/29/2016 12/28/2016 2/5/2016 12/31/2015 3/7/2016 11/27/2016 12/29/2016 12/28/2016 12/29/2016 9/21/2016 12/29/2016 12/28/2016 2/4/2016 9/21/2016 6/13/2016 4/8/2016 11/27/2016 3/7/2016 8/20/2016 4/9/2016 1/1/2016 5/12/2016 9/21/2016 10/23/2016 2/5/2016 12/28/2016 9/21/2016 4/10/2016 12/29/2016 5/12/2016 3/5/2016 7/17/2016 7/17/2016 9/22/2016 8/20/2016 11/27/2016 8/18/2016 11/27/2016 8/19/2016 12/28/2016 12/28/2016 10/24/2016 8/18/2016 2/4/2016 447 SK2625 448 DB2245 449 BJ2442 450 JD4442 451 PJ1522 452 QM1483 453 DG4464 454 KC2236 455 JA6318 456 IM6512 457 SQ3548 458 MA3766 459 KF5217 460 MG4841 461 GH4624 462 MG4841 463 HI6264 464 AQ3146 465 TA5187 466 DB2245 467 FK7523 468 PJ1522 469 LT7511 470 LT7511 471 JD4442 472 KH5616 473 OL1759 474 KF5217 475 QM1483 476 EK6564 477 TA5187 478 FP2155 479 SK2625 480 KH5616 481 LT7511 482 TA5187 483 CN2352 484 FP2155 485 MA3766 486 FK7523 487 AL7693 488 IM6512 489 SQ3548 490 CF3755 491 KC2236 492 TA5187 5,050 10,450 10,950 11,200 9,600 13,900 12,150 6,000 12,850 13,900 5,350 9,000 8,750 14,250 12,700 14,300 13,000 13,450 11,650 10,450 8,150 9,550 11,100 11,150 11,200 7,150 10,550 8,600 13,900 6,750 11,450 9,150 5,100 7,050 11,050 11,650 6,450 9,200 8,800 8,300 9,400 14,050 5,300 7,800 5,950 11,600 12/31/2015 7/16/2016 8/18/2016 8/19/2016 6/14/2016 11/27/2016 9/22/2016 2/3/2016 10/24/2016 11/27/2016 1/1/2016 5/12/2016 5/11/2016 12/28/2016 10/23/2016 12/28/2016 10/24/2016 11/26/2016 8/20/2016 7/16/2016 4/9/2016 6/14/2016 8/18/2016 8/19/2016 8/19/2016 3/6/2016 7/17/2016 5/11/2016 11/27/2016 3/5/2016 8/20/2016 5/12/2016 12/31/2015 3/6/2016 8/18/2016 8/20/2016 2/4/2016 6/13/2016 5/11/2016 4/10/2016 6/13/2016 11/28/2016 12/31/2015 4/8/2016 2/2/2016 8/20/2016 493 QM1483 494 JD4442 495 BJ2442 496 HI6264 497 IM6512 498 OL1759 499 NC3532 500 SK2625 501 NJ1636 502 KF5217 503 HI6264 504 CF3755 505 OL1759 506 II2656 507 QM1483 508 PJ8631 509 MA3766 510 II2656 511 AP1865 512 QQ5463 513 CC5373 514 QQ5463 515 DL1665 516 PJ8631 517 MG4841 518 EK6564 519 DB2245 520 II2656 521 LG6917 522 QQ5463 523 JM6371 524 SQ3548 525 FK7523 526 LT7511 527 HI6264 528 DD4444 529 JD4442 530 CF3755 531 HN6165 532 FK7523 533 SQ3548 534 FK7523 535 AP1865 536 PJ1522 537 MA3766 538 KC2236 13,800 11,350 10,800 13,050 13,900 10,600 6,950 5,200 8,050 8,750 13,100 7,700 10,550 13,650 13,700 12,450 8,850 13,600 12,000 5,700 7,400 5,700 14,800 12,400 14,250 6,600 10,350 13,550 9,800 5,700 8,500 5,400 8,150 11,100 13,050 11,750 11,300 7,700 7,450 8,250 5,250 8,200 11,950 9,600 8,950 6,000 11/27/2016 8/19/2016 7/18/2016 10/24/2016 11/27/2016 7/17/2016 3/6/2016 12/31/2015 4/9/2016 5/11/2016 10/25/2016 4/8/2016 7/17/2016 11/26/2016 11/26/2016 9/23/2016 5/11/2016 11/26/2016 9/21/2016 1/2/2016 3/7/2016 1/2/2016 12/30/2016 9/22/2016 12/28/2016 2/4/2016 7/16/2016 11/26/2016 6/14/2016 1/2/2016 5/10/2016 1/1/2016 4/9/2016 8/18/2016 10/25/2016 9/20/2016 8/19/2016 4/8/2016 3/7/2016 4/10/2016 12/31/2015 4/9/2016 9/21/2016 6/14/2016 5/12/2016 2/3/2016 539 IM6512 540 FP2155 541 KC2236 542 TA5187 543 BJ2442 544 DB2245 545 CF3755 546 JD5221 547 SK2625 548 GH4624 549 JD4442 550 PJ8631 551 LT7511 552 CN2352 553 CN2352 554 FP2155 555 EK6564 556 GA8424 557 KF5217 558 SK2625 559 SK2625 560 II2656 561 DD4444 562 FK7523 563 JD5221 564 CF3755 565 KK6222 566 BJ2442 567 AQ3146 568 NC3532 569 II2656 570 DG4464 571 SQ3548 572 QQ5463 573 SQ3548 574 MD5166 575 CC5373 576 SQ3548 577 GO9176 578 LT7511 579 CC5373 580 KF5217 581 JA6318 582 HN6165 583 EK6564 584 EK6564 14,050 9,100 5,900 11,550 11,000 10,450 7,850 10,000 5,000 12,600 11,350 12,500 11,050 6,450 6,550 9,200 6,700 14,650 8,600 5,100 5,100 13,600 11,750 8,350 9,950 7,800 5,450 10,950 13,200 7,000 13,550 12,250 5,200 5,750 5,450 14,450 7,400 5,450 10,200 11,050 7,400 8,750 12,900 7,550 6,700 6,800 11/28/2016 5/12/2016 2/2/2016 8/20/2016 8/18/2016 7/16/2016 4/8/2016 6/15/2016 12/31/2015 10/23/2016 8/19/2016 9/23/2016 8/18/2016 2/4/2016 2/4/2016 6/12/2016 3/5/2016 12/29/2016 5/11/2016 12/31/2015 12/31/2015 11/26/2016 9/20/2016 4/10/2016 6/15/2016 4/8/2016 1/1/2016 8/18/2016 10/25/2016 3/6/2016 11/26/2016 9/22/2016 12/31/2015 1/2/2016 1/1/2016 12/29/2016 3/7/2016 1/1/2016 7/16/2016 8/18/2016 3/7/2016 5/11/2016 10/24/2016 4/7/2016 3/5/2016 3/5/2016 585 AQ3146 586 DL1665 587 BJ2442 588 JM6371 589 NJ1636 590 DL1665 591 DG4464 592 GH4624 593 JA6318 594 MA3766 595 DL1665 596 JA6318 597 TA5187 598 KF5217 599 DG4464 600 QM1483 601 DG4464 602 MA3766 603 HN6165 604 TA5187 605 GO9176 606 IM6512 607 EK6564 608 GA8424 609 DG4464 610 KK6222 611 DG4464 612 JD5221 613 DD4444 614 AQ3146 615 GH4624 616 KF5217 617 FK7523 618 AL7693 619 JD4442 620 QQ5463 621 FP2155 622 AP1865 623 LG6917 624 HI6264 625 JA6318 626 QE4655 627 DG4464 628 GH4624 629 QE4655 630 JA6318 13,400 14,850 10,900 8,450 7,950 14,900 12,250 12,700 13,000 9,000 14,800 12,900 11,550 8,700 12,150 13,850 12,150 9,000 7,550 11,450 10,300 14,000 6,550 14,650 12,300 5,450 12,250 10,000 11,700 13,350 12,700 8,650 8,200 9,250 11,400 5,850 9,000 12,050 9,800 13,100 12,850 6,300 12,250 12,600 6,250 12,950 11/26/2016 12/30/2016 8/18/2016 5/10/2016 4/9/2016 12/30/2016 9/22/2016 10/23/2016 10/24/2016 5/12/2016 12/30/2016 10/24/2016 8/20/2016 5/11/2016 9/22/2016 11/27/2016 9/22/2016 5/12/2016 4/7/2016 8/19/2016 7/16/2016 11/27/2016 2/4/2016 12/29/2016 9/22/2016 1/1/2016 9/22/2016 7/15/2016 9/20/2016 11/25/2016 10/23/2016 5/11/2016 4/9/2016 6/13/2016 8/19/2016 2/2/2016 5/12/2016 9/21/2016 6/14/2016 10/25/2016 10/24/2016 2/3/2016 9/22/2016 10/23/2016 2/3/2016 10/24/2016 631 IM6512 632 MG4841 633 GH4624 634 GH4624 635 JD4442 636 SQ3548 637 AQ3146 638 DD4444 639 QM1483 640 DG4464 641 AP1865 642 LG6917 643 LG6917 644 SQ3548 645 OL1759 646 JD4442 647 MD5166 648 QE4655 649 KF5217 650 MA3766 651 JM6371 652 KC2236 653 GA8424 654 FK7523 655 HI6264 656 MA3766 657 FP2155 658 EK6564 659 GH4624 660 KC2236 661 PJ8631 662 SQ3548 663 MG4841 664 DG4464 665 GH4624 666 JD5221 667 NC3532 668 QE4655 669 KH5616 670 FP2155 671 MD5166 672 DG4464 673 NC3532 674 DB2245 675 OL1759 676 IM6512 14,050 14,250 12,550 12,700 11,350 5,300 13,250 11,650 13,800 12,250 11,900 9,750 9,850 5,450 10,600 11,450 14,350 6,100 8,750 8,950 8,550 5,900 14,600 8,100 13,050 8,850 9,150 6,750 12,650 5,950 12,500 5,250 14,250 12,250 12,650 10,000 6,900 6,300 7,150 9,050 14,400 12,150 6,850 10,550 10,600 14,050 11/28/2016 12/28/2016 10/23/2016 10/23/2016 8/19/2016 12/31/2015 10/25/2016 9/20/2016 11/27/2016 9/22/2016 9/21/2016 6/14/2016 6/15/2016 1/1/2016 7/17/2016 8/19/2016 12/28/2016 2/3/2016 5/11/2016 5/12/2016 5/11/2016 2/2/2016 12/29/2016 4/9/2016 10/24/2016 5/11/2016 6/12/2016 3/5/2016 10/23/2016 2/2/2016 9/23/2016 12/31/2015 12/28/2016 9/22/2016 10/23/2016 6/15/2016 3/5/2016 2/4/2016 3/6/2016 5/12/2016 12/29/2016 9/22/2016 3/5/2016 7/17/2016 7/17/2016 11/28/2016 677 PJ8631 678 AQ3146 679 NC3532 680 AQ3146 681 JA6318 682 DB2245 683 GH4624 684 HN6165 685 HN6165 686 GA8424 687 CC5373 688 IM6512 689 LG6917 690 NC3532 691 QE4655 692 AP1865 693 JA6318 694 KH5616 695 NJ1636 696 AP1865 697 GO9176 698 CC5373 699 MD5166 700 II2656 701 DL1665 702 CF3755 703 QM1483 704 KF5217 705 DL1665 706 MD5166 707 GA8424 708 DL1665 709 LG6917 710 OL1759 711 QQ5463 712 IM6512 713 FK7523 714 DB2245 715 IM6512 716 GO9176 717 OL1759 718 AQ3146 719 NJ1636 720 GH4624 721 PJ8631 722 II2656 12,350 13,350 6,900 13,200 12,800 10,450 12,600 7,650 7,500 14,700 7,300 14,000 9,700 7,000 6,300 12,050 13,000 7,200 8,050 12,000 10,150 7,450 14,500 13,600 14,800 7,700 13,650 8,550 15,000 14,350 14,750 14,950 9,800 10,700 5,750 14,050 8,250 10,450 13,900 10,200 10,600 13,300 7,900 12,650 12,350 13,500 9/22/2016 11/25/2016 3/5/2016 10/25/2016 10/24/2016 7/16/2016 10/23/2016 4/8/2016 4/7/2016 12/30/2016 3/7/2016 11/27/2016 6/14/2016 3/6/2016 2/3/2016 9/21/2016 10/24/2016 3/6/2016 4/9/2016 9/21/2016 7/16/2016 3/7/2016 12/29/2016 11/26/2016 12/30/2016 4/8/2016 11/26/2016 5/11/2016 12/30/2016 12/29/2016 12/30/2016 12/30/2016 6/14/2016 7/17/2016 1/2/2016 11/28/2016 4/10/2016 7/16/2016 11/27/2016 7/16/2016 7/17/2016 10/25/2016 4/9/2016 10/23/2016 9/22/2016 11/26/2016 723 II2656 724 JD5221 725 OL1759 726 DB2245 727 OL1759 728 CC5373 729 JA6318 730 TA5187 731 MD5166 732 QE4655 733 MA3766 734 FP2155 735 NC3532 736 KK6222 737 IM6512 738 CF3755 739 GH4624 740 KH5616 741 QQ5463 742 SK2625 743 QE4655 744 GH4624 745 JA6318 746 SQ3548 747 GH4624 748 GH4624 749 EK6564 750 KK6222 751 GO9176 752 MA3766 753 DL1665 754 JA6318 755 GA8424 756 KF5217 757 FK7523 758 QE4655 759 CF3755 760 GH4624 761 MA3766 762 MA3766 763 CC5373 764 HI6264 765 GH4624 766 SK2625 767 PJ1522 768 NC3532 13,500 10,000 10,600 10,350 10,750 7,450 12,950 11,550 14,550 6,200 9,000 9,200 6,950 5,450 14,050 7,750 12,600 7,150 5,750 5,050 6,200 12,650 12,850 5,400 12,750 12,600 6,600 5,550 10,200 8,800 14,850 12,900 14,600 8,750 8,100 6,250 7,700 12,700 8,850 8,950 7,250 13,150 12,550 5,100 9,550 6,950 11/26/2016 6/15/2016 7/17/2016 7/16/2016 7/17/2016 3/7/2016 10/24/2016 8/20/2016 12/29/2016 2/3/2016 5/12/2016 6/13/2016 3/6/2016 1/1/2016 11/28/2016 4/8/2016 10/23/2016 3/6/2016 1/2/2016 12/31/2015 2/3/2016 10/23/2016 10/24/2016 1/1/2016 10/23/2016 10/23/2016 2/5/2016 1/1/2016 7/16/2016 5/11/2016 12/30/2016 10/24/2016 12/29/2016 5/11/2016 4/9/2016 2/3/2016 4/8/2016 10/23/2016 5/11/2016 5/12/2016 3/7/2016 10/25/2016 10/23/2016 12/31/2015 6/14/2016 3/6/2016 769 AP1865 770 CC5373 771 MD5166 772 LG6917 773 HI6264 774 CF3755 775 II2656 776 HI6264 777 MD5166 778 DD4444 779 AL7693 780 IM6512 781 JM6371 782 JA6318 783 AL7693 784 EK6564 785 SK2625 786 DD4444 787 LG6917 788 HN6165 789 JM6371 790 CN2352 791 MG4841 792 DD4444 793 KK6222 794 QE4655 795 HI6264 796 II2656 797 FK7523 798 NC3532 799 EK6564 800 KH5616 801 CN2352 802 PJ1522 803 OL1759 804 DD4444 805 MD5166 806 BJ2442 807 HI6264 808 AL7693 809 BJ2442 810 CN2352 811 MG4841 812 HI6264 813 MA3766 814 KH5616 11,900 7,300 14,500 9,750 13,050 7,900 13,500 13,100 14,450 11,900 9,450 13,900 8,400 13,000 9,400 6,600 5,000 11,750 9,850 7,450 8,350 6,450 14,200 11,850 5,600 6,200 13,050 13,550 8,300 6,950 6,750 7,050 6,400 9,600 10,750 11,800 14,450 10,850 13,000 9,450 10,800 6,500 14,350 13,200 8,800 7,150 9/21/2016 3/7/2016 12/29/2016 6/14/2016 10/24/2016 4/8/2016 11/26/2016 10/25/2016 12/29/2016 9/21/2016 6/13/2016 11/27/2016 5/10/2016 10/24/2016 6/13/2016 2/4/2016 12/31/2015 9/20/2016 6/15/2016 3/7/2016 5/10/2016 2/4/2016 12/28/2016 9/21/2016 1/1/2016 2/3/2016 10/24/2016 11/26/2016 4/10/2016 3/6/2016 3/5/2016 3/6/2016 2/4/2016 6/14/2016 7/17/2016 9/21/2016 12/29/2016 8/18/2016 10/24/2016 6/13/2016 7/18/2016 2/4/2016 12/28/2016 10/25/2016 5/11/2016 3/6/2016 815 BJ2442 816 JD5221 817 OL1759 818 EK6564 819 PJ1522 820 SK2625 821 MG4841 822 PJ8631 823 KK6222 824 MA3766 825 LT7511 826 LG6917 827 DG4464 828 CN2352 829 FP2155 830 QE4655 831 IM6512 832 LG6917 833 SQ3548 834 LT7511 835 TA5187 836 PJ8631 837 JA6318 838 KK6222 839 JD5221 840 QQ5463 841 LG6917 842 QQ5463 843 CF3755 844 PJ1522 845 OL1759 846 PJ1522 847 JD5221 848 AQ3146 849 LG6917 850 IM6512 851 MG4841 852 BJ2442 853 FK7523 854 KC2236 855 KH5616 856 NJ1636 857 HI6264 858 CN2352 859 DL1665 860 BJ2442 10,950 10,050 10,700 6,600 9,650 5,150 14,150 12,550 5,550 8,900 11,050 9,800 12,100 6,450 9,050 6,300 13,900 9,850 5,250 11,150 11,650 12,400 12,800 5,450 10,000 5,750 9,800 5,750 7,700 9,500 10,600 9,600 10,050 13,250 9,700 14,000 14,250 10,900 8,300 6,050 7,050 7,950 13,050 6,400 14,850 10,950 8/18/2016 7/15/2016 7/17/2016 2/4/2016 6/14/2016 12/31/2015 11/28/2016 10/23/2016 1/1/2016 5/12/2016 8/18/2016 6/14/2016 9/22/2016 2/4/2016 5/12/2016 2/4/2016 11/27/2016 6/15/2016 12/31/2015 8/19/2016 8/20/2016 9/22/2016 10/24/2016 1/1/2016 7/15/2016 1/2/2016 6/14/2016 1/2/2016 4/8/2016 6/13/2016 7/17/2016 6/14/2016 7/15/2016 10/25/2016 6/14/2016 11/27/2016 12/28/2016 8/18/2016 4/10/2016 2/3/2016 3/6/2016 4/9/2016 10/24/2016 2/4/2016 12/30/2016 8/18/2016 861 HN6165 862 GA8424 863 QE4655 864 AL7693 865 QE4655 866 JM6371 867 HN6165 868 DB2245 869 BJ2442 870 AQ3146 871 LG6917 872 KC2236 873 AL7693 874 QE4655 875 LG6917 876 AP1865 877 EK6564 878 AP1865 879 AP1865 880 GO9176 881 LG6917 882 DB2245 883 IM6512 884 QM1483 885 II2656 886 KF5217 887 IM6512 888 HI6264 889 AL7693 890 PJ8631 891 TA5187 892 KC2236 893 EK6564 894 QM1483 895 AL7693 896 LG6917 897 CC5373 898 JM6371 899 KF5217 900 SQ3548 901 TA5187 902 KC2236 903 CF3755 904 MD5166 905 NC3532 906 GA8424 7,600 14,750 6,300 9,400 6,300 8,550 7,550 10,550 10,950 13,300 9,850 6,050 9,250 6,250 9,850 11,900 6,600 11,950 12,050 10,200 9,850 10,550 14,000 13,750 13,600 8,600 14,050 13,050 9,350 12,450 11,550 6,050 6,750 13,850 9,250 9,800 7,450 8,350 8,700 5,350 11,650 5,950 7,850 14,500 6,900 14,550 4/8/2016 12/30/2016 2/3/2016 6/13/2016 2/4/2016 5/10/2016 4/7/2016 7/17/2016 8/18/2016 10/25/2016 6/15/2016 2/3/2016 6/13/2016 2/3/2016 6/15/2016 9/21/2016 2/4/2016 9/21/2016 9/21/2016 7/16/2016 6/14/2016 7/17/2016 11/27/2016 11/27/2016 11/26/2016 5/11/2016 11/28/2016 10/25/2016 6/13/2016 9/23/2016 8/20/2016 2/3/2016 3/5/2016 11/27/2016 6/13/2016 6/14/2016 3/7/2016 5/10/2016 5/11/2016 1/1/2016 8/20/2016 2/2/2016 4/8/2016 12/29/2016 3/5/2016 12/29/2016 907 LT7511 908 PJ1522 909 PJ1522 910 QQ5463 911 DG4464 912 SK2625 913 MA3766 914 GH4624 915 FP2155 916 GH4624 917 JA6318 918 DD4444 919 DD4444 920 FK7523 921 CF3755 922 GA8424 923 PJ8631 924 BJ2442 925 AL7693 926 SK2625 927 NJ1636 928 SK2625 929 CN2352 930 KH5616 931 KK6222 932 QQ5463 933 CF3755 934 DL1665 935 AL7693 936 SK2625 937 OL1759 938 CC5373 939 DD4444 940 JD4442 941 PJ8631 942 PJ8631 943 KC2236 944 DD4444 945 GA8424 946 KH5616 947 JD5221 948 KH5616 949 MA3766 950 NC3532 951 QQ5463 952 CF3755 11,150 9,500 9,600 5,700 12,250 5,000 8,900 12,750 9,150 12,750 12,900 11,750 11,850 8,300 7,800 14,650 12,500 10,850 9,350 5,200 8,050 5,100 6,400 7,100 5,450 5,850 7,700 14,900 9,300 5,050 10,600 7,250 11,850 11,250 12,500 12,450 6,000 11,750 14,700 7,200 10,100 7,000 8,950 6,950 5,750 7,700 8/19/2016 6/13/2016 6/14/2016 1/2/2016 9/22/2016 12/31/2015 5/12/2016 10/24/2016 6/12/2016 10/24/2016 10/24/2016 9/20/2016 9/21/2016 4/10/2016 4/8/2016 12/29/2016 10/23/2016 8/18/2016 6/13/2016 12/31/2015 4/9/2016 12/31/2015 2/4/2016 3/6/2016 1/1/2016 2/2/2016 4/8/2016 12/30/2016 6/13/2016 12/31/2015 7/17/2016 3/6/2016 9/21/2016 8/19/2016 9/23/2016 9/23/2016 2/3/2016 9/20/2016 12/30/2016 3/6/2016 7/15/2016 3/6/2016 5/12/2016 3/6/2016 1/2/2016 4/8/2016 953 QE4655 954 AL7693 955 NJ1636 956 MD5166 957 FK7523 958 GO9176 959 NJ1636 960 AL7693 961 LT7511 962 JD4442 963 FK7523 964 LT7511 965 AP1865 966 DD4444 967 PJ1522 968 DD4444 969 FK7523 970 BJ2442 971 DG4464 972 CN2352 973 NJ1636 974 QM1483 975 KF5217 976 MD5166 977 SK2625 978 DB2245 979 KH5616 980 KK6222 981 GA8424 982 KC2236 983 LT7511 984 SQ3548 985 PJ8631 986 AQ3146 987 JM6371 988 QQ5463 989 KC2236 990 OL1759 991 GA8424 992 CN2352 993 FP2155 994 CF3755 995 KH5616 996 GO9176 997 CC5373 998 FK7523 6,250 9,450 8,050 14,400 8,150 10,250 8,050 9,300 11,000 11,400 8,150 11,100 12,000 11,800 9,450 11,850 8,150 10,800 12,300 6,350 8,000 13,750 8,600 14,500 5,050 10,500 7,100 5,550 14,650 5,900 11,100 5,400 12,400 13,450 8,500 5,750 6,050 10,700 14,550 6,550 9,100 7,800 7,050 10,250 7,250 8,200 2/3/2016 6/13/2016 4/9/2016 12/29/2016 4/9/2016 7/16/2016 4/9/2016 6/13/2016 8/18/2016 8/19/2016 4/9/2016 8/18/2016 9/21/2016 9/21/2016 6/13/2016 9/21/2016 4/9/2016 7/18/2016 9/22/2016 2/4/2016 4/9/2016 11/27/2016 5/11/2016 12/29/2016 12/31/2015 7/17/2016 3/6/2016 1/1/2016 12/29/2016 2/2/2016 8/18/2016 1/1/2016 9/22/2016 11/26/2016 5/10/2016 1/2/2016 2/3/2016 7/17/2016 12/29/2016 2/4/2016 5/12/2016 4/8/2016 3/6/2016 7/16/2016 3/6/2016 4/9/2016 999 QM1483 1000 MA3766 1001 CC5373 1002 DD4444 1003 JA6318 1004 QM1483 1005 MA3766 1006 LT7511 1007 SQ3548 1008 CC5373 1009 CF3755 1010 FP2155 1011 DB2245 1012 HN6165 1013 GH4624 1014 JD5221 1015 HI6264 1016 SQ3548 1017 MG4841 1018 HI6264 1019 MG4841 1020 IM6512 1021 QQ5463 1022 NJ1636 1023 JA6318 1024 BJ2442 1025 JM6371 1026 JA6318 1027 PJ8631 1028 DG4464 1029 CN2352 1030 KK6222 1031 CC5373 1032 GO9176 1033 QE4655 1034 NC3532 1035 QM1483 1036 GH4624 1037 FK7523 1038 QE4655 1039 TA5187 1040 MG4841 1041 OL1759 1042 LG6917 1043 DB2245 1044 DD4444 13,750 8,900 7,400 11,850 12,800 13,750 8,950 11,200 5,350 7,250 7,800 9,150 10,450 7,500 12,700 10,100 13,150 5,350 14,150 13,200 14,150 14,000 5,800 8,000 12,850 10,850 8,450 12,850 12,450 12,250 6,350 5,600 7,400 10,300 6,100 7,000 13,700 12,600 8,200 6,300 11,550 14,100 10,750 9,700 10,550 11,850 11/27/2016 5/12/2016 3/7/2016 9/21/2016 10/24/2016 11/27/2016 5/12/2016 8/19/2016 1/1/2016 3/6/2016 4/8/2016 5/12/2016 7/16/2016 3/7/2016 10/23/2016 7/15/2016 10/25/2016 1/1/2016 11/28/2016 10/25/2016 11/28/2016 11/27/2016 1/2/2016 4/9/2016 10/24/2016 8/18/2016 5/10/2016 10/24/2016 9/23/2016 9/22/2016 2/4/2016 1/1/2016 3/7/2016 7/16/2016 2/3/2016 3/6/2016 11/26/2016 10/23/2016 4/9/2016 2/4/2016 8/20/2016 11/28/2016 7/17/2016 6/14/2016 7/17/2016 9/21/2016 1045 KC2236 1046 LT7511 1047 KH5616 1048 DD4444 1049 AL7693 1050 SQ3548 1051 SQ3548 1052 FK7523 1053 GO9176 1054 QM1483 1055 FK7523 1056 QE4655 1057 NC3532 1058 HI6264 1059 GA8424 1060 QE4655 1061 AP1865 1062 KK6222 1063 QQ5463 1064 JD5221 1065 DG4464 1066 GH4624 1067 SQ3548 1068 DD4444 1069 JM6371 1070 OL1759 1071 PJ8631 1072 FP2155 1073 DD4444 1074 MA3766 1075 HN6165 1076 HN6165 1077 CC5373 1078 DB2245 1079 KF5217 1080 JM6371 1081 KK6222 1082 QE4655 1083 DG4464 1084 CC5373 1085 DG4464 1086 PJ1522 1087 QE4655 1088 NC3532 1089 DG4464 1090 SK2625 6,050 11,100 7,200 11,700 9,300 5,300 5,300 8,150 10,250 13,750 8,300 6,300 6,950 13,100 14,750 6,200 12,100 5,600 5,750 10,100 12,150 12,700 5,250 11,900 8,550 10,650 12,550 9,150 11,700 8,800 7,600 7,650 7,400 10,500 8,650 8,450 5,650 6,250 12,300 7,350 12,200 9,550 6,150 6,950 12,300 5,150 2/3/2016 8/18/2016 3/6/2016 9/20/2016 6/13/2016 12/31/2015 12/31/2015 4/9/2016 7/16/2016 11/27/2016 4/10/2016 2/4/2016 3/5/2016 10/25/2016 12/30/2016 2/3/2016 9/21/2016 1/1/2016 1/2/2016 7/15/2016 9/22/2016 10/23/2016 12/31/2015 9/21/2016 5/10/2016 7/17/2016 10/23/2016 5/12/2016 9/20/2016 5/11/2016 4/8/2016 4/8/2016 3/7/2016 7/17/2016 5/11/2016 5/10/2016 1/1/2016 2/3/2016 9/22/2016 3/7/2016 9/22/2016 6/14/2016 2/3/2016 3/5/2016 9/22/2016 12/31/2015 1091 MG4841 1092 LT7511 1093 CC5373 1094 LG6917 1095 MG4841 1096 PJ8631 1097 AQ3146 1098 KK6222 1099 CF3755 1100 OL1759 1101 GH4624 1102 QQ5463 1103 II2656 1104 CN2352 1105 JM6371 1106 JA6318 1107 AP1865 1108 IM6512 1109 PJ1522 1110 LG6917 1111 JA6318 1112 LG6917 1113 LT7511 1114 GH4624 1115 SQ3548 1116 OL1759 1117 MD5166 1118 NC3532 1119 DD4444 1120 NC3532 1121 PJ8631 1122 KK6222 1123 LT7511 1124 QE4655 1125 GA8424 1126 LG6917 1127 CF3755 1128 LT7511 1129 CC5373 1130 DG4464 1131 TA5187 1132 FK7523 1133 QM1483 1134 AQ3146 1135 JD5221 1136 JD5221 14,200 11,150 7,250 9,800 14,100 12,350 13,250 5,600 7,750 10,700 12,750 5,750 13,600 6,400 8,450 12,950 12,000 14,050 9,600 9,850 12,800 9,750 11,000 12,700 5,450 10,600 14,400 6,950 11,800 6,850 12,400 5,500 11,100 6,200 14,700 9,650 7,800 11,150 7,300 12,200 11,600 8,150 13,700 13,300 10,100 9,950 12/28/2016 8/19/2016 3/7/2016 6/14/2016 11/28/2016 9/22/2016 10/25/2016 1/1/2016 4/8/2016 7/17/2016 10/24/2016 1/2/2016 11/26/2016 2/4/2016 5/10/2016 10/24/2016 9/21/2016 11/28/2016 6/14/2016 6/15/2016 10/24/2016 6/14/2016 8/18/2016 10/23/2016 1/1/2016 7/17/2016 12/29/2016 3/6/2016 9/21/2016 3/5/2016 9/22/2016 1/1/2016 8/18/2016 2/3/2016 12/30/2016 6/14/2016 4/8/2016 8/19/2016 3/7/2016 9/22/2016 8/20/2016 4/9/2016 11/27/2016 10/25/2016 7/15/2016 6/15/2016 1137 MA3766 1138 KF5217 1139 IM6512 1140 JD5221 1141 KK6222 1142 OL1759 1143 DL1665 1144 PJ1522 1145 HI6264 1146 LT7511 1147 SK2625 1148 NC3532 1149 LG6917 1150 HN6165 1151 DB2245 1152 JD5221 1153 SK2625 1154 BJ2442 1155 QQ5463 1156 DB2245 1157 KH5616 1158 NC3532 1159 DG4464 1160 DB2245 1161 AP1865 1162 FP2155 1163 KH5616 1164 AQ3146 1165 MG4841 1166 GA8424 1167 CC5373 1168 QM1483 1169 OL1759 1170 GH4624 1171 IM6512 1172 GA8424 1173 CF3755 1174 GA8424 1175 GO9176 1176 AP1865 1177 JD5221 1178 FK7523 1179 JD4442 1180 KK6222 1181 LT7511 1182 GH4624 8,800 8,700 14,050 10,050 5,450 10,700 14,900 9,550 13,200 11,150 5,050 6,950 9,750 7,450 10,450 10,050 5,000 10,800 5,800 10,400 7,200 6,850 12,150 10,500 12,100 9,100 7,050 13,250 14,200 14,700 7,300 13,850 10,650 12,650 14,000 14,700 7,800 14,600 10,250 12,000 10,000 8,150 11,400 5,550 11,050 12,700 5/11/2016 5/11/2016 11/27/2016 7/15/2016 1/1/2016 7/17/2016 12/30/2016 6/14/2016 10/25/2016 8/19/2016 12/31/2015 3/6/2016 6/14/2016 3/7/2016 7/16/2016 7/15/2016 12/31/2015 7/18/2016 1/2/2016 7/16/2016 3/6/2016 3/5/2016 9/22/2016 7/17/2016 9/22/2016 5/12/2016 3/6/2016 10/25/2016 12/28/2016 12/30/2016 3/7/2016 11/27/2016 7/17/2016 10/23/2016 11/27/2016 12/30/2016 4/8/2016 12/29/2016 7/16/2016 9/21/2016 7/15/2016 4/9/2016 8/19/2016 1/1/2016 8/18/2016 10/23/2016 1183 HN6165 1184 OL1759 1185 NJ1636 1186 HN6165 1187 KF5217 1188 JA6318 1189 HN6165 1190 JA6318 1191 PJ8631 1192 MD5166 1193 SQ3548 1194 JA6318 1195 MD5166 1196 SK2625 1197 NC3532 1198 TA5187 1199 DB2245 1200 DG4464 1201 DD4444 1202 JD4442 1203 DG4464 1204 KH5616 1205 PJ1522 1206 HI6264 1207 MG4841 1208 LT7511 1209 AL7693 1210 DB2245 1211 DL1665 1212 SQ3548 1213 LT7511 1214 MG4841 1215 FK7523 1216 GH4624 1217 FP2155 1218 PJ8631 1219 LG6917 1220 PJ8631 1221 KF5217 1222 AL7693 1223 IM6512 1224 CC5373 1225 SK2625 1226 JD5221 1227 IM6512 1228 GH4624 7,500 10,650 7,950 7,550 8,600 12,800 7,600 12,900 12,400 14,550 5,450 12,900 14,400 5,050 7,000 11,650 10,500 12,200 11,700 11,350 12,200 7,100 9,450 13,150 14,250 11,100 9,300 10,350 14,850 5,350 11,050 14,200 8,250 12,700 9,100 12,350 9,800 12,500 8,700 9,350 13,950 7,250 5,150 10,100 14,050 12,600 3/7/2016 7/17/2016 4/9/2016 4/7/2016 5/11/2016 10/24/2016 4/8/2016 10/24/2016 9/23/2016 12/29/2016 1/1/2016 10/24/2016 12/29/2016 12/31/2015 3/6/2016 8/20/2016 7/17/2016 9/22/2016 9/20/2016 8/19/2016 9/22/2016 3/6/2016 6/13/2016 10/25/2016 12/28/2016 8/18/2016 6/13/2016 7/16/2016 12/30/2016 1/1/2016 8/18/2016 12/28/2016 4/10/2016 10/23/2016 5/12/2016 9/22/2016 6/14/2016 9/23/2016 5/11/2016 6/13/2016 11/27/2016 3/7/2016 12/31/2015 7/15/2016 11/27/2016 10/23/2016 1229 DL1665 1230 KK6222 1231 SK2625 1232 MA3766 1233 LG6917 1234 JD4442 1235 MA3766 1236 QE4655 1237 HI6264 1238 CF3755 1239 DG4464 1240 BJ2442 1241 MA3766 1242 MG4841 1243 QQ5463 1244 KK6222 1245 GH4624 1246 II2656 1247 NJ1636 1248 GO9176 1249 QE4655 1250 DD4444 1251 LG6917 1252 JM6371 1253 AQ3146 1254 CF3755 1255 AP1865 1256 JA6318 1257 MA3766 1258 CC5373 1259 QE4655 1260 SK2625 1261 BJ2442 1262 FK7523 1263 QE4655 1264 JM6371 1265 JA6318 1266 AL7693 1267 GA8424 1268 JD4442 1269 DD4444 1270 DB2245 1271 AL7693 1272 QQ5463 1273 CN2352 1274 QE4655 14,950 5,650 5,050 9,000 9,850 11,350 9,000 6,300 13,200 7,900 12,200 11,000 8,850 14,200 5,700 5,500 12,650 13,550 7,950 10,300 6,150 11,750 9,750 8,500 13,300 7,750 12,100 12,800 9,000 7,250 6,200 5,050 10,850 8,200 6,300 8,350 12,850 9,250 14,650 11,400 11,850 10,400 9,300 5,650 6,500 6,350 12/30/2016 1/1/2016 12/31/2015 5/12/2016 6/14/2016 8/19/