| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||||||||
2 | American Samoa Project Costs Submission Template Instructions | |||||||||||||||||||||||||
3 | To allow the BCORD Office to assess your proposed Project Costs in a consistent and concise manner, they must be submitted via this standard program template. Below you will find instructions to properly complete this form. The Project Info, Project Cost Details, and Investment Schedule tabs must be completed by the Applicant. | |||||||||||||||||||||||||
4 | Submission Instructions: 1.Complete Worksheets: Fill in all required fields on in the fields highlighted below. Do not fill out the automated sheets. 2. Supporting Documentation: Attach any supporting documentation quotes, engineer certifications, letters of credit, etc.) 3. Sumbit Workbook: Save the completed workbook as BEAD_Budget_[OrganizationName].xlsx and submit via the designated American Samoa BEAD Grants Portal. For more information contact our office a bcord@doc.as.gov. Visit our website at broadband.as.gov | |||||||||||||||||||||||||
5 | Tab Name | Fillable by Applicant | Tab Instructions | |||||||||||||||||||||||
6 | 1. Project Info | Yes | Applicants shall fill out their project and applicant information in the designated fields, this should be entered with the exact information as entered into the identical fields in the application. | |||||||||||||||||||||||
7 | 2. Cost Categories | No | This tab provides a description of the cost categories and is not editable by the Applicant. | |||||||||||||||||||||||
8 | 3. Project Cost Details | Yes | Applicants must enter individual cost items into the “Detailed Cost” tab. The “Project Cost Summary” tab will be automatically populated via the information entered directly into the “Detailed Cost” tab. Applicants shall provide cost details with sufficient granularity to demonstrate an understanding of the project and its associated costs. The provided cost details must include sufficient descriptiveness to verify the eligibility of each cost item proposed. For each proposed cost item, the applicant must fill out the following information fields: | |||||||||||||||||||||||
9 | Cost Description – A simple description of the cost item. (i.e. Labor – Directional Drilling 2x2” conduits, Material - 24”x26”x26” handhole, Contractor Fees - OSP design engineering). | |||||||||||||||||||||||||
10 | Cost Category – This is a drop-down field for each of the program cost categories, Applicant to select the field that is appropriate for the proposed cost item. Descriptions of the costs categories can be found in the "Cost Categories" tab. The "Cost Categories" tab also provides the applicable SF424C cost categories each program category is associated with. | |||||||||||||||||||||||||
11 | Unit Type – The unit of measurement for each cost item quantity (i.e. Feet, Each, Hours, etc.) | |||||||||||||||||||||||||
12 | Unit Quantity – The Applicant’s estimated quantity of each cost item that will be required to complete the project. | |||||||||||||||||||||||||
13 | Unit Cost – The Applicant’s estimated cost per unit for each cost item. | |||||||||||||||||||||||||
14 | Grant Funding Request – Amount of grant funding that the Applicant is requesting for this cost item. | |||||||||||||||||||||||||
15 | Required for each cost item. | |||||||||||||||||||||||||
16 | Cost Details and Justification – Where the Applicant provides sufficient narrative supporting their estimated unit quantities and cost. The Applicant can use this field to provide additional details such as proposed construction methodologies and materials specifications. | |||||||||||||||||||||||||
17 | 3. Project Cost Summary | No | This tab is automatically populated via the information submitted in the “Detailed Cost” tab and is not editable by the Applicant. Refer to this tab to ensure your proposed project costs category totals and applicant match totals are accurately reflected. | |||||||||||||||||||||||
18 | 4. Investment Schedule | Yes | Applicants must enter line item, on an annual basis, a schedule for when the costs identified in the “Detailed Cost” tab are to be expended over the course of the four-year project timeframe. For each applicable year, the applicant must fill out the following information fields: Grant Funds to be Expended – Amount of grant funding that the Applicant plans to expend for the corresponding cost item in that project quarter. Matching Funds to be Expended – Amount of match the Applicant plans to expend for the corresponding cost item in that project quarter. The capital investment schedule expenditures must match the totals proposed in the “Detailed Cost” tab. Cost items associated with the "Contingencies" cost category will not be entered into the capital investment schedule as the represent a contingency and not costs the Applicant anticipates incurring. The capital investment schedule must align with the Applicant’s proposed project timeline (Attachment 7c). For example, network deployment expenditures must align with the project quarters in which the Applicant’s proposes to perform network deployment. | |||||||||||||||||||||||
19 | 5. Invest. Sch. Summary | No | This tab is automatically populated via the information submitted in the “Investment Schedule” tab and is not editable by the Applicant. Refer to this tab to ensure your proposed project costs category totals and applicant match totals are accurately reflected. | |||||||||||||||||||||||
20 | 6. Calculate Cost per BSL or CAI | Yes | This tab is to be used to calculate the cost per location for your proposed project. Please enter the total number of Broadband Serviceable Locations (BSLs) and Community Anchor Institutions (CAIs) as submitted in your BEAD Deployment Application. Ensure that the figures entered here match the numbers provided in your official application submission. | |||||||||||||||||||||||
21 | ||||||||||||||||||||||||||
22 | ||||||||||||||||||||||||||
23 | ||||||||||||||||||||||||||
24 | ||||||||||||||||||||||||||
25 | ||||||||||||||||||||||||||
26 | ||||||||||||||||||||||||||
27 | ||||||||||||||||||||||||||
28 | ||||||||||||||||||||||||||
29 | ||||||||||||||||||||||||||
30 | ||||||||||||||||||||||||||
31 | ||||||||||||||||||||||||||
32 | ||||||||||||||||||||||||||
33 | ||||||||||||||||||||||||||
34 | ||||||||||||||||||||||||||
35 | ||||||||||||||||||||||||||
36 | ||||||||||||||||||||||||||
37 | ||||||||||||||||||||||||||
38 | ||||||||||||||||||||||||||
39 | ||||||||||||||||||||||||||
40 | ||||||||||||||||||||||||||
41 | ||||||||||||||||||||||||||
42 | ||||||||||||||||||||||||||
43 | ||||||||||||||||||||||||||
44 | ||||||||||||||||||||||||||
45 | ||||||||||||||||||||||||||
46 | ||||||||||||||||||||||||||
47 | ||||||||||||||||||||||||||
48 | ||||||||||||||||||||||||||
49 | ||||||||||||||||||||||||||
50 | ||||||||||||||||||||||||||
51 | ||||||||||||||||||||||||||
52 | ||||||||||||||||||||||||||
53 | ||||||||||||||||||||||||||
54 | ||||||||||||||||||||||||||
55 | ||||||||||||||||||||||||||
56 | ||||||||||||||||||||||||||
57 | ||||||||||||||||||||||||||
58 | ||||||||||||||||||||||||||
59 | ||||||||||||||||||||||||||
60 | ||||||||||||||||||||||||||
61 | ||||||||||||||||||||||||||
62 | ||||||||||||||||||||||||||
63 | ||||||||||||||||||||||||||
64 | ||||||||||||||||||||||||||
65 | ||||||||||||||||||||||||||
66 | ||||||||||||||||||||||||||
67 | ||||||||||||||||||||||||||
68 | ||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||
71 | ||||||||||||||||||||||||||
72 | ||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||