Skip to content
  • There are no suggestions because the search field is empty.

📄Cost Movements Report

This article covers an overview of the Cost Movements Report which allows for analysis of changes in Cost Price over a period of time.

Prerequisites

  • For an Operator to be able to access and run an Analysis Report within BackOffice, the Allow Analysis Reports flag within the  Reporting tab of Operator Maintenance  must first be enabled
  • If this flag is not enabled, an Operator cannot access ROIs, Cost Movements, and Other Reports

 

Accessing Cost Movements Reports

  • Complete the following steps to access ROI Reports:
    1. Log in to BackOffice
    2. From the side menu, Select "Analysis Reports" to expand the list of Available Reports
    3. Select Cost Movements Report which will open a new Cost Movements Window

Reporting Options 

  • Venue 
    • Sets the Venue for which the Cost Movements Report is generated 
  • Display Period
    • Sets the time period for which report will be generated 
      • The time can be selected either by choosing a specific Period or by choosing a particular shift
  • Suppliers
    • Sets a particular Supplier for the report 
  • Displays Products 
    • Will show the Products attached to the Individual Suppliers
  • Ignore Bonus Stock 
    • Ignores the bonus stock received while calculating price change

 

Report View Options 

"_Products" View

  • The Products View of the Cost Movement Report contains the following data columns by default:

 

Column Heading

Data Description/Formula
Item Volume
  • This column displays the volume of each item as configured in the Product Maintenance
First Cost
  • This column displays the previous cost of Products
Last Cost
  • This column displays the new cost of  Products
Cost Change Percent
  • This column displays the percentage of cost change
  • I.e., Cost Change Percent = ( Last Cost- First Cost / First Cost ) X 100% 
Total Purchased Cost
  • This column displays the previous Total Purchase Cost of the Product 
Purchased at Different Cost
  • This column displays the new total cost at which the products were purchased 
Purchased Difference Due to Cost Changes
  • This column displays the difference caused due to change in Product Cost
 
 

"_Supplier" View

  • The Supplier View displays all the Cost Changes made by Suppliers during the reporting period
  • This report consists of the following data columns by default:

 

Column Heading

Data Description/Formula
Cost Change Percent
  • This column displays the percentage of change by the supplier
  • I.e.,  (Last Cost - First Cost / First Cost) X 100%
Total Purchased Cost
  • The Total Purchased Cost is the first cost at which Products were purchased
Purchased at Different Cost
  • The Purchased at Different Cost displays the new cost at which products were purchased
Purchased Difference Due to Cost Changes
  • This column shows the difference occurred in purchase price due to change of price