 |
|
 |
|
 |
|
 |
|
 |
|
| |
|
|
|
 |
|
 |
| |
 |
|
|
 |
|
|
|
|
|
|
|
|
| |
|
|
|
 Identification
of Unearned Revenue. |
|
|
|
| Financial
Analytical Reporting System for Air NZ Revenue Accounting. |
|
|
|
|
|
|
|
|
|
 |
|
 |
|
|
| |
|
|
|
| |
 |
|
|
|
|
|
|
| |
Business Challenge |
|
|
|
|
|
|
| |
Subsequent to Air New
Zealand's acquisition of Ansett Air Lines one primary task for Air New
Zealand Revenue Accounting Department was to identify unearned revenue
within Ansett Air Lines. This process involved analysing over 30 million
unmatched sales transactions and boarding passes. |
|
|
|
|
|
|
| |
Boston
Software Solution |
|
|
|
|
|
|
| |
Boston Software,
working in collaboration with the accounting staff of Air New Zealand,
designed and developed a data mart to analyse the unearned revenues. Boston
Software developed algorithms to match more than 30 million sale transactions
to boarding passes.
These elegant PL/SQL algorithms developed by Boston Software for
transforming the unearned revenue into earned revenue were audited
and approved by Ansett’s auditing agency - Arthur Anderson.
Data mart was used to identify and declare unearned revenue for
each month for the period between 1995 and 2002.
Up
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
| |
 |
|
|
|
|
|
|
| |
Business Challenge |
|
|
|
|
|
|
| |
Air New Zealand
Revenue Accounting Department needed to produce financial reports
as close as possible to real time to enable the Air New Zealand marketing
department to make speedier ticket pricing decisions, relative to
the feasibility of its promotional pricing and new products, to enable
it to aggressively compete in the airline market. |
|
|
|
|
|
|
| |
Boston
Software Solution |
|
|
|
|
|
|
| |
Boston Software,
working in collaboration with the Revenue Accounting staff, designed
and developed a revenue reporting system which enabled the Air New
Zealand finance data warehouse to produce a set of diverse reports.
These included revenue reports for domestic and international routes,
revenue per kilometre (RPK) reports, and passenger kilometre reports
to facilitate aggressive marketing.
Up
| Back
to Our Work |
|
|
 |
|
 |
|
| |
|
|
|
|
|
|
|
|
|
