Small and medium business | Business Central, N...

Creating a production schedule of what items to produce each day.

(0) Share

Report

Posted on by JeffBan

Hello fellow business central users,

I'm looking for some help regarding setting up a production schedule for one of my plants.

Goal: Have business central tell me what products my plant should be producing each day to fill orders. IS THIS POSSIBLE?

To the best of my ability I have set up the following: machine centers, work centers, routings, production bom's, etc...

Can someone explain the best way to create a daily production schedule?

Your input is greatly appreciated.

Thanks,

Jeff

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report
RE: Creating a production schedule of what items to produce each day.

Jeff,

Follow these steps to run the Planning Worksheet (MPS): Note: Have you run off the Machine and Work Centers Calculate Work Center Calendar? Please make sure this is run before proceeding.

FYI - The terms "running the planning worksheet" or "running MRP" refer to the calculation of the master production schedule and material requirements based on actual and forecasted demand. The planning system can calculate either Master Planning Schedule (MPS) or Material Requirements Planning (MRP) on request, or it can calculate both at the same time.

MPS is the calculation of a master production schedule based on actual demand and the demand forecast. The MPS calculation is used for end items that have a forecast or a sales order line. These items are called MPS items and are identified dynamically when the calculation starts.

MRP is the calculation of material requirements based on actual demand for components and the demand forecast on the component level. MRP is calculated only for items that are not MPS items. The purpose of MRP is to provide time-phased formal plans, by item, to supply the appropriate item, at the appropriate time, in the appropriate location, in the appropriate quantity.

Let's get started:

1. Search for Planning Worksheet

2. Note: Make sure you have a Batch created to begin

3. Click Prepare/Calculate Regenerative Plan

4. Fill in Options MPS = Production Planning, MRP = Material Planning (Purchase Orders/Transfer Orders), Start and End Date for Planning Window to calculate, Use Forecast (If you have one). You can filter by Item or Location. When done click OK.

5. You can now see Production Orders

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
JeffBan 40 on at

Like (0)

Report

RE: Creating a production schedule of what items to produce each day.

Hi Steven,

Thanks for such a detailed response, really appreciate your support.

When I referenced your last photo I can clearly see the worksheet saying you need to produce 91 bicycles and it will take from 8:00am to 4:00pm. This sounds realistic.

When I calculated a regenerative plan on my worksheet it suggests unrealistic start time and finishing time. The system is almost saying I can produce these goods within a minute of production.... Which is not the case.

I must be missing something within my machine set up??

I have set up my shop calendar (7 days a week 24/7).

I think there is a disconnect between my machines and work centers and what they can produce.

Here's some details about my production

Work Centers: 1. Dryer 2. Sterilizer 3. de oiled 4. pin mill 5. big mill 6. packaging 1, packaging 2, packaging 3....

Machine centers: Exact same order as above

How do I set my my machines so they produce 1000lbs of goods an hour......

Would be greatly appreciated if you could explain this process.

Thanks again for your help.

Jeff

Was this reply helpful? Yes No
Suggested answer

JAngle 123 on at

Like (0)

Report

RE: Creating a production schedule of what items to produce each day.

Steve has drawn up a quality answer on what to do once you have a schedule. The to finalise this answer is the use of a demand forecast. This will give you a focus point for what you want produced per day. The what can be produced per day is then a mixture of what has already been explained. Steps for creating the forecast: docs.microsoft.com/.../production-how-to-create-a-forecast

Make sure items or SKUs are set for lot-for-lot

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Creating a production schedule of what items to produce each day.

Jeff,

The Start and End times are a derivative of Components and Routing Times. Let me explain...

If the Components are in-stock, nothing to calculate, however, if not in stock how long to receive the component. It looks at Item and Default Vendor and Lead Time for the Item. If no default Vendor/Lead Time, the expectation will be immediate receiving. Now we look at the Routing Lines and what has been set for Setup, Run, Wait, Queue, etc.. It will calculate how ling 1 Item to manufacture takes based on the Routing Lines to see how long from Start to End. If none are setup, immediate completion.

I would examine the Routing established against the Item. Check all the Work Center and Operations steps and the times. Then rerun the Planning Worksheet. Also, as Josh noted, you can establish a Demand Forecast to plan production better (i.e. Sales Forecast).

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No