Job Generation


+ Transcript

Jobs need to be created to fulfill customer orders, provide subassemblies to other jobs, and to replenish stock. Job planning must deal with the following issues:

  • Should an item be made to order or to stock?
  • If made to stock, what is the appropriate reorder level?
  • How can a job reflect an economical order quantity?
  • How much time should be allocated to make an item?
  • How can the delivery time for a make to order item be shortened?

In DBA jobs are generated by MRP, which stands for "material requirements planning." MRP generates jobs directly from sales order lines for custom to order items, and for all other items it uses four common sense item settings to generate jobs in response to the net demand within each item's planning period.

Jobs are generated on a just in time basis within a lean, coordinated master job schedule. The master job schedule is your blueprint for lean manufacturing - completing jobs on time using less inventory and WIP.

Jobs for custom to order items are generated differently than jobs for net demand items.

Here in the MRP Settings screen you can flag an item as being CTO, which stands for "custom to order." A CTO item is one that is altered or customized in some manner for each customer order such that it cannot be stocked or sold to other customers.

One-Off items generated during sales order entry are automatically designated as CTO items. See the Order Entry video for more information on One-Off items.

Jobs for CTO items are generated by MRP directly from sales order lines in the exact quantity ordered.

To generate CTO jobs, click the Generate button. Select the Generate Planned Jobs for CTO Items option.

The planned jobs are then listed in this grid where they can be reviewed and selected for conversion into actual jobs.

Here in the sales order, the CTO Job field indicates that a CTO job has been generated for this line item.

Unlike jobs for CTO items, which are generated directly from sales order lines, all other jobs are generated in response to the net demand within each item's planning period. Each item's planning period is simply the total number of days allocated by MRP for making the item.

Job generation for net demand items is driven by four common sense item settings that are maintained here in the MRP Settings screen - the Job Days, Lead Days, Reorder Level, and Minimum Order. Let's now review each of these in succession.

The first of our four common sense manufactured item settings is the Job Days.

The Job Days is the number of shop days allocated by MRP for making the item. Note that the Job Days amount is an "allocation" and is not the literal time it takes to manufacture the item. For example, on paper an item may only take so many hours to make the typical job quantity, but in reality, jobs spend much more time moving from work center to work center and waiting in queues than they do in actual production.

The best way to set the Job Days allocation is to give it a common sense value based on your past experience.

You can use the Production inquiry to get a listing of the actual shop days associated with past jobs.

The second of our four common sense manufactured item setting is the Lead Days.

The Lead Days is used by MRP to allocate sufficient time prior to starting the job for material procurement or making subassemblies. The Lead Days amount is automatically calculated by the program is made equal to the longest lead time among any of its components that are made or purchased to order.

The Lead Days plus the item's Job Days determines the time it takes to make the item and establishes sales order required dates when you enter orders for make to order items.

The Lead Days inquiry enables you to review the components that contribute to the calculated Lead Days amount. The inquiry displays a multi-level view in cases where a chain of subassemblies must be made to order before a job for this item can be started.

If you want to shorten a product's delivery time, it can be done by changing one or more contributor components to be made or purchased to stock instead of to order.

For example, the front undercarriage assembly is by far the biggest contributor to the red wagon's Lead Days, which is currently 17 days. Let's see what would happen if we make the front undercarriage assembly to stock instead of to order.

Here we have given the front undercarriage assembly. And now we see that our Lead Days has been reduced from 17 days down to 8.75 days.

Therefore, the Lead Days Inquiry gives you a powerful tool for gauging which items are best made or purchased to order or to stock.

The third of our four common sense manufactured item settings is the Reorder Level.

Some items need to be made to stock so that they are immediately available when needed by sales orders or other jobs. To make an item to stock, it must be given a Reorder Level. MRP will generate a job whenever net demand within the item's planning period falls below its Reorder Level.

The Reorder Level amount is established using the Reorder Calculator, which is launched by clicking the button in the Reorder Level field.

The Reorder Level must be sufficient to cover projected demand within the item's planning period. Projected demand consists of three elements:

Here you enter estimated monthly unit sales for the item. Here you enter estimated monthly usage for the item, meaning its use as a subassembly in other jobs. You can also enter a safety stock amount to cover potential variations in net demand that can occur in any given month.

In the lower portion of the screen you can review past sales and usage history with monthly and quarterly averages to help determine your monthly estimates.

Here we see the item's Planning Period, which is the number of days allocated by MRP to make the item.

The program translates the sum of these three amounts into a daily average that is then multiplied by the item's planning period days to arrive at a calculated Reorder Level.

The fourth and final common sense manufactured item settings is the Minimum Order.

The Minimum Order provides control over job quantities. When MRP generates a job, the quantity will be equal or greater than the Minimum Order amount, no matter how little the actual net demand may be.

The Minimum Order can be used as an economical order quantity. It generates job quantities sufficiently large enough to justify machine setups or to match quantities with machine sizes.

Jobs for net demand items are generated within the MRP screen.

To generate net demand jobs, click the Generate button. Select the Generate Jobs for Net Demand option. Jobs are generated in response to each item's net demand relative to its Reorder Level.

What is "net demand?" Within the item's planning period, it is the item's stock on hand, plus expected supply from open jobs, less demand from sales orders and other jobs. The item's planning period, is the number of days allocated by MRP to make the item. Any demand outside the planning period is responded to in a future MRP run. This makes the master job schedule easier to manage because scheduling dates are short term and the number of jobs is kept to a minimum.

The planned jobs are listed in this grid. Each planned job can be reviewed by clicking the Demand icon.

This launches the Projected tab of the Stock Status screen, which displays all the supply and demand details within the items planning period. In this lower grid, you see any demand that exists beyond the planning period that will be responded to in a future MRP run.

The Stock Status inquiry tells you everything you need to know about the planning for this item. Here on the summary tab you can see the item's MRP settings that drive MRP generation.

Based on your review, you have the option of bumping the planned job quantity or expediting the finish date for special situations. You can also click the Links button to link to the MRP Settings screen if you wish to refine this item's settings.

As you finish each review, select the Convert checkbox to flag the planned job for conversion. After all planned jobs are flagged for conversion, click the Convert checkbox to convert the planned jobs into actual jobs.

After each set of planned jobs is converted, the program examines manufactured components within the newly created jobs and automatically generates additional planned jobs for lower-level subassemblies as needed. This process continues, level by level, until no more net demand is detected. The Lead Days Generator ensures that each subassembly job is properly offset to meet the required dates of higher level jobs.

A major source of inefficiency with manual planning is treating each make to order product structure as an independent chain of multi-level jobs. In actuality, much of your demand is "interdependent", meaning that it is shared in a one-to-many relationship instead of one-to-one.

So instead of having separate sets of subassembly jobs for each top level job, MRP generates one subassembly job for multiple jobs whenever it is warranted. MRP does the same thing with purchased items where all the demand within the item's planning period is covered by one PO.

By combining interdependent demand into fewer jobs and POs, MRP generates a more efficient master schedule that is easier to manage and execute and helps keep work in process to a minimum.

The master job schedule can be viewed in the Job Schedule screen.

Because MRP only generates net demand jobs in response to the net demand within each item's planning period, jobs are scheduled on a just in time basis. Therefore the master schedule is short term in nature. Demand beyond an item's planning period does not require an immediate job and will be given a job later when that demand falls into the planning period. This keeps the schedule lean and accurate for maximum efficiency.

Is your shop run by expediting where dates don't have meaning and favored jobs are given priority attention at the expense of other jobs, and shortages, late deliveries, and over-stocking are the norm? DBA changes all this by generating a lean, just in time, coordinated master job schedule that is driven by four common sense item settings. Focus on the quality of your manufactured item settings and you can achieve lean manufacturing - completing jobs on time using less inventory and WIP.