Lab 13 Excel
Sam1
SalesReport.xlsxSalesReport
| Quarterly Sales Report | |||||||
| Rep Name | Sales | Gross Profits | Expenses | Net Profits | Commission | ||
| George Bush | 44,000 | 1,440 | |||||
| Bill Clinton | 108,000 | 1,650 | |||||
| Ron Reagan | 69,000 | 800 | |||||
| Jim Carter | 95,500 | 600 | |||||
| Total | |||||||
| Average | |||||||
| Lowest | |||||||
| Highest | |||||||
| Gross Margin | 35% | ||||||
| Comm % | 10% |
Charts
| Mountie Enterprises Sales Chart |
