Design Your System – Questionnaire & Quotation Request

To fully understand the questions, please watch the P-S Cycles presentation , and then read explanations of the features of Excel supply chain management systems.

Please download the model system data layout , populate it with as much of your own data as you can, and email it to us. We will run the P-S Cycles model system with your data, and send you the results.

Do you want to:
Print the 9 page explanation now (Right-click link and choose "Print Target")
Download as a Word document (Right-click link and choose "Save Target As....")
Download as a PDF file
Read the explanations on the screen as you complete the questionnaire ....

Name: Company:
Phone No.: Email:

Type of products you manufacture:
Details of your existing ERP/MRP system:
Brief description of your manufacturing process:
1. Do you make finished products before you have an order from a customer?
Click for more information 		Do you make any semi-finished products before you have an order?
If you have left both these questions unchecked, then you are a make-to-order manufacturer, so please skip to section 22.
MAKE TO INVENTORY
  Do you have a sales forecast for each finished product? Do you use sales history as a forecast?
    Is the forecast in periods of :    
     
 

     
 


   
2. Do you want a forecast accuracy measurement system?
 Is actual demand (rather than invoiced sales) in a host system?
3. Do you need a demand calendar?    
4. Do you need a demand profile?    
5. Do you want to split monthly forecasts into weeks?    
6.

   
     
7.
 
8. Do you have forecast consumption rules? If so:
   Example 1?
        Example 2?
9.    
     
     
10.   What is the most appropriate unit to express inventory cover in:
   
11.   Do you want to express min/max inventory policy in:
   
12. Do you currently use TOC style Drum-Buffer-Rope?    
13. Do you want an inventory cover report?
 Do you also want inventory variance from policy, in dollars?
14. Are there some make-to-order products?    
15. Do you hold inventory at regional depots or retail outlets? Do you want a distribution plan with products to be sent to depots now?
16. Do you want a distribution plan with products to be sent to depots in the future?
17. Do you need to manage inventory of finished products with MPS? Do you have a buffer of semi-finished products that needs to be managed?
18. Do you want to manufacture products with lowest cover first?    
19. Do you want to see ideal vs. achievable inventory reported?    
20. Do you want projected inventory value reported?    
21. Do you want to manage inventory on your customer's premises?    
         
MATERIAL REQUIREMENTS PLANNING (MRP1)
22. Is there just one work centre for each finished product? Are products made from manufactured sub-assemblies?
      Do products and/or sub-assemblies go through more than one work centre?
23. Does the BOM have more than one level? Does the BOM data reside in a host system?
24. Is each level of the BOM in a separate table?
    
25. Do you hold manufactured sub-assemblies in inventory?    
26. Is dynamic re-allocation of inventory appropriate for your business?
27. Is there a record of materials in work-in-progress?    
28. Do you have an existing MRP system with pegging?    
         
PURCHASING
29.   Do you want to maintain purchase order records in:
   
30. Do you want a purchase action report?    
31. Do you want purchase exception reports?    
         
CAPACITY PLANNING
32.   Do you want to maintain routing data in:    
33.   How Is your manufacturing process constrained?:
   
34.   Do you want the system to consider:    
35. are there opportunities for a rule based BOM? are there opportunities for rule based routings?
36. Do you have inventory of semi-finished products?    
37. Do you want capacity planning charts?    
38. Do you want variable sized capacity time buckets?    
39.

   
     
40. Should change over or set up times be considered?    
41. Do you want to apply lead time offsets for capacity planning?    
42. Do you want to use closed loop MRP    
43.   What is an appropriate planning horizon?    
44.   What is an appropriate horizon for reports?    
         
FINITE SCHEDULING
45. Do you want to use finite scheduling?    
If the answer to question 45 is unchecked, then proceed to the end. If checked, then continue
46. Does the logic "the next job can start when the previous job stops" apply?
47.   What hours do all work centres work:    
48. Do products pass through more than one work centre?    
49. Are more than one manufactured components assembled together?
50. Do you have multi-machine work centres?    
51. Do you have transfer batches?    
52. Do you want to apply pull scheduling?    
53. Do you have seasonal demand?    
54. Do you want a change over or set up matrix?    
55. Do you want to manually change the sequence at a work centre? Do you want to manually re-assign work to an alternative work centre?
56. Do you have works orders or manufacturing orders in a host system? Do you want the system to "remember" the manually changed sequence?
      Do you want the system to "remember" alternative work centres?
57.

   
     
         
58. Would you prefer to capture a WIP count?    
59. Do you want to track actual production against a snapshot of the sc