Company financial year is from July to June, total 12 months...

Prompt

Company financial year is from July to June, total 12 months. Please help me to do analysis on items: 1. P.K91.14.001.NA 2. P.K91.16.004.NA 3. P.K91.15.001.NA The periods I need are from: 1. July 2024 to June 2025 2. July 2025 to June 2026 All required information is available on the attached spreadsheet. Based on the attached spreadsheet, F2ASSY1, F2FGS, F3ASSY, F3LDBAY, OTHERS and PALLET are the places that contain items mentioned above. For more information, posting date format is day.month.year (for example: 01.10.17 means 1st October 2017). The yellow highlighted quantities are purchased from supplier. Within the analysis data must contain opening stock (only for F2ASSY1, F2FGS, F3ASSY, F3LDBAY, OTHERS and PALLET), purchases (only for PALLET), quarterly usage (only for F3LDBAY), closing stock (only for F2ASSY1, F2FGS, F3ASSY, F3LDBAY, OTHERS and PALLET). The prices for mentioned items above: 1. P.K91.14.001.NA = RM 30.00 per piece 2. P.K91.16.004.NA = RM 14.30 per piece 3. P.K91.15.001.NA = RM 1.95 per piece Please deliver in understandable form.