hello, I need help with tgis question. it is for my enterprise systems class

This is an exercise that you will do by hand. The objective is to give you a both an idea how actual MRP calculations are done in a simple scenario and appreciate the complexity of the material planning process for highly complex Bill of Materials for real manufacturing Organizations Download the file . Document and complete the requirements of task, then upload your completed excrcise here. TRUS plans to manufacture 100 tables for the month of January 2024. The first working day for the month is Tuesday January 2nd. Assume that all material needed should be on hand at the beginning of the day to begin production. Therefore, all material should be on hand by Friday, December 29, 2023 Plan the material based on the information provided below. By planning we need to be able to answer the questions. - What material is needed? - What quantities? - When is it needed? (When action needs to be taken to ensure that material is available when needed) Bill of Material for Table Purchasing Lead Times and Lot Sizes for Materials TRUS estimates based on its production plans that it will have the following quantities of materials on hand at the end of the day on December 29,2023 . These are the quantities without planning for material required for the January 2024 production plan. Note that all the required material for production in January must arrive by December 29, 2023. Using this information fill out the procurement plan below. Assume that there is no delay in sending the order and its receipt by the vendor