B08 Exhibit E - MMD-01 Maintenance Report Format.xlsx

XLSX spreadsheet 21 KB Posted Oct 3, 2023

Attached to: EAGLE REDSTONE ARSENAL, AL W519TC-23-R-0094
Solicitation number: W519TC-23-R-0094
Issued by: Department of the Army Materiel Command Contracting Command Rock Island Arsenal

About this file

Written by GovTribe AI · Dec 21, 2023

This document provides a maintenance report format template for a federal contract opportunity. The template includes three Excel spreadsheets for contractors to report monthly maintenance work schedules, direct labor personnel, and indirect labor personnel to the Contracting Officer Representative, Alternate Contracting Officer Representative, Division Chief, and Supply Program Officer/Directorate of Maintenance and Contracting. The work schedule spreadsheet template requires contractors to input beginning and end dates for the reporting period, holidays, and scheduled daily work hours. It then automatically calculates total scheduled hours for the month. The direct and indirect labor personnel spreadsheets template require contractors to report personnel names, locations, work centers, positions, and scheduled hours. Contractors must submit the completed maintenance reports in Excel format by the 5th workday of each month to the listed government recipients.

View the file

Other files

File	Type	Posted
W519TC23R0094 Conformed thru Amendment 0002.pdf	PDF	Oct 31, 2023
W519TC23R0094-0002.pdf	PDF	Oct 31, 2023
B08 Attachment 0032 - Redstone Arsenal QA Responses.xlsx	XLSX spreadsheet	Oct 25, 2023
B08 Attachment 0004 - Letter of Consent (19 Oct 23).pdf	PDF	Oct 25, 2023
W519TC23R0094-0001.pdf	PDF	Oct 25, 2023
W519TC23R0094 Conformed thru Amendment 0001.pdf	PDF	Oct 25, 2023
B08 Exhibit B - CDRL Listing 19 Oct 23.xlsx	XLSX spreadsheet	Oct 25, 2023
B08 Attachment 0007 - SCA WD 2015-4603 Rev 24 (04 Aug 2023).pdf	PDF	Oct 25, 2023
B08 Attachment 0001 - PWS (27 Jul 23).pdf	PDF	Oct 25, 2023
B08 Attachment 0027 - PWS Annex C Transportation PRS.pdf	PDF	Oct 3, 2023
B08 Attachment 0029 - PWS Annex E Definitions Acronyms Abbreviations.pdf	PDF	Oct 3, 2023
B08 Attachment 0001 - PWS (27 Jul 23).pdf	PDF	Oct 3, 2023
B08 Attachment 0025 - PWS Annex A Maintenance PRS.pdf	PDF	Oct 3, 2023
B08 Attachment 0002 - Staffing and Labor Mix (27 Jul 23).xlsx	XLSX spreadsheet	Oct 3, 2023
B08 Attachment 0005 - Cost Price Matrix (14 Sep 23).xlsx	XLSX spreadsheet	Oct 3, 2023
B08 Exhibit B - CDRL Listing.xlsx	XLSX spreadsheet	Oct 3, 2023
B08 Exhibit K - SS-01 Supply and Services Report Format.xlsx	XLSX spreadsheet	Oct 3, 2023
B08 Attachment 0011 - Contract References Spreadsheet (14 Sep 23).xlsx	XLSX spreadsheet	Oct 3, 2023
B08 Attachment 0007 - SCA WD 2015-4603 Rev 23 (27 Dec 2022).pdf	PDF	Oct 3, 2023
B08 Attachment 0009 - Purchasing Invoicing Guide (9 Feb 23).pdf	PDF	Oct 3, 2023
B08 Attachment 0026 - PWS Annex B Supply PRS.pdf	PDF	Oct 3, 2023
B08 Attachment 0013 - Mission Essential Services (7 Jun 23).pdf	PDF	Oct 3, 2023
B08 Attachment 0010 - Blocked File Extensions (21 Jan 16).pdf	PDF	Oct 3, 2023
B08 Attachment 0015 - Subcontractor Cost Information Submission (18 Jul 23).pdf	PDF	Oct 3, 2023
B08 Exhibit F - PM-01 Contractor Employee Information Format.xlsx	XLSX spreadsheet	Oct 3, 2023
B08 Exhibit A - DD 1423-1 (27 Jul 23).pdf	PDF	Oct 3, 2023
B08 Exhibit C - CD-02 Burn Rate Report Format v10.xlsx	XLSX spreadsheet	Oct 3, 2023
B08 Exhibit H - PM-09 Performance Management Review Format (5-01-23).pptx	PPTX presentation	Oct 3, 2023
B08 Attachment 0028 - PWS Annex D Environmental Requirements.pdf	PDF	Oct 3, 2023
B08 Attachment 0004 - Letter of Consent (14 Sep 23).pdf	PDF	Oct 3, 2023
B08 Attachment 0006 - Preaward Survey of Prospective Contractor Accounting System (SF 1408).pdf	PDF	Oct 3, 2023
B08 Attachment 0030 - PWS Annex F Publications and Forms.pdf	PDF	Oct 3, 2023
B08 Attachment 0003 - Performance Questionnaire (29 Jan 21).pdf	PDF	Oct 3, 2023
B08 Attachment 0031 - PWS Annex G Government Property Incidental.xlsx	XLSX spreadsheet	Oct 3, 2023
B08 Exhibit J - PM-12 KTR Accident Reporting Format.xlsx	XLSX spreadsheet	Oct 3, 2023
B08 Solicitation - RAAL.pdf	PDF	Oct 3, 2023
B08 Exhibit G - PM-08 Scheduled Government Furnished Property (SGFP).xlsx	XLSX spreadsheet	Oct 3, 2023
B08 Exhibit D - ITD-01 Transportation Report Format.xlsx	XLSX spreadsheet	Oct 3, 2023

Show all 38

On GovTribe

Work with this file

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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	Microsoft Exce1	Monthly	5th Workday	COR/ACOR/Div Chief SPO/DMC
2	Direct Labor Personnel	Microsoft Exce1	Monthly	5th Workday	COR/ACOR/Div Chief SPO/DMC
3	Indirect Labor Personnel	Microsoft Exce1	Monthly	5th Workday	COR/ACOR/Div Chief SPO/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	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 Fort XXXX W6YKAA 6YKA0BI1 N/A N/A Clerk IDL Cool, Dude 612890

File details come from the government source that posted it. Updated Oct 3, 2023.