Go to HomeTreks Home

Note: Going home clears all of these panels.

Synchronize panels by clicking the panel directional buttons found at the top of the panel.

Get
M and E 2 Operating Budget

Operating Budget NPV Calculator

Introduction
This tool calculates net present value totals for operating and capital budget uris. The discounted totals include operating, allocated overhead, capital, and incentive-adjusted totals. Annual totals reflect the cost for operations or components that have an effective life different than 1 period.

Calculation View Description
v210a

Version: 1.7.0

Relations

Use In Childs?
Overwrite Childs?

Step 3 of 3. Save

Method 1. Do you wish to save step 2's calculations? These calculations are viewed by opening this particular calculator addin.

Step 1

• Step 1. Real and Nominal Rates: The nominal rate includes inflation while the real rate does not. In the USA, DevTreks recommends using Office of Management and Budget rates for the same year as the date of the input.

Step 2

• Step 2. Use Same Calculator Pack In Descendants?: True to insert or update this same calculator in children.
• Step 3. Overwrite Descendants?: True to insert or update all of the attributes of this same calculator in all children. False only updates children attributes that are controlled by the developer of this calculator (i.e. version, stylehsheet name, relatedcalculatorstype ...)
• Step 2. What If Tag Name: Instructional videos explaining the use of what-if scenario calculations should be viewed before changing or using this parameter.
• Step 2. Related Calculators Type: When the Use Same Calculator Pack in Descendant is true, uses this value to determine which descendant calculator to update. Inserts a new descendant when no descendant has this same name. Updates the descendant that has this same name.
• Step 2. Alternative Type: This property is used to analyze differences between Alternatives.
• Step 2. Target Type: This property is used to analyze progress being achieved with budget goals.
• Step 2. Calculated Results: Please refer to the references below.

References

• Hallam, Eidman, Morehart and Klonsky (editors) Commodity Cost and Returns Estimation Handbook, Staff General Research Papers, Iowa State University, Department of Economics, 1999

Current view of document
M and E 2 Operating Budget
Budget Group : M and E 2 Malnutrition Projects
Document Status : notreviewed
Description : Tests of ME Analysis 2.
Label : BG120 Budget Type : 39
Date : 2/11/2014 12:00:00 AM Last Changed : 2/11/2014 12:00:00 AM
Budget :M and E 2 Operating Budget
Label 1 Label 2 Last Modif. Init. Value Salv. Value Interest Rates Nom. Rate Real Rate
BUD100 none 2/12/2014 12:00:00 AM 0.0000 0.0000 0.0300 0.0100
Description
Tests of M and E 2 Analysis.
Time Period : Food Security Program, Province 05
Ending Date Common Ref.? Discount? Enterprise Amt. Enter. Unit Growth Type Growth Periods
12/31/2012 True True 2 each 0 0
Time Period 2012 Malnutrition Progress Last Changed 2/12/2014 12:00:00 AM
Description
Tests of M and E Analysis 2.
Label 2012 Incentive Amount 0.0000 Incentive Rate 0 Overhead Factor 0
Revenues
Outcome : 2012 Families no malnourished children
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/31/2012 OC123 2 none 1 0.0000 0.0000 0
Description
Sample data used in a DevTreks tutorial. v135a
Times Compos Amount Compos Unit Output Amount Output Unit Output Price Total Revenue Annual Total
Date Received Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Output : 2012 Number of children examined for malnutrition, Project 01 Label : O123
2 2 each 1000 each 5.0000 20,000.00
Description
Indicators include the average number of children measured for malnutrition symptoms per month.
Interest 291.12
7/8/2012 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Revenue 20,291.12
Output : 2012 Number of food nutrient packages distributed Label : O122
1 1 each 1200 package 0.5000 600.00
Description
Indicators include the average number of food nutrient packages delivered per month to targeted families and proportion of targeted families receiving packages.
Interest 8.73
7/8/2012 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Revenue 608.73
Revenue Interest - Outcome 599.70 599.70
Total Revenue - Outcome 41,799.70 41,799.70
Total Incentive-Adjusted Revenues - Outcome 41,799.70 41,799.70
Totals Annual Totals
Total Revenue -Time Period 83,599.40 83,599.40
Total Incentive Ben -Time Period 83,599.40 83,599.40
Costs
Operation : 2012 Packages Delivered
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/31/2012 OM100 2 each 1 0.0000 0.0000 0
Description
Sample data set used in a DevTreks tutorial.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : 2012 Food Package Label : I122
07/10/2012 2 False 2 package 2.5000 10.00
Allocated OH 0 none 0.0000 0.00
Capital 0 package 2.5000 0.00
Incentive 0.0000 0 10.14
Description
Each food package contains enough food to sustain a family of four for one day.
Operating Cost Interest 0.29 0.29
Total Operating Costs - Operation 20.29 20.29
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Operation 0.00 0.00
Capital Cost Interest 0.00 0.00
Total Capital Costs - Operation 0.00 0.00
Total Incentive-Adjusted Costs - Operation 20.29 20.29
Operating Costs (OC)
Total Operating Costs -Time Period 40.58 40.58
Net Operating Profits -Time Period 83,558.82 83,558.82
Allocated Overhead Costs (AOH)
Total Allocated Overhead Costs -Time Period 0.00 0.00
Net Operating and Overhead Profits -Time Period 83,558.82 83,558.82
Capital Costs (CAP)
Total Capital Costs -Time Period 0.00 0.00
Net Profits -Time Period 83,558.82 83,558.82
Incentive Costs (INCENT)
Total Incentive Costs -Time Period 40.58 40.58
Net Incentive Profits -Time Period 83,558.82 83,558.82
Time Period : Food Security Program, Province 05
Ending Date Common Ref.? Discount? Enterprise Amt. Enter. Unit Growth Type Growth Periods
12/31/2013 True True 1 each 0 0
Time Period 2013 ME 2 Malnutrition Progress Last Changed 2/12/2014 12:00:00 AM
Description
Test of M and E 2.
Label 2012 Incentive Amount 0.0000 Incentive Rate 0 Overhead Factor 0
Revenues
Outcome : 2013 Families no malnourished children
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/31/2013 OC123 1 none 1 0.0000 0.0000 0
Description
Sample data used in a DevTreks tutorial. v135a
Times Compos Amount Compos Unit Output Amount Output Unit Output Price Total Revenue Annual Total
Date Received Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Output : 2013 Number of children examined for malnutrition, Project 01 Label : O123
1 1 each 1000 each 5.0000 5,000.00
Description
Indicators include the average number of children measured for malnutrition symptoms per month.
Interest -50.19
7/8/2013 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Revenue 4,949.81
Output : 2013 Number of food nutrient packages distributed Label : O122
1 1 each 1200 package 0.5000 600.00
Description
Indicators include the average number of food nutrient packages delivered per month to targeted families and proportion of targeted families receiving packages.
Interest -6.02
7/8/2013 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Revenue 593.98
Revenue Interest - Outcome -56.21 -56.21
Total Revenue - Outcome 5,543.79 5,543.79
Total Incentive-Adjusted Revenues - Outcome 5,543.79 5,543.79
Totals Annual Totals
Total Revenue -Time Period 5,543.79 5,543.79
Total Incentive Ben -Time Period 5,543.79 5,543.79
Costs
Operation : 2013 Packages Delivered
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/31/2013 OM100 1 each 1 0.0000 0.0000 0
Description
Sample data set used in a DevTreks tutorial.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : 2013 Food Package Label : I122
07/10/2013 1 False 1 package 2.5000 2.50
Allocated OH 0 none 0.0000 0.00
Capital 0 package 2.5000 0.00
Incentive 0.0000 0 2.47
Description
Each food package contains enough food to sustain a family of four for one day.
Operating Cost Interest -0.03 -0.03
Total Operating Costs - Operation 2.47 2.47
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Operation 0.00 0.00
Capital Cost Interest 0.00 0.00
Total Capital Costs - Operation 0.00 0.00
Total Incentive-Adjusted Costs - Operation 2.47 2.47
Operating Costs (OC)
Total Operating Costs -Time Period 2.47 2.47
Net Operating Profits -Time Period 5,541.32 5,541.32
Allocated Overhead Costs (AOH)
Total Allocated Overhead Costs -Time Period 0.00 0.00
Net Operating and Overhead Profits -Time Period 5,541.32 5,541.32
Capital Costs (CAP)
Total Capital Costs -Time Period 0.00 0.00
Net Profits -Time Period 5,541.32 5,541.31
Incentive Costs (INCENT)
Total Incentive Costs -Time Period 2.47 2.47
Net Incentive Profits -Time Period 5,541.32 5,541.31
Budget Totals and Nets Totals Annual Totals
Total Revenue -Budget 89,143.19 89,143.19
Total Operating Costs -Budget 43.05 43.05
Net Operating Profits -Budget 89,100.14 89,100.14
Total Allocated Overhead Costs -Budget 0.00 0.00
Net Operating and Overhead Profits -Budget 89,100.14 89,100.14
Total Capital Expenditure Costs -Budget 0.00 0.00
Net Profits -Budget 89,100.14 89,100.14
Equivalent Annual Annuity -Budget 45219.43
Total Incentive Ben -Budget 89,143.19 89,143.19
Total Incentive Costs -Budget 43.05 43.05
Net Incentive Profits -Budget 89,100.14 89,100.14
Dataset: M and E 2 Operating Budget IRI Tests of M and E 2 Analysis.

Uploading a new file will replace any existing file. If necessary, please package and download the existing file prior to this action. If the file has been uploaded successfully, this page will refresh and show the new file information. If the file can't be uploaded (i.e. exceeds 60MB, unsupported mimetype, bad xml, bad html) this page will refresh and show the existing file information.

The file has been uploaded.