Gross Margin Inventory Report
This is a sample of our gross margin report. It consists of two parts - the Inventory Valuation Summary and the Inventory Valuation Detail. Part One of the report presents your inventory summarized by Category within the Salesfloor and Stockroom. Part Two presents your inventory by Location/Section and Category. And, it includes the gross margin percentage and calculated cost for each detail line.
Blue Chip Inventory Service International |
|||
INVENTORY VALUATION SUMMARY |
|||
Store: |
Your Store |
Job Number: |
98576 |
Address: |
Address: 1000 Main Street |
Starting Date: |
03/14/11 |
Time: |
6:00PM |
||
Ending Date: |
12/15/11 |
||
Time: |
11:00PM |
||
Category |
Salesfloor |
Stockroom |
Retail (12/15/11) |
Gross Margin % |
Calculated Cost |
Grocery Non Tax /Tax Dairy Eggs |
253,940.02 |
44,782.19 |
298,722.21 |
30.00 |
209,105.55 |
Cigarettes and Tobacco |
19,086.51 |
216.38 |
19,302.89 |
30.00 |
13,512.02 |
Non Foods |
165,353.65 |
8,716.33 |
174,069.98 |
30.00 |
121,848.99 |
Greeting Cards on Display |
7,280.42 |
|
7,280.42 |
30.00 |
5,096.29 |
Card Understock and Backstock |
1,966.00 |
|
1,966.00 |
30.00 |
1,376.20 |
Distilled Spirits |
20,437.28 |
1,416.75 |
21,854.03 |
30.00 |
15,297.82 |
Bottle Deposits |
2.00 |
714.00 |
716.00 |
0.00 |
716.00 |
Garden Seeds |
2,044.94 |
|
2,044.94 |
15.00 |
1,738.20 |
L'eggs Hosiery |
6,546.57 |
|
6,546.57 |
15.00 |
5,564.58 |
GRAND TOTAL |
476,657.39 |
55,845.65 |
532,503.04 |
29.72 |
374,255.65 |
Blue Chip Inventory Service International
INVENTORY VALUATION DETAIL
Store: |
Your Store |
Job Number: |
98576 |
|
|
Location |
Department |
Category |
Retail (12/15/11) |
Gross Margin % |
Calculated Cost |
0001 F 01 |
0001 001 |
Grocery Non Tax/Tax Dairy Eggs |
188.51 |
30.00 |
131.96 |
0001 F 01 |
0001 015 |
Non Foods |
87.12 |
30.00 |
60.98 |
0001 L 01 |
0001 001 |
Grocery Non Tax/Tax Dairy Eggs |
2,936.04 |
30.00 |
2,055.23 |
0001 L 01 |
0001 015 |
Non Foods |
4.23 |
30.00 |
2.96 |
0001 B 01 |
0001 001 |
Grocery Non Tax/Tax Dairy Eggs |
984.11 |
30.00 |
688.88 |
0001 B 01 |
0001 015 |
Non Foods |
109.02 |
30.00 |
76.31 |
0001 R 01 |
0001 015 |
Non Foods |
7,261.91 |
30.00 |
5083.34 |
0002 F 01 |
0001 015 |
Non Foods |
1,370.74 |
30.00 |
959.52 |
0002 L 01 |
0001 015 |
Non Foods |
5,684.22 |
30.00 |
3,978.95 |
0002 B 01 |
0001 001 |
Grocery Non Tax/Tax Dairy Eggs |
799.48 |
30.00 |
559.64 |
Partial report only, entire report follows the displayed pattern. |
|||||
0817 X 01 |
0001 001 |
Grocery Non Tax/Tax Dairy Eggs |
851.23 |
30.00 |
595.86 |
0817 X 01 |
0001 005 |
Cigarettes and Tobacco |
216.38 |
30.00 |
151.47 |
0817 X 01 |
0001 030 |
Distilled Spirits |
1,416.75 |
30.00 |
991.73 |
|
|
GRAND TOTAL |
532,503.04 |
29.72 |
374,255.65 |