Marine Corps Food Information Systems Support

In support of Marine Corps Installations Command Food Service and Subsistence Section (MCICOM G-4), MCICOM intends to award Computrition Inc. modification P00009 under contract M95494-17-F-0011 which acquires additional consolidated reporting functionality in support of the Marine Corps Food Management Information System (MCFMIS). This requirement will be solicited sole source from Computrition Inc. which is the current provider of the SuitePoint! Point of Sale Terminal Register Software License, pursuant to 10 U.S.C. 2304(c)(1), only one responsible source and no other supplies or services will satisfy agency requirements. This will be a firm-fixed-price type Order issued off of GSA Schedule GS-35F-0037M. The Government is actively seeking information on potential sources of the requirements described below. All costs associated with responding to this notice are solely at the responding parties' expense. Respondents are solely responsible for properly marking and clearly identifying any proprietary information or trade secrets contained within their response. The Government will not be liable for, or suffer any consequential damages for any proprietary received in response to this notice will be safeguarded and handled in accordance with applicable Government regulations.

BACKGROUND

The Government collects and manages vast amounts of data within MCFMIS. Turning that data into information and using that information to intelligently manage government operations is a huge challenge. In some cases it may take days or weeks of pulling together data from different sources and reports, to obtain historical, current, and predictive information required for effect business operations. 

The Government is looking for a way to access timely, detailed, and trustworthy data to drive timely decision making. The Government believes the use of Business Intelligence (BI) and Data Warehousing will enable more effective strategic, tactical, and operational insights and decision making.

The Contractor shall incorporate the current Data ARC Pro module to help the Government incorporate the use of Business Intelligence (BI) and Data Warehousing. The Contractor’s BI solution shall incorporate enhanced BI reporting, visualization, Extract, Transform, Load (ETL) packages, as well as Data Warehousing.

ETL packages are sets of tasks that pull raw data from the Hospitality Suite! (HS) and SuitePoint! (SP) transactional databases and organizes that data into extract files that represent denormalized tables. Each data extract contains sets of related information that is the source for multiple reports. The Contractor shall coordinate with  the Facilities Sustainment Branch (FSB), MCICOM to install and schedule the ETL packages. The Contractor shall also implement the process for importing the extracted data into the new Data Warehouse database. Each ETL shall include a Data Reference Guide.

The Contractor’s Data Warehousing solution must incorporate implementing and assisting the Government on maintaining a central repository system where the enterprise stores all its data (from all MCFMIS, FMCFMIS and POS sources) in one place. The Data Warehouse will assist in reporting and data analysis from current and historical data stored, and hence it is a core component of Business Intelligence. The Contractor will work with the Government (MCICOM, G-4, Food Service) to create an onsite Data Warehouse at Facilities Support Branch (FSB) in Kansas City and ensure it has the correct configuration to achieve the outline BI solution. This will entail creating a database schema and providing structures, creating a database command line tool, and adding functionality for database maintenance. The Government will provide the onsite data warehouse at FSB, and the Contractor will assist with the setup and maintenance of the warehouse. 

The Contractor will assist in the setup of the servers, the installation of DataArc Manager, the setup of the Data Warehouse, scheduling of the ETLs, the import of the ETL data into the Data Warehouse database, and perform the installation and configuration of the reports within the BI reporting tool.

The Contractor shall establish baseline BI Reporting. The reporting will consist of utilizing existing and creating new ADHOC reports that are restricted to data specific to certain organizational entities (HQ, Bases, Mess Halls, etc.) as needed.

The reports below will be part of the Data Arc consolidated reporting:


Menu Cost / Revenue
Menu Total Cost
Menu Total Cost per person
Menu Total Count
Cost of Overproduction
Inventory Movement Details (physical inventory)
Inventory Cost Report
Daily Cost Analysis (DCA) Details Report
Item Tracking Report
Requisition Details
Requisition Summary
All Headcounts Reports
Funding Reconciliation Report
Other than Cash Reimbursement Reports (at all levels)
Cash Reimbursement Report (at all levels)
Meal Plan Allowance Daily Cost Analysis Reports (at all levels)
SuitePoint! Back Office Close Out Report
SuitePoint! Meal Activity Report
Standard Accounting, Budgeting, and Reporting System (SABRS) Funding Status Report
Subsistence Financial Report (at all levels) 
Meal Preference Report
Meal Plan Allowance History Report
Procurement Report (all levels)
ADHOC reports (as required)

Additional DataArc Pro Functionality will include the following:

• The ability to set a schedule task to generate data extracts.
• The ability to set scheduled task to generate custom reports.
• The ability to receive emailed Summary reports for all scheduled and On Demand Activity.
• The ability to view estimated export size for transactions.
• The ability to send export files to a network share or File Transfer Protocol (FTP).
• The ability to run one-time exports for historical data.
• The ability to pull and consolidate data from all levels (i.e. HQ, Base, Mess Hall, MEF, MSC and Exercise).
• The ability to set privileges by site and user group.

Respondents are requested to review the above summary and provide the following information:


Company Name
Company Address
CAGE Code
Website Address
Points of Contact with names, email addresses, and telephone numbers
Business Category (i.e. large, small disadvantage, veteran, women owned, etc.)
Company Qualifications and Experience:

Describe your capability to provide the necessary licenses for the SuitePoint! Point of Sale Terminal/Register Software Licenses required herein.

All information in response to this notice shall be submitted on or before 12:00 PM (EST) on 28 July 2020. Email submissions are acceptable. Proprietary information, if any, must be clearly marked.

Please be advised that all submissions become Government property and will not be returned. Information provided shall be treated as Business Sensitive and will not be shared outside of Government activities and agencies without permission of the provider.

Product Service Code:- D319 - IT AND TELECOM- ANNUAL SOFTWARE MAINTENANCE SERVICE PLANS
NAICS Code:- 511210 - Software Publishers
Primary point of contact:- Samuel Kistner  
samuel.kistner@usmc.mil  
Phone Number 7036040143
Secondary point of contact:- Nicholle Clinton  
nicholle.clinton@usmc.mil  
Phone Number 7036405404