# Average Selling Price Template

Document Sample

```					Average Selling Price Analysis
August 11, 2008
This worksheet helps you calculate the average selling price for multiple products sold across multiple distribution channels. It also calculates the simple average selling price of the products sold in each channel.

Units Marsetts Retail Wholesale Mail Order Telemarketing Private Label Total Ramsetts Retail Wholesale Mail Order Telemarketing Private Label Total Gosetts Retail Wholesale Mail Order Telemarketing Private Label Total Chipsetts Retail Wholesale Mail Order Telemarketing Private Label Total Keysetts Retail Wholesale Mail Order Telemarketing Private Label Total 1000 4000 3000 2000 1000 11000

Sales \$40,000 \$60,000 \$70,000 \$70,000 50,000 \$290,000

Percentage of Total Sales 13.8% 20.7% 24.1% 24.1% 17.2% 100.0%

Weighted Average Selling Price \$40.00 \$15.00 \$23.33 \$35.00 \$50.00 \$26.36

Simple Average Selling Price

\$32.67

3000 4000 3000 2000 1000 13000

\$40,000 \$60,000 \$70,000 \$70,000 50,000 \$290,000

13.8% 20.7% 24.1% 24.1% 17.2% 100.0%

\$13.33 \$15.00 \$23.33 \$35.00 \$50.00 \$22.31

\$27.33

5000 6000 3000 2000 1000 17000

\$140,000 \$160,000 \$70,000 \$70,000 50,000 \$490,000

28.6% 32.7% 14.3% 14.3% 10.2% 100.0%

\$28.00 \$26.67 \$23.33 \$35.00 \$50.00 \$28.82

\$32.60

7000 8000 3000 2000 1000 21000

\$240,000 \$260,000 \$70,000 \$70,000 50,000 \$690,000

34.8% 37.7% 10.1% 10.1% 7.2% 100.0%

\$34.29 \$32.50 \$23.33 \$35.00 \$50.00 \$32.86

\$35.02

9000 10000 3000 2000 1000 25000

\$240,000 \$260,000 \$70,000 \$70,000 50,000 \$690,000

34.8% 37.7% 10.1% 10.1% 7.2% 100.0%

\$26.67 \$26.00 \$23.33 \$35.00 \$50.00 \$27.60

\$32.20