Shift and Calendar Tables

In this article, we will show how to register and change the working time and day in Asprova – setting up shift and calendar and assigning resources based on the calendar.

This is the Shift table where working hours are set. The Shift code is set to “All Day”, which means to operate for 24 hours.


This is the Calendar table. The asterisk symbol (*) in the Resource column denotes “all resources” are available and will operate for 24 hours every day. In short, a 24-hour up-time every day.


In the Order table, there is a request to produce 5 items of AX by 15:00 of June 5th.


Press the reschedule button to see the operation.


Now, let’s add a lunch break in the operation. Go to the Shift table and add “Day Shift”, type in the Patterns field the following –  “8:0012:00;13:0017:00“. This tells us that the shift starts from 8:00 am until 12:00 nn, with an hour lunch break from 12:00 to 13:00, and then resumes operation from 13:00 to 17:00.


Next, go to the Calendar table and set the Day Shift in the shift code and * in the Resource.
Input 11 in the Sort order because the larger Sort order will be prioritized.


You will notice that grey fields will be displayed in the Resource Gantt Chart. It indicates the operating time of the resources and this is where the operations will be assigned.


Press the Reschedule button. Operation will be scheduled with 8-12 and 13-17 shifts.


We can also specify the shift directly at the Resource Gantt Chart. Right-click on the operation and select Holiday – this will make the specified date a “Day Off”.


Press the Reschedule button. The operation was unassigned here because it became a holiday.


To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s e-Learning videos at (see 24. Scheduling Logic).



Reschedule Modify Order

In this sample, let’s assume there was a sudden request from the customer to change the due date. The request was to move up the due date of Order 08 by one day.


Open the Order Gantt chart. Go to Window and select New Order Gantt Chart.


Highlight the column where you need to search the code ex. Order Code. Go to Edit and click Find. Search the order code and it will move to the position of the order quickly. In this sample, type the Order Code 08.



Order 08’s due date is pegged at November 17th. To change due date based on desired date of November 16th, drag and drop the red triangle mark between November 16th and 17th to modify the due date.


Press the Reschedule button. Order 08 is now made in time for the date it was dragged to – November 16th.


To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s e-Learning videos at (see 23. User Interface).


Reschedule Again – Change Scheduling Basis Time

In this sample, we will create a new schedule with the result input and change it to scheduling layout for confirmation.

Go to View tab, then Layout Setting, select Scheduling.
asprova1To change the scheduling basis time, drag and drop the scheduling basis time to November 3rd.

You will see that some operations were assigned in the past by moving the date.

The progress of the operation can be seen through the slant line. You will notice also that a part of the operation 3:10 with no slant lines was also assigned in the past and is delayed.


Next is to reschedule and reflect the results and re-assign the operations. The scheduling results will be changed and will be seen near the scheduling basis time. Run the reschedule button. You will see that the released operations that were not started are shifted to a future time.


The 3:20 operation now matched the delay of the previous process and shifted to a future time since the previous process 3:10 was delayed with the original plan.


To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s e-Learning videos at (see 23. User Interface).



Enter Result – Resource Gantt Chart

In this sample, we will input the result from the Resource Gantt Chart. Right-click on Operation 01:10 and select Operation, then Results.


This operation is done, so we will change the status to Completed. Click Ok.


A gray underline will be displayed in the operation and the slant lines will show the progress of the operation.


Do the same for operation 3:10 and input the result. Let’s assume that this operation has been delayed from the plan. Enter the reported start time as 2016/11/1 13:00. Input 7,000 in the reported quantity. Then, click Ok.


The result input is done.


You can also input the result from the Operation table aside from the Resource Gantt Chart. If you enter the result to some operations, you may use the Operation table.


To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s e-Learning videos at (see 23. User Interface).


Change Status to Release – Resource Gantt Chart

In Asprova, you can set the status of the operations as either Released or Completed. In this sample, operations have been rescheduled and adjusted. Now, we will change the status of the operation that has been scheduled to start by November 3rd to be released.

Click on the area that has no operation bar on the resource Gantt chart and drag to select the range.


Select the operation which is scheduled to start on November 3rd. Right-click on the selected operation and select Status, then choose Release. The status will change to Released.


If for whatever reason you made a mistake in the changing of status, you can easily remove the status to Unfreeze.


In addition, you can save the state of the window as a Layout.



Now the schedule which can put out instructions is completed. Save the project file for future reference.

To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s e-Learning videos at (see 23. User Interface). You may also check Online Help on Status.


User Interface: Pivot and Grouping

Pivot functions are used to aggregate specified conditions on the table. In this sample, we are going to make a list of the quantity of each resource, each item and each day as the material for the report of the scheduling results.

Go to the Table View and open the Operation table.
1In this table, the main resource Inventory is not needed, therefore right-click on the cell which displays Inventory and select Filter, then !=. This process will take out the Inventory details from the table.


Right-click on the upper-left cell of the Operation table and select Display Settings to set the Pivot function parameters.


Go to the Pivot rows and enter “Resource” in the New data cell.


Click the Right Arrow icon beside the (1) data cell to Set the details of the pivot row.

5Set the group key as Group by resource. Click on the blank cell in the Value column to update.


Choose the Group by resource and click Insert. Then press OK to exit.


Set also the Sort expression in an ascending order.


Choose the Value with ascending description.


To add another property, enter “Item” in the new data cell.


Click the Right Arrow icon, set the group key as Group by main item.

11Key in Summary in the new data cell of the Pivot contents.

12Click the Right Arrow icon, select (Operation) Production qty as the display content expression.



Return to the dialog of the Operation table display settings by clicking OK on all of the pop up tables. You will then see that pivot columns are now summarized on the horizontal axis.


Key in the word Date to aggregate using the date as base.


Click the Right Arrow icon, change the group key to Group by day (LET).



Select the month, day and time for the Label property.


Enter Qty in the pivot contents to aggregate the production quantity.



Click again the Right Arrow icon, select (Operation) Production qty as the Displayed content expression.


Close the property window. You will then see the complete list below aggregated with the production quantity of each resource, each item and each day.


Grouping can also be enabled if you want to aggregate some of the fields. In this sample, let’s get the aggregated level of the quantity of each customer and each item.  Open the Order table and filter again the Inventory order.


Right-click on the top line Customer and select Grouping then, Sum. Repeat the same for the top line Item.


As a result, you will see the order quantities aggregate by customer, by item.


To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s e-Learning videos at (see 23. User Interface). You may also check Online Help to learn more about Pivot and Grouping.




User Interface: Inventory Graph

The Inventory graph shows the changes in an item’s inventory level and helps confirm whether there is a shortage in materials or not.

To view this, go to Window tab and choose New Inventory Graph.

Asprova1To display shorting items only, right click on the upper left cell and select Filter then, Inventory shortage item.

Asprova2The item “A” is in shortage as there is a negative quantity on November 25th.

Asprova3We can check the details by right-clicking the date. Select Drilldown then, Assigned Resources

Asprova4The related Resource Gantt Chart will be displayed under the Inventory graph where you can check which operations will cause the shortage.

Asprova5In this sample, the process has no effect at any nearby time, so this time will be fine, but to be sure, confirm the former arrival plan with the procurement staff.

To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s e-Learning videos at (see 23. User Interface). You may also check Online Help on Inventory Graph.


Improving Supply Chain Performance

asprovaGetting a 360-degree view of their supply chain is critical for manufacturers and distributors in today’s business world. Those that have unparalleled insight, visibility to their supply chain and understand how their company actually functions (versus how they expect it to) can find ways to optimize vendor relationships, focus on tactics that will increase supply chain efficiency and be able to monitor the myriad of factors that impact supply chain performance. By managing and improving environmental, social and economic performance throughout supply chains, the very best companies can conserve resources, optimize processes, uncover product innovations and save costs. Any manufacturing company that wants to enhance their performance must pay attention to the following key strategies:

Improve Demand Forecasting- Constructing a feasible, constrained and profitable demand plan is essential. Without accurate demand forecasting, manufacturers can only be confident in their ability to meet demand if they rely on inefficient stockpiling of inventory: The emphasis is on “just in case” processes, rather than “just in time.” Many companies now recognize that the only way to attack demand volatility is to expect it, and they are adopting the best practice and advanced technical tools to deliver improvements to forecast accuracy, inventory levels and working capital. For the rest, it is becoming increasingly clear that inadequate demand planning can do serious damage to shareholder value and overall profitability.

Create a Modern, End-to-End Supply-Chain OrganizationThe times of managing the supply chain in separate tiers is over. Sophisticated data analysis enables companies to manage supply chains end to end and, in industries such as manufacturing, almost in real time. Appoint a single leader with responsibility for end-to-end performance and for delivering improvement projects across tiers and traditional functions such as marketing, manufacturing, and procurement. Make sure your supply-chain organization combines operational excellence with strong analytical capabilities and data-driven, cross-functional decision making. Ensure your IT function is supporting them with nimble applications and platforms that enable collaboration and analytical decision making.

Join Industry Collaboration- Many companies recognize that complex supply chain challenges cannot be solved by individual efforts and that industry wide collaboration is required. Working in a pre-competitive environment, peer companies that share similar supply chains can set common standards and best practices for sustainability performance and allow suppliers to be evaluated on the same metrics. These collaborations help prevent audit fatigue, training redundancy and mountains of paperwork for suppliers working to meet similar requirements from their customers. Working with your industry peers is a great way to share knowledge about the sustainability performance of your suppliers.

Develop Training and Capacity Building ProgramsThis is an important step in improving sustainability and driving behavioral changes throughout your supply chain. First, formulate a comprehensive plan to increase productivity, reduce costs, and improve customer service and satisfaction levels. Then tie an incentive plan into the supply chain’s core mission, a critical element to building a performance-based approach. Incorporate your workforce into the culture of the supply chain by emphasizing ways in which employees and management may improve their workplace strategies and execution. This constructive training will drive a successful organization and improve supply chain productivity.

Asprova is the manufacturing industry’s leading performance improvement solution suite. Our advanced planning and scheduling functions help organizations achieve sustainable cost reductions and improve supply chain performance while remaining focused on quality, productivity and better service levels.



Phot credits: flickr © The U.S. National Archives

User Interface: Resource Load Graph

In this article, we are going to take a look at the load graph of each resource.

The load graph shows the load of each resource on each day. Looking at the graph below, you will see the resources on the left side and the loads on the right side in percentage value.

We can also set the color of the graph for easier viewing.  Right-click on the upper-left cell, and select Display settings.


Set the Display color expression on the Load Graph tab.


Select “Red if over 80%” from the standard registered expressions and click Ok.


You will then see that the parts with a heavy load (those with loads greater than 80%) will be displayed in red. You can see both the resources of the Assembly process have a heavy load near the scheduling basis time.


Let’s change the unit term of the load. Right-click the date, select Unit term then, 1 week.


Now you can see that both the resources of the Assembly process are holding a heavy load all the time.


To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s e-Learning videos at (see 23. User Interface). You may also check Online Help on Resource Load Graph.


User Interface: Change and Move Operations – Dispatching View

To confirm or adjust operations, we are going to use the dispatching view. Go to Window and Select New Dispatching View option.


The Dispatching View shows the time on the vertical axis (see date below) and resources on the horizontal axis (see Assembly below).


This is .different from the Resource Gantt chart as it shows one operation on each line, to confirm and adjust easily. In this view, you can also choose what resources you want to display. Let’s just display the operations of the 2 Assembly machines. Go to Dispatching View and select Resource filter.


Set the property as “Resource code”, the condition as “==”, and the value as “Assembly 1”. In the next line, select “or” and set another expression of “Assembly 2” with the same setup as Assembly 1”.


Click the OK button. You will see that only the Assembly machines are displayed.


In this view, you can also move the operations from one machine to another as well as from one date to another just by dragging the operation.





To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s e-Learning videos at (see 23. User Interface).