Analysis Tool – An overview

Introduction

The Cost Sheets are important MIS reports. The prime cost object in MAC is the Cost Center. The need to report costs as period actuals, budgets, past actuals, year’s accumulated figures and the variances between them, at various levels of aggregation between them, end up in countless pre formatted reports for an organization. Using the MAC Analysis Tool the user will be able to configure such reports dynamically and store them as templates, to work upon the available data of any period(s) and bring out meaningful presentations out of them.

Contribution Analysis recognizes the operating income available after meeting the variable costs, to contribute for the fixed costs and to yield profit. This analysis helps to identify and study the behavioral patterns of both the revenues and costs and helps in planning and enforcing cost control, especially the fixed costs because many a times fixed costs absorbs a major portion of the gross income yielding a very less net profit. The Analysis Tool component supports Contribution Analysis for a Profit Center and for individual items on which revenues have been earned.

Feature Highlights

• The Analysis Tool Component supports the definition of, what the Report Column should represent, through the definition of the Column Structure.

• A Column can be defined as a formula that operates on other columns. The remaining part of the report is the definition of the Rows that form the Report.

• The Contribution Analysis Report is used to get the Profitability Details at Cost Center and Item Code Levels.

• The Cost Center can be a Group / Detail Cost Center.

• The Cost Element Structure ID can be specified to additionally specify the Cost Elements to be considered while taking a Report.

• The Cost Elements that satisfy the criteria can be fetched into the multiline.

• Existing Elements can be removed form the scope of the Report. When Item wise Reports are to be taken then the distribution between the Fixed Cost and Variable costs can be specified Item Wise.

• A Sensitivity Analysis can be performed by comparing the Actuals to Budgets and specifying data that you want to see in the Report.

List of Activities