Item Cost Analysis Reports

The Item Cost Analysis Reports helps the user in tracking the overall profitability or cost for the Stock Item, without affecting the stock values during the entire process. The Item Cost Analysis reports provide the detailed information as per Stock Group, Stock Item and Item Cost Track breakup via various transactions.

To access the Item Cost Analysis Reports,

Go to Gateway of Tally > Display > Statements of Inventory > Item Cost Analysis

Item Cost Analysis menu is displayed as shown:

Click the below links for details.

Stock Group Cost Analysis

Stock Item Cost Analysis

Item Cost Track Break-up

 

Stock Group Cost Analysis

The Stock Group Cost Analysis report displays the Stock Group-wise Cost Track for All or Selected Stock Groups. The report displays the Cost, Revenue, the Balance at Cost and Profit/Loss details for Stock Group at primary level.

To view the Stock Group Cost Analysis report,

The Stock Group Cost Analysis screen is displayed as shown:

Note: By Default, the report displays the period till the date of last entry.

Cost Analysis Column Details

A. Cost (Expense): This column displays the total cost incurred for the selected Stock Group, such as  Purchases, Expenses (Direct and Indirect) and Consumption Cost.

B. Revenue (Income): This column displays the total revenue earned for the selected Stock Group, such as Sales, Incomes (Direct and Indirect).

C. Balance at Cost: This column displays the balance cost (closing stock) available for the selected Stock Group (A - B)

Profit/Loss (B-(A-C)): This column displays Profit earned or Loss incurred for the selected Stock Group.

Select the required Stock Group from the list to drill down to display the Sub-Group/Stock Item Cost Analysis report, further drill down to view the Item Cost Track Break-up, and then to Ledgers and finally to the voucher level.

Note: This button toggles between Detailed / Condensed.

Note: This button toggles between Item-wise/ Grouped.

The Stock Group Cost Analysis report expanded in detailed format displays the Stock Group, Sub-Groups/Stock Items and the Cost Tracking Number, as shown:

Stock Item Cost Analysis

The Stock Item Cost Analysis report allows the user to display the Cost Tracking Number list for the selected Stock Item.

To view the Stock Item Analysis report,

The Stock Item Cost Analysis report of the selected Item (E.g.i-5 Desktops) is displayed as shown:

Note: This report can be viewed from Stock Group Cost Analysis through drill down or by viewing the report Item-wise (F5).

F12: Configuration at Stock Group / Stock Item Cost Analysis

Note: Anyone of the options has to be set to Yes.

Item Cost Track Break-up

The Item Cost Track Break-up report displays the details of Tracking, Cost, Revenue, Balance at Cost, Net Profit/Loss for the selected Item Cost Track (Cost Tracking Number). It also displays the Item Movement Summary which contains the details of Item Movement Inward/Outwards, such as, Order Placed/Received, Material Received/Delivered, Materials Billed and Materials Manufactured.  

This report can also be viewed from Stock Group/Item Cost Analysis through drill down.

To view the Cost Track Break-up,

The Item Cost Track Break-up report of the selected Cost Track (E.g.CT-01-CPUi5) appears as shown:

Note: This button toggles between Ledger-wise/ Grouped.

Ctrl+C: Close Cost Track

This button allows the user to Close/Open the Cost Track. The user may operate this button from Stock Group and Stock Item Cost Analysis report screens.

Close Cost Track

To Close the Cost Track,

Note: The button Ctrl+A: Open/Close Track will be active only incase the Cost Track row(s) are selected using Spacebar.

The button F5 toggles between Show All and Pending.

Open Cost Track

To Open the closed Cost Track,

From the Cost Track Closure screen,


www.tallysolutions.com