| [Company name] |
|
|
|
| Cost of Sales Tool |
|
|
|
|
| [Date] |
|
|
|
|
| |
|
|
|
|
| Model key: |
|
|
|
|
| White cells are fields that you can edit. |
|
|
|
| Gray cells are calculated for you and should not be changed. |
|
|
| |
|
|
|
|
| Customer name |
Annual total sales |
Annual cost of sales |
Gross profit |
Cost of sales % |
| Proseware, Inc. |
$2,865.00 |
$221.00 |
$2,644.00 |
8% |
| A. Datum Corporation |
23,000.00 |
3,210.00 |
19,790.00 |
14% |
| Margie's Travel |
5,678.00 |
1,234.00 |
4,444.00 |
22% |
| The Phone Company |
8,540.00 |
2,210.00 |
6,330.00 |
26% |
| Coho Winery |
45,752.00 |
12,456.00 |
33,296.00 |
27% |
| Tailspin Toys |
22,000.00 |
12,131.00 |
9,869.00 |
55% |
| Fabrikam, Inc. |
1,523.00 |
854.00 |
669.00 |
56% |
| Wingtip Toys |
17,154.00 |
11,546.00 |
5,608.00 |
67% |
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
Total gross profit: |
$82,650.00 |
34% |
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
|
|
|
