A Closer Look: The following data is from American Express Business Insights. According to the company's experts, each quick serve will watch different factors to decide whether expansion into an area is right. But negative numbers don't always tell the full story. For example, if a city posts a declining transaction size but its number of real transactions is up, it may be a good place for operators to expand, if their concepts rely on high traffic and low ticket averages.
Click row headers to re-sort the chart.
'asc', 'metro' => 'asc', 'pop_change' => 'asc', 'spend' => 'asc', 'num_transactions' => 'asc', 'avg_trans_size' => 'asc', 'score' => 'asc', ); $indicators = array( 'ranking' => '', 'metro' => '', 'pop_change' => '', 'spend' => '', 'num_transactions' => '', 'avg_trans_size' => '', 'score' => '', ); $header_fields = array( 'ranking' => 'Ranking', 'metro' => 'Metropolitan Area', 'pop_change' => 'Population Change (2000-10)', 'spend' => 'Change in Spend (2000-10)', 'num_transactions' => 'Change in # Transactions (2000-10)', 'avg_trans_size' => 'Change in Avg. Transaction Size (2000-10)', 'score' => 'Score', ); //echo $_GET['sort']; die; if ( in_array( $_GET['sort'], array_keys( $sort_dirs ) ) ) { //echo $_GET['sort']; die; $sort_field = $_GET['sort']; } else { $sort_field = 'ranking'; } if ( in_array( $_GET['dir'], array( 'asc', 'desc' ) ) ) { $sort_dir = $_GET['dir']; } else { $sort_dir = 'asc'; } $opposite_dir = ( $sort_dir == 'asc' ) ? 'desc' : 'asc'; $sort_dirs[$sort_field] = $opposite_dir; $indicators[$sort_field] = theme_tablesort_indicator( array( 'style' => $sort_dir ) ); $header_cols = array(); foreach ( $header_fields as $field => $text ) { $header_cols[] = array( 'data' => l( $text, $_GET['q'], array( 'query' => array( 'sort' => $field, 'dir' => $sort_dirs[$field]), 'html' => TRUE ) ) . $indicators[$field], ); } $table_rows = array(); $table_rows[] = $header_cols; //$sorted_data = get_growth40_sorted_rows( $header_fields, $the_data, $sort_field, $sort_dir ); $values = array(); foreach ( $the_data as $id => $value ) { $values[$id] = $value->$sort_field; } if ( $sort_dir == 'asc' ) { asort( $values ); } else { arsort( $values ); } foreach ( $values as $key => $value ) { $data_cells = array(); foreach ( $header_fields as $field => $text ) { $cell_data = $the_data[$key]->$field; if ( $field == 'pop_change' ) { $cell_data = number_format( $cell_data ); } elseif ( in_array( $field, array( 'spend', 'num_transactions', 'avg_trans_size' ) ) ) { $cell_data .= '%'; } $data_cells[] = array( 'data' => $cell_data, 'class' => $field ); } $sorted_data[] = $data_cells; } foreach ( $sorted_data as $data_row ) { $table_rows[] = $data_row; } print theme( 'table', array( 'header' => NULL, 'rows' => $table_rows, 'attributes' => array( 'id' => 'datatable' ) ) ); //if (!function_exists('get_growth40_sorted_rows') { //} ?>Methodology: The Growth 40 cities are ranked based on a cumulative score. That cumulative score is made up of population rank, spending rank, number of transactions rank, and average transaction size rank. Population data is based on the 2010 U.S. Census. Spending, number of transactions, and average transaction size data were provided by American Express Business Insights. Ties in the cumulative scores were decided based on raw population data, with the larger metro ranking higher.
