Average Costing to Standard Costing

> We too were unaware of the change in version 4.
> Please could you send me some more detail of how you changed the
> costing
> method using the Macro.
> Thanks
> Sophie
>
[Plaman Dick]
You can find the macro @ www.unisyn.com
the application is called Automate.
What you do is create a text file with your part numbers and
copy from it,
paste the part number in the part maintenance panel and then
apply the appropriate keystrokes to tab down and change the cost
method flag. It's pretty user friendly.
>
My superiors want to convert from Average Costing to Standard Costing at the fiscal year. I don't even know where to begin thinking and looking to find what kind of trouble I'm going to get into. We are currently running 3.0, evaluating 4.0 on the side.

Troy Funte
Liberty Electronics



[Non-text portions of this message have been removed]
Well we did it!! And I have to tell you that there is not enough paper in
this world to write all of the problems that occurred. My payroll/AR person
says you should consider investing in Rogain because your hair is going to
fall out in clumps

My question to your superiors would be, "why are you considering this
change?" Do you manufacture to stock or customer order? Do you have
approved methods of manufacture in place? Do you have accurate operation
standards? Vantage added standard costing as an after thought and as a
result many of the tools that are needed to analyze wip variances do not
exist. For example, there is no wip variance report explaining what the wip
variances consist of and why (I created my own in excel). Vantage has no
report advising what impact a standard cost change will have on the value of
inventory until after the roll up is complete. How do you capture your
labor? If you are using data collection do your employees clock in and out
properly, and log quantities accurately? Do you run big jobs with few
setups, or a lot of small jobs? Do you make the same parts repetitively or
continually make new parts? If you have varying production quantities the
part lot size will need maintained. Do you have a part numbering system?
Do you link jobs to sales orders? Do your employees know how to build to
stock, inspect, and ship from stock?

Our company always shipped from WIP and had no clue how to manufacture or
ship from stock. Our QA department still certs the order and not the job.
Our operation standards are not accurate but were entered to get Vantage up
and running quickly. We had no approved methods of manufacture because they
were unnecessary with an average cost system when the parts shipped from
WIP. Our parts master had eleven thousand parts that needed changed from
average to standard, eight thousand that were manufactured parts needing
ABOMs. Changing to standard in company configuration does not change it
globally, it must be done manually or a program written to uncheck average
and populate the standard field. Lot sizes need analyzed and determined or
the standard cost is the cost of manufacturing one part, which may or may
not be correct. Vantage allows purchase orders to be created and received
for parts without a standard cost. Jobs can get opened, manufactured to
stock, and the parts shipped without having an approved method of
manufacture and consequently a zero cost. I run queries every day to inform
me of any purchase orders open for parts with no standard cost, and of any
open jobs for parts without an approved method of manufacture or lot size.
The list goes on.

After all of that, all I can say is to think this out carefully. Our
experience does not need to be your experience. I don't know when your
fiscal year ends, and how many parts are in your part master, but this is
going take a lot of planning, possibly training, and a ton of work. Set a
realistic date for full implementation. Definitely upgrade to V4 and it is
my understanding that Cairo will have changes to the standard cost program.

Kathleen Harrington
SPS Non-Ferrous



-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, September 08, 2000 2:13 PM
To: Vantage
Subject: [Vantage] Average Costing to Standard Costing


My superiors want to convert from Average Costing to Standard Costing at the
fiscal year. I don't even know where to begin thinking and looking to find
what kind of trouble I'm going to get into. We are currently running 3.0,
evaluating 4.0 on the side.


Troy Funte
Liberty Electronics



[Non-text portions of this message have been removed]


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
We just went from Standard to Average in the past month. We changed
over in Vantage 3.0 because we found
that in Vantage 4.0, you cannot change cost methods when you have an
onhand balance. With about 13,000
part headers, we realized that if we were going to change, we needed to
do it right away. It went well with the
assistance of a macro. I started it on Friday night and it finsihed up
about 8 hours later.

We were on standard cost for 4 years and because costs are variable and
dynamic, individuals had to manually
modify costs from time to time. We know that the average costing
methods computes a new unit cost when
a receipt is processed, so we watch the receipts closely. Much less
work!

Just be advised of the change in V4. If you are going to change, and
have parts with on hand balances, you would
save yourself a lot of work by doing it before you migrate. Good luck.
We too were unaware of the change in version 4.
Please could you send me some more detail of how you changed the costing
method using the Macro.
Thanks
Sophie

-----Original Message-----
From: Plaman Dick [SMTP:dick.plaman@...]
Sent: Friday, September 15, 2000 12:50 PM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Average Costing to Standard
Costing


http://click.egroups.com/1/8974/13/_/411782/_/969047252/

http://adimg.egroups.com/img/8974/13/_/411782/_/969047252/WarningCollect
ibles468x602E.gif
eGroups My Groups <http://www.egroups.com/mygroups> | vantage
Main Page <http://www.egroups.com/group/vantage> | Start a new group!
<http://click.egroups.com/1/8150/13/_/411782/_/969047252/>


We just went from Standard to Average in the past month. We
changed
over in Vantage 3.0 because we found
that in Vantage 4.0, you cannot change cost methods when you
have an
onhand balance. With about 13,000
part headers, we realized that if we were going to change, we
needed to
do it right away. It went well with the
assistance of a macro. I started it on Friday night and it
finsihed up
about 8 hours later.

We were on standard cost for 4 years and because costs are
variable and
dynamic, individuals had to manually
modify costs from time to time. We know that the average
costing
methods computes a new unit cost when
a receipt is processed, so we watch the receipts closely. Much
less
work!

Just be advised of the change in V4. If you are going to
change, and
have parts with on hand balances, you would
save yourself a lot of work by doing it before you migrate.Â
Good luck.


We no longer allow attachments to files. To access/share Report
Files, please go to the following link:Â
http://www.egroups.com/files/vantage/
(Note:Â If this link does not work for you the first time you
try it, go to www.egroups.com, login and be sure to save your password,
choose My Groups, choose Vantage, then choose Files. If you save the
password, the link above will work the next time you try it.)