A materials resource planning system designed by Greg Frazier, CPA, PLLC for manufacturing companies.


MARS is an acronym for Material and Assembly Requirements Scheduling. This is an add-on module for the Microsoft Business Solutions Dynamics GP product line and Small Business Financials (SBF).

The MARS Module enhances your accounting software with an MRP reporting capability that supports your manufacturing purchasing and scheduling needs. MARS reports tell you how much raw material you need to buy and when in an easy-to-read time-phased columnar format. MARS auto generates purchase orders and creates supplier schedules. You can edit and print the POs within Dynamics GP and SBF. MARS generates an 84-day daily production schedule using Microsoft Project.

Developed in Dexterity, C+ and Visual Studio .NET, MARS has been tested and certified by VeriTest, a leading software testing company. MARS is an ideal reporting tool for the automotive, food processing, chemical processing, and other repetitive manufacturers driven by a make-to-order or finish-to-order environment.

MARS distinguishes itself from other MRP solutions by using data from the following core financial modules of Dynamics GP or SBF:

  • Sales Order Processing (SOP)
  • Inventory Management with Bills-of-Material
  • Purchase Order Processing

So you don’t need to maintain other, outdated, manufacturing tables that provide limited value for the added cost of maintenance.

The core logic of the MARS Module is an algorithm driven by customer orders, invoices, quotes and back orders within the Sales Order Processing (SOP) Module:

  • MARS extracts the quantity ordered and requested ship date for each finished part or product, and time phases that information into user-defined intervals of days, weeks, months, etc… The requested ship date is used to derive a production start date. MARS computes the production start date as follows:
  • Production start date = requested ship date - production lead time - ship lead time per finished good item number - ship lead time per customer address location
  • It then explodes through each finished good’s bill-of-material to derive gross purchase or assembly requirements for the raw material and components that make up the finished good (finished part or product).
  • MARS then checks the quantity-on-hand and open purchase orders of the respective raw material and components. Net Requirements are computed from requirements that exceed the sum of the quantity-on-hand and projected purchase receipts.

Unlike other MRP reporting applications, there is very little setup. You will have MARS up and running in minutes.

And MARS works. To quote one customer,_ ýResource planning and scheduling was extermely tedious prior to MARS. With automatic PO generation and 10 weeks out planning, we’ve reduced a full time office job to five hours a week, with fewer errors!ý _- Tim Doelman, Manager, HRP Manufacturing, Boise, Idaho.

Product Overview

Other Software by Greg Frazier, CPA, PLLC

User Reviews of MARS MRP

No reviews have been submitted. Do you use MARS MRP? Have you considered it as part of your software evaluation process? , and help other organizations like yours make smarter, more informed software selection decisions!