Get instant live expert help on I need help with inventory management excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
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