To have the system calculate amounts for you, click the budget method you want to use.

You can transfer the displayed amounts directly from the inquiry columns, or you can manipulate the numbers in various ways before adding them to the budget. For example, you might want to use last year's actual amounts, increased by five percent to adjust for inflation, as this year's budget for a category. To move inquiry amounts to your new budget, use one of the Copy budget methods.

Use Budget Set Lookup to compare or copy budgets from one category to another. The Budget Set Lookup portion of the form lets you display actual or recognized amounts, or existing budget sets for any contract, project, and category in your database. You can use any of these amounts as the basis for the new budget you are adding.

To use the Lookup feature, you enter in the Budget Set Lookup fields the contract, project, category, budget set, and fiscal year you want to use, then click Go button. The amounts from the budget set lookup appear in the Inquiry fields on the form.

Select the budget set number and the year for which you are adding the budget.

You can enter up to five budget sets per fiscal year for a project category.

The Budget Set field also lets you select Actuals and Recognized, which let you view actual or recognized amounts from the project.

The methods for calculating budget amounts based on amounts or percentages you specify are:

• Fixed Amount

  Select this option to enter an amount that the system adds or copies into the budget column for each period.

  When you select this option, a Fixed Amount field appears, letting you specify the amount. You must also indicate whether the amount is for costs, quantity, or revenue.

• Spread Amount

  Select this option to enter an amount that the system distributes evenly across the budget column for each period. Any remainder is added into the last period.

  When you select this option, a Spread Amount field appears, letting you specify the amount. You must also indicate whether the amount is for costs, quantity, or revenue.

• Base, Percent Increase

  Select this option to enter the base amount you want to budget for Period 1 in the Base Amount field.

  Enter the percentage by which to increase the amount in each subsequent period in the % Increase field. You must also indicate whether the amount is for costs, quantity, or revenue.

  The system uses the base quantity, cost, or revenue you specify as the Period 1 budget amount.

  To calculate the budget amount for Period 2, the system multiplies the Period 1 amount by the percentage in the % Increase field.

  To calculate the Period 3 budget amount, the system multiplies the Period 2 amount by the % Increase percentage.

  The system continues to calculate budget amounts in this manner until all the periods have a budget quantity, cost, or revenue.

• Base, Amount Increase

  Select this option to enter the base amount you want to budget for Period 1 in the Base Amount field.

  Enter the amount by which to increase the amount in each subsequent period in the Amount Increase field. You must also indicate whether the amount is for costs, quantity, or revenue.

  The system uses the base cost, quantity, or revenue you specify as the Period 1 budget amount.

  To calculate the budget amount for Period 2, the system adds the Amount Increase to the base amount.

  To calculate the budget amount for Period 3, the system adds the Amount Increase to the Period 2 amount.

  The system continues to calculate budget amounts in this manner until all the periods have a budget amount.

The methods for calculating budget amounts based on the inquiry amounts are:

• Copy, As Is

  Select this option to copy or add the exact amounts in each period of the inquiry column into the corresponding periods of the Budget Quantity, Budget Cost, or Budget Revenue column.

   

• Copy, Percent Increase

  Select this option to enter the percentage by which to increase the period amounts in the % Increase field.

  The system multiplies the period amount in the Inquiry Amount field by the percentage in the % Increase field and adds or copies the result into the Budget Amount field for the corresponding period.

   

• Copy, Amount Increase

  Select this option to enter the amount by which to increase the period amounts in the Amount Increase field.

  The system adds the amount in the Amount Increase field to the inquiry amount for each period, and adds or copies the result into the corresponding Budget Quantity, Budget Cost, or Budget Revenue field for the period.

   

• Copy, Prorated Spread

  Select this option to enter a base amount and have the system apply a weighting factor in calculating the period amounts.

  The system performs a weighted distribution of amounts based on:

  • The period amount in the inquiry (quantity, cost, or revenue) column.

  • The sum of period amounts in the inquiry (quantity, cost, or revenue) column.

  • The amount you specify in the Spread Amount field.

  The program first calculates a ratio (weight factor) by dividing the individual period's inquiry amount by the sum of the inquiry amounts for all periods. It then multiplies that weight factor by the spread amount you specify to arrive at each period's budget quantity, cost, or revenue amount.

   

Use these fields to identify the project category for which you want to enter a budget.

You can also select the project category from the tree, on the left side of the form. To view information for another level of the contract, you can select it on the tree or use the contract field or contract and project fields to specify the level. (Note, however, that while you can view information for the contract or project, you can enter budgets only for project categories.)

You must specify whether to calculate the budget cost, budget quantity, or budget revenue. Because you calculate the quantity, cost, and revenue separately, you can use a different method for the quantity, cost, and revenue. If you use multicurrency, you need to indicate the currency of the revenue amount you are entering.

In multicurrency systems, when the customer currency is different from your functional currency, you specify exchange information to use to convert the revenue amounts.

If you change the rate, a dialog box appears that lets you choose whether to:

• Recalculate the home revenue amounts.

• Recalculate the source revenue amounts.

• Do not recalculate anything.

This field lets you choose additional information to display in the Quantity, Cost, Revenue (functional), and Revenue (customer) fields that appear beside the Show field. You can select:

• None, if you do not want to view the additional information.

• Original, to display the original estimated quantity, costs, and revenues for the specified contract, project, or category.

• Current, to display the current estimated quantity, costs, and revenues for the specified contract, project, or category.

• Actual, to display actual quantities, costs, and revenues for the specified contract, project, or category.