Show Spread Calculation (Expanded Spread Method) Article

Show Spread Calculation (Expanded Spread Method) Article

By clicking on the below button the "Show Spread" columns will appear.  These columns provide for on screen calculations.



1) Enter the assumptions you would like to calculate.  In this example, 1 shipment of 10 boxes at $100 per box. 

2) Then in click into the "Spread Amt" box to activate the calculation and the amount is automatically calculated, in this case $1000 (1*10*$100).

3) Then select the Spread Method you wish to use by clicking on the dropdown menu, making the selection, and then clicking in the "Jan" column to activate the calculation.  In this case, a monthly spread of $1000 which is $83.33 per month.



The "Show Spread" columns can be hidden on clicking on "Hide Spread" to reduce the number of columns on the screen.

    • Related Articles

    • Simple Spread Methods Article

      Spread Methods provides a way to allocate a total budget expense by AccountNum into each budget month. There are three options: A) The Manual Spread Method Enter the required amounts by typing them in manually.  In the below example, $50, was ...
    • Account Details - Expanded Spread Method Video

      click the brackets icon [  ] in the lower right of the video to expand to full screen,  hit escape to return to this page
    • Refresh Spread Method Source Values Article

      The Simple Spread Methods provides the option to spread a budget over months in the budget year using as the spread basis Actual data from Great Plains Accounting (ERP) software.  Should the selected Actual spread year remain open for posting, ...
    • Spread Annual Budget Article

      This screen provides the Administrator the ability to spread budget data entered by users.  In other words, users can enter a budgeted number for the year in a single month, say January, and the Administrator can then spread this number using the ...
    • Manage Spread Methods Article

      Users can define how to spread the budget for each line item over the year. 1) Search on the required CompanyDB, and Budget ID that you wish to add a user defined spread method; 2) Click on the "Manage Budget Spread Metholds" tab; 3) Enter the ...