Solved

Cost Set 2 inventory value break

  • 10 May 2021
  • 4 replies
  • 212 views
R
Rank
Userlevel 2
Badge +5

We have a user that is updating Cost set 2 monthly and would like to be able to see a break of Material, Labor and OH for Cost Set 2.  The inventory value report is reporting on CS1 only, and the Inventory Simulation only shows the rolled up costs for manufactured parts.

Is there any other reports we could use to get CS2 inventory value that breaks out Material, Labor and OH?  We would really like to be able to run the Inventory value report using the different Cost sets.

 

We are running APPS 9.

Rob

 

 

icon

Best answer by Tharindu Illangasinghe 11 May 2021, 11:00

View original
This topic has been closed for comments

4 replies

Rasika Lakmal
Rank
Userlevel 7
Badge +17

@rcanning Could you please check whether “Part Cost History ” window works for you?

 

 

Rasika Lakmal
R
Rank
Userlevel 2
Badge +5

Hi Rasika

Thank you for your quick response; however the Part Cost History window will not work in this case.

Our user would like to run an Inventory Simulation for Cost set 1 vs cost set 2, and be able to see the cost break out for Manufactured parts.  This would tell the user what is driving the cost differential, is it material costs, is it labor costs from changing the routings. Right now they would have to look at manufactured part, that had a cost difference, to see if it is a material price increase, or if it is driven by changes to the routings which would effect labor and OH costs.  We are using Standard Cost, and only updating labor and OH rates once a year.

 

Rob

 

Tharindu Illangasinghe
Rank
Userlevel 6
Badge +13

Hi @rcanning ,

 

If you want to view the detail breakdown of the CS2 you can use the Part Cost window.

Search for Part No and Cost Set “2”. Highlighted value will be the Unit Cost once this CS is copied to CS1

 

However, I believe what you are looking for is a way to compare CS1 vs. CS2. So, you can identify what costs has been changed now. For that, you can use “Part Cost Bucket Variance” window.

The yellow highlighted values can be taken as the possible Unit Cost. There you can see a difference (1105 vs 1145) between two CSs. Now, using this window user can identify how that difference has come up.  Note that Labor Overhead Cost bucket is no longer there in the CS2 (highlighted in Red at CS1).Additionally, the Delivery OH too has been increased in the CS2 now (highlighted in Blue). Such changes can be observed here.

However, if you want a high-level comparison between two CSs then you can use below windows as well.

 

Lot more columns are there if you scroll to right hand side

 

 

Last but not least, you can use the below report as well. But you will have to get two reports, one for CS1 and another for CS2, then compare the changes manually. 


:slight_smile:

Best Regards, Tharindu Illangasinghe, https://www.linkedin.com/in/tharindubi/
R
Rank
Userlevel 2
Badge +5

Hi @Tharindu Illangasinghe 

Our user found the Part Cost Variances window helpful, thank you very much.

Regards,

Rob

 

Terms & ConditionsCookie settings