The requirement is two-fold. Firstly to calculate the cash expenditure required to pay for the inventory purchases as forecasted by the model. Secondly to calculate the date that payments are due and to accumulate this information into a weekly summary for all inventory items… (Budget: $30-$250 USD, Jobs: Excel, Inventory Management, Mathematics, Visual Basic)
