Generate catalog and rate reports
Rates (unit prices) are extracted directly from the budget data by dividing all the costs of deliverables sold by a given unit (eg, by the hour) by the total forecasted units (eg, number of hours).
In some cases, rates include direct costs; in other cases, directly reimbursable project costs are removed before rates are calculated.
In some cases, prime contractors' rates are inclusive of all subcontractors; in other cases, subcontractors charge the project directly at their respective rates.
A rate sheet is produced for each Budget Unit. When managers share a line of business, a blended rate is calculated.
Requirements: Identify the various groups which share a line of business and which use common rates. Remove directly reimbursable direct costs from rows. Summarize the data by unit on the price list within each line of business.
Key learning: Rates provide a key benchmark to be compared with external vendor prices