B08 - Exhibit E - MMD-01 Maintenance Report Format.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- EAGLE Fort Huachuca, AZ W519TC-24-R-0027
- Solicitation number
- W519TC24R0027
About this file
This is a Contract Data Requirements List (CDRL) template titled "MMD-01 Maintenance Report Format" that outlines reporting requirements for maintenance activities. The template specifies seven different reports that must be submitted, including Work Schedule, Direct Labor Personnel, Indirect Labor Personnel, Maintenance Administrative-Audit Readiness, Closed Maintenance Request Report, Open Maintenance Request Status Report, and Service Schedule Customer Notification. Each report has defined submission frequencies (weekly or monthly) and specified recipients (COR/SPO/DMC).
The file includes detailed worksheets for tracking work schedules and personnel data, with specific formatting for calculating scheduled work hours and recording direct/indirect labor information. The personnel tracking includes fields for location, UIC, maintenance work centers, position descriptions, and GCSS-Army Personnel Numbers. This template appears to be part of a larger maintenance services contract at Fort Huachuca, supporting contract W519TC-24-R-0027 for maintenance, supply, and transportation services.
View the file
Other files
Show all 45
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
CDRLs
| MMD-01 Maintenance Report FORMAT | |||||
| The Contractor shall provide all CDRLs in electronic format unless otherwise directed by the Government. | |||||
| Number | Report Title | Format | Frequency | Date Due | Recipients |
| 1 | Work Schedule | Gov't Format Provided | Monthly | 5th Workday | COR/SPO/DMC |
| 2 | Direct Labor Personnel | Gov't Format Provided | Monthly | 5th Workday | COR/SPO/DMC |
| 3 | Indirect Labor Personnel | Gov't Format Provided | Monthly | 5th Workday | COR/SPO/DMC |
| 4 | Maintenance Administrative - Audit Readiness | Contractor Format Acceptable | Monthly | 5th Workday | COR/DMC |
| 5 | Closed Maintenance Request Report | Contractor Format Acceptable | Weekly | 2nd Workday | COR/DMC |
| 6 | Open Maintenance Request - Status Report | Contractor Format Acceptable | Weekly | 2nd Workday | COR/DMC |
| 7 | Service Schedule (60 Day) - Customer Notification | Contractor Format Acceptable | Monthly | 5th Workday | COR/DMC |
Work Schedule
| Work Schedule | |||||||||
| DO NOT INPUT OVERTIME | Input data into cells that are yellow | ||||||||
| Beginning Date | Ending Date | Holidays | Num of days (Monday) | Num of days (Tuesday) | Num of days (Wednesday) | Num of days (Thursday) | Num of days (Friday) | Num of days (Saturday) | Num of days (Sunday) |
| 1/1/18 | 1/31/18 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | |
| Work Schedule (hrs per day) | 8 | ||||||||
| Sub Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Total Scheduled hrs 0
How to use tool to find personnel Scheduled hours:
1) Input beginning date and ending date (Cells A5 and B5)
2) Input the number of holidays in the month and hours worked (per day)(Cell C5 and C6)
3) Input hours scheduled to be worked Monday through Sunday (Cells D6, E6, F6, G6, H6, H6, I6, and J6)
4) Hours will automatically calculate into Total scheduled hrs (highlighted in Green, cell C11)
5) Data in cell C11 will auto populate in the Personnel data tab (column G).
*Note: DO NOT INPUT OVERTIME HOURS (OT will automatically be added in personnel tab column I)
Explanation of formula:
-The formula counts the number of days from the dates inputted. For instance, there are 5 mondays in the month of January (1/1/18-1/31/2018). Then is multiples the number of mondays in a month by the hours worked on mondays (5 mondays * 8hrs per monday = 40 hrs for mondays in the month of Jan 18.) The spread sheet will then automatically added up all the time worked subtracted by the holidays to give a total scheduled hrs worked.
Direct Labor Personnel
| Direct Labor Personnel | |||||||||||
| Location | UIC | Maintenance Work Center | Operational Work Center Assigned | Operational Work Center description | Position Description | CTR/DAC | Name | GCSS-Army | |||
| Personnel Number | Scheduled Hrs per month | CLIN | Reason scheduled time is less than other Personnel | ||||||||
| Fort XXXX | W6YKAA | 6YKA0BI5 | 6YKA0BI5ALL | Allied Trades | Painter | CTR | Fake, John | 670012 | 0 | ||
| Fort XXXX | W6YKAA | 6YKA0BI5 | 6YKA0BI5AU1 | Automotive 1 | Mechanic | CTR | Fake Jane | 679787 | 0 | ||
| Fort XXXX | W6YKAA | 6YKA0BI1 | 6YKA0BI5SAR | Armament | Small Arm Repair | CTR | not real, Doug | 674875 | 0 | Started on 2 Jan 18 | |
| Fort XXXX | W6YKAA | 6YKA0BI1 | 6YKA0BI5AC&E | Commo | Electrionic mechanic | CTR | not real, Susan | 612780 | 0 | ||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 | |||||||||||
| 0 |
Indirect Labor Personnel
| Indirect Labor Personnel | |||||||||
| Location | UIC | Maintenance Work Center | Operational Work Center Assigned | Operational Work Center description | Position Description | Direct Laborer or Indirect Laborer | Name | GCSS-Army | |
| Personnel Number | CLIN | ||||||||
| Fort XXXX | W6YKAA | 6YKA0BI1 | N/A | N/A | Clerk | IDL | Cool, Dude | 612890 |
File details come from the government source that posted it. Updated .