Inventory Aging Summary for CEO Presentation
I have to create inventory aging summary for CEO presentation, i have upload excel named zmm042.xlsx, with following table headers, Please give my excel output for summary ,please show inventory aging analysis in excel, i have to present to CEO,inclusing following, how much is inventory <180 days, 180 to 360 days, >360 days in terms of value and quantity; Material Material Description X plant status Material Type Material Type Desc. Material Group Material Group Desc Ext. Matl Group Ext. Matl Group Desc. Unit of Measurement Batch SIT Batch Plant Plant Desc HSN Code SLoc. SLoc. Desc Division Profit Center G/L Account Special Stock Indicator Vendor Customer MRP Unrestricted Stock Unrestricted Value Unrestricted Quality Unrestricted Quality Value Blocked Stock Blocked Stock Value Restricted Batches Stock Restricted Batches Stock Value Blocked Stock Returns Blocked Stock Returns Value Stock In Transfer(S2S) Stock In Transfer Value(S2S) Tied Empties Stock Tied Empties Stock Value Stock In Transit Stock In Transit Value Stock In Transfer(P2P) Stock In Transfer Value(P2P) GR Block Stock GR Block Stock Value Total Age Stock Total Age Stock Value Total Age M0 SEP 2024 M0 SEP 2024 Value M1 AUG 2024 M1 AUG 2024 Value M2 JUL 2024 M2 JUL 2024 Value M3 JUN 2024 M3 JUN 2024 Value M4 MAY 2024 M4 MAY 2024 Value M5 APR 2024 M5 APR 2024 Value M6 MAR 2024 M6 MAR 2024 Value M7 FEB 2024 M7 FEB 2024 Value M8 JAN 2024 M8 JAN 2024 Value M9 DEC 2023 M9 DEC 2023 Value M10 NOV 2023 M10 NOV 2023 Value M11 OCT 2023 M11 OCT 2023 Value M12 SEP 2023 M12 SEP 2023 Value M13 AUG 2023 M13 AUG 2023 Value M14 JUL 2023 M14 JUL 2023 Value M15 JUN 2023 M15 JUN 2023 Value M16 MAY 2023 M16 MAY 2023 Value M17 APR 2023 M17 APR 2023 Value M18 MAR 2023 M18 MAR 2023 Value >18M >18M Value Others Others Value
