In a rental business it's common to bundle a pack with some distance included in the pack. Excess distance is billed at a certain rate. The payment of the pack is pre-paid, excess usage will happen at the end of rental period. How should I configure my products to allow me to bundle say 100 Kms in the default purchase, and simply enter the total usage and let odoo automatically figure out which pack has excess usage.
Example:
Bundle 1:
100Kms included. Excess is billed at 10 per km.
Bundle 2:
150Kms included. Excess is billed at 9 per km.
Now if a customer purchase bundle 1, the user(odoo user) will simply state how many total kms driven, and odoo should be able to identify the previously purchased bundle, find the excess usage and bill accordingly.
How do I achieve this?