4Reports and Inquiry
Option 4Sales Analysis By Product 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 product by warehouse.
Here is a sample Sales Analysis By Product Report:
Expert Distributing, Inc.
05/23/91 04:22 pm KAY Page: 1
Sales Analysis By Product Report
MTD MTD Avg YTD YTD Avg
Wh Name Units Sales Costs GM% Sale Units Sales Costs GM% Sale
=================================================================================================================================
Product 10 #10 3-1/2" White Round
10 Main Facility 4.00 1000.00 560.00 44 250.00 31.00 6820.00 3420.00 50 220.00
20 South End Facility 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
99 Drop Ship Warehouse 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
---------- ---------- ---------- --- ---------- ---------- ---------- ---------- --- ----------
-- Product Totals --> 4.00 1000.00 560.00 44 0.00 31.00 6820.00 3420.00 50 0.00
========== ========== ========== === ========== ========== ========== ========== === ==========
Product 20 #4 12" Gold Plated Black Round
00 ?????????????????????? 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
10 Main Facility 0.00 0.00 0.00 0 0.00 3.00 960.00 730.00 24 320.00
20 South End Facility 2.00 580.00 180.00 69 290.00 44.00 12690.00 6625.00 48 288.41
30 North End Facility 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
---------- ---------- ---------- --- ---------- ---------- ---------- ---------- --- ----------
-- Product Totals --> 2.00 580.00 180.00 69 0.00 47.00 13650.00 7355.00 46 0.00
========== ========== ========== === ========== ========== ========== ========== === ==========
Product 30 #56 10" Red Cylinder
20 South End Facility 1.00 360.00 13.50 96 360.00 6.00 2160.00 1463.50 32 360.00
30 North End Facility 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
---------- ---------- ---------- --- ---------- ---------- ---------- ---------- --- ----------
-- Product Totals --> 1.00 360.00 13.50 96 0.00 6.00 2160.00 1463.50 32 0.00
========== ========== ========== === ========== ========== ========== ========== === ==========
Product 40 #58 10" Yellow Cylinder
20 South End Facility 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
30 North End Facility 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
---------- ---------- ---------- --- ---------- ---------- ---------- ---------- --- ----------
-- Product Totals --> 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00
========== ========== ========== === ========== ========== ========== ========== === ==========
---------- ---------- ---------- --- ---------- ---------- ---------- ---------- --- ----------
-- Grand Totals --> 14.00 3880.00 1520.50 61 900.00 168.00 45260.00 25940.50 43 870.43
========== ========== ========== === ========== ========== ========== ========== === ==========