MARS for QuickBooks Software Demo

Job #3069

Job Posting Details

Job # 3069 MARS for QuickBooks Software Demo

Posted Date
Mar 5, 2007 @ 21:49
Respond By
Mar 9, 2007
Word Count
Age Range

Job Description

This is an online presentation for a software product called MARS. MARS is a software program that runs with QuickBooks to help manufacturers determine what their production needs and raw material purchase requirements.

The script is approximately 1,600 words. Direction is provided in brackets following the words being referenced. The voice over will be synced with an animated video combined with a video recording of the software demonstrated.

The primary objective of the audio-video is to get them to buy the software. Secondary objectives are to inform the audience about MARS, and to educate the audience to a more simple method for getting manufacturing reports. Please be sure to use 4400 megahertz for the .mp3 or .wmv files.

Note from The full script has been provided for quoting purposes. You are welcome to submit a standard business presentation demo. Should you choose to submit a custom demo, it is recommended that you watermark your work.


1. If you run a company that produces make-to-order products in a repetitive manufacturing environment, you have probably asked questions like these when it comes to the software in your industry:

a. Why do they make the software so complicated?
b. Why is the software so tedious and difficult to set up?
c. I just want to know what I need to buy and when I need to buy it, why is that information so difficult to get?

2. Well you’re not alone when you ask these questions. The fact is most businesses like yours are forced to use manufacturing software that is far too complex for their needs, or, they fall at the other end of the spectrum: they use information manually copied from their accounting systems to spreadsheets, and blackboards and post-it notes.

3. Why do they make the software so complicated? It’s because most of today’s manufacturing software is actually nothing more than third and fourth generation remakes of software created in the 1960’s, and created for huge manufacturing plants with big corporate staffing resources for maintaining the data required to make this software function correctly. That is also why the software is so tedious and difficult to set up.

4 Unfortunately, many of today’s institutions of higher learning and professional organizations continue to promote the same archaic philosophies and methodologies that gave birth to this outdated software. So experts and professional consultants tend to be of little help because they tend to promote the archaic and complex, not the new and simple.

5. MARS is new and MARS is simple.

6. MARS is an ideal reporting tool for automotive, food processing, chemical processing, and other businesses driven by a repetitive, make-to-order or finish-to-order environment.

7. MARS stands for Material and Assembly Requirements Scheduling.

8. MARS enhances QuickBooks with an MRP-lite (like bud-lite) reporting capability that supports your manufacturing, purchasing and scheduling needs. The reports tell you how much you need to buy and when, in an easy-to-read, time-phased columnar format.

9. MARS challenges the assumption that every manufacturing business must have complicated manufacturing software. MARS is simple!

10. MARS uses the latest .NET technology to provide user-friendly MRP reports that interact through drill-down functionality

11. MARS distinguishes itself from other MRP solutions by using nearly all of the data it needs from information you already maintain in QuickBooks. This means you have little or no set-up and maintenance of additional data.

12. Information is obtained from the following tables in QuickBooks:

- Sales Orders
- Sales Invoices
- Sales Estimates
- Inventory Assembly
- Inventory Part
- Inventory Service
- Purchase Orders
- Purchase Receipts
- Customer Records
- Vendor Records

13. MARS also auto generates purchase orders that you edit and print within QuickBooks.

14. Producing reports in MARS is easy.

15. After launching QuickBooks, launch MARS from the ‘Start’ button in Windows.

16. Set the parameters in MARS’ main window to control which transactions are processed and the content of the MARS reports.

17. For example, let’s set the starting date of the MRP schedule to November 19th, 2007. Let’s select the check boxes to include sales orders and sales estimates. We want to produce a 7-column time-phased MRP schedule, so we’ll accept the default value of ‘report type.’ We could select the option to run a “short-list,” which is a handy quick-and-dirty report that tells us what are the immediate net raw material and component requirements in order to meet short-term customer demand, or we could have selected the option to run a 13-column time-phased MRP schedule.

18. We’ll also accept the default to include ‘all requirements’ in the reports. This way, any inventory items with projected depletions are included in the MRP schedule, even if that item still has sufficient inventory to meet customer demand. We could have selected the alternative option to include ‘net requirements.’ This would result in a more stream-lined schedule because only those items that don’t have sufficient inventory to meet projected customer demand are included.

19. After selecting the MARS parameters, we produce the MRP schedule by simply clicking on the button labeled ‘Make MRP schedule.’

20. MARS goes to work by gathering the information it needs from the data in QuickBooks. A status bar displaying progress is shown at the bottom of the MARS window, and a second window is displayed that contains animated graphical silos filling up as MARS completes each process.

21. When the process is complete, a window is displayed that contains the MRP schedule. As you see here, we have a seven column MRP schedule from sales orders and sales estimates. Each column has a time interval of seven days starting the week of November the 19th.

22. Let’s look at the content of the MRP schedule.

23. The item number 1000-MC has a quantity-on-hand of 9 units. This information is pulled directly from QuickBooks, as you can see here.

24. The projected demand from sales is 15 in the week of November 19th, 17 in the week of November 26th, 30 in the week of December 10th and 23 in the week of December 24th.

25. Select the adjacent link to view the detail for these projections. In this example, there are five sales orders for this product.

26. A total of 76 units must be manufactured or produced in order to fill the sales orders. Six units must be produced by the week of November 19th, 17 units by the week of November 26th, 30 by the week of December 10th and 23 by the week of December 24th.

27. Total demand from sales is 85. Total units to make are 76, since 9 units are already in inventory.

28. Let’s scroll down and look at another item number. Item number ANSP (say the letters) is a component that must be ordered from a supplier. Viewing the detail for this component’s projections, we see that the parent for this component is item number 1000-MC. We also know this by looking at the indented bill-of-material for item number 1000-MC. Every one unit of item number 1000-MC requires 50 units of item number ANSP. MARS indented bill-of-material report can show up to 11 levels.

29. Returning back to item number ANSP in the MRP schedule, we see that two inbound shipments expected. Viewing the detail, we see that there are two purchase orders, one for an inbound shipment due in January of 2008 and the other for an inbound shipment due November 27th of 2007.

30. But we have a couple of problems that need to be addressed here. First, the quantity-on-hand of 255 units plus inbound shipments of 145 units are not sufficient to meet the projected demand of 4,250 units for this component. We’re 3,850 units short. That’s a problem. MARS is telling us that we need an additional 495 units in the week of November 19th, an additional 705 units in the week of November 26th, an additional 1,500 units in the week of December 10th and an additional 1,150 units in the week of December 24th. But our second problem is that MARS is telling us that our primary supplier, Anderson’s Hardware and Tools Supply, requires a 24-day lead time on orders. MARS computed this lead time from the transactions of previous completed orders placed with this supplier. So based on a 24-day lead time requirement, MARS computes an ‘order by’ date of October 26th to ensure delivery of 495 units by November 19th, November 2nd to ensure delivery of 705 units by November 26th, November 16th to ensure delivery of 1,500 units by December 10th and November 30th to ensure delivery of 1,150 units by December 24th.

31. Since the first three of these ‘order by’ dates occur before November 19th, the starting date of our MRP schedule, MARS flags this item number with a warning of “insufficient lead time.” So it might be a good idea to contact this supplier by phone and expedite the first three orders.

32. As a matter of fact, we can get a bird’s eye view of the overall status of our inventory by looking at a summary level pie-chart. As shown here, there are 15 items in the MRP schedule with insufficient stock levels and lead time. There are 21 items in the schedule with sufficient inventory, in other words, inventory at the right level to meet projected demand. But in addition to flagging items with insufficient inventory, MARS has flagged seven items as having excessive inventory. Items with excessive stock levels are those items with a projected ending inventory that exceeds the sum of the total requirements for all of the time periods combined plus any re-order level for that item.

33. Let’s look at an item number with excessive inventory: Item number POCO-DB (say the letters) is flagged as an item with excessive inventory and we can easily see why it is flagged. Projected demand for this item is only 5 units while quantity-on-hand plus expected inbound shipments are 25 units. The result is that the projected quantity-on-hand significantly exceeds projected sales.

34. As we conclude, note that the reports produced by MARS can be exported to Excel or formatted into .PDF files.

35. To learn more about MARS for QuickBooks, download a free 60-day trial version of the software.

36. Simple, easy-to-use, easy-to-install – MARS is a natural fit for most manufacturing companies using QuickBooks as their accounting software.

37. Future releases of MARS will leverage even more functionality by linking to Microsoft Excel and Microsoft Project using the latest SQL database technology.

Ready to get started?

Join the #1 marketplace for voice-over talent

Need Some Help?
Contact us for help with your voice over project.