The Scrap Refining Analysis report provides a detailed view of inventory items that have been processed through scrap refining in Bravo. This report allows users to see which items were included in scrap batches, their associated costs, and how much they sold for after being refined.
Users can generate this report for individual stores or company-wide and filter by date range and scrap batch ID for more granular analysis.
Accessing the Scrap Refining Analysis Report
To locate the report in Bravo:
- Open Bravo Reporting Pro in your web browser
- Navigate to Operational Reports
- Select All Reports
- Choose Scrap Refining Analysis
Configuring the Report
Before running the report, users must configure the parameters:
- Store Selection: Defaults to all stores, but users can filter by individual locations.
- Date Range: Enter the start and end date for the refining period you wish to analyze.
- Batch ID (Optional): If you want to view a specific scrap batch, select the batch from the list. The batch list will populate after selecting a valid date range.
If you want to see all batches for your date range, you must check "Select All" from the top of the batch list. Otherwise you will see the following error:
Once you have entered the parameters click from the right hand side of the screen.
As the report is running, you will see a notification that the report is loading. Clicking Cancel will abort the reporting process.
Understanding the Report Output
The report generates a list of all items that were processed through scrap refining in Bravo..
Key Columns in the Report
- Store: The store where the item was processed.
- Inventory Number: Unique identifier for the inventory item.
- Item Tag Description: Description of the item’s tag.
- Item Description: Detailed description of the item.
- Sale Date: The date the item was sold as scrap.
- Date Added to Batch: When the item was added to the scrap batch.
- Item Cost Amt: The original cost of the item before refining.
- Avg Sale Amt: The portion of the total bucket sale amount assigned to this item.
- Scrap Batch: Identifies the batch where the item was included.
- Category Name: The item's category (e.g., Gold Scrap, Diamond Jewelry, etc.).
- Source: Indicates whether the item was bought or came from another source.
- Employee Alias: The employee who processed the item.
- Last Ticket ID: The last transaction associated with the item.
- Split From: If the item was split from another inventory piece, the original reference ID appears here.
Understanding Sales Amounts in the Scrap Refining Report
When jewelry items are added to a scrap refining batch, Bravo distributes the total bucket sale amount across all items in that batch.
How the Sales Amounts Are Distributed
- Each individual item shows an "Avg Sale Amt", which represents a portion of the total bucket sale price.
- The store and company-wide totals reflect the actual bucket sale amount.
Example of How the Report Works
If a scrap bucket with three items sells for $1,483.33, the report will show:
- Each item with a proportional "Avg Sale Amt" (e.g., ~$494.44 per item).
- The total at the top of the report will show $1,483.33 (Total Bucket Sale Amount).