|
midrange.com
Bob,
We use standard cost, but only revalue inventory once a quarter. We have
the I/M-G/L interface turned off (waaaaay too many entries!). We wrote our
own inventory valuation reports to conform to the requirements of our
accounting group. Summaries print to the accountant, details goes to our
optical storage system (LaserVault).
For our standard product line (pop-up campers), we use unique part numbers
for all end products. However, for the Caravan (configurable via F&O), we
use a calculated standard cost based on a "standard" configuration (long
story, based on mutual agreement between Sales, Engineering, and
Accounting).
The issue I was talking about in my earlier posting was not related to
costing, but instead was relating to callouts being incorrect due to
effectivity dates.
Dale @ Fleetwood
"Bob Tenney"
<bobtenney@xxxxxxx To: "MAPICS ERP System
Discussion" <mapics-l@xxxxxxxxxxxx>
nk.net> cc:
Sent by: Subject: Re: Question on M/O's
from C/O's
mapics-l-bounces@x
idrange.com
05/20/2003 11:09
AM
Please respond to
MAPICS ERP System
Discussion
Dale, I realize the question about using feature and option costs for MO's
has come up before. Perhaps explaining things again would be helpful:
When you set up a standard cost for an item all movements in and out of
inventory are based on that standard. When you change an item's standard
cost you effectively revalue your inventory. MAPICS tracks standard cost
changes and automatically makes the G/L entries to record the revaluation.
If you used the COM-generated standard cost, you would be unintentionally
revaluing your inventory each time you put an item to stock. Trust me, your
auditors would go ballistic!
If you manufacture a feature and options item, MAPICS uses the COM BOM to
backflush material, labor, and overhead. Since the standard cost. Since
this
BOM differs from your engineering standard cost, it results in MO variances
which you can record, by cost element, in your general ledger. Bottom line,
the differences between F/O costs and engineering costs are recorded when
they happen--they are not lost.
There are several things you can do to get better standard costs for F/O
items:
(1) If the cost impact of F/O selection is so great that you are really
dealing with different items, then setting up different item numbers is the
way to go.
(2) When you create standards for F/O items, you can estimate the percent
of
products that use each F/O item and then have MAPICS calculate a standard
cost that reflects your weighting.
(3) You can use the COM files to generate reports that use the item's
actual
feature and option cost. Barring changes in your standards, these costs
should equal the engineering standard cost +/- the variances that MAPICS
records when it closes out the MO.
Bob Tenney
Bob Tenney Solutions, LLC
MAPICS - FRx - Presence - Crystal Reports
828-526-8976
Visit www.tenneypubs.com for books about
IFM, COM, G/L Interfaces
Info WorkPlace, Cost Accounting,
FRx, and PRESENCE
----- Original Message -----
From: <DaleGindlesperger@xxxxxxxxxxx>
To: <mapics-l@xxxxxxxxxxxx>
Sent: Tuesday, May 20, 2003 9:57 AM
Subject: Question on M/O's from C/O's
> Hello group!
>
> I'm hoping one of you has already had to deal with this situation and can
> help me. Here's the scenario.
>
> We produce one of our product lines (the Coleman Caravan travel trailer)
as
> make-to-order, configured using COM's Features and Options. That is more
> than adequate for our needs. The sales person goes through the order
form,
> and picks the options for the trailer. COM F&O builds a customer order
> bill of materials and costs it out. The order sits in queue until it is
> scheduled for production (there is no date assigned during COM order
> entry).
>
> When the trailer is going to be built and shipped (1.2 days on the line),
> the factory department scheduler releases the manufacturing order from
the
> customer order, standard MAPICS I/M order release feature. That takes
the
> COM open order bill of material and loads it to the MO bill of material.
I
> understands why MAPICS does it that way - the order has been costed using
a
> custom built product structure and that could be important for product
> costing. Incidentally, that is NOT an issue for us.
>
> The problem is that during the interim period between when the CO is
> entered, and the MO is launched, Engineering effectivity dates may (do)
> pass, and the MO bill of material is no longer accurate for production.
We
> use MDCC's automatic inventory backflush by operation (hundreds of
> components per operation, not practical to verify on the line), and we
are
> charging parts that are no longer used or available, and not charging
parts
> that are actually being used. An example would be if we change tire
> manufacturers. We charge out Company X's 14" tire, but actually put on
> Company Y's 14" tire. Instant Automatic Inventory Error!
>
> I need to have the bill of material rechecked for effectivity dates when
> the order is released to production from the customer order. The only
way
> I can think of is to have the factory department scheduler enter the MO
in
> I/M, and just use the S-number from the CO to have I/M order release
> rebuild the open order bill of material, then go in and add the CO#
> information after the order is released. (I could write something to do
> that automatically, I suppose).
>
> Have any of you on the thread had to deal with this? And have you come
up
> with a better idea?
>
> Thanks!
>
> Dale Gindlesperger
> IT Manager
> Fleetwood Folding Trailers, Inc.
>
>
> _______________________________________________
> 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.
>
>
_______________________________________________
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
