1 / 28

Building an Activity Based Costing Solution

Building an Activity Based Costing Solution. Presenter: Heron Jayawardena Supervisor: Gary Lau (Macquarie Analytics). Agenda. Project Background Project Purpose Business Problem Solution Design - Architecture, Approach , Technologies Demo Benefits Limitations Future Work Questions.

sitara
Download Presentation

Building an Activity Based Costing Solution

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Building an Activity Based Costing Solution Presenter: Heron Jayawardena Supervisor: Gary Lau (Macquarie Analytics)

  2. Agenda • Project Background • Project Purpose • Business Problem • Solution Design - Architecture, Approach, Technologies • Demo • Benefits • Limitations • Future Work • Questions

  3. Project Background What is ABC? Is  A Management Accounting Approach Which  Allocate all Direct and Indirect costs To  Cost objects (products and services) To Help management understand critical business information

  4. Project Background -- continued • Currently there are varieties of ABC approaches and models in place across the Macquarie University •  FBE uses spread sheets • FoS uses their own system (PHP, MySql) • Activities for this project - Academic Activities • Teaching • Research • Services

  5. FBE Model

  6. Project Purpose Develop a web based data collection and reporting capability for ABC

  7. Business Problem Every faculty has their own methodology No common terminology across the faculties Reporting - Data stored in different locations/formats

  8. End User Layer: Browser Reports Form Data Model Cube Report Data Collection Data Cost Pools Cost Objects ABC (On Virtual Server) Allocate HR Data Data Bank Time Table Finance Solution Design - Architecture

  9. Solution Design – Approach • Obtain data sets (OFS, HR, Unit Bank..etc) • Analyse data sets • Load data in to the Databank (Analytics) • Create data cubes to load the acquired data • Design web forms to capture academic activities • Build ABC reports

  10. Solution Design - Technologies

  11. Demo Personae: Academic Staff – entering data & review Faculty General Manager – reviewing faculty reports

  12. Individual Academic Input

  13. Teaching Activity Input - 1

  14. Teaching Activity Input - 2

  15. Research Activity Input

  16. Service Activity Input

  17. Reports

  18. Individual Summary Report

  19. Faculty Summary Drill-Down Report - 1

  20. Faculty Summary Drill-Down Report - 2

  21. Faculty Summary Drill-Down Report - 3

  22. Faculty Summary Drill-Down Report - 4

  23. Faculty Cost Drill-Down Report

  24. Benefits • Provide a common base for ABC • Data collection & Reporting for ABC • Academic Workload Planning (AWP) • Academic PDR • Meet Macquarie's operational & strategic targets

  25. Limitations • Review is done only on two faculties • Limited feedback and user acceptance testing

  26. Future Work • Automate ABC as much as possible to reduce OFS workload. • Standardise data capturing from other sources.

  27. Questions

  28. Thank You

More Related