MPSSF Estimate of Hours.xlsx

XLSX spreadsheet 69 KB Posted Dec 10, 2010

Attached to: Professional, Administrative and Management Support Services Federal contract opportunity
Solicitation number: FA8217-10-R-5022
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Hill Air Force Base

View the file

Other files for this federal contract opportunity

Other files attached to Professional, Administrative and Management Support Services, newest first.
File	Type	Posted
Response to Questions	—	Feb 25, 2011
Response to Questions	—	Dec 10, 2010
Performance Work Statement	—	Dec 10, 2010
Section L Attachments	—	Dec 10, 2010
Pricing Table	—	Dec 10, 2010
FA8217-10-R-5022 0002.pdf	PDF	Dec 10, 2010
Contract Data Requirements List	—	Dec 10, 2010
FA8217-10-R-5022 0001.pdf	PDF	Dec 2, 2010
Response to Questions	—	Nov 24, 2010
Response to Questions	—	Nov 17, 2010
Contract Data Requirements List.pdf	PDF	Nov 5, 2010
Section L Attachments.docx	DOCX document	Nov 5, 2010
Contract Security Classification Specification.pdf	PDF	Nov 5, 2010
FA8217-10-R-5022.pdf	PDF	Nov 5, 2010
Government Furnished Property.pdf	PDF	Nov 5, 2010
Performance Work Statement.pdf	PDF	Nov 5, 2010
Appendix C.pdf	PDF	Nov 5, 2010
Pricing Table.xlsx	XLSX spreadsheet	Nov 5, 2010
Staffing Table.xlsx	XLSX spreadsheet	Nov 5, 2010

Show all 19

On GovTribe

Work with this file on GovTribe

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.

OPS_SMEs and Rovers

Task	Responsible party	Time to accomp-lish	# per year	Total time per year	Estimation Methodology	Comment
SME
CM Validations	SME	8	20	160	20 MPEs X 1 day per validation
Fielding	SME	800	20	16000	20 MPEs X 800 hours/MPE *Very Rough Estimate*
Test Support	SME	80	20	1600	Typically a two-week effort
Help Desk Support/Response	SME	1	1000	1000	1000 calls/year * 1 hour average effort
In-House Testing	SME	24	16	384	Based on 6 hardware test support plus 10 fielding MPE hardware tests
Site Visits	SME	40	20	800	Estimated at an average of 1 per MPE per year X 20 MPEs
Tech Pubs Validation	SME	16	25	400	Based on 25 new tech pubs/ year and 2 days per validation
TCNO Testing	SME	2	240	480	Based on 20 MPEs tested monthly
Post Implementation Review	SME	24	20	480	20 MPEs fielded/year X 3 days per PIR	Includes survey development, approval, distribution and processing
Help Desk Analysis and Reporting	SME	45	12	540	40 hours per month post-call analysis plus 5 hours reporting
			SME Total:	21844

Rovers
Test Support	Rover	80	8	640
SSR Augmentation	Rover	80	24	1920
Fielding Support	Rover	90	30	2700
In-House Testing	Rover	8	10	80
			Rover Total:	5340

Tech Pubs Task Responsible party Time to accomp-lish # per year Total time per year Estimation Methodology Comment

Develop Technical Orders (TOs)	Writers	360	15	5400	Historical (hours), forecast number of TOs
Develop Time Compliance Technical Orders (TCTOs)	Writers	220	10	2200	Historical (hours), forecast number of TCTOs

Total: 7600

Task Responsible party Time to accomp-lish # per year Total time per year Estimation Methodology Comment

Packaged Processed (DT/OT/Fielding/Miscellaneous)	CM Techs	6.5	600	3900	Packages sent - includes duplication, labeling, packaging, deliver for shipment - 6.5 hours per package (5 disks) 600 packages per year
Package Support - MPE Validation, Telecons, Meetings, SME Support	CM Techs	6.5	600	3900	Package Support - MPE Letter Review - Telecons or other meetings - SME Support
Help Desk / Miscellaneous Mission Planning Support	CM Techs	4	45	180	Package Support - MPE Letter Review - Telecons or other meetings - SME Support

Total: 7980

Hardware Task Responsible party Time to accomp-lish # per year Total time per year Estimation Methodology Comment

Hardware Acquisition support
Keep abreast of user requirements and identify new computer and peripheral technologies that can improve the Mission Planning computer systems to meet those requirements.	Hardware	20	12	240	One topic per month, 40 hours per topic
Attend requirements meetings to discuss new hardware requirements and schedules.	Hardware	40	4	160	Quaterly meetings
Provide Request for Proposal (RFP) support.	Hardware	16	6	96	Once per new item
Plan hardware fly off.	Hardware	40	6	240	Once per new item
Conduct hardware fly off.	Hardware	100	6	600	Once per new item
Conduct First Article Inspection.	Hardware	8	6	48	Once per new item
Create Operating System (OS) Restore Disk for each new Mission Planning Computer.	Hardware	40	4	160	Once per new computer
Conduct Final Acceptance Inspections.	Hardware	80	6	480	Once per new item
Provide technical expertise to the Technical Publications team for the creation of all Technical Orders and Time Compliant Technical Orders related to the new hardware.	Hardware	120	6	720	Once per new item
			Hardware Acquisition Total:	2744

Hardware Sustainment support
Provide Tier 2 hardware and OS technical support to the users in the field.	Hardware	1	750	750	Interview/Historical data
Initiate Warranty Request action on non-operational Mission Planning equipment.	Hardware	0.5	500	250	Interview/Historical data
Periodically conduct inspection of Mission Planning equipment stored in government warehouses to ensure that the equipment is stored IAW the RFP.	Hardware	2	12	24	Once per month
Conduct failure trend analysis to detect trends in equipment failures.	Hardware	20	6	120	Interview/Historical data
Provide support to the fielding effort for new hardware.	Hardware	520	1	520	Interview/Historical data
Define and install mission planning systems hardware / software modification kits.	Hardware	40	8	320	Interview/Historical data
Refurbish mission planning systems and provide depot support / repair	Hardware	40	5	200	Interview/Historical data
Provide turn-in instructions to users when equipment has reached its end-of-life.	Hardware	2	10	20	Interview/Historical data
Provide support to the Mission Planning Users Conference	Hardware	40	1	40	Interview/Historical data
			Total:	2244

Hardware Total: 4988

MPC

Task Responsible party Time to accomplish (hrs) # per week # per year Total time per year Performed Estimation Methodology Comment

Develop and release new SharePoint training manuals	MPC Trainer	60.0		3	180.0	Yes	Average 60 pages per manual/ 1 hour per page includes research, writing and verification, based on previous manual development.	Guides yet to be developed: SharePoint Designer, Advanced Design, Advanced Workflow
Maintain existing SharePoint Training manuals	MPC Trainer	4.0		40	160.0	Yes	300 current manual pages @ 8 pages per week @ .5 hours per page, based on previous manual maintenance.	Add to and improve existing manuals. Topics to be maintained: Document Management, Security, InfoPath, Excel Services, PowerPoint Libraries, Site Design
Maintain existing EDR and MPC custom application training manuals	MPC Trainer	4.0		24	96.0	Yes	280 current manual pages
Develop and release new training manuals for MPC custom applications	MPC Trainer	24.0		5	120.0	Yes	5 custom application upgrades or new products per year @ average of 24 pages per training guide @ 1 hour per page, based on average of previous application releases.
Develop CBT modules for SharePoint	MPC Trainer	16.0		24	384.0	Yes	24 high use SharePoint topics @ 16 hours per module for research, development and verification, based on time to develop prototypes.
Develop CBT modules for EDR and MPC custom applications	MPC Trainer	16.0		16	256.0	Yes	16 high use EDR topics @ 16 hours per module, based on time to develop prototypes.
Deliver classroom training for SharePoint	MPC Trainer	16.0		4	64.0	Yes	4 two day events @ 16 hours ea
Deliver online training for SharePoint	MPC Trainer	2.0		48	96.0	Yes	48 online training events @ 2 hours ea
Deliver online training for MPC custom applications	MPC Trainer	2.0		48	96.0	Yes	48 online training events @ 2 hours ea
Deliver classroom training for EDR	MPC Trainer	12.0		2	24.0	Yes	2 1.5 day events @ 12 hours ea
Pre and post class online training preparation and wrap up.	MPC Trainer	2.0	2.00	96	192.0	Yes	96 total events @ 1 hour prep and 1 hour post ea
Manage training projects	MPC Trainer	4.0	1.00	48	192.0	Yes	4 hours per week @ 48 weeks, based on three previous training projects	Monitoring schedule, plans, risks, and testing, developing reports, communicating with stakeholders
Travel associated with training events	MPC Trainer	16.0		2	32.0	Yes	One day depart and one day return for two events.
Back up help desk support	MPC Trainer	2.0	1.00	48	96.0	Yes	2 hours per week @ 48 weeks, based on last years average weekly support	Receiving calls, resolving help desk requests
MPUC Preparation and Attendance	MPC Trainer	160.0		1	160.0	Yes	Based on average of three previous MPUC events	customize training guides for MPUC breakout sessions, manage project, coordinate and develop booth material
Test MPC Systems	MPC Helpdesk	1.0	5.00	260	260.0	Yes	Run through various 'tasks' that test mulitple tools on MPC. Receive alerts and then write summary of test in description.
Provide MPC Helpdesk Support	MPC Helpdesk	3.5	5.00	260	910.0	Yes	Support to MPC customers provided through phone, email, and helpticket submiting. Research for problem solution and correspondance with user. Including follow up and ticket closure.
Maintain existing MPC Helpdesk site	MPC Helpdesk	0.5	3.00	156	78.0	Yes	Make sure all submited tickets are either resolved and closed or assigned to appropriate team member. Monitor customer submited tickets. Make sure assigned tickets are closed in timely manner.
Develop and release new Knowledge Base wiki articles	MPC Helpdesk	1.5	1.50	78	117.0	Yes	Write 'How To' articles and add to the MPC Knowledge Base.
Maintain existing Knowledge Base articles	MPC Helpdesk	0.5	0.50	26	13.0	Yes	Scan Knowledge base articles to ensure they are current and correct. Add new knowledge base articles when nessicary or when new tool has been pushed to live version of MPC.
Approve or deny request for Mission Planner Access	MPC Helpdesk	1.5	5.00	260	390.0	Yes	View Access Request, verify and approve all military and government users. Contact contractor sponsors for verification and approve. Deny request where authorization has not been given. Correspondance with users and sponsors.
Order and Purchase MPC office materials	MPC Helpdesk	3.0		4	12.0	Yes	Create and submit purchase requests for all supplies. Order supplies once PR is approved. Count all supplies to verify aquaracy of order and finish paperwork send to corporate.
Order and purchase all MPC Library books	MPC Helpdesk	2.0		4	8.0	Yes	Create and submit purchase requests for all books. Order once PR is approved. Count all books after arrival to verify aquaracy of order and finish paperwork send to corporate.
Gather MPC weekly activity reports and assist creating MAR	MPC Helpdesk	0.5	1.00	52	26.0	Yes	Gather WAR and add to spreadsheet. Send to Tom Jones. End of Week assist in producing a Monthly activity report.
EDR Working Group meeting	MPC Helpdesk	2.0	1.00	52	104.0	Yes	Attend and record meeting minutes for EDR WG. Write meeting minutes and submit.
Monthly and weekly reporting of Helpdesk/access request stats	MPC Helpdesk	1.0	1.00	52	52.0	Yes	Gather number of Helpdesk tickets submitted in week or month and number of access requests/MPC accounts.
Manage MPC Helpdesk project	MPC Helpdesk	1.0	3.00	156	156.0	Yes	Insure all MPC Project tasks, deliverables, and milestones are met according to schedule and ensure that the project site reflects they are met.
MPUC Preparation and Attendance	MPC Helpdesk	100.0		1	100.0	Yes	Create materials, guides, flyers etc. for MPUC event.
Software Versioning Accuracy	CM/Data Quality Manager	4.0	3.00	156	624.0	Yes	Work estimates derived from average MPE letters received.	Based on historical data.
Build Date Accuracy	CM/Data Quality Manager	1.0	3.00	156	156.0	Yes	Work estimates derived from average MPE letters received.	Based on historical data.
MPE Software completeness	CM/Data Quality Manager	1.0	3.00	156	156.0	Yes	Work estimates derived from average MPE letters received.	Based on historical data.
Classification Accuracy	CM/Data Quality Manager	0.5	3.00	156	78.0	Yes	Work estimates derived from average MPE letters received.	Based on historical data.
Lifecycle management	CM/Data Quality Manager	1.0	3.00	156	156.0	Yes	Work estimates derived from average MPE letters received.	Based on historical data.
Owning Organization Research	CM/Data Quality Manager	0.5	3.00	156	78.0	Yes	Work estimates derived from average MPE letters received.	Estimate-depends on complexity of task.
Sub-Assembly Creation	CM/Data Quality Manager	4.0	0.50	26	104.0	Yes	Work estimates derived from average MPE letters received.	Based on historical data.
Sub-Assembly Management	CM/Data Quality Manager	0.5	3.00	156	78.0	Yes	Work estimates derived from average MPE letters received.	Based on historical data.
Sub-Assembly Maintenance	CM/Data Quality Manager	1.0	1.00	52	52.0	Yes	Average of updating data on existing subessmblies.	Based on historical data.
Variants Nomenclature Accuracy	CM/Data Quality Manager	4.0	0.25	13	52.0	Yes	Work estimates derived from average new component variant requests received.	Based on historical data.
Variants Classification Accuracy	CM/Data Quality Manager	0.5	0.25	13	6.5	Yes	Work estimates derived from average new component variant requests received.	Based on historical data.
Variants Branching Maintenance	CM/Data Quality Manager	0.5	0.25	13	6.5	Yes	Work estimates derived from average new component variant requests received.	Based on historical data.
Variant Version Software Versioning Accuracy	CM/Data Quality Manager	1.0	5.00	260	260.0	Yes	Work estimates derived from average new component variant versions received.	Based on historical data.
Variant Version Build Date Accuracy	CM/Data Quality Manager	1.0	5.00	260	260.0	Yes	Work estimates derived from average new component variant versions received.	Based on historical data.
Variant Version Lifecycle management	CM/Data Quality Manager	1.0	5.00	260	260.0	Yes	Work estimates derived from average new component variant versions received.	Based on historical data.
Variant Version Supersedes Management	CM/Data Quality Manager	0.5	5.00	260	130.0	Yes	Work estimates derived from average new component variant versions received.	Based on historical data.
Variant Version Archive management	CM/Data Quality Manager	1.0	5.00	260	260.0	Yes	Work estimates derived from average new component variant versions received.	Based on historical data.
Variant Version Owning Organization Research	CM/Data Quality Manager	0.5	5.00	260	130.0	Yes	Work estimates derived from average new component variant versions received.	Based on historical data.
Patch Software Versioning Accuracy	CM/Data Quality Manager	1.0	3.00	156	156.0	Yes	Work estimates derived from average new patch requests received.	Based on historical data.
Patch Build Date Accuracy	CM/Data Quality Manager	1.0	3.00	156	156.0	Yes	Work estimates derived from average new patch requests received.	Based on historical data.
Patch Association management	CM/Data Quality Manager	1.5	3.00	156	234.0	Yes	Work estimates derived from average new patch requests received.	Based on historical data.
Patch Archive management	CM/Data Quality Manager	0.5	3.00	156	78.0	Yes	Work estimates derived from average new patch requests received.	Based on historical data.
Product Line Issues Research stakeholder	CM/Data Quality Manager	4.0	0.50	26	104.0	Yes	Work estimates derived from average times that MPEs and components have needed to be escalated to the PMs or government.	Estimate-depends on complexity of task.
Product Line Issues Email communication	CM/Data Quality Manager	2.0	0.50	26	52.0	Yes	Work estimates derived from average times that MPEs and components have needed to be escalated to the PMs or government.	Estimate-depends on complexity of task.
Product Line Issues Telephone communication	CM/Data Quality Manager	1.0	0.50	26	26.0	Yes	Work estimates derived from average times that MPEs and components have needed to be escalated to the PMs or government.	Estimate-depends on complexity of task.
Product Line Issues Conduct Meetings	CM/Data Quality Manager	2.0	0.50	26	52.0	Yes	Work estimates derived from average times that MPEs and components have needed to be escalated to the PMs or government.	Estimate-depends on complexity of task.
Product Line Support Phone Call help desk suport	CM/Data Quality Manager	0.5	3.00	156	78.0	Yes	Work estimate calculated from previous year.	Estimate-depends on complexity of task.
Product Line Support Email help desk support	CM/Data Quality Manager	0.5	12.00	624	312.0	Yes	Work estimate calculated from previous year.	Estimate-depends on complexity of task.
Product Line Support Conduct Meetings	CM/Data Quality Manager	2.0	0.50	26	52.0	Yes	Work estimate calculated from previous year.	Estimate-depends on complexity of task.
Product Line Support Process Management Meetings	CM/Data Quality Manager	2.0	0.50	26	52.0	Yes	Work estimate calculated from previous year.	Estimate-depends on complexity of task.
MPE Site loading for Navy	CM/Data Quality Manager	1.5	0.25	13	19.5	Yes	Work estimates derived from average MPE letters received.	Based on historical data.
MPE Site loading for SOF	CM/Data Quality Manager	1.5	0.25	13	19.5	Yes	Work estimates derived from average MPE letters received.	Based on historical data.
Product Line Tool Developer Group Participation	CM/Data Quality Manager	1.0	2.00	104	104.0	Yes	Work estimate calculated from previous year.	Estimate-depends on complexity of task.
Product Line Tool Requirements documentation	CM/Data Quality Manager	1.0	1.00	52	52.0	Yes	Work estimate calculated from previous year.	Estimate-depends on complexity of task.
Product Line Tool Tool Design / Testing	CM/Data Quality Manager	1.0	1.00	52	52.0	Yes	Work estimate calculated from previous year.	Estimate-depends on complexity of task.
Product Line Tool Planning Area Support	CM/Data Quality Manager	1.0	1.00	52	52.0	Yes	Work estimate calculated from previous year.	Estimate-depends on complexity of task.
MPE Letter Generator Tool Developer Group Participation	CM/Data Quality Manager	1.0	1.00	52	52.0	Yes	Work estimate calculated from previous tool design.	Estimate-depends on complexity of task.
MPE Letter Generator Tool Requirements documentation	CM/Data Quality Manager	0.5	1.00	52	26.0	Yes	Work estimate calculated from previous tool design.	Estimate-depends on complexity of task.
MPE Letter Generator Tool Tool Design / Testing	CM/Data Quality Manager	0.5	1.00	52	26.0	Yes	Work estimate calculated from previous tool design.	Estimate-depends on complexity of task.
MPE Letter Generator Tool End User Training / Support	CM/Data Quality Manager	0.5	1.00	52	26.0	Yes	Work estimate calculated from previous tool design.	Estimate-depends on complexity of task.
Develop and release new MPC Documentation	MPC Technical Writer	3.0	5.00	260	780.0	Yes	Work estimate calculated from previous tool design.
Administer MPC CRB weekly meeting	MPC Technical Writer	1.0	1.00	52	52.0	Yes	Work estimate calculated from previous tool design.
Administer MPC IPT meeting	MPC Technical Writer	2.0	0.50	26	52.0	Yes	Work estimate calculated from previous tool design.
CM Database Management	MPC Technical Writer	0.5	5.00	260	130.0	Yes	Work estimate calculated from previous tool design.	Create meeting sites, communicate with IPT members
Deliverables / Task Management	MPC Technical Writer	0.5	5.00	260	130.0	Yes	Work estimate calculated from previous tool design.	Develop breakout training material, teach breakout classes, man MPC booth
Develop and release new MPC-S Documentation	MPC Technical Writer	4.0	0.25	13	52.0	Yes	Work estimate calculated from previous tool design.
Incident Documentation	MPC Technical Writer	2.0	0.25	13	26.0	Yes	Work estimate calculated from previous tool design.	Conduct quarterly internal QA audits
Internal QA Auditor	MPC Technical Writer	2.0	1.50	78	156.0	Yes	Work estimate calculated from previous tool design.
Maintain existing MPC documentation	MPC Technical Writer	3.0	5.00	260	780.0	Yes	Work estimate calculated from previous tool design.
Maintain existing MPC-S documentation	MPC Technical Writer	3.5	0.25	13	45.5	Yes	Work estimate calculated from previous tool design.
MPUC Preparation and Attendance	MPC Technical Writer	100.0		1	100.0	Yes	Work estimate calculated from previous tool design.
Peer Reviews	MPC Technical Writer	2.0	2.00	104	208.0	Yes	Work estimate calculated from previous tool design.
Project Monitoring / Control	MPC Technical Writer	0.5	3.00	156	78.0	Yes	Work estimate calculated from previous tool design.
Requirements Gathering	MPC Technical Writer	1.5	1.50	78	117.0	Yes	Work estimate calculated from previous tool design.
Secuity / Infrastructure Testing Results Reports	MPC Technical Writer	8.0		4	32.0	Yes	Work estimate calculated from previous tool design.
Security / Access Maintenance	MPC Technical Writer	1.5	0.25	13	19.5	Yes	Work estimate calculated from previous tool design.
Team Meetings	MPC Technical Writer	1.0	1.00	52	52.0	Yes	Work estimate calculated from previous tool design.
Testing	MPC Technical Writer	0.5	3.00	156	78.0	Yes	Work estimate calculated from previous tool design.
Automation Tools	Systems Analyst	2.0	1.00	52	104.0	Yes	Work estimate calculated from previous year.
Building Access Control	Systems Analyst	1.0	0.25	13	13.0	Yes	Work estimate calculated from previous year.
Business Continuity Committee	Systems Analyst	1.0	3.00	156	156.0	Yes	Work estimate calculated from previous year.
CER Management	Systems Analyst	0.5	15.00	780	390.0	Yes	Work estimate calculated from previous year.
Country Manager / SSF Training MPC-I	Systems Analyst	2.5	0.25	13	32.5	Yes	Work estimate calculated from previous tool design.
Customer Meetings	Systems Analyst	1.0	3.00	156	156.0	Yes	Work estimate calculated from previous year.
Deliverable / Tasks	Systems Analyst	0.5	15.00	780	390.0	Yes	Work estimate calculated from previous year.
Develop Training	Systems Analyst	3.0		6	18.0	Yes	Work estimate calculated from previous year.
Develop Training MPC-I	Systems Analyst	4.0	0.25	13	52.0	Yes	Work estimate calculated from previous tool design.
Developing / Maintaining MPC-I	Systems Analyst	2.0	3.00	156	312.0	Yes	Work estimate calculated from previous tool design.
Developing / Maintaining MPC-S	Systems Analyst	4.0	0.50	26	104.0	Yes	Work estimate calculated from previous year.
Developing / Maintaining WEDGE	Systems Analyst	0.5	5.00	260	130.0	Yes	Work estimate calculated from previous year.
Developing / Maintaining WEDGE-S	Systems Analyst	0.5	5.00	260	130.0	Yes	Work estimate calculated from previous year.
Documentation / Network Diagrams	Systems Analyst	1.0	10.00	520	520.0	Yes	Work estimate calculated from previous year.
Email Maintenance / Support	Systems Analyst	0.5	5.00	260	130.0	Yes	Work estimate calculated from previous year.
Helpdesk Support Phone / Email	Systems Analyst	2.0	6.00	312	624.0	Yes	Work estimate calculated from previous year.
Local Systems Administration	Systems Analyst	1.0	1.50	78	78.0	Yes	Work estimate calculated from previous year.
Peer Reviews	Systems Analyst	1.0	3.00	156	156.0	Yes	Work estimate calculated from previous year.
Printer / Copier Maintence	Systems Analyst	0.5	5.00	260	130.0	Yes	Work estimate calculated from previous year.
Project Monitoring / Control	Systems Analyst	1.5	3.00	156	234.0	Yes	Work estimate calculated from previous year.
Purchasing Requests	Systems Analyst	2.0	0.75	39	78.0	Yes	Work estimate calculated from previous year.
Requirements Gathering	Systems Analyst	1.0	1.50	78	78.0	Yes	Work estimate calculated from previous year.
Researching Technology	Systems Analyst	1.0	15.00	780	780.0	Yes	Work estimate calculated from previous year.
Security Access / Training	Systems Analyst	1.5	0.75	39	58.5	Yes	Work estimate calculated from previous year.
Security Contingency Testing	Systems Analyst	36.0		2	72.0	Yes	Work estimate calculated from previous year.
Security Monitoring MPC-I	Systems Analyst	1.0	2.00	104	104.0	Yes	Work estimate calculated from previous tool design.
Software Integration	Systems Analyst	2.0	1.50	78	156.0	Yes	Work estimate calculated from previous year.
System Backups	Systems Analyst	1.0	5.00	260	260.0	Yes	Work estimate calculated from previous year.
System Data / Security Logging	Systems Analyst	1.0	5.00	260	260.0	Yes	Work estimate calculated from previous year.
Systems Security / Virus Scan	Systems Analyst	0.5	5.00	260	130.0	Yes	Work estimate calculated from previous year.
Systems Testing / Generator	Systems Analyst	12.0		4	48.0	Yes	Work estimate calculated from previous year.
Team Meetings	Systems Analyst	1.5	4.50	234	351.0	Yes	Work estimate calculated from previous year.
Update patches	Systems Analyst	2.0	5.00	260	520.0	Yes	Work estimate calculated from previous year.
Automation Tools MPC-I	Systems Analyst	2.0	1.00	52	104.0	Yes	Work estimate calculated from previous tool design.
MPUC Support	Systems Analyst	300.0		1	300.0	Yes	Work estimate calculated from previous year.
Hardware Integration	Systems Analyst	4.0	0.25	13	52.0	Yes	Work estimate calculated from previous year.
Change Request Handling	Software Engineer	2.5	5.00	260	650.0	Yes	Work estimate calculated from previous year.
Customer Meetings	Software Engineer	5.0	5.00	260	1,300.0	Yes	Work estimate calculated from previous year.
Deliverables / Project Task Development	Software Engineer	8.0	1.00	52	416.0	Yes	Work estimate calculated from previous year.
Develop Schedules	Software Engineer	7.0	0.50	26	182.0	Yes	Work estimate calculated from previous year.
Developer Meetings / Training	Software Engineer	8.0	2.50	130	1,040.0	Yes	Work estimate calculated from previous year.
Developing/ Maintaining Development / Staging	Software Engineer	30.0	0.25	13	390.0	Yes	Work estimate calculated from previous year.
Developing/ Maintaining MPC-S	Software Engineer	8.0	2.00	104	832.0	Yes	Work estimate calculated from previous tool design.
Documentation	Software Engineer	8.5	1.00	52	442.0	Yes	Work estimate calculated from previous year.
Help Desk Support Phone/Email	Software Engineer	28.0	1.00	52	1,456.0	Yes	Work estimate calculated from previous year.
Maintaining Security / Access	Software Engineer	20.0	0.25	13	260.0	Yes	Work estimate calculated from previous year.
MPUC Support	Software Engineer	500.0		1	500.0	Yes	Work estimate calculated from previous year.
Peer Reviews Documents and Code	Software Engineer	6.0	3.50	182	1,092.0	Yes	Work estimate calculated from previous year.
Project Monitoring and Control	Software Engineer	14.0	0.50	26	364.0	Yes	Work estimate calculated from previous year.
Requirements Gathering	Software Engineer	20.0	0.50	26	520.0	Yes	Work estimate calculated from previous year.
Researching new Technology	Software Engineer	12.0	0.25	13	156.0	Yes	Work estimate calculated from previous year.
Software Integration / Deployment MPC	Software Engineer	5.0	2.00	104	520.0	Yes	Work estimate calculated from previous year.
Software Testing	Software Engineer	10.5	2.00	104	1,092.0	Yes	Work estimate calculated from previous year.
Software Integration / Deployment MPC-S	Software Engineer	5.0	0.50	26	130.0	Yes	Work estimate calculated from previous tool design.
Software Engineering / Maintaining MPC	Software Engineer	20.0	5.00	260	5,200.0	Yes	Work estimate calculated from previous year.

Total 35,643.0

Task Responsible party Time to accomp-lish # per year Total time per year Estimation Methodology Comment

Administer the NT network for the existing MPSSF network.	IT	11	242	2662
Maintenance and backup of server file library.	IT	0.5	52	26	once per week
Maintain and track MPSSF support equipment inventory, to include software, hardware, and associated documentation.	IT	2	52	104	weekly
Maintain and track the warranties and maintenance agreements of the support resources.	IT	8	12	96
Ensure support resources are taken care of in case of a disaster. (Disaster Preparedness).	IT	1	4	4
Troubleshoot and track all MPSSF network support resources. Compile, analyze, consolidate and / or develop reports of potential deficiencies and determine corrective action and coordinate prioritized recommendations.	IT	2	350	700	4 times per week
Monitor MPSSF support resources and MPS for viruses and take corrective action, when necessary.	IT	0.5	356	178	daily
Maintain technology currency and make recommendations for network updates required.	IT	2	12	24	monthly
Implementation, maintenance, and configuration management of software and hardware installation / deinstallation scripts on MPSSF support resources.	IT	2	700	1400
Create / maintain network security accreditation in accordance with DoD / Air Force / Hill AFB requirements.	IT	1	50	50
Assist in tracking available databases for trends and make prioritized recommendations as required for their resolution.	IT	0.5	100	50
Maintain government requested metrics and assist in performing trend analysis and include in MPSSF support documentation as required.	IT	0.5	52	26
			Total:	5320

SST

Task Responsible party Time to accomp-lish # per year Total time per year Estimation Methodology Comment

Provide monthly TCNO set per MPE evaluation.	SST	9	480	4320
Maintenance of internal MPE-TCNO evaluation utilities.	SST	6.5	480	3120
Creation of MPE GPOs and related files.	SST	53	26	1378
Security Hardware Evaluations	SST	2	48	96
DIACAP package reviews	SST	8	20	160
MPS OU Support	SST	10	96	960
SSR Support	SST	1	840	840
SDC/FDCC	SST	34	66	2244

Total: 13118

FMS

Task	Responsible party	Time to accomp-lish	# per year	Total time per year	Performed	Estimation Methodology	Comment
Training and SME support
Work closely with the country managers, SSRs and other System Matter Experts to keep the systems in the field in compliance with the approved hardware and software baseline(s).	SME	8	20	160	Yes (at fielding)	One day (8 hours) per fielding/delivery event
Perform final system checkout of the MPE prior to fielding/delivery. Checkout will consist of building the MPE—use the applicable install instructions and load the entire software package on the specified hardware, connecting all peripherals and ensuring the MPE works as expected. Any problems/discrepancies will be brought to the attention of the country manager and MPSSF leadership to identify workarounds or required fixes.	SME	8	20	160	Yes	One day (8 hours) per fielding/delivery event
Monitor changes to each FMS Mission Planning Environment (MPE) and as required, work with country managers (if requested) to implement changes.	SME	0	0	0	Yes		Rarely occurs, would be picked up during operations meeting attendance
Support the FMS Help Desk by taking and responding to problems/inquiries from FMS clients. Record all inquiries and responses in the Help Desk Tool to archive data for trend analysis and metric reporting.	SME	2	100	200	Yes	Based on estimate of approx imately 2 calls/week and an average of 2 hours effort for each response
Through self-study and cross-talk with respective USAF SMEs, develop and maintain expertise/currency in each of the various mission planning systems (PFPS, JMPS) and aircraft specific software programs (PFPS A/W/Es and JMPS UPCs).	SME	8	20	160	Yes		*New item in SOW* This will require more effort/time for new hires.
Where practical and when approved by the respective country manager, travel to a USAF installation for familiarization with new mission planning software/hardware components, and aircraft interfaces (data transfer procedures).						Time included in 1.2.1 e above
Develop training materials to support FMS work. To the maximum extent possible, training will be standardized and modular to support use among countries with similar MPEs. Training will be tailored to the requirements of each country, to include country specific exercises.	SME	240	20	4800	Yes	Based on 20 training events and 6 man-weeks per effort. Rough (and low) estimate based on expectation of extensive re-use of training materials. Initial efforts will be greater; subsequent ones less. (Note: Standards for training development are anywhere from 20-80 hours development time per hour of classroom instruction).	*Dedicated Training Specialist would do bulk of this** Will go down as core curriculum gets built
Provide in-country hardware setup, hardware training, and software training, to include system administration and operational use of the MPE.	SME	192	20	3840	Yes	Based on 2 travelers x 2 weeks (@40 hours) plus 16 hours each trip prep
Review and modify documentation (e.g., pocket guides, workbook material) to meet the specific FMS case requirements	SME	8	20	160	Yes	Based on 20 trips/events and 8 hours per event
Work with the government Foreign Disclosure Office (FDO) to get all training materials released prior to distribution.	SME	2	20	40	Yes	Based on 20 trips/events and 2 hours per event	*New item in SOW*
Validate and provide input changes to installation instructions for FMS MPEs	SME	4	20	80	Yes	Based on 20 trips/events and 4 hours effort each	*Combined two steps (validate, provide input) from previous SOW**
Provide estimates for travel, labor, and material costs, as requested	SME	2	20	40	Yes	Based on 20 trips and 2 hours total per trip
Participate and support all Integrated Product Team meetings/briefings as required/directed by the Government.	SME			600	Yes	Based on 3 one-hour meetings/week * 50 weeks * 4 SMEs	Includes MPUC, face to face, and local meetings
			Training and SME Total:	10240

Logistics
Accomplish travel as necessary to both CONUS and OCONUS locations to provide integrated hardware and logistical support to international customers	Logistics	40	4	160	Yes	Interview/Historical data
Ensure timely mission planning support to international customers	Logistics	0.3	1250	375	Yes	Interview/Historical data
Formulate and prepare maintenance plans, programs and schedules for assigned mission planning systems during the introduction of new or modified systems into the inventory. Determine the logistic (technical) requirements to support new or modified systems	Logistics	1	20	20	Yes	Interview/Historical data
Participate in engineering inspections, technical order / engineering data verifications, test / evaluation programs and maintainability demonstrations to assure that systems and equipment can effectively and economically maintained	Logistics	1	5	5	Yes	Interview/Historical data
Assure accuracy of technical data by participating in post publication reviews, recommend updates as necessary	Logistics	0.5	12	6	Yes	Interview/Historical data
Coordinate with applicable government mission planning POC to set hardware configuration with the correct software MPE before each test and fielding	Logistics	2	10	20	Yes	Interview/Historical data
Ensure that hardware requests from all international customers have been fully approved for release by the proper US Government authority	Logistics					Interview/Historical data	Included in #23
Inventory all purchased hardware ensuring the order is correct and complete	Logistics	1	10	10	Yes	Interview/Historical data
Arrange shipment and manage tracking of FMS hardware/software from the MPSSF to the designated freight forwarder, in-country POC or applicable test/development organization	Logistics	2	10	20	Yes	Interview/Historical data
Track and maintain warranty information on FMS hardware and assist with any warranty issues regarding purchased equipment. Once developed, warranty data will be migrated and maintained in the FMS Product Line database.	Logistics	0.5	5	2.5	Yes	Interview/Historical data
Provide Country Managers with assistance for MPE development, integration and customer specific requirements	Logistics						Included in #23
Document and distribute all FMS software patches to approved countries that purchased affected software	Logistics						covered by CM actions
Attend and participate in bi-weekly FMS Mission Planning meetings to include providing current status on hardware purchase dates, and shipment dates for hardware / software deliveries	Logistics	0.5	15	7.5	Yes
			Logistics Total:	626

Tech Pubs Support
Develop and modify T.O.s and supporting documentation for FMS mission planning systems per FMS requirements; ensure documentation meets FMS case specific requirements	Tech Writer	240	5	1200	Yes	Based on standard 240 hours for T.O. development
Review vendor provided documentation and take actions to correct discrepancies	Tech Writer			0	Yes		Included in line 34

Develop and publish FMS T.O. Project Plan that encompasses all mission planning systems	Tech Writer			0	Yes		Included in line 34; AFTO 00-5-19 covers this process
Participate and perform functions, if required, in the acquisition of T.O.s from the manufacturing contractor. These include Verification, Validation, Program Management Reviews (PMR), In-progress Reviews (IPR), and Critical Design Reviews (CDR	Tech Writer			0	No		We do not aquire TO's or TCTO's, they are developed on site
Develop TCTOs for software updates and hardware modification to FMS mission planning systems	Tech Writer	120	5	600	Yes	Based on standard 120 hours for TCTO development
Coordinate publications-related activities, including identification and correction of deficiencies, coordination with FMS country specific program office and contractor personnel, scheduling and performing kit proofing	Tech Writer			0	Yes		included in lines 34/38
Maintain configuration control of supported T.O.s to include modifications, baselines, updates, releases, lessons learned, and process documentation	Tech Writer			0	Yes		included in lines 34/38
			Tech Data Support Total:	1800

Configuration Management
Develop and maintain procedures, policies and practices to manage software configuration to include tracking, staffing, maintaining requirements and requirements databases.	Configuration Management	10	34	340	Interview/Historical data
Software Duplication and Distribution: Load hardware with software prior to shipping , duplication of software media, distribution of software media FMS countries and test organizations	Configuration Management	3	20	60	Interview/Historical data
Provide software duplication and distribution for Developmental Test / Operational Test / Operational Releases per the country managers signed MPE letter	Configuration Management	1	24	24	Interview/Historical data	Included in line 51
Work with Air Force Configuration Management to d. Work with Air Force Configuration Management to assign Computer Product Identification Numbers (CPINs) all FMS software releases, including beta releases.	Configuration Management	0.5	20	10	Interview/Historical data
Ensure compliance of Software distribution & CM processes	Configuration Management	1	150	150	Interview/Historical data
Coordinate all deliveries with country managers to verify receipt of test/CPINed software	Configuration Management					Included in line 16
Conduct hardware and software configuration checkout	Configuration Management	0.5	24	12	Interview/Historical data
			CM Total:	596

FMS Web Services Support
Provide administrative oversight for FMS web sites; ensure web sites are accessible to each country and that country only, are reliably available (minimize downtime), and are backed up and restorable.	Systems Analyst	12	50	600	Estimated @ about 12 hours/week in sustainment
Ensure compartmentalization and integrity of each country’s web site.	Systems Analyst	0	50	0	Included in #57
Develop and implement procedures for creating user accounts with country unique access.	Systems Analyst	4	50	200	Estimated @ about 4 hours per week
Develop an FMS specific database(s), to track FMS MPEs (hardware and software components) for each FMS case and facilitate cross-referencing and data queries to identify trends, problems, and fixes for the entire FMS community.	Systems Analyst	300	1	300	Estimate for initial effort
Modify and/or develop web-based applications to support unique data handling and reporting requirements.	Systems Analyst	120	5	600	Rough estimate--depends on complexity of tasking
Work with stakeholders to modify existing structure/reports and plan for future development.	Systems Analyst			300	Total time over year
			MPC-I Total:	2000

FMS MPUC Support
Provide planning support, expertise and conference execution activities as directed by the MPUC Program Manager as needed to support all MPUC and FMS activities	MPUC

FMS ADMIN Support
Prepare travel estimates, review travel vouchers and expense reports	FMS
Provide funding updates/ invoices / purchase order tracking for entire FMS effort	FMS
Track funds for specific countries, input contract mods, and maintain country specific funding balances	FMS
Track and report to the Government the amount of hours, per case, used for in-country training	FMS
Prepare and/or confirm security clearances and associated forms, as well as country entry paperwork	FMS
Provide any necessary coordination between Tybrin Corporate and SSF	FMS
Assist with logistical support	FMS

FMS Management Support
Coordinate with government POCs for tasking and direction related to FMS support	FMS
Provide direction and guidance for team members. Determine priorities in the event of conflicting tasks	FMS
Provides reports as requested by the government	FMS

Total: 15262

MPTT Development Task Responsible party Time to accomp-lish # per year Total time per year Estimation Methodology Comment

MPE Training Development-New Development	Trainers	1120	2	2240	Historical Experience	Includes development of training materials and support of development/ test events
MPE Training Development-Update	Trainers	800	6	4800	Historical Experience	Includes revision of training materials for MPE spiral release and support of development/ test events
Fielding Training	Trainers	50	59	2950	Historical Experience	1 week travel plus 10 hrs prep (avg) per event
Miscellaneous Training	Trainers	80	8	640	Historical Experience	Includes ESC/46TS/Other support--8 events for 1 week plus 1 week prep
Miscellaneous Trips	Trainers	40	8	320	Historical Experience	Includes PMRs and other meetings
			Total:	10950

MPTT Sustainment

Task	Responsible party	Time to accomp-lish	# per year	Total time per year	Estimation Methodology	Comment
Sustainment Trainers
Monthly PFPS classes @Hill	Trainers	40	12	480	32 hours of instruction + 8 hours prep per event
Provide PFPS training on the road	Trainers	60	12	720	Assumes one-week (40 hrs) per training trip plus 20 hours prep (tailoring)
PFPS Curriculum Devlopment	Trainers	960	2	1920	Assumes one-week (40 hrs) per training trip plus 20 hours prep (tailoring)
			Total Sustainment Trainers:	3120

Unix and Training Support
Conduct Solaris/Unix Classes	Sys Analyst	40	3	120
IT Support for Training Office/Classroom	Sys Analyst	10	52	520
			Total System Analyst:	640

Total: 7520

File details come from the government source that posted it. Updated Nov 14, 2017.