Create New Workbook

How to Use in Excel: Create New Workbook: Open a blank Excel workbook. Rename Sheets: Double-click on “Sheet1”, “Sheet2”, “Sheet3”, “Sheet4” at the bottom and rename them to “Instructions”, “Summary”, “Labor Detail”, and “Non-Labor & ODC Detail” respectively. Copy and Paste: For each sheet, copy the entire table (including column headers) from above and paste it starting in cell A1 of the corresponding Excel sheet. Adjust Formulas: Excel should automatically adjust the SUM ranges if you add/remove rows within the defined sections (e.g., adding a new role under “Project Management”). However, always double-check, especially if you add sections outside the initial rows. Fill in Your Data: Start on the “Labor Detail” tab. Fill in your FTEs, Hourly Rates. The “Annual Rate” and annual cost columns will calculate. Go to the “Non-Labor & ODC Detail” tab. Fill in your estimated costs for each item per year. The “Summary” tab will automatically populate. Adjust the Contingency % and Profit % as needed in cells B10 and B15 respectively. Formatting: Apply currency formatting, bolding, and borders as desired for readability. This template will give you a solid, organized foundation for your budget submission!