MR070: Product Sales and Cost by Manufacturer/Product Category

The MR070 report shows products sold within the date range sorted by manufacturer or product category, with a breakdown of Income, Avg. Cost, Total Value Sold, Total Profit, percentage metrics, and much more.

Tip: Run the MR070 regularly to review the profitability of each product line.

Report definitions

Click here for details on each of the fields that appear in the MR070 report.Click here for details on each of the fields that appear in the MR070 report.

  • Manuf. / Prod Cat. / Prod. Subcat. / Prod.: The manufacturer, Product Category/Subcategory, and product.
  • # Sold: The number of the specific product that was sold.
  • Income: The sum of sales for the product.
  • Avg. Cost: The average cost of the item for the selected date range. Meevo uses the Average Daily FIFO to calculate this value.
  • Total Value Sold: (# Sold X Avg. Cost)
  • Total Profit: (Income ‒ Total Value Sold)
  • % Profit: (Total Profit / Income) X 100
  • % of Category Total: (Total income for that product / Total income for the Product Category)
  • % of Overall Total: (Total income for that product / Total income across all products)
  • % of Male: Percentage of product sales that were purchased by persons whose client profile gender defines them as males. Clients count only once per day.
  • % of Female: Percentage of product sales that were purchased by persons whose client profile gender defines them as females. Clients count only once per day.
  • % of Other: Percentage of product sales that were purchased by persons whose client profile gender defines them as Other. Clients count only once per day.
  • % of Unspecified: Percentage of product sales that were purchased by persons whose client profile gender defines them as Unspecified. Clients count only once per day.

Setting up the MR070 report

  1. Type MR070 in the Convobar, or go to Meevo > Reports > Register/Sales, and then select the MR070 report.
  2. Select a date or date range for running the report:
    1. To run a report for a specific date range, select Custom and specify the Start Date and End Date for the report.
    2. Otherwise, select a predefined date or range (Yesterday, This Week, Last Week, etc.).

Note: If you select a predefined range (a date other than Custom), you can still change the Start Date and End Date. Doing so automatically changes the date range to Custom.

  1. In Sort Report by, select a sorting option:
    1. Manufacturer: Sorts by product manufacturer as defined in the product definition.
    2. Product Category: Sorts by Product Category as defined in the product definition.
  2. Page Break after Sort Option: Creates a new page for each category in the report, sorted by your selection in Sort Report By.
  3. All Drawers: Select All Drawers to run the report for all register drawers. Otherwise, deselect the option and use the list to select the drawers.

Running the report

  1. When you are ready to generate the report, select a Report Format beside the Run Report button.
  2. Here is a rundown of each format type:
    1. PDF: Each time you select Run Report with PDF selected, Meevo opens a separate browser tab that displays the PDF'ed report. Meevo remains on the setup page, so you can quickly jump back over to Meevo to run more date ranges or other reports. Each PDF report you run will open its own browser tab, so you can easily review and compare reports by simply jumping between browser tabs.
    2. HTML: This is our original legacy format, which opens the report within Meevo. All of the functionality within that report is still there and available via the toolbar.
    3. XLSX: Each time you select Run Report, your browser auto-downloads the report in .xlsx format. Select the downloaded file in the browser footer to open the spreadsheet.
  3. Select Run Report to generate the report in your chosen format. Depending on the type of report and criteria you entered, this process may take a few minutes.