Specifications

Computer Tutorial 3 Appendix C
5
Copy, As Is
The program copies the amounts in the Inquiry Amount fields to the Budget Amount fields
without modification.
Copy, Percent Increase
The program copies the amounts from the Inquiry Amounts fields to the Budget Amount
fields, with each Budget Amount field increased or decreased by the percentage entered.
Copy, Amount Increase
The program copies the amounts from the Inquiry Amount fields to the Budget Amount
fields, with each Budget Amount field increased or decreased by the amount entered.
Copy, Prorated Spread
The program performs a weighted distribution of amounts based on the period amount in the
Inquiry Amount column, the sum of period amounts in the Inquiry Amount column, and the
amount you specify in the Spread Amount field. The system uses the following equation to
compute each period’s budget amount:
Period inquiry amount
×
Spread amount
=
Budget amount
Sum of inquiry amounts for period for period
for all periods
Explanations for the buttons at the bottom of the Budget Maintenance window follow:
Add button: adds the new budget information.
Save button: saves changes to an existing budget set.
Delete button: deletes a budget fiscal set.
Add to button: adds the amounts you are calculating or copying in the Budget Method box to
the existing amounts that are already in the Budget Amount column.
Replace button: replaces the amounts in the Budget Amount column with the amounts being
copied or calculated from the selected Budget Method.
Clear button: clears all the amounts in the Budgeted Amount column and reset them to zero.
This does not delete the fiscal set and will not permanently change the amounts unless you
click the Save button.
EXERCISE C.2
1. You should have the Budget Maintenance window open. It should look like Exhibit C-3. If
not, repeat Exercise C.1.
2. Click the Fixed Amount radio button under Budget Method. Enter -400,000 in the Fixed
Amount field. Click Replace. Note that -400,000 appears in the Budget Amount column for
every period.
3. Click the Spread Amount radio button. Enter -6,000,000 in the Spread Amount field. Click
Replace. Note that -500,000 appears in every period (that is, the 6,000,000 was spread among
all periods.)
4. Click the Add to button. Note the Budget Amount column for every period increased by
500,000 (the amount of the per-period spread amount) so that the amount is now 1,000,000.