Basic Assignments
|
Options & Settings
|
Main Time Information
|
||||||||||||||||||||||
|
|
|
|
|||||||||
|
|||||||||
|
Notes:
|
Decimal Examples: Ideas for Tracking Inventory: Entering a new part: - The first thing we need to catch is the lowest possible increment (or value of 1). o Cost per 1 = cost/qty o Weight/measurement per 1 = weight/measurement/qty o Weight/measurement type = text or look-up value - Once we have the base of 1. We can start doing conversions to other measurement type. - Main at value of 1: o Qty = 1 o Cost = o Price = o Other measurements = o Measurement type = - Conversion at a value 1 o Other measurement = 1 o Measurement type = o Cost per pack = o Price per pack = o Items per pack (qty of main) = - Main goals for this little project o Corp wide settings o Catch multi point decimals and details o Allow for different measurement conversions o Allow for conversions to be used on PO’s and invoices o Show conversions and measurements on invoice Questions and ideas about breaking parts into different smaller pieces – also multi decimal point questions – Basically, deeper detail on inventory tracking and selling. - Currently, as of 7/16/09, we are able to bring in any quantity of items (parts) via a PO. We take the qty time a cost to get the extended value. This seems to work fine for basic items (retail or singular items). - The problem occurs when we buy at bulk and want to sell on an individual level or someone wants a partial amount (splitting a package) that is a portion of the original. - Because of the problem listed above (splitting a package) we have a problem with costing, quantities, and rounding errors. This is where the need for multiple decimals comes in to play. - I’m wondering if part of the problem lies in how we bring things into the system. Currently all we have is a quantity and a cost. I’m wondering if we need some additional fields. o Cost each o May need to combine – weight each, dimensions each, length each – dealing with a single item or qty of 1 o Price each (sale price) o Items per pack, cost per pack, [weight per pack, dimensions per pack, length per pack] – size or measurement, pack type, price per pack o This might be a multi if they sell the item by the pound, by the foot, by the gallon, by the sheet, by the bundle, etc. Deeper inventory tracking continued: - What other possible things do we need to track? o Color o Sizes o Seconds/defects - Just for fun… I wanted to list a couple of items that are sold and how they are sold o Item • Cost Per/Price Per • Special Requirements o Item: Bottles of water • Cost per: 0.25 per bottle, or 7.95 per case (32 units)/ Price per: 1.00 • Could be sold each, by gallon, by case, by whatever • May be a different price or cost depending on amount and container type o Item: Nuts & bolts • Cost per: 0.00025 per pound/ Price per: 0.0007 • If only one is sold must be 0.01 • May be sold as individuals, per pound, or per box • Quantity or weight are important o Items: Services • Cost per: 0/ Price per: set or variable price • None o Items: Wood or steal • Cost per: 1.50/foot/ Price per: 3.00/foot • Sold by length • May be sold by sheet or some other measure • May have other dimensions w, h, L o Item: Gas or oil • Cost per: 2.159 per gallon/ Price: 2.599 per gallon • Liquid volume • Maybe sold at higher volume like barrel or a tank o Item: Fruit • Cost per: 0.25 per piece, 1.99 per pound/ Price per: 0.5 per piece, 3.99 per pound • Sold at lower quantities by the piece • Sold at higher quantities by the pound • Purchased by the box (pounds) o Item: T-Shirts • Cost per: 7.87 per shirt/ Price per: 14.95 per shirt • Need colors • Need sizes – xs, s, med, lg, XL, XXL, etc. |