Posts Tagged ‘manufacture’

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.