My idea for improving Cougar Mountain is...

Sales Price Calc from Cost In Inventory (like COGS) NOT Just Last Cost

Currently Sales price, if calculated by the system, is based off the Last Cost. This works, EXCEPT when the Last Cost is LESS than the cost of the items sitting in inventory, in which case you would be selling those old items at a loss! The current work around is a manual report to identify the items being purchased that are less than the previous cost and we then have to manually update the Last Cost. To allow the system to be totally mechanical when pricing, why can't the Selling Price be calculated off of the Cost in inventory? In other words, just like the Cost of Goods Sold is calculated off the cost of the item in inventory, can the Selling Price also be set up the same? For example, if you have an inventory item purchased at $2.00 and then you purchase more in inventory at $1.50 -- the COGS will calculate based off of the $2 and the $1.50 -- why can't the selling price be calculated the same instead of only off the last cost of $1.50 as it is today? This would eliminate the need to manually update the last cost so when you sold the $2.00 items you didn't lose money. We would always also need the ability to override the cost for those scenarios where we purchased items at a deep discount and we didn't want to pass that on to the customer.

4 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Nancy Flessner shared this idea  ·   ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base