C07_B5945_Att_06_Schedule_of_Values.xlsx

This is a Schedule of Values (SOV) template for tracking contract performance and invoicing on the Building 5945 Electrical Upgrade project at Naval Undersea Warfare Center (NUWC) Division, Keyport, Bangor Annex. The spreadsheet is designed to document monthly invoicing for a subcontract/task order by breaking down work into individual activities with associated costs for labor, materials, equipment, and bond/insurance. Each activity row captures the total budgeted value, percentage completion, total earned to date, previous payments, current billing amount, and amount remaining. The template includes 75 activity line items plus dedicated rows for bond and special insurance costs, with all values currently populated at $0.00, indicating this is a blank template awaiting project data population.

The SOV instructions direct users to update monthly invoices by copying the current month's earned values (column g) to the previous payments column (column h) using the paste special "value" feature, then updating the percentage complete for each activity in column (e). The template calculates total budget value by summing labor, materials, equipment, and bond/insurance costs for each activity, multiplies this total by the percentage complete to derive earned value, and automatically computes billing amounts and remaining balances. This standardized federal contracting form serves as the primary invoice support document for progress payments under the Building 5945 Electrical Upgrade subcontract.