Allied Signal - Automotive
C-Profit System
System Objective
The C-Profit system is intended to provide income statement (P&L) visibility by individual customers, product lines, product categories (divisions) and distribution channels - for end-user analysts at AlliedSignal Automotive Detroit headquarters.
The C-Profit system is populated by AS-400 production system extracts and consists of ~70 queries and ~100 tables, which are ultimately consolidated into a single de-normalized table ([User.mdb]![T_User]) for end-user use. P&L line item allocations are individually processed - to facilitate modification with minimal impact on other components.
The T_User table is exported to Microsoft Excel spreadsheet format for flexible "pivot table" end-user analysis, such as profitability ranking. The C-Profit system was designed, developed, documented and delivered in 5 weeks.
Architectural Levels
| 1 | Input tables (e.g. from mainframe files) | Allocation ($) matrix tables |
| 2a | Allocated tables | estimates of income statement line items |
| 2b | End-user table (single table) | P&L reports (by customer or organizational summaries) |
| 3 | Forecasting: table-creating queries | Exporting to files e.g. for spreadsheet use etc. |
To provide flexibility and freedom from interdependency restrictions, this leveled concept was implemented in a modular fashion, creating a number of databases with separate tables for line-items needing allocation treatment.
