Product Cost Sheet Report

Basics of using Ramco Enterprise series web page

Using online help

The Product Cost Sheet Report gives you a report of the various expenses accounted against each item / variant – cost element. Tell me more

The “Product Cost Sheet Report” page appears.

Item Code From

The starting code in the range of codes identifying the item for which you want to generate the product cost sheet report (Alphanumeric, 32). The item code must have been defined in the “CSET” component. The value entered in this field must be lesser than the value entered in the “To” field.

Note: If this field is blank, then all the “Item Codes” will be selected.

To

The ending code in the range of codes identifying the item for which you want to generate the product cost sheet report (Alphanumeric, 32). The item code must have been defined in the “CSET” component. The value entered in this field must be greater than the value entered in the “Item Code From” field.

Note: If this field is blank, then all the “Item Codes” will be selected.

Item Variant From

The starting code in the range of codes identifying the item variant for which you want to generate the product cost sheet report (Alphanumeric, 32). The item variant must have been defined in the “CSET” component. The value entered in this field must be lesser than the value entered in the “To” field.

Note: If this field is blank, then all the “Item Variants” will be selected.

To

The ending code in the range of codes identifying the item variant for which you want to generate the product cost sheet report (Alphanumeric, 32). The item variant must have been defined in the “CSET” component. The value entered in this field must be greater than the value entered in the “Item Variant From” field.

Note: If this field is blank, then all the “Item Variants” will be selected.

Year

Use the drop-down list box to select the year from which you want to generate the product cost sheet report. All the values mapped to the “CSET” component and the concatenated start and end dates of all the MAC accounting years are available for selection in the ascending order. The system displays the current accounting year by default on the launch of the page. 

Period

Use the drop-down list box to select the period from which you want to generate the product cost sheet report. All the values mapped to the “CSET” component and the concatenated start and end dates of all the MAC accounting periods are available for selection in the ascending order. The system displays the current accounting period by default on the launch of the page. 

Date Option

Use the drop-down list box to select the date option in which you want to generate the product cost sheet report. You can select from “Year To Date” and “Period”. The system displays “Period” by default on the launch of the page.

Note: If Year-to-Date is selected, then the Cost Sheet will be generated based on the transaction from the year selected in the “Year” field and to the period selected in the “Period” field.

If Period is selected, then the Cost Sheet will be generated based on the period selected in the “Period” field and for the selected year.

Compare With

Use the drop-down list box to select the comparison for which you want to generate the product cost sheet report. You can select from blank, “Actuals”, “Budget”. The system displays blank by default on the launch of the page.

Note: Based on the selection made in this field the comparison of the product cost sheet is done.

Budget No.

A unique number identifying the budget for which you want to generate the product cost sheet report (Decimal).

 

Help facility available

Note: If the “Budget” is selected in the “Compare With” field, then the “Budget No” is mandatory.

Version No

A unique number identifying the version for which you want to generate the product cost sheet report (Decimal).

Note: If the “Budget” is selected in the “Compare With” field, then the “Budget No” is mandatory.

Year

Use the drop-down list box to select the year from which you want to generate the product cost sheet report. All the values mapped to the “CSET” component and the concatenated start and end dates of all the MAC accounting years are available for selection in the ascending order. The system displays the current accounting year by default on the launch of the page.

  Note: If the “Actuals” or “Budget” is selected in the “Compare With” field, then this field is mandatory.

Period

Use the drop-down list box to select the period from which you want to generate the product cost sheet report. All the values mapped to the “CSET” component and the concatenated start and end dates of all the MAC accounting periods are available for selection in the ascending order. The system displays the current accounting period by default on the launch of the page.

  Note: If the “Actuals” or “Budget” is selected in the “Compare With” field, then this field is mandatory.

Variance Option

Use the drop-down list box to select the variance option in which you want to generate the product cost sheet report. You can select from blank, “Flat” and “Percentage”. The system displays “Flat” by default on the launch of the page.

Note: If the “Actuals” or “Budget” is selected in the “Compare With” field, then this field is mandatory.

Filter Option

Use the drop-down list box to select the filter option for which you want to generate the product cost sheet report. You can select from blank, “>”, “>=”, “=”, “<=” and “<”. The system displays blank by default on the launch of the page.

Note: If the “Actuals” or “Budget” is selected in the “Compare With” field, then this field is mandatory.

Percentage / Value

The number identifying the percentage / value for which you want to generate the product cost sheet report (Decimal).

Note: If the “Actuals” or “Budget” is selected in the “Compare With” field, then this field is mandatory.

If “Actuals” is selected the variances will be generated for Total Cost Variance.

If “Budget” is selected the Total Variance will be generated, which satisfies the Filter Condition and the value provided in this field.

The system prints the product cost sheet report based on the values entered in the search criteria.

The system displays six types of report layouts.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Product Cost Sheet Report - An overview

The cost sheets are generated for each product and it is represented by the total quantity, variable cost, fixed cost and total Cost against each cost element that is mapped to the product. You can generate the report by selecting a range item codes, item variants, accounting year, accounting period and data option combination. You can also compare these fields with the Actuals and the Budget for a given Period and Year to Date. On comparison the details can be viewed in the Flat or Percentage values. You can also select the filters for the option and for the variances. You can also choose the report to be displayed for a Period and Year to Date.