Introduction

IT IS VERY IMPORTANT TO NOTE THAT NOVTEL DO NOT AT ALL CRITICISE PASTEL PARTNER'S WAY OF MANUFACTURING, OR SAY THERE IS SOMETHING WRONG WITH PASTEL PARTNER.

 

THE WAY PASTEL WORKS, WORKS FOR MANY COMPANIES; OUR CLIENTS SIMPLY HAVE DIFFERENT NEEDS TO PASTEL PARTNER’S OFFERINGS.

 

PASTEL TAKES OUR CLIENTS 75% TO WHERE THEY WANT TO BE AS FAR AS MANUFACTURING IS CONCERNED.

 

TOGETHER NOVTEL AND PASTEL PARTNER CREATES THE PERFECT MANUFACTURING SOLUTION FOR EVERYONE TO ENJOY.

 

The instructions received from our clients were as follows:

 

1. Design module for Pastel Partner that manufacture at last cost.

 

            1.1 At the same time adjust selling prices of the manufactured goods as the mark-up % specified in the BOM (Bill Of Materials) in Pastel Partner.

1.2 Base the selling price calculation of the manufactured item on the sum of the last cost of the BOM.

1.3 Allow the manufacturing process to automatic transfer manufactured stock items to the deferent stores/branches in Pastel Partner.          

1.4 Adjust the inventory quantities according the BOM's defined quantities and store selection to complete the manufacturing process

     with the new Novtel Manufacturing  system.

           

2. Design system that automatically adjust shelf item's selling prices based on last cost of the purchased item.

 

2.1 Pastel's "Adjust Selling Prices" is not adequate because the adjustment requires manual Input form the user after GRN's (Goods Received Notes)

     are processed.

2.2 Each shelf item have 3 selling prices List A, B and C; each inventory category have different pre-set mark-up margins.

2.3 The mark-up margin for each inventory item needs to be recorded on the Pastel inventory master file showing the % mark-up for each price list.

2.4 For the mark-up margins the 3 Inventory Numeric user defined fields in Pastel are used to store the information.  

2.5 All purchased goods are received in a store we call this receiving store; the Pastel GRN's are done in this store as deliveries are received from

     suppliers.

2.6 All manufactured and shelf items are transferred form the receiving to the various stores we have.

2.7 Design a store transfer module that will adjust the selling price of each shelf item based on the mark-ups as described in note 2.2, 2.3 and 2.4

      above as stock transfer are done.

 

3. Referring to 2.2, 2.3 and 2.4 above design a system that will automatically populate the Inventory mark-up % to each

    of the 3 Inventory item's Numeric user defined fields;  allow this automatic % mark-up adjustment to be made per inventory category.

 

4. Design System to adjust stock on hand per inventory item to "0" quantity on hand with the click of one button;

    allow this adjust stock to "0"adjustment to be made per inventory category. This feature is to help with the take on of new stock balances at last cost.

 

Manufacture at last cost

Pastel can only manufacture at average cost. 

 

For the Novtel Manufacturing system to work the Bill of Materials item have to exist as an Inventory item in Pastel

the Lock BOM to this item and Update Selling Price tick boxes must be ticked as shown in the example below.

Each component of the Bill of Materials do have a average cost and last cost. Pastel's calculation of

average cost calculated as follows:

 

Total amount paid for the inventory item divided by the quantity purchased.

 

There is no periods or dates linked the calculation of Pastel Average Cost it is simply average of all transactions on the master file

for that specific inventory item over the period purchases were done by the system.

 

The Edit Bills of Materials screen of Pastel can show what the selling prices should be at last cost in the example below.

The only problem is that when the actual manufacturing process is done in Pastel the system will manufacture at average cost only.