...
- Isolating the Hardware Repair business within the SAP cost object is difficult as revenues from the Software side are mixed in as well. (This would be less of an issue if the RT-ticket-to-SAP-transaction link were more clear and consistent).
- Reconciling RT tickets against SAP financial transactions needs a much better link between SAP and RT records. SAP DTR transactions generally do not record the respective ticket number that match them. Cases RT tickets generally do not record the amount we to be taking in from the work done. The of revenue expected to be billed. The several different ways we can receive payment each create a different kind of documentation trail in SAP, and only two of which indicate the RT ticket.
- Staffing model is a muddle. Payroll expenses in 1637500 are indeed only for Hardware Service, but an uncertain amount of Help Desk staff also contribute effort to tickets that end up in Hardware; that time is difficult to document.
- Metadata fields in RT tickets are note used consistently enough. These fields are the ones that power management reporting and metrics. They are the only ones that tell us what kind of work is what within the system of record. Indeed, one or two additional fields are needed to give a complete picture in RT of the repair lifecycle (see recommendations below).
- Free text fields sometimes have haphazard entries. This causes some consternation when exporting data to Excel for analysis, but Excel can also correct for this using lookup functions to convert as-entered text to canonical values at analysis time. (For instance,"Apple", "Mac" and "Macintosh" can be converted to the one entry "Apple", which is how it shows up in SAP reimbursements. "Lenovo" and "IBM" are another common pairing.)
- Some record-keeping and reconciliation is on paper only. All important numbers matching work done to money received need to be electronically available and reportable, not just hand-written on a paper that is then filed. The number that connects Apple reimbursements to RT warranty work isthe case in point.
...