## Instructions

## Executive Summary Tables

\*\*\*DRAFT\*\*\*

# Enable Macros upon opening the document.

## I.YR1

## Click on tab labeled YR1

## The "Clear Data" on Year 1 will erase all of the information you are about to input. This feature cannot be "Undone"

## PVO/Country: Type the name of your organization and the program country. If your organization is working in multiple countries, list all of them. 

## Inland Rate: 

i.  If your inland rate is not \$100/MT type in your new inland rate. If
    there is no inland, enter "0".

ii. If your **inland rate is different for different commodities**, type
    in the inland rate that applies to the majority of your commodities.

iii. You will have an opportunity to change the inland rate for various
     commodities in a moment.

```{=html}
<!-- -->
```
1)  Now enter the technical sector, recipient category and commodity for
    Year 1 commodities.

    i.  Click on the appropriate cell to view drop down lists. If the
        text is too small to read go to "View" on your menu bar and
        select "Zoom".

    ii. Each requested commodity must be listed under a technical sector
        and a recipient category.

        a.  List commodities for Direct Distribution on lines 1-26 and
            commodities for Monetization on lines 27-40.

        b.  To enter monetization amounts scroll down to the bottom of
            the table or click on the button labeled 'Enter
            Monetization'.

# [Direct Distribution]{.underline}

[**Technical Sectors:**](#_Technical_Sectors_Possible) From the drop
down list, select the appropriate sector. \[HYPERLINK\] If you have
questions as to which technical sector you should select contact the
USAID Country Backstop Officer.

**Recipient Category:** From the drop down list select the appropriate
recipient category. \[HYPERLINK\] If you have questions as to which
recipient category you should select contact the USAID Country Backstop
Officer.

**Commodities:** From the drop down list select the commodity you would
like to request.

**No. of Recipients**: Enter the number of recipients.

**Daily Ration (KGs):** Enter the rate of kilograms/day at which the
commodity will be distributed to each recipient.

**No. Of Feeding Days per Month:** Indicate the number of feeding days
per month for the recipient group.

**No. Of Months Operating:** Indicate the number of months during the
fiscal year in which the CS plans to distribute the commodity to the
noted recipient group.

**MT:** This cell calculates the following formula:

Requested MT = [((No. of Recipients )(Daily Ration (KGs))(No. Of Feeding
Days per Month)(No. Of Months Operating))]{.underline}

1000

# Rounded MT: This cell automatically rounds to the nearest tenth.

Inland Rate: If the inland rate for this commodity is not the rate that
you inputted as the inland rate for the majority of commodities click on
the cell you may type in the correct rate here. NOTE: Do not double
click on this cell. If you accidentally do so, and you see a formula
within the cell, click "enter". If you see that the cell has changed in
a way that you did not intend type CTRL+Z.

**Estimated Total Commodity and Freight:** Rounded MT \* (Inland Rate
+Ocean Rate+Estimated Price); This is an automatic calculation.

# 

# [Monetization]{.underline}

**[Technical Sectors:](#_Technical_Sectors_Possible)** See Direct
Distribution, Technical Sector

**Recipient Category:** You have two options. MON or MON-DF

**MT:** Enter the requested MT.

**Rounded MT:** This cell automatically rounds the MT to the nearest
tenth.

**Estimated Total Commodity and Freight:** Rounded MT \* (Inland Rate
+Ocean Rate+Estimated Price); This is an automatic calculation.

## 

## II.YR2-YR5

## Click on the tab labeled "YR2"

## If you click on the button labeled "Clear Data" it will erase all information for that year. This feature cannot be "Undone". 

1)  The Technical Sector, Recipient Category, and Commodity will be
    repeated from Year One of the DAP. However, you have are able to
    change the Technical Sectors, Recipient Categories and/or
    Commodities if your requirements for the out years vary from year 1.

2)  Complete the table as in Year 1.

3)  Complete all 5 years.

**III. Executive Summary: Cost Estimates**

1)  Click on the tab labeled "ExecSumCostEst".

2)  Click on the button labeled "Update Table."

3)  Print

**IV. Executive Summary Tables: Metric Tonnage**

## Click on the tab labeled "ExecSumMT"

1)  Click on the button labeled "Update Table"

2)  This worksheet contains the table, "Commodity Summary by Technical
    Sector"

3)  Print

**V. Executive Summary Tables**

## Click on the tab labeled "ExecSum"

1)  Click the button labeled "Update Tables"

2)  Complete **"Table 3 Summary of Beneficiaries"**

    -   Numbers should reflect the number of direct beneficiaries met in
        each year of the program.

    -   Total LOA beneficiaries should not necessarily equal the sum of
        beneficiary numbers in each FY, but should reflect the actual
        number of individual direct beneficiaries over the LOA.

    -   Number of beneficiaries should equal total direct monetization
        beneficiaries.

    -   Beneficiaries should not be double-counted (e.g., same direct
        beneficiaries for more than one program category).

    -   Monetization beneficiaries should include those covered by
        direct distribution (costs supported by monetization) as well as
        those beneficiaries participating solely in monetization-funded
        activities.

3)  Verify that the column widths allow all the information to be seen.
    Pay particular attention to Column A. Table 7, Column A contains
    commodities; therefore you may need to widen this column.

4)  Either click on the button labeled "Enter Commodity Procurement
    Schedule' or scroll down to table 7.

    a.  In the first column you will see all the commodities that you
        will be requesting for year 1.

    b.  In the second column you will see the total rounded MT for each
        of those commodities.

    c.  Kindly complete the table to indicate which month you would like
        your commodities to **arrive at their US port** by typing the
        appropriate tonnage for each commodity under the correct month.

5)  Print

[]{#_Technical_Sectors_Possible .anchor}**Technical Sectors Possible
Recipient Categories**

### AG: Agriculture\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

FFW: Food for Work

MON: Monetization

MON-DF: Monetization

in support of Direct Feeding

### ED: Education\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

SF: School Feeding

PSF: Pre-School Feeding

MON-DF: Monetization

in support of Direct Feeding

### HA: Humanitarian Assistance\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

GR: General Relief

OCF: Other Child Feeding

OCF-I: Other Child Feeding Institution

FFW: Food For Work

MON: Monetization

MON-DF: Monetization

in support of Direct Feeding

### HN: Health and Nutrition\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

MCH-M: Maternal Child Health-Mother

MCH-C: Maternal Child Health-Child

FFW:Food for Work

MON: Monetization

MON-DF: Monetization

in support of Direct Feeding

### MF: Micro-Finance\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

MON: Monetization