Prepare a bill of material for each end item. Continue on to prepare a master production schedule by end item for the months of April and May which be both 4-week months. Prepare a material plan for component parts and include procurement lead-time where applicable. Include crew size required. (12 marks) Part # CHAIR-BLUE Blue Chair Item # Part # Lead Time Unit Qty Part Description Proc Cat. 1 2357 2 1 Blue Seat Assembly P 2 2370 3 1 Base Assembly P 3 8500 1 5 Screws P 4 6527 2 5 Wheels P Part # CHAIR-BLACK Black Chair Item # Part # Lead Time Unit Qty Part Description Proc Cat. 1 2358 2 1 Black Seat Assembly P 2 2370 3 1 Base Assembly P 3 8500 1 5 Screws P 4 6527 2 5 Wheels P Part # CHAIR-LW Executive Leather Chair Item # Part # Lead Time Unit Qty Part Description Proc Cat. 1 2359 2 1 Executive Seat Assembly P 2 2371 3 1 Executive Base Assembly P 3 8500 1 5 Screws P 4 6529 2 5 Executive Wheels P Note: With no drawing to reference an item number, start with 1, 2, 3 etc. These parts are also made to stock so use MTS for the order number. Date of release is todays date. The Exhilarating Executive Chair takes 3.5 hours of assembly and the other 2 chairs require 2.5 hours of assembly. All components are to be in stock one week prior to schedule which allows for assembly lead time. Since this is a make to stock company, shipments do not need to be considered at this point. The company works a 40-hour workweek, 48 weeks of the year. The internal procurement lead-times are: 1) 1 week for Purchase Requisition and Purchase Order. 2) As per BOM 3) 1 week for Transportation and Receiving a) When would the first parts need to be received at the Platinum Seating facility? b) How many people total would be required for final assembly? Justify your answer? Hint: do not use regular rounding rules here; give me a well thought out answer.