Portes chap2lab1
•Download as XLSX, PDF•
0 likes•120 views
The document summarizes sales data for six sales representatives at Façade Importers. It shows each representative's sales amount, sales returns, net sales, sales quota, and amount above or below their quota. Total sales were $4.6 million with $95,000 in returns, for net sales of $4.5 million. On average, representatives met 98% of their sales quotas and exceeded them by $28,900. Grace Li had the highest net sales and amount above quota of $106,654, while Bernard Polizzi had the lowest net sales and was below his quota by $186,250.
Portes chap2lab1
- 1. Façade Importers Sales Analysis Sales Representative Sales Amount Sales Return Net Sales Sales Quota Above Quota Polizzi, Bernard $591,518.00 $12,638.00 $578,880.00 $765,130.00 ($186,250.00) Li, Grace 895,050.00 12,015.00 883,035.00 776,381.00 106,654.00 Volpe, Pamela 716,502.00 18,141.00 698,361.00 733,309.00 -34,948.00 Khan, Anwer 709,672.00 22,326.00 687,346.00 566,940.00 120,406.00 Hudson, Emma 802,525.00 11,138.00 791,387.00 712,222.00 79,165.00 Hueta, Terese 885,156.00 18,721.00 866,435.00 778,060.00 88,375.00 Total $4,600,423.00 $94,979.00 $4,505,444.00 $4,332,042.00 $173,402.00 Average $766,737.17 $15,829.83 $750,907.33 $722,007.00 $28,900.33 Highest $895,050.00 $22,326.00 $883,035.00 $778,060.00 $120,406.00 Lowest $591,518.00 $11,138.00 $578,880.00 $566,940.00 ($186,250.00) % of Quota Sold====>