Get instant live expert help on I need help with inventory management excel formulas

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need help fixing my inventory management systemin excel
Solved by F. J. in 24 mins
Management Instructions - Ending inventory target for Period 5
Solved by B. Q. in 20 mins
I need help fixing an inventory management formula
Solved by M. B. in 18 mins
Hello, I have an inventory management Excel file, split into two inventory sheets, Incoming Stock and Outgoing Stock. I am looking for a way to make the following happen: - when I input a new entry in the Incoming Stock for item X, I would like the corresponding field from G1 Inventory sheet (the field for item X) to update with the actual values. Likewise, G2 Inventory also has daily entries. When I input an entry for item X in G2 Inventory, I would like the corresponding field in G1 Inventory to be updated with the current values.
Solved by Z. J. in 17 mins
Management Instructions Beginning Inventory 25 Safety Stock - Lot Size 480 Master Production Schedule Period 1 2 3 4 5 6 7 8 Demand 4,400 3,750 3,200 4,175 4,225 4,300 3,350 3,400 Customer Orders 4,410 4,500 5,300 4,280 3,705 2,700 1,285 880 "Projected On-Hand Inventory (POHI) (at the end of the period)" Master Production Schedule "Available To Promise (1-period look ahead)"
Solved by A. Y. in 21 mins