Subcontracting Troubles

Yahoo Archive
1
Thanks for your input Scott! We will give it a try.

Josh Serwe
Wisconsin Converting Inc.
Production Planning
(920)437-6400 x 327 My extension changed!

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Scotty K.
Sent: Tuesday, January 28, 2014 7:55 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Subcontracting Troubles


The checkbox will break up the cost elements(labor, burden, material, material burden and subcontract) for materials pulled into a job, instead of totalizing the cost in material.
It also works in Quoting(worksheet) which comes in handy when we are building complex methods.

Scott

On Mon, Jan 27, 2014 at 10:27 PM, Joshua Giese <jgiese@...<mailto:jgiese@...>> wrote:


9.05.700B. What does that checkbox do? I will confirm tomorrow if it is checked or not.

Sent from my Atari 600

-----Original Message-----
From: Scotty K [scottyk537@...<mailto:scottyk537@...>]
Received: Monday, 27 Jan 2014, 21:20
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>]
Subject: Re: [Vantage] Subcontracting Troubles

What version are you on?
In company config | modules | production | job, there is a checkbox called "enable mfg cost elements".
I believe this functionality was added in 607?

Scott

Sent from my iPhone.

On Jan 27, 2014, at 7:26 PM, <jgiese@...<mailto:jgiese@...>> wrote:

Here is a challenge for all of you production gurus... anyone care to show their prowess? Give this process a shot and see if you can come up with something.

Multi Job Part Subcontract Job
We send Part A (76" Roll of paper) out to a subcontractor to tint. The subcontractor sends it back as Parts B (13.25" roll), C (17.75" roll), D (24.75" roll), E (30.25" roll) & F (34.75" roll). We need the Average costing to split evenly across one UOM (pounds) that is used for all lot tracked parts going into inventory. We enter the material & labor cost factors to match the actual pounds going to inventory. We use a similar process for jobs that we do in house with labor instead of subcontract and the costing comes out.

Here is our current process:
Create a job for Part B at a quantity of 1,100 lbs. (2 lots)
Add a job part for Part C at a quantity of 1,300 lbs. (2 lots)
Add a job part for Part D at a quantity of 2,250 lbs. (3 lots)
Add a job part for Part E at a quantity of 2,550 lbs. (3 lots)
Add a job part for Part F at a quantity of 1,900 lbs. (2 lots)
Add the subcontract operation
Add the raw material Part A at a quantity of 9,200 lbs. at a cost of $0.45/lb (there is waste... we'll just say 100 lbs for this one)
PO is entered for Parts B, C, D, E & F all separate lines linked to each job part at a cost of $0.75/lb
Raw material is issued
PO Receipt is processed
Job Receipt to Inventory is processed

Our desired result is that each job part ends up with a Unit cost of $1.205/lb (Material cost of $0.455/lb & Subcontract cost of $0.75/lb)




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

Here is a challenge for all of you production gurus… anyone care to show their prowess? Give this process a shot and see if you can come up with something.

 

Multi Job Part Subcontract Job

We send Part A (76” Roll of paper) out to a subcontractor to tint. The subcontractor sends it back as Parts B (13.25” roll), C (17.75” roll), D (24.75” roll), E (30.25” roll) & F (34.75” roll). We need the Average costing to split evenly across one UOM (pounds) that is used for all lot tracked parts going into inventory. We enter the material & labor cost factors to match the actual pounds going to inventory. We use a similar process for jobs that we do in house with labor instead of subcontract and the costing comes out.

 

Here is our current process:

Create a job for Part B at a quantity of 1,100 lbs. (2 lots)

Add a job part for Part C at a quantity of 1,300 lbs. (2 lots)

Add a job part for Part D at a quantity of 2,250 lbs. (3 lots)

Add a job part for Part E at a quantity of 2,550 lbs. (3 lots)

Add a job part for Part F at a quantity of 1,900 lbs. (2 lots)

Add the subcontract operation

Add the raw material Part A at a quantity of 9,200 lbs. at a cost of $0.45/lb (there is waste… we’ll just say 100 lbs for this one)

PO is entered for Parts B, C, D, E & F all separate lines linked to each job part at a cost of $0.75/lb

Raw material is issued

PO Receipt is processed

Job Receipt to Inventory is processed

 

Our desired result is that each job part ends up with a Unit cost of $1.205/lb (Material cost of $0.455/lb & Subcontract cost of $0.75/lb)

3
What version are you on?
In company config | modules | production | job, there is a checkbox called "enable mfg cost elements". 
I believe this functionality was added in 607?

Scott

Sent from my iPhone. 

On Jan 27, 2014, at 7:26 PM, <jgiese@...> wrote:

 

<div id="ygrps-yiv-158431536ygrp-text">
  
  
  <p></p><p class="ygrps-yiv-158431536MsoNormal"><span style="color:#1F497D;">Here is a challenge for all of

you production gurus… anyone care to show their prowess? Give this process a shot and see
if you can come up with something.

 

Multi Job Part Subcontract Job

We send Part A (76” Roll of paper) out to a subcontractor to tint. The subcontractor sends it back as Parts B (13.25” roll), C (17.75” roll), D (24.75” roll), E (30.25” roll) & F (34.75” roll). We need the Average costing to split evenly across one UOM (pounds) that is used for all lot tracked parts going into inventory. We enter the material & labor cost factors to match the actual pounds going to inventory. We use a similar process for jobs that we do in house with labor instead of subcontract and the costing comes out.

 

Here is our current process:

Create a job for Part B at a quantity of 1,100 lbs. (2 lots)

Add a job part for Part C at a quantity of 1,300 lbs. (2 lots)

Add a job part for Part D at a quantity of 2,250 lbs. (3 lots)

Add a job part for Part E at a quantity of 2,550 lbs. (3 lots)

Add a job part for Part F at a quantity of 1,900 lbs. (2 lots)

Add the subcontract operation

Add the raw material Part A at a quantity of 9,200 lbs. at a cost of $0.45/lb (there is waste… we’ll just say 100 lbs for this one)

PO is entered for Parts B, C, D, E & F all separate lines linked to each job part at a cost of $0.75/lb

Raw material is issued

PO Receipt is processed

Job Receipt to Inventory is processed

 

Our desired result is that each job part ends up with a Unit cost of $1.205/lb (Material cost of $0.455/lb & Subcontract cost of $0.75/lb)

</div>
4

9.05.700B. What does that checkbox do? I will confirm tomorrow if it is checked or not.



Sent from my Atari 600



-----Original Message-----

From: Scotty K [scottyk537@…]

Received: Monday, 27 Jan 2014, 21:20

To: vantage@yahoogroups.com [vantage@yahoogroups.com]

Subject: Re: [Vantage] Subcontracting Troubles



 

What version are you on?
In company config | modules | production | job, there is a checkbox called "enable mfg cost elements". 
I believe this functionality was added in 607?

Scott

Sent from my iPhone. 

On Jan 27, 2014, at 7:26 PM, <jgiese@...> wrote:

 

Here is a challenge for all of you production gurus… anyone care to show their prowess? Give this process a shot and see if you can come up with something.

 

Multi Job Part Subcontract Job

We send Part A (76” Roll of paper) out to a subcontractor to tint. The subcontractor sends it back as Parts B (13.25” roll), C (17.75” roll), D (24.75” roll), E (30.25” roll) & F (34.75” roll). We need the Average costing to split evenly across one UOM (pounds) that is used for all lot tracked parts going into inventory. We enter the material & labor cost factors to match the actual pounds going to inventory. We use a similar process for jobs that we do in house with labor instead of subcontract and the costing comes out.

 

Here is our current process:

Create a job for Part B at a quantity of 1,100 lbs. (2 lots)

Add a job part for Part C at a quantity of 1,300 lbs. (2 lots)

Add a job part for Part D at a quantity of 2,250 lbs. (3 lots)

Add a job part for Part E at a quantity of 2,550 lbs. (3 lots)

Add a job part for Part F at a quantity of 1,900 lbs. (2 lots)

Add the subcontract operation

Add the raw material Part A at a quantity of 9,200 lbs. at a cost of $0.45/lb (there is waste… we’ll just say 100 lbs for this one)

PO is entered for Parts B, C, D, E & F all separate lines linked to each job part at a cost of $0.75/lb

Raw material is issued

PO Receipt is processed

Job Receipt to Inventory is processed

 

Our desired result is that each job part ends up with a Unit cost of $1.205/lb (Material cost of $0.455/lb & Subcontract cost of $0.75/lb)

5
We are on V.8.03, but here is an idea:

Set each of your final materials (B-F) to standard costs
Do Cost Adj. for each of the parts to what you want to see

Purchase and issue Part A as normal
Create a Job for one of the parts B-F. (Say part B).
Receive Part B
Change Job's Part Number to Part C
Receive Part C
Etc..

Any variations in cost will be caught and washed to mfg-var when the job closes. These should be minimal if the costs on this process does not change much. Not as elegant as a checkbox, but an idea if the checkbox doesn't work.



Sent from my ColecoVision
________________________________________
From: vantage@yahoogroups.com [vantage@yahoogroups.com] On Behalf Of Joshua Giese [jgiese@...]
Sent: Monday, January 27, 2014 10:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Subcontracting Troubles


Here is a challenge for all of you production gurus… anyone care to show their prowess? Give this process a shot and see if you can come up with something.

Multi Job Part Subcontract Job
We send Part A (76” Roll of paper) out to a subcontractor to tint. The subcontractor sends it back as Parts B (13.25” roll), C (17.75” roll), D (24.75” roll), E (30.25” roll) & F (34.75” roll). We need the Average costing to split evenly across one UOM (pounds) that is used for all lot tracked parts going into inventory. We enter the material & labor cost factors to match the actual pounds going to inventory. We use a similar process for jobs that we do in house with labor instead of subcontract and the costing comes out.

Here is our current process:
Create a job for Part B at a quantity of 1,100 lbs. (2 lots)
Add a job part for Part C at a quantity of 1,300 lbs. (2 lots)
Add a job part for Part D at a quantity of 2,250 lbs. (3 lots)
Add a job part for Part E at a quantity of 2,550 lbs. (3 lots)
Add a job part for Part F at a quantity of 1,900 lbs. (2 lots)
Add the subcontract operation
Add the raw material Part A at a quantity of 9,200 lbs. at a cost of $0.45/lb (there is waste… we’ll just say 100 lbs for this one)
PO is entered for Parts B, C, D, E & F all separate lines linked to each job part at a cost of $0.75/lb
Raw material is issued
PO Receipt is processed
Job Receipt to Inventory is processed

Our desired result is that each job part ends up with a Unit cost of $1.205/lb (Material cost of $0.455/lb & Subcontract cost of $0.75/lb)
6
The checkbox will break up the cost elements(labor, burden, material, material burden and subcontract) for materials pulled into a job, instead of totalizing the cost in material.
It also works in Quoting(worksheet) which comes in handy when we are building complex methods.
 
Scott


On Mon, Jan 27, 2014 at 10:27 PM, Joshua Giese <jgiese@...> wrote:

  
<div>
  
  
  <p>

9.05.700B. What does that checkbox do? I will confirm tomorrow if it is checked or not.



Sent from my Atari 600



-----Original Message-----

From: Scotty K [scottyk537@…]

Received: Monday, 27 Jan 2014, 21:20

To: vantage@yahoogroups.com [vantage@yahoogroups.com]

Subject: Re: [Vantage] Subcontracting Troubles



 

What version are you on?
In company config | modules | production | job, there is a checkbox called "enable mfg cost elements". 
I believe this functionality was added in 607?

Scott

Sent from my iPhone. 

On Jan 27, 2014, at 7:26 PM, <jgiese@...> wrote:

 

Here is a challenge for all of you production gurus… anyone care to show their prowess? Give this process a shot and see if you can come up with something.

 

Multi Job Part Subcontract Job

We send Part A (76” Roll of paper) out to a subcontractor to tint. The subcontractor sends it back as Parts B (13.25” roll), C (17.75” roll), D (24.75” roll), E (30.25” roll) & F (34.75” roll). We need the Average costing to split evenly across one UOM (pounds) that is used for all lot tracked parts going into inventory. We enter the material & labor cost factors to match the actual pounds going to inventory. We use a similar process for jobs that we do in house with labor instead of subcontract and the costing comes out.

 

Here is our current process:

Create a job for Part B at a quantity of 1,100 lbs. (2 lots)

Add a job part for Part C at a quantity of 1,300 lbs. (2 lots)

Add a job part for Part D at a quantity of 2,250 lbs. (3 lots)

Add a job part for Part E at a quantity of 2,550 lbs. (3 lots)

Add a job part for Part F at a quantity of 1,900 lbs. (2 lots)

Add the subcontract operation

Add the raw material Part A at a quantity of 9,200 lbs. at a cost of $0.45/lb (there is waste… we’ll just say 100 lbs for this one)

PO is entered for Parts B, C, D, E & F all separate lines linked to each job part at a cost of $0.75/lb

Raw material is issued

PO Receipt is processed

Job Receipt to Inventory is processed

 

Our desired result is that each job part ends up with a Unit cost of $1.205/lb (Material cost of $0.455/lb & Subcontract cost of $0.75/lb)

</div>
 


<div style="color:rgb(255,255,255);min-height:0px;"></div>