Group Productivity Report - Summary
5 2 8 3 4
6
7
8
Quarter 1 Sales Dollars $ 534,656 747,561 370,822 206,674 201,801 $ 2,061,514 ltv 701,089 1,264,519 579,428 305,280 238,741 3,089,057
Quarter 2 Sales Dollars $ 561,210 799,244 394,439 217,045 201,801 $ 2,173,739 ltv 767,749 1,352,817 648,238 315,089 249,501 3,333,394
Quarter 3 Sales Dollars $ 604,980 873,952 402,889 227,937 168,168 $ 2,277,926 ltv 827,243 1,555,375 699,900 307,997 212,001 3,602,516
Quarter 4 Sales Dollars $ 668,070 978,952 454,839 257,328 140,140 $ 2,499,329 ltv 902,698 1,773,547 875,519 325,615 180,331 4,057,710
Quarter 5 Sales Dollars $ 737,738 1,201,001 513,487 290,509 116,783 $ 2,859,519 ltv 988,851 2,028,299 1,061,074 352,104 144,321 4,574,649
Quarter 6 Sales Dollars $ 832,190 1,494,155 615,673 329,814 $ 3,271,834 ltv 880,191 1,740,159 1,000,643 315,177 3,936,171
Quarter 7
Total
Sales Rep Bill Doug Kathleen Melissa Nate Grand Total Sales Rep Bill Doug Kathleen Melissa Nate Grand Total
Sales Dollars Sales Dollars $ 987,898 $ 4,926,742 1,970,859 8,065,725 735,539 3,487,688 346,305 1,875,612 828,693 $ 4,040,601 $ 15,143,860 ltv 998,261 2,350,496 1,155,508 346,421 4,850,686
$
$
$
$
$
$
$
$
$
$
$
$
$
$
Sales Less:COGS Gross Profit Less: Sales Costs Salaries Administration Travel Promotion Contribution Income Ending Stock Price
$ $
2,061,514 824,606 1,236,908 62,896 123,323 123,691 206,151 720,847 3.14
$ $
2,173,739 869,496 1,304,243 64,074 123,912 130,424 217,374 768,459 3.39
$ $
2,277,926 911,170 1,366,755 65,168 124,459 136,676 250,572 789,881 3.52
$ $
2,499,329 999,731 1,499,597 67,493 225,621 149,960 249,933 806,590 3.94
$ $
2,859,519 1,143,807 1,715,711 95,662 202,512 171,571 285,952 960,013 5.22
$ $
3,271,834 1,308,734 1,963,100 109,656 204,677 163,592 327,183 1,157,992