• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Inventory Tracking without Helpers

Gregg Wolin

Member
The attached has a Sales column that relies on 2 helper columns that I'd like to eliminate but have been unsuccessful building the requisite formula.
Thanks in advance for your assistance would be appreciated.
 

Attachments

  • chandoo-sales with no helpers.xlsx
    12.6 KB · Views: 16
This solution represents total and utter overkill! Because I had a function Allocateλ I had written for 365, I copied it in and popped the data in.
Code:
= Allocateλ(IF(Date>=startDate,demandByMnth,0), units)
The catch is that the Lambda function is intended to deal with multiple products, bought in over time at varying cost price, and meeting a fluctuating demand. The objective is to identify the purchase batch/es for any given sale to calculated the cost of sales on an order by order basis.

It works, but it represents a very large sledgehammer to crack a rather modest nut!
 

Attachments

  • chandoo-sales with Allocateλ.xlsx
    15.6 KB · Views: 8
Back
Top