ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Would this be a Make-From??
http://www.istechforum.com/YaBB.pl?num=1059513370

Message started by Mike@TEK on 07/29/03 at 15:16:10

Title: Would this be a Make-From??
Post by Mike@TEK on 07/29/03 at 15:16:10

A hypothetical to illustrate what we are doing wrong:

We have a work order for 10 dining tables (Parent item TABLE #9). BOM is
TABLE TOP #9 qty 1
TABLE LEG #9 qty 4
BRACKET #12 qty 8
WOOD SCREWS # 20 qty 16

1) We buy 100 leg blanks from ACME Wood with the item on the PO being LEG BLANK #5. PO Unit cost is $10.
2) Item LEG BLANK #5 is received into stock and then all 100 are sent to Joes LatheWorks (who finishes the product for us) via a negative inventory adjustment.
3) Concurrently, a PO is written to Joes Lathe Works for qty 40 (the total work order qty) of the finished product, item TABLE LEG #9. PO Unit Cost is $20.
4) We receive from Joes the qty 40 of TABLE LEG #9 into stock and turnaround to issue it to the dining table work order at $20 per unit.

So the problem is multiple. Most importantly I think, we are not capturing the $10 cost of the LEG BLANK #5 in the finished cost of the parent item TABLE #9. Our COGS dummy acct ends up getting debited $1000 for the negative adjustment of 100 units. We are also misusing the item TABLE LEG #9, putting it on the PO to Joes Lathe Works for the service of turning LEG BLANK #5 into TABLE LEG #9.

My questions then:
A) Would a type-M Make-From designation be proper for the TABLE LEG #9, with its BOM then being :
1) LEG BLANK #5
2) LEG FINISH #5 (a T-type item for the service of lathe, sanding and finishing services?

B) Other possible options in regard to item and/or BOM setup?
C) Anything else to be aware of as far as correcting inventory movement and subsequent G/L accts?

Thanks!
Mike

Title: Re: Would this be a Make-From??
Post by aricon on 07/29/03 at 16:05:15

The answer is Yes, this is most definitely a Make-From.

Title: Re: Would this be a Make-From??
Post by Lynn_Pantic on 07/29/03 at 16:42:25

Yes, it is a Make-From but you do not need the T item in the BOM, only the Leg Blank. The cost of the lathe work should be defined as the Outside Processing component of Standard cost for the type M finished leg and that cost will automatically pull into the PO to Joe's Lathwork.

When the PO from Joe's Lathework is received, the leg blanks will automatically be depleted from inventory and their cost rolled up into the finished leg cost which in turn is issued to the WO for the table.

Title: Re: Would this be a Make-From??
Post by Mike@TEK on 07/30/03 at 11:50:20

So step 1, the PO to ACME wood (item LEG BLANK #5) would stay the same, correct?

Then my PO to Joes Lathe Works would have the M-type item TABLE LEG #9 (it having one item on its BOM, LEG BLANK #5)? I assume that TABLE LEG#9 would stay on the work order BOM.

On the PO to Joes, why wouldn't I write the PO unit cost for $20? I don't understand what the standard cost has to do with it, except when we wanted to enter partial completions of the parent TABLE #9 into finished production and wanted more accurate top-level standard costs. If the costs of the lathe/finishing work flucuates, a lot of manual maintenance. What would the PO cost be then?

Title: Re: Would this be a Make-From??
Post by Lynn_Pantic on 07/30/03 at 13:43:20

Yes, you can enter the PO to Joe's and manually enter the $20 price. If you enter it into the standard cost screen it will pull into the PO automatically, that's all. And will also correctly roll up into the total table standard cost.

But if the cost of the lathe work fluctuates, then yes, manually entering the cost might be less work. In any event, the actual cost of the table will refect what is entered on the PO, not the standard.