Challenge #65: Fulfilling Inventory Orders

[Bluemoon]

Lots of IF logic needed for this one!

Spoiler

[SubratDas5]

My Solution

[SueDonim]

A useful exercise I have run into in Excel-land for mortgage calculations.

I'll confess I had to do this in Excel first to get my thoughts straight....

Spoiler

There also was a wrinkle that my "Initial Supply" calculation couldn't refer to the prior row's "Remaining Supply" as I would do in Excel.  That took a bit of time to sort.

Process:

- Join the two tables based on SKU

- Initialise Initial Supply and Remaining Supply (not sure if that was needed, but it helped me to think)

- Calculate the Initial Supply for each attempted order based on prior orders filled

- Calculate Remaining Supply after each attempted (or filled) order

- Calculate the number of units provided in each order that was filled

- Filter results to get rid of those orders not filled

[shahryal]

Spoiler

Spoiler

[jagdeep_singh85]

PFA my solution

[paulburrows]

Heres my solution - thanks

[blundebjerg]

Sorta the same as the solution... 

[kmcdaniel]

Spoiler

[mat_budden]

Hi All,

Please find my Result below.

Spoiler

Joined the Tables and used Multirow formula's to work out fulfillment, Can be tricky but its a method I use alot.

Thanks

Mat