on 08-11-2015 2:34 PM
We have an issue where some process orders are calculating mixed prices variances and false variances. This data is false and cannot stay on our books. There are other miscalculations that we cannot figure out root cause for. We are at the point where we want to do an entry to send the resulting variance calculationg on a process order back to the account where it originated. Does anyone know how this would be done?
60515916 Production Variance Clearing is the variance cost element and we are on standard cost.
Thanks.
This revolves around the mixed price variance. We have exhausted all options in finding an error in the master data. The quantity multiplied by the standard price is the actual amount, however, this mixed price variance shows up on this process order and creates a huge variance. There are no items in our BOMs to justify a mixed price variance. We need to have a work around to correct this "false variance."
Cost Elem. | Cost Element (Text) | Origin | Material (Text) | Target qty | Actual Qty | Total tgt | Ttl actual | Variance | Variance | Crcy | Qty var. | Price Var. | MxdPrcVar | |
60515916 | Production Variance Clearing | 0 | -14,894.38 | -14,894.38 | 0 | USD | 0 | 0 | 0 | |||||
0 | -14,894.38 | -14,894.38 | 0 | USD | 0 | 0 | 0 | |||||||
60515909 | Finished Goods Reclass | 2100/908717 | OXYCODONE BASE PURE WETCAKE, POB3 | -477.6 | -477.6 | -422,755.64 | -422,757.19 | -1.55 | -389,014.85 | USD | 0 | 0 | -389,013.30 | |
60515913 | Consumption Issues, Actives Affiliates | 2100/2070 | Acetic Acid, 56%, Bulk | 0 | 171.08 | 0 | 148.84 | 148.84 | 148.84 | USD | 0 | 0 | 0 | |
60515913 | Consumption Issues, Actives Affiliates | 2100/2088 | Sodium Hydroxide, 18% | 0 | 320.38 | 0 | 176.21 | 176.21 | 176.21 | USD | 0 | 0 | 0 | |
60515913 | Consumption Issues, Actives Affiliates | 2100/2089 | Sodium Metabisulfite | 0 | 4 | 0 | 14.56 | 14.56 | 14.56 | USD | 0 | 0 | 0 | |
60515913 | Consumption Issues, Actives Affiliates | 2100/2180 | Sodium Hydrosulfite | 0 | 1.8 | 0 | 5.6 | 5.6 | 5.6 | USD | 0 | 0 | 0 | |
60515913 | Consumption Issues, Actives Affiliates | 2100/2284 | Catalyst, Palladium/Carbon | 0 | 5.9 | 0 | 1,042.35 | 1,042.35 | 1,042.35 | USD | 0 | 0 | 0 | |
60515913 | Consumption Issues, Actives Affiliates | 2100/2307 | Sodium Hypophosphite | 0 | 10 | 0 | 75 | 75 | 75 | USD | 0 | 0 | 0 | |
60515913 | Consumption Issues, Actives Affiliates | 2100/2103 | Isopropanol, 99%, Bulk | 0 | 429.878 | 0 | 700.7 | 700.7 | 700.7 | USD | 0 | 0 | 0 | |
60515913 | Consumption Issues, Actives Affiliates | 2100/1396 | 1-Butanol, Bulk | 0 | 1,127.33 | 0 | 2,389.94 | 2,389.94 | 2,389.94 | USD | 0 | 0 | 0 | |
60515913 | Consumption Issues, Actives Affiliates | 2100/1401 | JJPac - FIBC-700 L | 0 | 2 | 0 | 236.38 | 236.38 | 236.38 | USD | 0 | 0 | 0 | |
60515913 | Consumption Issues, Actives Affiliates | 2100/1402 | JJPac - FIBC-185 L | 0 | 2 | 0 | 298.78 | 298.78 | 298.78 | USD | 0 | 0 | 0 | |
60515913 | Consumption Issues, Actives Affiliates | 2100/1440 | Encapsulated Carbon Filter 16 in, Teflon | 0 | 8 | 0 | 3,976.40 | 3,976.40 | 3,976.40 | USD | 0 | 0 | 0 | |
60515915 | Cons Issues, WIP | 2100/906322 | nOxycodone, Base, Crude, NCOB | 0 | 505.4 | 0 | 398,583.72 | 398,583.72 | 398,583.72 | USD | 0 | 0 | 0 | |
Material | -422,755.64 | -15,108.71 | 407,646.93 | 18,633.63 | USD | 0 | 0 | -389,013.30 | ||||||
95002041 | Machine Hours | -2,617,423.57 | 0 | 2,617,423.57 | 0 | USD | 0 | 0 | -2,617,423.57 | |||||
95002041 | Machine Hours | 19066/MACH | 25.255 | 22.3 | 33,742.34 | 30,003.09 | -3,739.25 | -3,739.25 | USD | -3,948.07 | 208.82 | 0 | ||
Overhead | -2,583,681.23 | 30,003.09 | 2,613,684.32 | -3,739.25 | USD | -3,948.07 | 208.82 | -2,617,423.57 | ||||||
-3,006,436.87 | 0 | 3,006,436.87 | 14,894.38 | USD | -3,948.07 | 208.82 | -3,006,436.87 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I am also not understanding your concept o false variances..system is never calculating false variances. Can you explain by providing data/facts so that we can understand your requirement and suggest some solution to adjust your accounts.
So far I think..your problem is that business does not want to account all the variances in accounts which have been generated and posted during order settlements..is it so? please explain your requirements.
kamal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I am sorry for not understanding "false variance".
Can you please give screen shots of this and explain how you are saying them false and also what is your expectation from the system?
Rajneesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We have tried that. We can't change the master data, though, so it keeps returning. We need to erase these false variances and create a new part number in the future. Some of the items are months old and we cannot reverse them out without impacting financials. We are stuck with the false variance on our balance sheet right now.
User | Count |
---|---|
101 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.