Below Is an Exception Report for Records Selected Because of the Size

question 11

Essay

Below is an exception report for records selected because of the size of their variance. If the system would allow you to order the list of customers from the most severe variance to the lease severe variance, what would be the order of the records?
SOUTHWEST SALES REPS, INC.
SALES BY CUSTOMER
FOURTH QUARTER 2012

$\begin{array}{lrrrrr}\text { Customers } & \text { This Year } & \text { Last Year } & \text { Variance }&\text { Budget } & \text { Variance }\\\hline\text { Barrett Company } & \$ 30,000 & \$ 26,000 & \$ 4,000+ & \$ 32,000 & \$ 2,000- \\\text { Cardenas Bros. } & 94,000 & 95,000 & 1,000- & 90,000 & 4,000+\\\text { Estrada Coaches } & 72,000 & 69,000 & 3,000+ & 80,000 & 8,000- \\\text { Reed Enterprises } & 52,000 & 44,000 & 8,000+ & 54,000 & 2,000-\\\text { Tran Industries } & 39,000 & 35,000 & 4,000+ & 31,000 & 8,000+ \\\text { Wise Imports } & 80,000 & 85,000 & 5,000- & 90,000 & 10,000-\end{array}$

---

Definitions:

Tax Rate

The percentage at which an individual or corporation is taxed by the government.

Net Profit Margin Percentage

A financial metric that shows the percentage of revenue that remains as profit after all expenses have been subtracted from total sales.

Net Operating Income

A measure of a company's profitability from its regular business operations, excluding expenses and revenues from non-operational activities.

Gross Margin

The difference between the sales and the cost of goods sold, which shows the profitability before deducting operational expenses.