# Billing Specific Clients A Flat-Rate On Per-Diem Meal Types (Doc ID 2439400.1)

Last updated on JULY 24, 2019

## Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.

## Goal

Billing Specific Clients a Flat-Rate on Per-Diem Meal Types

In Projects, per-diem meals are charged by employees to a project and then are billed back to the client. But because meals are tax-included, the adjusted cost base of the meal varies from province to province if there is a different tax basis.

EXAMPLE:
1) Breakfast Per-Diem: \$15/day (tax included)
2) Employee from Québec: Breakfast is then broken out to become \$13.18/breakfast + \$1.82 taxes = \$15.00
3) We wish to bill a specific project a flat rate of \$10.40/breakfast BEFORE taxes
4) In Bill Rates & Discount Overrides (See Note 1), for this specific project, we can define a markup% to rebill (See Note 2)

NOTE 1)
ENTERING BILL RATES FOR SPECIFIC PROJECTS:
Oracle --> Project Billing Super User --> Projects --> Number: (enter project #) --> Click "Find" --> Click "Open" --> Options: Option Name: Bill Rates and Discount Overrides: Non-Labor Bill Rate and Discount Overrides -->

NOTE 2)
= Original x (1 + MU%) = Bill Rate
= (1 + MU%) = (Bill Rate / Original)
= MU% = (Bill Rate / Original) - 1
= MU% = (\$10.40 / \$13.18) - 1
= MU% = -21.09%

Because "Original" amount can vary depending on sales tax of each province, there is no way to include a markup/discount rate that factors in tax rates into the equation. Is there a simple way to charge a flat rate per meal type? The other option the user could think of would be to create every single permutation of mark up % rate (i.e. (10 provinces + 3 territories) x 4 per diem meal types = 52 individual markup % bill rates for the project)