Hi, I am brand new to VBA an I am stuck on how to construct my first project. I need to make a program for inventory managment, where the reorder point, reorder quanitity, setup cost, holding cost, and penalty cost are fixed values. It also needs to include lead time, demand rate, and production which are limit values produced using a random generator function.
Total Inventory cost = setup cost + Holding Cost + penalty cost, and this should be calculated and displayed in a message box.
Last it has to calculate Average Daily Cost = Total Inventory Cost/Lapsed Time, where lapsed time = the time it took to run the program.
Please if anybody help me with code it would greatly appreciated i'm really in a jam here!!!!!