Re: Surcharge question -- MAPICS-L

Hi Joan,

We use price books in COM. With pricebooks, you are able to use percentages or amounts on item level. I suppose you can make a baseprice for the item, based on 100% material cost and normal overhead, margin etc.

As long as the marerial index is 100, the amount to add is 0. if it rises, you can put a positive amount in the book and if it is going down a negative.......

I hope this will help,

Best,

Lucas

At 08:53 16-07-03 -0500, you wrote:

To all -

Our sales department came to me with an interesting question. We manufacture
stainless steel parts. Metals prices fluxuate constantly, and at the moment
certain raw materials are fluxuating enough that we need to make a sales
price increase to compensate. We need to track a "metal surcharge" per item
to reflect this fluxuation (updated annually, unless a given material
increases significantly in the shorter term).

Example: part XYZ sells for $125, but we need to add $10 to the price to
cover the increase in raw materials used to make the alloy. The customer
order, therefore, is for $135 each. How/where do we track historically that
the part sells for $125 and the metal surcharge is $10. I.e. how can we tell
if an historic sale price increase is due to raw materials increases (which
we can't control), or due to manufacuring & overhead increases (which we can
control), or both (i.e. metal surcharge is $10 and actual price increase is
$5, raising price from $125 each to $140 each; in the future, raw material
prices drop so we don't need the surcharge - sale price drops from $140 to
$130, keeping the actual price increase).

Any suggestions? We have one customer who wants to see these surcharges, so
we have a separate CO line item for the metal surcharge per part (i.e. they
order 10 items, we issue a CO with 20 line items - first the part for $125,
then that part's surcharge ($10), then the next part ($250), then its
surcharge ($15), etc.) However, most customers want to see a single line
item for (using example) $135 each... I know we can't be the only company
having to track this information, so I look forward to your collective
wisdom / experience.

Thanks as always - Joan

Joan McCready, IS Manager      phone:  636-479-4499
MetalTek International               fax:  636-479-3399
The Carondelet Division             www.metaltekint.com
<www.metaltekint.com>
8600 Commercial Blvd
Pevely, MO  63070

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.


www.viva-lancia.com
Best Regards,
                Lucas

A good player makes himself look good;
a great player makes the team look good.

L. Geheniau M.I.S. supervisor / Logistic Engineer Tokheim Corp. Industrieweg 5, 5531 AD Bladel The Netherlands Fax: +31497381950 e-mail: geheniau@xxxxxxxxxxxxxxxxxx l.geheniau@xxxxxxxxx sms: No phone! 0615026840