jagomart
digital resources
picture1_Budget Spreadsheet 40659 | Budget And Rff 2in1 Step Yr 9b 1


 190x       Filetype XLSX       File size 0.13 MB       Source: commerce.idaho.gov


File: Budget Spreadsheet 40659 | Budget And Rff 2in1 Step Yr 9b 1
sheet 1 instructions step financial assistance award faa budget and reimbursment 2in1 template please review the following instructions for completing the 2in1 template below is a blue quot template quot ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Instructions
STEP FINANCIAL ASSISTANCE AWARD (FAA)
BUDGET AND REIMBURSMENT 2in1 TEMPLATE

Please review the following instructions for completing the 2in1 template.











Below is a blue "TEMPLATE" tab that serves dual purpose for Financial Assistant Awards (FAA).

First the budget portion of the template is completed when applying for an award. The completed template is uploaded into the Commerce Grants Portal.

After award and project completion, the reimbursement portion of the template is completed and uploaded with supporting documentation to the Commerce Grants Portal.

Budget Section
Complete columns B - G
Review the "Sample Budget Template" tab for a specific example template and for further instructions. Pay close attention to instructions in yellow higlighted cells in red print

Reimbursement Section
Complete columns I - R
Review the "Sample Reimbursement Template" tab for a specific example template and for further instructions.


































Sheet 2: Template





















Company Name







Project Title





Traveler Name(s) Traveler 1:
Traveler 2:
























REQUIRED - TRAVEL NARRATIVE: Delete this text and provide details of the travel requested in this space:

* Refer to the Sample Budget Template for an example.
* Include the travelers name(s), hotel name(s), and ground transportation details if known.
* If travel exceeds the dates of a trade show, include details about the itinerary and what will be accomplished in the days before and/or after the trade show.
* You may also upload an itinerary with your budget if you feel it would be helpful to evaluators.










BUDGETED TRAVEL EXPENSES Enter detailed information below about the expense that will help us to understand how you arrived at that cost and why it is reasonable.
ACTUAL TRAVEL EXPENSES Enter detailed information about the receipt. For example airline, hotel name, ground transport name etc.

Line items in actual expenses do not need to line up with initial budget.
Location Origin: Destination:
TOTAL MATCH AMOUNT DUE RECEIPT # RECEIPT DATE
Dates of Travel Depart: Return:

Cost # People (Max = 2)


Airfare $-

$-

$- $- $-


Baggage Fees $-

$-

$- $- $-



Cost # Rooms (Max = 2) # of Nights


$- $- $-


Lodging (rate at or below Dept. of State max - HERE) $-

$-

$- $- $-


Rental Car $-

$-

$- $- $-


Fuel (Rental Car Only) $-

$-

$- $- $-



Rate # People (Max = 2) # of Days


$- $- $-


M & IE (rate per GSA / Dept. of State - HERE) Travel Days: First & Last Calculated at 75% $-

$-

$- $- $-

NO RECEIPTS REQUIRED FOR M&IE, just use rate for travel dates, first and last travel days at 75% of the rate
M & IE (rate per GSA / Dept. of State - HERE) $-

$-

$- $- $-

Total $-

$- $- $-























TRADE SHOW EXPENSES Enter detailed information below about the expense.
ACTUAL TRADE SHOW EXPENSES Enter detailed information about each receipt.
Show Name

TOTAL MATCH AMOUNT DUE RECEIPT # RECEIPT DATE
Location (City, Country)

Dates of Show


Cost



Booth Space/Registration Fee $-

$-

$- $- $-


Booth Insurance $-

$-

$- $- $-


Booth Build/Display $-

$-

$- $- $-


Booth Furnishings $-

$-

$- $- $-


Show Services (Labor, utilities, security, storage) $-

$-

$- $- $-


Demonstration supplies $-

$-

$- $- $-


Shipping ($5,333 maximum expense) $-

$-

$- $- $-


Total $-

$- $- $-























OTHER ALLOWALBE EXPENSES Enter detailed information below about the expense.
ACTUAL OTHER ALLOWABLE EXPENSES Enter detailed information about each receipt.

# Hours Rate/hr


TOTAL MATCH AMOUNT DUE RECEIPT # RECEIPT DATE
Interpreter Fees
$- $-

$- $- $-



Cost # People (Max = 2)


$- $- $-


Trade Mission Participation Fees $-
$-

$- $- $-


Design of Marketing Media ($10,666 maximum expense) $-
$-

$- $- $-


Export Training Workshop Participation Fees $-
$-

$- $- $-






US Commercial Service Products
(Gold Key, Int'l Partner Search, RAISE etc.)
$-
$-

$- $- $-


Total $-

$- $- $-


TOTAL ACTUAL PROJECT BUDGET $-
$- $- $-


TOTAL ADJUSTED PROJECT BUDGET $-
$- $- $-






TOTAL REIMBURSABLE BUDGET (MAXIMUM $9,000) $-
TOTAL ACTUAL








TOTAL REQUIRED CASH MATCH (25%) $-
$-














$- Total Reimbursable Amount
(actual will be equal to or less than award)
$0.00 Awarded Amount
(this is the maximum reimbursement)
The amount calculated on this budget in cell 57F should match the grant amount request in the online portal
$- Total Required Match Amount
(actual will be equal to or greater than required match)












































































Funded in part through a grant with the U.S. Small Business Administration











Sheet 3: Sample Budget Template























NOTES AND LINKS TO HELP YOU WITH INDIVIDUAL LINE ITEMS







Company Name Company ABC, Inc.

Include the full legal name of the company
Project Title China Horse Fair

Include the title of the project
Traveler Name(s) Traveler 1: Jane Doe Traveler 2: TBD

Include the names of up to 2 employee travelers.








REQUIRED - TRAVEL NARRATIVE:
-Two travelers will depart Boise for Beijing, China on United Airlines connecting in San Francisco on American Airlines to Beijing.
-Accommodation will be at the Hotel Express, downtown Beijing. Ground transportation will be by train, bus and taxi service.
-Day 1 is travel. Days 2-3 are for booth set up. Days 4-6 are the trade show. Day 7 is weekend. Days 8-9 are for post trade show business meetings. Day 10 is return travel.
-Meetings will be with ABC Manufacturing, DEF Packaging, Worldwide Imports and buyers for China Imports, XYZ Imports. (See uploaded itinerary for details)

Detail the air carriers you will be flying on. REMEMBER FLY AMERICA ACT APPLIES. CLICK HERE FOR MORE INFORMATION.


AND HERE FOR OPEN SKIES AGREEMENTS & EXCEPTIONS

State the itinerary, especially for any travel before and/or after the trade show or event.

Detail any customer meetings and the purpose of the meetings.

Allowable, but optional, to upload into the portal a more detailed itinerary




BUDGETED TRAVEL EXPENSES Enter detailed information below about the expense that will help us to understand how you arrived at that cost and why it is reasonable.

Location Origin: Boise, Idaho Destination: Beijing, China
Enter your travel origin and destination
Dates of Travel Depart: 3/11/2019 Return: 3/20/2019
Enter the full dates of your travel (example: 03/11/2019 - 03/20/2019)

Cost # People (Max = 2)



Airfare $1,495.00 2
$2,990 Delta.com for economy fair for travel dates
Enter the total airfare per person and the number of people. In column G, justify the expense.
Baggage Fees $400.00

$400 Delta.com baggage rates, 1 extra bag/person each way at $100/ea
Enter the total of all excess baggage fees

Cost # Rooms (Max = 2) # of Nights



Lodging (rate at or below Dept. of State max - HERE) $155.00 2 8 $2,480 Marriott.com website for travel dates, under GSA max of $258
Enter the hotel cost per night, the number of rooms and the total number of nights. REMEMBER: The maximum lodging rate can be found HERE for foreign rates. Go to GSA.gov for domestic rates.
Rental Car $835.89

$836 Hertz.com quote for travel dates
Enter the costs as indicated. In column G, justify the expense.
Fuel (Rental Car Only) $200.00

$200 Estimate based of current fuel rates for destination
Enter the total of fuel charges, ONLY if renting a car. . In column G, justify the expense

Rate # People (Max = 2) # of Days



M & IE (rate per GSA / Dept. of State - HERE) Travel Days: First & Last Calculated at 75% $119.00 2 2 $357 Travel there on 11th and travel back on 20th
Enter the M & IE Rate for the destination city. Only 75% of rate is allowed on travel days. For multiple cities, itemize in the narrative. The maximum per diem (M & IE) rate can be found HERE for foreign rates. Go to GSA.gov for domestic rates. Or call IDC with questions.
M & IE (rate per GSA / Dept. of State - HERE) $119.00 2 8 $1,904 Based on GSA, arrive on 12th, show set up on 12/13th, show 14-16th, meetings on 18-19th
Total $9,167









TRADE SHOW EXPENSES Enter detailed information below about the expense.
Show Name China Horse Fair
Enter the name of the trade show
Location (City, Country) Beijing, China
Enter location, city and country of the trade show
Dates of Show 3/14/19 - 3/16/19
Enter the dates of the trade show

Cost




Booth Space/Registration Fee $3,000.00

$3,000 show website - chinahorsefair.com.cn
Enter the costs as indicated. In column G, justify the expense.
Booth Insurance $550.00

$550 show organizer quote
Enter the costs as indicated
Booth Build/Display $2,250.00

$2,250 booth builder quote at $250/sq. meter for 9 sq. meters
Enter the costs as indicated
Booth Furnishings $300.00

$300 purchasing additional chairs and tables, cheaper than through builder
Enter the costs as indicated
Show Services (Labor, utilities, security, storage) $200.00

$200 electricity quote
Enter the costs as indicated
Demonstration supplies $92.00

$92 brochure racks
Enter the costs as indicated
Shipping ($3,077 maximum expense) $500.00

$500 shipping of saddles to display
Enter your total shipping costs, $2000 maximum reimbursement
Total $6,892









OTHER ALLOWALBE EXPENSES Enter detailed information below about the expense.

Hours Rate


Interpreter Fees 15 $35.00
$525 quote form interpreter
Enter the total hours of interpreter fees provided and the hourly rate.

Cost # People (Max = 2)




Trade Mission Participation Fees


$- n/a
Enter the total participation fees
US Commercial Service Products
(Gold Key Registration, etc.)
$700.00

$700 working with Amy Benson at USCS on a Gold Key in conjunction with this show
Enter the total for all Gold Key Registrations purchased.
Total


$1,225


TOTAL ACTUAL PROJECT BUDGET $17,284

TOTAL ADJUSTED PROJECT BUDGET $15,385

When total actual budget exceeds $15,385 this line will auto adjust to the maximum $10,000 award
TOTAL REIMBURSABLE BUDGET (MAXIMUM $10,000) $10,000

When total reimbursable allowable exceeds $10,000 this line will auto adjust to the maximum $10,000 award
TOTAL REQUIRED CASH MATCH (35%) $5,385

When total required match exceeds 35% ($5,385) this line will auto adjust to the maximum $5,385


The words contained in this file might help you see if this file matches what you are looking for:

...Sheet instructions step financial assistance award faa budget and reimbursment in template please review the following for completing below is a blue quot tab that serves dual purpose assistant awards first portion of completed when applying an uploaded into commerce grants portal after project completion reimbursement with supporting documentation to section complete columns b g sample specific example further pay close attention yellow higlighted cells red print i r company name title traveler s required travel narrative delete this text provide details requested space refer include travelers hotel ground transportation if known exceeds dates trade show about itinerary what will be accomplished days before andor you may also upload your feel it would helpful evaluators budgeted expenses enter detailed information expense help us understand how arrived at cost why reasonable actual receipt airline transport etc line items do not need up initial location origin destination total match ...

no reviews yet
Please Login to review.