Blog - Latest News
You are here: Home / Blog

How to be a Scheduling Superstar like Judy

May 28, 2019/in /by

What tools does Made2Manage have to assist the scheduler?

  • Planning and Scheduling module: Performs the heavy lifting scheduling work centers.
  • Shop Floor Manager: Updates all of Job Routings with completions and actual time spent.
  • Additional Fields:
Additional Resources: Tools, Other Equipment, Ability Level
Operational Characteristics: Steel Gauge, Paint Color
Simultaneous Operations: The number of Work Centers that can be used.
<


What is Daily Capacity Planning modeling tool and how does it work with Made2Manage?

Daily Capacity Planning Model is an Excel Model with Tab, Pivot tables and totals that allow a scheduler to get a complete visual of the daily schedules, analyze conflicts and set the priories and changes to the schedule as the day proceed.

Without a similar tool the scheduler is left to guess, manually try to build models and enter data or go out to the plant to see what is really happening.

It uses data from Made2Manage and perform simple to complex calculations for key factors and metrics to keep production scheduling efficiently. To update the model all that is needed is to click the refresh Icon in Excel.

How does the Daily Capacity Planning modeling tool enhance Judy’s scheduling ability?

  • Breaks down the Jobs operations in tabs that are color coded and have logical relationships to list and total together. These can be work centers, high value customers, rush jobs or any characteristics that allow the scheduler to view the information from their preferred view point.
  • Pulls in other job/operation data element characteristics that can be used to filter the data. Such data allows scheduling to minimize setup and group logical jobs together.
  • Perform complex calculations to highlight potential problems such as Jobs not moving according to estimate, slack to complete a job on time diminishing or daily/weekly/mthly capacity views.

What changes does Judy easily handle using the Daily Capacity Planning model?

  • Moving up a job in the schedule or slide in an unexpected rush Job.
  • Number of employees per work center have unexpectedly changed.
  • Unexpected material delay and implications to schedule.
  • The ability to view implications to transfer employees between Work Centers or Departments.
  • How much would the company gain by working overtime in Work Centers or Departments?

How does NuStar Resources help us setup our Daily Capacity Planning model?

  • The base model is free as part of NuStar Resource’s consulting tools.
  • We work with your operation personnel to define tabs, views, data and calculations to be part of the model. Determine sources of scheduling issues and how the model can help resolve.
  • Build the model base on the definition derived from the group including SQL query statements.
  • Continue to work with the scheduling group to refine and extend the model.


COPYRIGHT 2019 NUSTAR RESOURCES

BASOAN – One of the Most Important Least Used Made2Manage Report

March 19, 2019/in /by

What is the BASOAN Report and why is it so Important?

BASOAN report is one of the Business Analytics reports that sends the information directly to an excel
file which has Popups, Pivot Tables and Graph to analyze Sales, Cost and Profit. You are provided with
Base Data (M2M Data tab) and summarizes by Customer, Part Number, Product Class and other tabs.

The Selling Price comes from the Sales Order. The COGS comes from the source connected from the
Shipper. Source Make: Actual Job Costs. Source Stock: Accounting Cost at time of Shipper. Source Buy:
PO Cost adjusted by the AP Cost. You want to choose the Selection: Shipped SO (Price, Cost, Profit).

This Excel can give you a picture of your business. One of my clients CEO called this report:

“We use it for so many of our metrics reporting – not sure what we would do without it.”

Yet almost half of the CEO’s and CFO’s are not even aware of the report. This report is available in
versions 6.01 and above.

Some issues with the report in some versions that can be fixed:

Date Selection: You have the choice of Order Date. Shipped Date is better for performance evaluations.

Date inconsistencies: The Base Data (M2M Data tab) uses Shipped Date. The summary tabs use SO Due
Date for Yearly, Quarterly, Monthly period determination. This can cause confusion. Shipped Date
should be used throughout the report.

The above issues were fixed in versions 7.51 and can easily be fixed in other versions.

Improvements to the report to make the data more valuable:

  • Remove the Estimated Cost / Profit and Actual Cost. Most executives are just interested in Sales
    and Profit when summarizing. This allows more than the Top 10 (which can be altered) to be
    easily seen in the Excel display.
  • Addition of other Customer and Part characteristics that assist in the analyzing the data such as
    Part Description, Customer Sub-Type, Sales Person, Sales Coordinator or any other fields that
    have been added with screen customizations.
  • Add tabs for Customers and other relevant criteria at the Quarterly level with percent changes
    to evaluate Sales Trends.

Uses of the Report by different periods:

  • Weekly: Tracking of Sales/ Profit to meet monthly objectives. Reviewing out of range profit
    margins to determine the accuracy of the data.
  • Monthly: Determine which Products / Customers / Sales Person contributed the most to the
    Sales/ Profit monthly objectives.
  • Quarterly over multiple periods: Customer, Product Class, Part Number Sales Trends. New
    product introduction evaluations.
  • Yearly: Customer / Part Price Increases. Sales Person / Territory / Sales Coordinator
    realignment.

COPYRIGHT 2019 NUSTAR RESOURCES

Copyright 2013. Developed by Snap Agency