the first 3 pictures are solved. the last picture is what i need solved please. i will gove thumbs up. thanks.

Information for this assignment: A certain product has the following bill of materials. This applies to the following questions 1-5. Note that the number in parentheses refers to the number of respective items needed in the assembly process. The master production schedule for A for the next 6 weeks is shown below. Use the above information to do your analysis in the next 5 questions. Do not answer this question OR enter 0 here: What would be the weekly_gross requirements of B and C, respectively, for weeks 11-16? Edit View Insert Format Tools Table For B 11- A=29, each A requires 8 units of B:298=232 units 12- A=22, each A require 8 units 228=176 units 13A=21,218=16814A=22,228=17615A=27,278=21616A=26,268=208 What would be the weekly gross requirements of B and C, respectively, for weeks 11-16? - Item B's projected on-hand at the end of week 10 was 66 and we were scheduled to receive 50 on week 12. - The gross requirements on weeks 11-16 were as found in the information for this assignment. Use the above information to do your analysis in the next question. Do not answer this question OR enter 0 here: Question 4 4 pts What would be the projected on-hand at the end of week 12? Show all your calculations