Need Help: Creating Simple MRP for Production Purpose

Hello, my name is James and currently i am in charge for production planning and inventory control in an audio company. I need to keep track of all materials movement and ensuring that the materials will be available at production due date. Therefore, i want to create a spreadsheet to help me track the amount of materials needed at certain date. I have created the mock up spreadsheet, which include the materials requirement for each finished goods and production schedule in the attachment below. What I want to achieve is that I can see the materials needed for each date based on the production schedule. For example, in the 1st date I produce 3 "as" , so I will need 3 X, 6 Y, and 6 Z to complete the production and so on. I need your help to create the formula in "MRP" tab to show all the required materials at corresponding date. Thank you so much, really appreciated any kind of help.

=SUM(TRANSPOSE(INDEX('Prod Schedule'!$B$3:$M$14,0,COLUMNS($B$2:B$2)))*INDEX('Material Requirement'!$B$3:$M$14,ROWS($B$2:$B2),0)) as array formula and pull across

Thank you for your help, however there is a little bit of issue in here. The formula above can't calculate all materials required for the finished good. For example, in the 1st date I produce 3 "as", I should prepare 3X, 6Y, 6Z for the production. By using the formula above I got 3X,0Y, 0Z, which is incorrect. Would you mind to explain the issue? Thanks a lot for your help

Never mind, previously I never used array formula so I didn't know if I should press Ctrl+Shift+Enter to make the formula works. Now, it works perfectly. Thank you so much for your help