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.BACKGROUNDThe 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 / RevenueMenu Total CostMenu Total Cost per personMenu Total CountCost of OverproductionInventory Movement Details (physical inventory)Inventory Cost ReportDaily Cost Analysis (DCA) Details ReportItem Tracking ReportRequisition DetailsRequisition SummaryAll Headcounts ReportsFunding Reconciliation ReportOther 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 ReportSuitePoint! Meal Activity ReportStandard Accounting, Budgeting, and Reporting System (SABRS) Funding Status ReportSubsistence Financial Report (at all levels) Meal Preference ReportMeal Plan Allowance History ReportProcurement 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 NameCompany AddressCAGE CodeWebsite AddressPoints of Contact with names, email addresses, and telephone numbersBusiness 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.