4Reports and Inquiry
Option 5Sales Analysis By Warehouse Report
This report shows the month-to-date and year-to-date units sold, sales dollars, cost of sales, gross margin percentage, and average sales dollars for each warehouse by product.
Here is a sample Sales Analysis By Warehouse Report:
Expert Distributing, Inc.
05/23/91 04:24 pm KAY Page: 1
Sales Analysis By Warehouse Report
MTD MTD Avg YTD YTD Avg
Product Name Units Sales Costs GM% Sale Units Sales Costs GM% Sale
=================================================================================================================================
Warehouse
20 #4 12" Gold Plated Black Round
0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
---------- ---------- ---------- --- ---------- ---------- ---------- ---------- --- ----------
-- Wh Totals --> 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
========== ========== ========== === ========== ========== ========== ========== === ==========
Warehouse 10 Main Facility
10 #10 3-1/2" White Round
4.00 1000.00 560.00 44 250.00 31.00 6820.00 3420.00 50 220.00
20 #4 12" Gold Plated Black Round
0.00 0.00 0.00 0 0.00 3.00 960.00 730.00 24 320.00
---------- ---------- ---------- --- ---------- ---------- ---------- ---------- --- ----------
-- Wh Totals --> 4.00 1000.00 560.00 44 0.00 34.00 7780.00 4150.00 47 0.00
========== ========== ========== === ========== ========== ========== ========== === ==========
Warehouse 20 South End Facility
10 #10 3-1/2" White Round
0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
20 #4 12" Gold Plated Black Round
2.00 580.00 180.00 69 290.00 44.00 12690.00 6625.00 48 288.41
30 #56 10" Red Cylinder
1.00 360.00 13.50 96 360.00 6.00 2160.00 1463.50 32 360.00
40 #58 10" Yellow Cylinder
0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
---------- ---------- ---------- --- ---------- ---------- ---------- ---------- --- ----------
-- Wh Totals --> 3.00 940.00 193.50 79 0.00 50.00 14850.00 8088.50 46 0.00
========== ========== ========== === ========== ========== ========== ========== === ==========
Warehouse 30 North End Facility
20 #4 12" Gold Plated Black Round
0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
30 #56 10" Red Cylinder
0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
40 #58 10" Yellow Cylinder
0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
---------- ---------- ---------- --- ---------- ---------- ---------- ---------- --- ----------
-- Wh Totals --> 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
========== ========== ========== === ========== ========== ========== ========== === ==========