Planning Worksheet

Planning Worksheet

The supply planning process involves the delicate art of balancing unconstrained demand forecasts with organizational constraints like people and resources. Balancing or creating a supply plan is done either by (a) Production - manufacturing the products (b) Purchasing - from 3rd party supplier (c) Transferring - from an alternate warehouse or DC.





The S&OP Planning Worksheet provides a workspace for creating the supply plan. As you enter production, procurements, and transfers into the worksheet, and inventory balances are automatically updated. In addition, Arkieva constantly monitors the plan for detailed violations so that the user can focus on these exceptions.


Use the Planning Worksheet to:
  1. Create production, purchases, or transfers
  2. Uncover violations in the supply plan 



Tree

On the left part of the screen is the same flexible hierarchical structure as in the demand focus collaboration module. In this case, the tree is also defined by item group, item, and location. Item and location must always be included in the tree. 




Overrides

Double-click a cell in the planning area of the application and type a numerical value to create to change data which will be reflected in the Summary chart and the planning area.  













Summary

Summary tab shows the aggregated data of the selected tree data. 




  1. Click and drag across rows and columns to show the Count, Sum, and Average.










  1. You can switch between the chart view and the aggregated stock view by clicking the toggle buttons to the left. 







  1. You can also select and unselect aggregated stock data to drilldown to specific data.





Item Group Capacity

The Item Group Capacity tab shows the capacity utilization percentage, available capacity, used capacity, and free capacity for an item group. 





Storage Group Capacity

The Storage Group Capacity tab shows the capacity utilization percentage, capacity available, used available, and free capacity for a storage group. 






Chart

The Chart tab visually shows the supply demand balance over the planning horizon for an SKU. 






Flow

The Flow tab shows the flow of demand through your supply plan. Here you can check for Violations, view Affected Demand, and see any details connected with the different demand flow items. 






View Violations 

If you see an item with a warning sign, this means there is a violation attached to the item. You can click the View Violations button to launch a drawer showing an explanation of the violation. 




Here you can see there is a Supply violation causing excess inventory to be produced. You can add a comment, go to where the violation is coming from to attempt to fix it, or click the Summarize button to use AI to offer possible solutions. 





View Affected Demand 

Clicking the View Affected Demand button allows you to view all details related to that Flow Item. The details shown will depend on the Flow Item. 





  1. You can also view any violations from the View Affected Demand details. 











  1. And you can evaluate items with a What If Scenario. Click the Evaluate link to launch the Evaluate window.





  1. Here you can change aspects and evaluate a What If Scenario. The results will show as Widgets in the window. If the What If is acceptable, you can click Accept and these changes will reflect in the planning worksheet. 









Utilization

View the Resource Type and Batch for that Resource. 






Transactions

View an items Demands, Procurements, Productions, Stock Transfers, Stock Adjustments, and Stock Pegs from the Transactions tab. 





  1. Demands, Procurements, Productions, and Stock Transfers have an Edit Mode toggle allowing you to edit column data. Click the Edit Mode toggle and select a column name, you can then edit the data with that column.







Demand

Name
Submitted
Description
End Time
Item
Expiry Date
Item Description
Status
Location
Is Feasible
Location Description
Short Fall Quantity
Customer
Late Fill Quantity
Customer Description
Priority
Demand Type
Expedite
Quantity
Earliest Fill Date
Need Time
Late Fill Time
Need Interval






Procurements

Name
Submitted
Description
Cost
Procurement Type
Supplier
Item
Label
Item Description
Start Delivery
Location
Delivery Time
Location Description
Order Date
Quantity





Productions

Name
Location Description
Description
Manufacturing Method
Production Type
Resource
Earliest Start Time
Scheduled
Need Time
Quantity
Order Type
Manufacturing
Item
Is Feasible
Item Description
Days Late
Location
Days Early




Stock Transfers

Name
Source Location Description
Description
Source Time
Is Feasible
Source Quantity
Earliest
Short Fall
Submitted
Late Fill
Transfer Cost
Dest Item
Transfer Type
Dest Item Description
Vehicle Type
Dest Location
Source Item
Dest Location Description
Source Item Description
Dest Time
Source Location
Dest Quantity




Stock Adjustments

Name
Location Description
Description
Quantity
Item
Time
Item Description
Age Days
Location






Violations

Making changes to the plan, will resolve violations as the plan comes into balance. The system will also recommend solutions to the violations. 

Clicking on the Violations icon in the Tree will launch a left hand panel displaying all of the planning diagnostics or violations for a particular stock item in location over the full planning horizon.





The violation screen shows different violations categorized by type.



S&OP Violations

S&OP violations are related to demand fulfillment and supply balancing with demand.








Supply Violations

Supply violations deal with a range of issues like late purchases, or if planned production is missing a component.





Inventory Violations

Inventory violations result in too much or too little inventory.









Demand Violations 

Demand violations show sales orders that are not consistent with historical patterns. For example, if a customer has ordered more than usual, or place an order for the first time in a while, the system will flag it and display the order as a demand violation. 




Summarize Violations

Click the Summarize button to use Arkieva AI to summarize the violations into actionable insights. 








Bottom Grid

The bottom Grid shows all Summary data, publish, views options, comments, optimize, manage backorders, sales opportunities, and right-click options.




Publish




Views

  1. Toggle on or off the data in the grid from the Views dropdown. You can also reorder the data by clicking and dragging the data up or down. Click Apply to save changes.  









  1. Selections made in the Views dropdown will affect the Summary Grid as well.






Manage in Settings

  1. Click the Manage in Settings dropdown to access the Manage Views and Manage Planning Objects links. These links will take you to the S&OP Views Configuration Settings and the S&OP Planning Objects Settings tabs.











Time Period / Visible future time period

Click this dropdown to access different Time Period and Visible Future Time Period viewing options. 





Time Period:



Visible future time period: 




Units

Change how the data is viewed in Units. 










Compare

Switch between None, Official, or Budget view to compare different views of the data.



Comments

Toggle on or off the Comments with the toggle button. 



  1. You can create comments by right-clicking the desired cell in the grid and selecting Comments.





  1. Select a Data Range, and write a Comment Topic and Comment Text. You can optionally mark the comment as important by checking the Mark as Important box. Click Add Comment to create the comment and save it to the grid.




  1. The Comment drawer will launch and show the new comment. 




  1. You can also access this drawer from the Comment Icon that will appear when a comment has been created.





  1. Click the Settings button to access the Show my comments and Show comments with replies checkbox options. 




  1. Click the ellipses button to access the Open the comment in Collaboration or Planning Worksheet dropdown.






  1. Click on the comment to access the edit edit, mark as important, and delete options.






Transaction Details

Select Transactions Details from the right-click menu to view that attribute's:
  1. Order
  2. Due Date
  3. Quantity
  4. Status (View Violations)
  5. Quantity (On Time, Late, Lost Quantity)
  6. Revenue (Revenue, Revenue in Jeopardy, Lost Revenue)
  7. Edit, Evaluate, and Delete options 









Edit

Edit the Transaction Demand for that attribute.







Edit Purchase Transactions

Vendor and Contract fields are synchronized when editing Purchase Transactions. Vendor is editable when the Vendor Optimization module is not enabled. Selecting or changing a contract automatically updates the associated vendor.















Evaluate

Perform a What If scenario on a transaction by clicking the Evaluate link.





  1. Type a Quantity and select a Start Date for the Transaction, then click Evaluate to start the What If process.




  1. The Evaluate drawer will populate with Sales Revenue, Capacity Utilization, Demand Met, Monthly Inventory, and Demand Filled on Time data widgets by default.











  1. You can add more widgets by clicking the +Add Widget button.















Delete

Click Delete to launch the Confirm deletion popup. Click Cancel or Confirm. 





Create New Transactions

Create transactions for Procurement, Production, Transfer, Demand, and Substitutions. Right-click a data attribute in the table and select Create Transactions.















Optimize

From the Optimize dropdown, select Run MRP Engine, Run DRP Engine, Align Transfers, and View Log.






Run MRP Engine

The MRP engine uses the Bill of Materials to determine production and procurement requirements for intermediates and raw materials. It also looks at the Item Group capacity and to time phase production. 








Run DRP Engine

Select the items to optimize. The optimization engine will run on all related stocks.






DRP Order Priorities

DRP looks at the priority on the Sales Order line (or by extension allowing to put a priority on Forecast as well) to replenish the demand. Demand is replenished per time period (week), per priority (highest first).


















Sales Order Details





Align Transfers

Click to align transfers. A message will popup to confirm a successful or failed attempt to align transfers. 


View Log

View the Optimization Engine Activity log. Here you can view the transaction date, solution, algorithm, input calculation method, output total production created, total procurement created, and total transfers created data. You can also clear the activity log and delete transactions. 




DRP/MRP Configuration Isolation for Workflow Scheduling

This feature allows users to define and store one or more named configurations for MRP and DRP separately. Users can create, update, and delete named DRP/MRP configurations under Global Settings → Supply → DRP Configurations, MRP Configurations.

  1. Click Run MRP Engine to launch the MRP Engine window.




  1. Click Manage Configurations.





  1. Click +New to create a new MRP Configuration and launch the Add MRP Configuration drawer.







  1. Fill out the appropriate information in the Add MRP Configuration drawer, then click Save. The New MRP Configuration will appear in the MRP Configuration list.









  1. Go back to the planning worksheet, and launch Run MRP Engine, you can now select the new Configuration from the dropdown list. 






  1. You can also select the new configuration while running DRP by selecting Filter from selected DRP Configuration.







Manage Backorders

Manage Backorders allows you to include (Submit) or exclude (Unsubmit) Sales Backorders from planning logic, based on business preference or scenario.
  1. Submit: Sales Backorders are considered in planning by including sales backorders in start and end stock calculations (impact stock, but do not consume future forecast).
  2. Unsubmit: Sales Backorders are excluded from future forecast consumption by excluding sales backorders entirely from planning worksheet calculations (same as current behavior).
Arkieva recognizes sales backorders by using the following criteria:
  1. Order date < today
  2. Expiry date ≥ today
  3. Status = open





Sales Opportunities 








Vendor

DRP will consider a non-preferred vendor when the system cannot meet the demand with a preferred vendor. 

Example:
QL input (since we cannot visualize the vendors by stock table in Supply Inputs):
  1. As can be seen, supplier 2 has the preference, but a way longer lead time.
  2. Supplier 1 is not preferred, but way shorter lead-time. 



  1. Within lead-time of supplier 2, order with the non-preferred Supplier 1 to meet the demand.
  2. Outside the lead-time of supplier 2, order with the preferred supplier 2. 







    • Related Articles

    • Generate / Share View Link for Forecast Strategy, SOP Planning Worksheet, and Collaboration

      If making changes to Forecast Strategy, SOP Planning Worksheet, and Collaboration, and you would like to share these changes with a colleague, you can click the Generate/Share View Link and send that URL to your colleague so they can view the ...

    • Ladder Planning

      The Ladder Planning tool is used in addition to the Planning Worksheet for customers who need to keep track of weekly cash register sales (POS sales), and to make sure inventory meets demand. The Ladder Plan only allows Item and Customer data to be ...

    • Planning Objects

      Manage the data objects available in S&OP from the Planning Objects section of the Settings module. Add New Planning Objects To add a new Planning Object for S&OP, first click the + Add New button. The Add Planning Object drawer will slide out. Under ...

    • Planning Period

      Global Data settings allow you to define custom periods with specific start and end dates and integrate this functionality within the collaboration and planning grids. In the collaboration and planning grids, users will be able to select from the ...

    • Planning Period

      Change the period that is displayed by default within the system. Change planning period start date To change the planning period start date, first selecting a beginning planning period from the dropdown. Then select a planning horizon strategy from ...