Answer to Test #9: Negative Sales Growth, Negative Company Volatility
Volatility and Sales GrowthAnswer to Test #9: Negative Sales Growth, Negative Company Volatility
Yellow Highlighting=Change from Beginning of Period
End of Period |
|||||||
Customers in Market |
Amt Purch from all Suppliers | Primary Supplier % of Cust Purch | Units of Sale by Primary Supp | Secondary Supp % of Cust Purch | Units of Sale by Secondary Supp | ||
Customer A | 1200 | Supplier 1 | 40% | 480 | Supplier 2 | 60% | 720 |
Customer B | 1200 | Supplier 1 | 80% | 960 | Supplier 2 | 20% | 240 |
Customer C | 1000 | Supplier 2 | 50% | 500 | Supplier 3 | 50% | 500 |
Customer D | 0 | None | 0% | 0 | None | 0% | 0 |
Total | 3400 | 1940 | 1460 | ||||
Suppliers in Market | Amount Sold |
% Total Market Share | |||||
Supplier 1 | 1440 | 42.4% | |||||
Supplier 2 | 1460 | 42.9% | |||||
Supplier 3 | 500 | 14.7% | |||||
Total | 3400 | 100.0% | |||||
|
|||||||
Supplier |
Change in Unit Sales Volume | % Volume Change from Beginning to End | Net Unit Volatility in Volume Change | Volatility as % of Unit Sales Volume Change |
Customer Growth in Volume Change |
Customer Growth as % of Unit Sales Volume Change | |
Supplier 1 | -420 | -22.6% | -270 | 64% | -150 | 36% | |
Supplier 2 | 120 | 9.0% | 270 | 225% | -150 | -125% | |
Supplier 3 | 0 | 0% | 0 | 0% | 0 | 0% | |
Total | -300 | -8.1% | 0 | 0% | -300 | 100% |
Explanation: In order for this condition to hold, Supplier 1's customers must allocate less of their purchases to the company, and its original customer group must purchase less than it did in the beginning of the period. We reached our answer by having Customer A purchase only 1200 units and then allocate only 40% of those units to Supplier 1.