ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon How can I find table and column names in SQLManex
DrillDown Icon FAQ- KB and Help Desk
DrillDown Icon FAQ- System Admin
DrillDown Icon FAQ- Terminal Server
DrillDown Icon FAQ- System Setup
DrillDown Icon FAQ- System Utilities
DrillDown Icon FAQ- Accounting
DrillDown Icon FAQ- Standard Modules
DrillDown Icon FAQ for Sales Mgmt Modules
DrillDown Icon FAQ for Inventory Mgmt Modules
DrillDown Icon FAQ- Inventory Control Management (ICM)
DrillDown Icon Can ManEx Value Raw Material based off of the Purchase Price versus Std Cost?
DrillDown Icon Can a "Netable" part be excluded from MRP?
DrillDown Icon Can the Part Souce be changed from MAKE to Make/Buy on a Product?
DrillDown Icon Can I return Transferred Stock back to the Instore Location?
DrillDown Icon Can I clear 0.00 qty MRB locations?
DrillDown Icon Can I clear 0.00 qty WO-WIP locations?
DrillDown Icon Can Users Print Component Labels to help Shop Floor Locate and Identify Parts?
DrillDown Icon Do Users Create Separate Part Masters for Components not Interchangeable in Both Directions?
DrillDown Icon Do Users put the Rev Level in the Description or do they use the Rev Field?
DrillDown Icon Does the ABC Calculation Consider Leadtime?
DrillDown Icon How Inventory, BOM's and AVL's are Connected
DrillDown Icon How do Users Handle Passive Comp as far as Invt Ctl, Issuing Full Reels, Floor Stk, Ord Point vs MRP Actions?
DrillDown Icon How do Users Handle Issues by Manufacturing Part Number when they are Under the Same Internal PN?
DrillDown Icon How do Users Cope with Substitutions of Passives with Tighter Tolerance and/or Higher Voltages?
DrillDown Icon How does Pull-in Push-out days affect MRP?
DrillDown Icon How does the Cycle Counting affect ICM Records?
DrillDown Icon How does the "Disallow this Part from Purchase" affect MRP?
DrillDown Icon How the Manex Automatic Part Numbering System is Setup to Operate.
DrillDown Icon How the Inventory Control AVL Pref Code Works
DrillDown Icon How is the EAU Calculated?
DrillDown Icon How to "Disallow this Part from Purchasing/Kitting" if there is more than one customer that uses the same MPN.
DrillDown Icon How can I Identify all Duplicate MPNs in my System?
DrillDown Icon How can ManEx help me in Eliminating Attrition and Scrap?
DrillDown Icon How can ManEx help me Streamline Inventory Tracking & Control?
DrillDown Icon Inventory PN/Consigned PN/Supplier PN Relationship
DrillDown Icon Unable to create PL due to selected Mfgr location
DrillDown Icon What Causes Records to be pulled into Update Kit screen?
DrillDown Icon What the Message "There are no Valid Inventory Locations...... means.
DrillDown Icon Why are the Inventory Transaction Detail Log Reports not displaying the correct WHSE for the original receipt?
DrillDown Icon Why is Purchase History Indicating no History Available?
DrillDown Icon Why is the Weighted Cost different from the PO History Info?
DrillDown Icon Why isn't the Beginning Balance 0 on the Part Transaction Log with Balance 0?
DrillDown Icon When does the System use Stock UOM versus Purch UOM?
DrillDown Icon Why doesn't the Invt Valuation Rpt match GL Bal for the Invt GL Acct #
DrillDown Icon Why doesn't the Material Type Change update the Customer Part Number?
DrillDown Icon Why doesn't ManEx allow users to Auto Approve POs generated from MRP?
DrillDown Icon Why doesn't the Supplier Tab display in Red to indicate a Supplier is Available?
DrillDown Icon Why doesn't the system allow you to assign multiple customer PNs for the same cust to one internal PN?
DrillDown Icon WIP - FAQs
DrillDown Icon What will happen if the Std Cost is changed during the time the kit is in WIP?
DrillDown Icon The kit amount calls for fractions. Will this cause problems?
DrillDown Icon What can cause a difference between the WIP Evaluation Report and the Balance Sheet?
DrillDown Icon If there is no actual inventory count for WIP inventory, only a dollar amount, then what is the WIP Evaluation report as found i
DrillDown Icon FAQ- Inventory Handling
DrillDown Icon FAQ - Kitting & Shortage Management
DrillDown Icon FAQ - PO Receiving & DMR Module
DrillDown Icon FAQ - Standard Cost Adjustment
DrillDown Icon FAQ for Material Planning Modules
DrillDown Icon FAQ for Production Modules
DrillDown Icon FAQ for Quality/Engineering Module
DrillDown Icon FAQ for Invoicing Module
DrillDown Icon FAQ- How-to
DrillDown Icon FAQ-Reports
DrillDown Icon FAQ- eManEx
DrillDown Icon FAQ- POSSIBLE REPORT QUERY
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
What will happen if the Std Cost is changed during the time the kit is in WIP?

First, it means that the WIP account is proplery address AFTER all kits are closed, and GL records are released and posted.

When there is a cost adjustment while there are components in WIP, the value of the WIP account is not updated until the kits are closed. Then, the WIP value is updated, but erroneously attributed to manufacturing variance instead of cost adjustment.

So, making major cost adjustments when there is a large amount of affected inventory in wip will result in major discrepancies in the reported WIP VALUE from the Production reports and the WIP account value in accounting. When all kits so affected are closed, the discrepancy will be corrected. Put another way, the Production WIP VALUE is calculated on the current inventory in kits (by calculating the remaining assemblies in the kit, extending the QPA for each component based on the current BOM, subtracting any shortages and extending by the CURRENT Standard cost per component) and the GL reports are based on the value at the time of issue to the kit.

At the time this happens, (when the kit is closed) the value of all items issued to the kit is totaled and compared to the value of the totaled BOM component cost for the assemblies completed at the time of the kit closing.. The difference is currently logged as a manufacturing variance.

To validate the standard cost of the items issued in the INVT_ISU records with the current standard costs, system will total that value, and subtract it from the total manufacturing variance for each work order.  Then the true manufacturing variance should be realized, and the difference due to standard cost changes posted at the same time to the inventory adjustment account. Then, the total of the manufacturing variance and the total of the cost adjustment change should add up to the total difference between what was actually issued to WIP and what should have been issued to WIP (via the BOM).

bld qty = 100

action BOM qpa qty issued issued cost WIP Value Change Std Cost & roll assy Extended issue cost Extended Bom cost @ close Extended Cost Delta
part1 2 200 $1.00 $200.00 $1.00 $200.00 $200.00 $0.00
part2 56 5600 $1.00 $5,600.00 $1.00 $5,600.00 $5,600.00 $0.00

part3

14

1400

$1.00

$1,400.00

$1.00

$1,400.00

$1,400.00

$0.00

 

part4

9

900

$12.00

$10,800.00

$12.00

$10,800.00

$10,800.00

$0.00

 

part5

5

500

$2.00

$1,000.00

$2.00

$1,000.00

$1,000.00

$0.00

 

part6

7

700

$2.00

$1,400.00

$5.00

$1,400.00

$3,500.00

$2,100.00

 

part7

1

100

$2.00

$200.00

$2.00

$200.00

$200.00

$0.00

 

part8

1

100

$13.00

$1,300.00

$13.00

$1,300.00

$1,300.00

$0.00

 

part9

3

325

$14.00

$4,550.00

$14.00

$4,550.00

$4,200.00

$0.00

 

part10

8

800

$5.00

$4,000.00

$5.00

$4,000.00

$4,000.00

$0.00

 

 

 

 

 

 

 

 

 

 

 

total $53.00 $30,450.00 $56.00 $30,450.00 $32,200.00 $2,100.00 to cost adjustment
$30,100.00 Adjusted Std cost of components
($350.00) Manufacturing Variance

Article ID: 2300