CONSUMPTION SUMMARY REPORT

Consumption Summary Report

The Consumption Summary Report allows you to see how much of your Category Items were consumed within a selected Period or Multi-Period. A negative consumption may indicate that vendor invoices are not being approved thus understating the Category Items you have Received. Refer to the steps below on how to view the Consumption Summary Report.

Viewing Consumption Summary Report

  1. Click Reports > Reports List from the navigation.

    mceclip0.png

  2. Click Cost Summary by Category under the Inventory heading.

    mceclip1.png

  3. Filter by Period/Multi-Period.

  4. Click Go to view the results.

    mceclip2.png

 

Some things to keep in mind

  • Each column in the report can be clicked on in order to reorganize the data. 
    For example you can click on End to see in descending order which Categories you have the most stock of at the end of the viewed Period.

  • Export the data in this report to Excel by clicking the download button in the upper right.

  • The Start and End quantities for each Category are the total counts from your two most recent Audits, respectively. 

Column Key

Category: Name of Category

Start: Total quantity of Category Items at the beginning of selected Period

Received: Total quantity of Category Items received via vendor invoices during selected Period

Transferred: Total quantity of Category Items transferred in or out during selected Period

End: Total quantity of Category Items at the end of selected Period

Consumed: Start + Received + Transferred - End

Amount: Total $ value of Category Items consumed during selected Period