This workbook investigates the total amount of money generated by enrollments in each training class, and allows training classes to be ranked by the enrollment amount generated.
Enrollments for a course may occur using a variety of currencies. The Course Ranking by Amount Workbook can convert foreign currencies to a common currency for reporting purposes. Currencies are converted using exchange rates maintained in a general ledger application.
Enrollments are possible through both OLM and Order Management (OM). This workbook reports on enrollments from both systems to produce a total enrollment amount for each class.
This workbook includes the following worksheet:
Course Ranking by Amount
Which is the most profitable training class?
Which is the least profitable training class?
What is the total enrollment amount generated within a given period of time?
You must specify values for some of the following parameters:
Category
Class start date
Class end date
Reporting currency
Exchange rate
Training class status
Order header status
Order line status
Training center hierarchy
Top training center
The worksheet uses the following calculations:
Class days
Calculates the page item Class Duration Days, based on the Class Duration in days multiplied by the total number of enrollments.
Class days - internal
Calculates the page item, Class Days--Internal, based on a sum of Total Internal Enrollments multiplied by the Class Duration.
Class days - external
Calculates the page item, Class Days--External, based on a sum of Total External Enrollments multiplied by the Class Duration.
Class duration days
Calculates the page item, Class Duration, based on the number of days between the Class Start Date and Class End Date.
Reporting currency
Populates the Reporting Currency column with the currency code for the currency being used.
Total amount per class
Populates the page item Total Amount per Class with the sum of Amount per Class.
Total attended amount
Calculates the page item Total Non Attended Amount, based on a sum of Total Amount where the booking status is equal to Attended.
Total enrollments
Calculates the total number of enrollments for each iLearning training class, based on a sum of Places Booked per Class.
Total external enrollments
Populates the variable Total External Enrollments, based on a sum of Places Booked for external bookings only.
Total internal booking amount
Populates the page item Total Internal Booking Amount, based on a sum of Internal Booking Amount per Class.
Total internal enrollments
Populates the variable Total Internal Enrollments, based on a sum of Places Booked for internal bookings only.
Total non-attended amount
Calculates the page item Total Non Attended Amount, based on a sum of Total Amount where the enrollment status is not equal to Attended.
Total OM amount per class
Calculates the page item, Total OM Amount per Class, based on a sum of OM Amount per Class.
Total OTA amount per class
Populates the variable Total External Enrollments, based on a sum of Places Booked for external bookings only.