Appendix E - Sample Monthly Report Work Log.xlsx

XLSX spreadsheet 26 KB Posted

Attached to
RFP 118-26 MVSS Bus Maintenance Contract
Solicitation number
BD-27-1206-40000-40000-132987
Issued by
Suffolk County, Massachusetts

About this file

This file is a Sample Monthly Report Work Log in spreadsheet format for the Massachusetts MVSS Bus Maintenance Contract (RFP 118-26). The document serves as a template for contractors to track and report labor hours and activities related to bus maintenance operations on a monthly basis. The work log is designed to capture detailed information about maintenance tasks performed, including the date of work, description of work completed, hours spent on each task, and employee or technician information. The spreadsheet format allows for systematic documentation of all maintenance activities, which is essential for contract compliance, invoicing, and performance monitoring throughout the contract term.

The sample work log appears to be a standard reporting requirement for the bus maintenance contract, enabling the contracting agency to verify that work is being performed as specified in the scope of work and to ensure accurate billing for labor hours. This type of documentation is critical for state and local transportation contracts where detailed record-keeping is necessary to demonstrate productivity, track resource allocation, and maintain audit trails for public funds expenditure. The template's structure suggests that monthly submissions will be required from the contractor throughout the contract period, making it a key administrative and accountability tool for the MVSS Bus Maintenance Contract.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Work Log

MBTA MVSS — Monthly Work Log (SAMPLE) | Contractor: _______________ | Month/Year: _______________
SN Ticket #Date ReceivedDate ClosedBus / Vehicle #Fleet TypeGarageStatusPriorityHardware ImpactedIssue TypeTriage HrsField Svc HrsEngineer HrsTotal HrsIssue DescriptionWork PerformedParts UsedMBTA Eng ReviewDispositionNTF - MBTA Confirmed?Notes / Follow-Up
500160204/23/202605/04/20261669BusArborwayClosedLevel 1 - StandardNVRNVR Offline1247Bad NVR — bus showing offlineNVR reimaged and enrolled; replaced monitor and DVI cablePart# 20131944YesNVR ReplacedYes
500164605/01/202605/04/20261405BusFellswayClosedLevel 1 - StandardMoxa SwitchConnectivity/Network00.500.5Bus on road; cameras offline; Moxa unpluggedSecured Moxa switch; no clip availableYesConfig AdjustedVerify next visit
500167105/07/202605/13/20261272BusSouthamptonClosedLevel 1 - StandardUPS/Power FilterPower/UPS Issue11.502.53.4 power hits; needs UPSInstalled UPSPart# 25470011YesUPS Replaced
500165905/06/202605/18/20261831BusCabotClosedLevel 2 - ElevatedNVRConfiguration Error110.52.5Unable to export video; offline in AVL; Genetec not auto logging onCertificate issue — created new server and generated new certificate; NVR workingYesConfig Adjusted
500172305/20/202605/26/20261831BusCabotClosedLevel 1 - StandardNVRConfiguration Error10.2523.25Cameras recorded with future date (Sep 2026); date off on archiverDeleted future-dated video; deleted archiver/DB links; restarted server and federationYesConfig AdjustedThird visit this month — flag for trend review
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Monthly Summary

Monthly Summary Dashboard
TICKET VOLUMETICKETS BY GARAGECOUNTOPEN
Total Tickets5Arborway10
Open Tickets0Cabot20
Closed Tickets5Charlestown00
NTF - Pending MBTA Conf0Fellsway10
Duplicates0Lynn00
Southampton10
LABOUR HOURSQuincy00
Total Triage Hrs4Albany00
Total Field Svc Hrs5.25Wellington00
Total Engineer Hrs6.5Forest Hills00
TOTAL ALL HOURS15.75North Cambridge00
HARDWARE BREAKDOWN
NVR Issues3
Camera Issues0
UPS / Power Issues1
Moxa Switch Issues1
Router Issues0
TS Module Issues0
ISSUE TYPE BREAKDOWN
Video Not Offloading0
NVR Offline1
Camera Offline/Inop0
Power/UPS Issue1
Config Error2
Video Request0
NTF0

UPS Install Tracker

MBTA MVSS — UPS Fleet Installation Tracker
Vehicle #GarageFleet TypeSN Ticket #Install DateInstalled ByUPS Part / Serial #Prior Failure Hx?Install MethodVerified Functional?Notes
1272SouthamptonBus500167105/13/2026Tech: SB25470011Yes - 3.4 power hitsRoutine VisitYes
1401FellswayBus05/18/2026Tech: SBN/AYes - install team flaggedDedicated VisitYes
1409FellswayBus05/20/2026Tech: SB25470008Yes - camera 3 issue concurrentDedicated VisitYes
Units Installed This Month:3
Cumulative Units Installed (all months):Enter manually each month
Target Remaining:Enter cumulative count in D206

Instructions

Instructions
GENERAL
PurposeThis workbook is the official monthly work log for the MBTA MVSS Maintenance Contract. All entries must reconcile to a ServiceNow ticket prior to invoicing.
Sheet: Work LogEnter one row per ServiceNow ticket / service event. Do not merge rows for multi-day or multi-visit events; create a new row per visit.
Sheet: Monthly SummaryAuto-calculates from the Work Log. Review before each monthly report submission. No manual entry required.
Sheet: UPS Install TrackerTrack all MBTA-furnished UPS installations here. One row per vehicle. Update cumulative count manually each month.
FIELD GUIDANCE — KEY COLUMNS
SN Ticket #Enter the ServiceNow incident number. Must be populated before invoicing. Contractor creates the ticket if MBTA has not yet done so.
StatusUse 'NTF-Pending MBTA Confirmation' when you believe a ticket is NTF — do NOT set to Closed until MBTA confirms in writing.
Hardware ImpactedSelect the primary hardware item from the dropdown. If multiple, select 'Multiple Components' and detail in Parts Used / Notes.
Issue TypeSelect the closest category. 'Video Request' = MBTA requested specific footage. 'NTF' = no fault found after full diagnostic.
Triage / Field Svc / Engineer HrsEnter hours per role. Total auto-calculates in column N. These hours feed the monthly invoice.
Parts UsedEnter part name and serial/part number. Format: [Part Name] [S/N or P/N]. If no parts used, leave blank.
MBTA Eng ReviewHas the MBTA engineering contact reviewed and acknowledged this ticket? Yes/No/N/A.
DispositionSelect from dropdown. 'NTF - MBTA Confirmed' requires written MBTA confirmation first.
NTF - MBTA Confirmed?MUST be 'Yes' before disposition can be set to NTF. Red cell = not yet confirmed. Do not close these tickets.
NTF POLICY
NTF RulePer contract specification: The Contractor shall NOT close any ticket as NTF without prior written MBTA confirmation. Document all diagnostic steps. Set Status to 'NTF-Pending MBTA Confirmation' and notify the MBTA representative. MBTA has 1 business day to confirm or reject.
RED/ORANGE LINE
Force Account RequirementAll work at Red Line (Cabot Carhouse, Codman, Cadigan) and Orange Line (Wellington, Forest Hills) facilities requires MBTA personnel present. Do not commence work without MBTA confirmation. Log any MBTA-caused delays in Notes .
UPS INSTALL PROGRAM
UPS RuleMBTA will supply ~200 UPS units staged at Bridgewater. Contractor retrieves per install schedule and logs each installation on the UPS Install Tracker tab. Target: 5–10 units/month. Each install requires a discrete ServiceNow ticket and is invoiced as a separate line item.

File details come from the government source that posted it. Updated .